Forum Discussion

Zenly's avatar
Zenly
Regular Visitor
3 years ago

Web API Query Issue

Hi,   This is my first post on this forum. My name is Carl. 🙂   I wish to import the XML table https://boardgamegeek.com/xmlapi2/collection?username=Zenly&excludesubtype=boardgameexpansion  into...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Zenly - sorry, but I sent an advanced developer feature that is not available in normal Power Query, and I had trouble replicating your issue.  The API documentation suggests there are throttling limits and process latency.  The API will issue a valid "202" response with the message "Your request etc... ".  The function should allow Power Query to wait for a "200" response, which contains the XML file.  The "Value.WaitFor" is not an Power Query function, so it is not recognising as a custom function.  I am not sure how to fix because I can't replicate the "202" response.