Hi everyone,
I played around with automated data refresh using data from a website.
when opening the website with a single open prompt like this in a script:
Open( "https://www.bundesnetzagentur.de/_tools/SVG/js2/_functions/csv_export.html?view=renderCSV&id=1081180" );
Here get the data table without issues.
When using the HTTP Request (which I need to make the data updateable in JMP Live) I run into issues:
request = New HTTP Request(
Url( "https://www.bundesnetzagentur.de/_tools/SVG/js2/_functions/csv_export.html?view=renderCSV&id=1081180" ),
Method( "Get" ),
Insecure
);
request << Send;
data = request << Send;
dt = JSON To Data Table( data );
"Unexpected ".". Perhaps there is a missing [ or {.
Line 1 Column 1: ►.;10/2021-09/2022;10/2022-09/2023;Minimum 10/2018-"
Is there a way to get the data via HTTP Request?
Not sure if the "." as the first character is the problem or something else.
Thanks
Jonas
