Dealing with errors from a webservice

Wed, 20 Mar 2013 11:00:26 GMT

Hi all,

I am trying to construct a webservice load statement using a http request string that returns either a csv table or xml. Due to the large amounts of data that is being returned, the server is timing out and the load is failing.

However in the api call I can input a date range - so I decided to try running the query using a series of incremental 2 week periods. This works fine when there is data present,limiting the data returned to more managebale chunks, but when there is no data for the time period the server returns a no data present error and the load freezes.

Is there a way of dealing with this error? Maybe like a time out to push on to cancel the http call and then move on to the next?

Heres my code - you can see I tried the set ErroroMode, but thats not helping.

Any help gratefully recieved.

Mark..

set ErrorMode =0;

// Create initial table to load data to

DATA_TABLE:

LOAD *,

Date#('2013-03-19', 'YYYY-MM-DD') as Date_Extracted

FROM

[http://....&filterIds=7&parameters1=2012-09-14&parameters2=2013-03-18]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//Set start load date and number of iterations

let Date1= Num(Date#('2012-09-21', 'YYYY-MM-DD'));

let weeks = 12;

//Start looping

for i=0 to $(weeks)

//Amend date variable with iteration

let date1= $(Date1) + 28*$(i);

let date2= $(date1) + 28;

// format date variable to work in http call

let date4=Date($(date1));

let date5=Date($(date2));

//load next iteration

Concatenate (DATA_TABLE) LOAD *,

$(date4) &'-'& $(date5) as Date_range

FROM

[http://.....&filterIds=7&parameters1=$(date4)&parameters2=$(date5)]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

//end loop

NEXT

//Store to qvd

STORE * from DATA_TABLE into DATA_TABLE.qvd;

Re: Dealing with errors from a webservice

Sat, 06 Apr 2013 06:40:22 GMT

Probaly you need to modify you API, insted of returning fault contract. you need to return the null response.

topic Re: Dealing with errors from a webservice in QlikView

Dealing with errors from a webservice

Re: Dealing with errors from a webservice