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.