Log In
Register
Home
Active Member
July 8, 2021
Offline
Successfully downloaded https://services.swpc.noaa.gov.....1-day.json for years, suddenly getting error message. Select Data on the ribbon>get data>from file>from json>enter the URl>enter. Entire message is: Unable to Connect, We encountered an error while trying to connect. Details: "We found extra characters at the end of JSON input." NOAA, the source says they made no recent changes, the link and data are good.
See Answer
VIP
Trusted Members
December 7, 2016
Offline
Hello Ben,
It works fine for me to load the data from this JSON file, see attached.
The M code.
let
Source = Json.Document(Web.Contents("https://services.swpc.noaa.gov/json/goes/primary/magnetometers-1-day.json")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"time_tag", "satellite", "He", "Hp", "Hn", "total", "arcjet_flag"}, {"time_tag", "satellite", "He", "Hp", "Hn", "total", "arcjet_flag"})
in
#"Expanded Column1"
Br,
Anders
Answers Post
Active Member
July 8, 2021
Offline
Thank you Anders, the copy of Excel installed here must be corrupt if you can download it. I will delete it and re-install. When I contacted Microsoft, their support agent did not have an Excel to test.
Active Member
July 8, 2021
Offline
Well, delete and re-install did not work. Same error message. Something is interfering?
VIP
Trusted Members
December 7, 2016
Offline
Have you tried to load the data from a new Excel file?
Active Member
July 8, 2021
Offline
The link is the only source.
VIP
Trusted Members
December 7, 2016
Offline
Sorry, probably some Swenglish from me in my previous question.
When I read ”delete and re-install” I assume you are still working in the same Excel file, have you tried to load the data in a new Excel file? Just to check if error is with your original file or not.
Active Member
July 8, 2021
Offline
Thanks, Anders. The entire Microsoft Office suite was deleted and re-installed. The same error reoccurred. I work alone so there is only one Excel installation to test. I thought it was a corrupt Excel, but something else is the problem. If you can download it in Sweden...mystery.
VIP
Trusted Members
December 7, 2016
Offline
Well, the error seems not to be in the JSON file, but perhaps in your Excel file. If you haven’t already, do try to import the JSON data in a new empty file. If you still get the same error then it is something strange going on.
1 Guest(s)
