How can I read a HTTP-header while making an API call from Excel VBA using JSON?

Question

I am making API-calls to a server from Excel VBA by using this JsonConverter:

*) https://github.com/VBA-tools/VBA-JSON/blob/master/JsonConverter.bas

I use this commands which works fine:

http.Open "GET", APIString, False
http.send    
Set JSON = ParseJson(http.responseText)

Although in some cases the received JSON-string is corrupt and my code stops with an error.

If I am correct, there should be a 'http-header' containing a number which indicates the JSON-string is corrupt.

Do you know where and how I can import this 'http-header' from Excel VBA. In that case I could cancel my API-call in those cases the number in the header indicates the content is corrupt.

Thanks!

FunThomas · Accepted Answer · 2017-09-14 08:44:39Z

2

Check the status of your http-request:

if http.Status = 200 Then
    Set JSON = ParseJson(http.responseText)
else
    ' ... (error handling)
end if

answered Sep 14, 2017 at 8:44

FunThomas

31.3k4 gold badges24 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2165379 Over a year ago

Thank you Thomas, I will add these lines.

Collectives™ on Stack Overflow

How can I read a HTTP-header while making an API call from Excel VBA using JSON?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related