Forum Discussion
Mquery error: 404
Hi all,
This is what I need to be able to do
I am trying to achive the below with an Mquery:
1. First I need to run to call a REST endpoint to start the export
(modified link)
2. running the above REST endpoint, the output will look something like the below
(modified link)
https://tis.obss.io/rest/export/3kjhrqoi-asd-3rrd34-3rerwr34-94c797e9f590
I need to run the post command output to get to the data table
I managed to get to the point of writing an Mquery (screen shot) that runs successfully the first time executed (weblinks provided are modified)
However when refreshing the query, I get a 404 error: Web.Contents failed to get contents pointing to the sourcelink given in 'webdata.2'.
possible reasons that I could expect for this error is that I am missing some sort of loop that would require for checking the status of the export link..
Request generate data => status link
Loop
Request status (status link) => status, export link
exit loop when status == Succesful
Request download data (export link)
Any ideas how to include this in the query?
5 Replies
I would guess the url is wrong, try printing the returned url for the statusLink and check is it works without load, using the browser.
Are you able to query this new url:
statusLink1 & "/download" & "/?ApiKey
on the browser ?
Also, check this link: https://blog.crossjoin.co.uk/2016/08/09/handling-404-not-found-errors-with-web-contents-in-power-query-and-power-bi/
You can handle the 404 error manually and get some responses from the header.
