Reading HTTP response headers from a web api

[cesarowicz]

I'm trying to access a web api (labs.ig.com) which returns an authentication token in the response header.

Is there any way to access the contents of the response header in a query? I can use Web.Contents to read the response body (which is a JSON string containing miscellaneous details about the account) but can't see a way to access the header itself so I can use the token for a subsequent api call.

[lauritxi]

Hi!

Can you tell me how you resolve this? Thank you.

[uria]

You can try this solution :

http://www.excelandpowerbi.com/?p=14

http://www.excelandpowerbi.com/?p=58