topic REST Connector - Http Status Codes in Variable in Connectivity & Data Prep

REST Connector - Http Status Codes in Variable

jochem_zw — Mon, 17 Apr 2017 21:00:25 GMT

Is it possible to get the HTTP Status code from a API request with the Qlik REST Connector?

I want to have the status 200, 204 or 206 from my API Datasource, as long as I got a 206 (Partial) there is more data available, so I have to page.

BR Jochem

Re: REST Connector - Http Status Codes in Variable

Bjorn_Wedbratt — Tue, 18 Apr 2017 08:35:20 GMT

Hi Jochem,

I'm using ScriptErrorDetails in my script and searches for '404' to stop loading. You should be able to do something similar.

SET ErrorMode = 0;

SQL SELECT

FROM <something>;

Let vContinueLoad = SubStringCount('$(ScriptErrorDetails)','206');

exit do when vContinueLoad <> 1;

Something like that might do the trick

Re: REST Connector - Http Status Codes in Variable

jochem_zw — Tue, 18 Apr 2017 08:53:33 GMT

I like to use it in the 'WITH CONNECTION' part of the script

I already tried the errormode, but there is no error coming from the 'WITH CONNECTION'

So ScriptErrorDetails stays <NULL>

When I get a 206 means there is more data available from the REST API so I would like to take the next 100 (page_size).

Re: REST Connector - Http Status Codes in Variable

celindho — Thu, 14 Mar 2019 07:36:11 GMT

Did you manage to solve this?

Re: REST Connector - Http Status Codes in Variable

Josh-Head-of-BI-HGreg — Sat, 09 Oct 2021 17:06:39 GMT

My script was exiting without saving when HTTP Error 416 was returned, and that is when I know the system is making a call beyond last page. So I just did

SET ErrorMode = 0;

Before loading part and I just ignore the errors.

Not sure what's the proper way of telling:

IF HTTP Error = 416 THEN STOP