Successfully downloaded https://services.swpc.noaa.gov/json/goes/primary/magnetometers-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.
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
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.
Well, delete and re-install did not work. Same error message. Something is interfering?
Have you tried to load the data from a new Excel file?
The link is the only source.
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.
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.
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.
