Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to pull in data from predicthq.com. I'm not connected with this group other than as a data consumer.
Their webservice has a 308 redirect. From the docs I can see Web.Contents() has the required redirection logic for 300-307.
I've tried extending this function with a re-try request having no success - see below. Python works as does Postman.
Any workarounds for this? Using Python I've checked the history of the response and I can verify the 308 and the redirection to the final location which happens to be, annoyingly, the same uri as in my original request.
let req = () =>
let
uri = "https://api.predicthq.com",
utiResponse = Web.Contents(uri, [RelativePath="/v1/events",
Headers = [
#"Authorization" = "Bearer privatekey",
#"Accept" = "application/json"
],
ManualStatusHandling={308}
]),
finalResponse = Web.Contents(uri, [RelativePath="/v1/events",
Headers = [
#"Authorization" = "Bearer privatekey",
#"Accept" = "application/json"
],ManualStatusHandling={308}
])
,
body = Json.Document(finalResponse)
in body
in req
Thanks Maggie. This is a good article, I'll give it a go.
Lee
I couldn't get around this bug. It seems .net http doesn't handle 308 Redirects. Hence not a Power BI issue, moreover a .net issue.
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 15 | |
| 8 | |
| 6 | |
| 5 | |
| 5 |