Http request for an array

[spidaman]

I am struggling to make a http request for each item of an array in VBA. When I make the request for a single object there is no problem:

Dim xml_obj As MSXML2.XMLHTTP60
Set xml_obj = New MSXML2.XMLHTTP60

xml_obj.Open bstrMethod:="GET", bstrURL:=url1
xml_obj.send

But when I try and use the request method for each item in an array I get the error: '-2147024809 (80070057)'.
I can't find anything useful online for the error code.
The code below is throwing the error.

Dim url1(1 To 5) As String
Dim xml_obj As MSXML2.XMLHTTP60
Set xml_obj = New MSXML2.XMLHTTP60

For i = 1 To UBound(url1)
    xml_obj.Open bstrMethod:="GET", bstrURL:=url1(i) ' error thrown on this line
    xml_obj.send
Next i

I have tested the url1 string for each item in the array before the http request and these are valid strings for the request, so I believe the problem is my code for making the multiple requests.

I am unsure if I need to set an array for the xml_obj. Can anyone help please?

 

[Kenneth Hobson]

I see no data in the array. I guess you can do i=1 to 1 and see if the first element does what you want.

Set the 3rd input to False for ASYNC.

'xml_obj.Open bstrMethod:="GET", bstrURL:=url1(i) ' error thrown on this line
xml_obj.Open "GET", url1(i), False

 

[spidaman]

I see no data in the array. I guess you can do i=1 to 1 and see if the first element does what you want.

Set the 3rd input to False for ASYNC.

'xml_obj.Open bstrMethod:="GET", bstrURL:=url1(i) ' error thrown on this line
xml_obj.Open "GET", url1(i), False

Hi Kenneth, what does setting the third input to asynchronous do?

 

[Kenneth Hobson]

I put it at False. We usually want one process to end before starting another. I guess you can try True to see if that is the better route.

of or requiring a form of computer control timing protocol in which a specific operation begins upon receipt of an indication (signal) that the preceding operation has been completed.