Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi I am using the value.waitfor in a function with an API, I am pretty sure the parameters to this function within the web.contents is causing the issue, however, I am not sure how I can restructure this to get around this, any suggestions would be great, thanks
Solved! Go to Solution.
All found the issue, so instead of this
result = Web.Contents("https://api.practitest.com/api/v2/", [RelativePath= "projects/" & ProjectKey & "/tests.json?api_token=" & Practitest_api_token] & [ManualStatusHandling = {429}, IsRetry = iteration > 0]),
I used this
result = Web.Contents("https://api.practitest.com/api/v2/", [RelativePath= "projects/" & ProjectKey & "/tests.json?api_token=" & Practitest_api_token, ManualStatusHandling = {429}, IsRetry = iteration > 0]),
All found the issue, so instead of this
result = Web.Contents("https://api.practitest.com/api/v2/", [RelativePath= "projects/" & ProjectKey & "/tests.json?api_token=" & Practitest_api_token] & [ManualStatusHandling = {429}, IsRetry = iteration > 0]),
I used this
result = Web.Contents("https://api.practitest.com/api/v2/", [RelativePath= "projects/" & ProjectKey & "/tests.json?api_token=" & Practitest_api_token, ManualStatusHandling = {429}, IsRetry = iteration > 0]),
Thanks, I read through that, not quite sure how to disect this though
result = Web.Contents("https://api.practitest.com/api/v2/", [RelativePath= "projects/" & ProjectKey & "/tests.json?api_token=" & Practitest_api_token] & [ManualStatusHandling = {429}, IsRetry = iteration > 0]),
I believe you will need to combine the various elements to create your relative path prior to passing it into the Web.Contents function. This can be done by creating the relative path in table rows and then invoking the function for the table column.
Here is a good resource:
https://hatfullofdata.blog/power-query-dynamic-data-source-and-web-contents/