Forum Discussion
Host Header error in an API call
I have an API call that works in Postman (GET) It is a OAuth 1.0 authentiacation and I have all keys, secrets and signature. When I do it in Power Query - I just try to replicate the Headers that P...
A little update - I removed the Json.Document, leaving just the Web.Contents part.
I also removed the Accept header.
Same error. Now it I click "Edit Settings" I just see the "From Web" settings where it correctly recognizes my headers.
It just doen't like the "Host" header somehow...
I've played with its values - same error, it just doesn't like this header being there...
Any ideas? Please help...
Hi michaelsh,
Have tried to use any other methods to invoke your api? AFAIK, normally power query web connector not required 'host' parameters. Maybe you can try to split the authorizations string to standalone parameters and remove 'host'.
Regards,
Xiaoxin Sheng