
Active Member

July 8, 2021

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.

VIP

Trusted Members

December 7, 2016

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

VIP

Trusted Members

December 7, 2016


VIP

Trusted Members

December 7, 2016


Active Member

July 8, 2021

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.
1 Guest(s)
