topic How to set-up REST-API Link in script / what changed...? in Discussions

How to set-up REST-API Link in script / what changed...?

Ole_Luehn — Sat, 10 Jun 2023 23:25:14 GMT

Dear.

I made a try to import data from a cloud via a Rest-API script - and it worked - so I continued with the table and "modified it, wrote specs, made graphs etc.".

Now, I re-opened the same script and in the log-file there is some error which I don´t unterstand in the log-file.

Please have a look in the png file. When I copy the https link into a browser, it works and shows data.

Could it be that JMP doesn´t read the rest-api link because there are some < or [ or { which are missing in the link itself?

@eromeu

Re: How to set-up REST-API Link in script / what changed...?

Craige_Hales — Tue, 26 Jan 2021 12:42:23 GMT

The qm_data is HTML, not JSON. The <doctype> is the header on an HTML file. The JSON importer is producing the message because it does not understand HTML.

The JSON may be embedded in the HTML, or there may be a better rest api to get just the JSON data without an extra wrapper.

Ideally the rest api will return bare JSON. If necessary, you can write some sort of pattern matching/regex/substring JSL to dig the JSON out of the HTML.

use

write(qm_data); // if really long, use: write(left(qm_data,1000) );

and look at the log to see what you received.

Re: How to set-up REST-API Link in script / what changed...?

Ole_Luehn — Tue, 26 Jan 2021 14:30:37 GMT

Hi Craige.
Wonderful. Thank you very much!
Why is it so easy...;-)...

Best wishes. and thank you.
Ole

Re: How to set-up REST-API Link in script / what changed...?

Craige_Hales — Tue, 26 Jan 2021 14:38:10 GMT

Welcome! I also sent a request asking for the error message to be improved.

Re: How to set-up REST-API Link in script / what changed...?

Byron_JMP — Tue, 02 Feb 2021 02:29:32 GMT

...many things are easy for Craige ; )