Forum Discussion
Datalflow failed to get data from API
I'm having a problem with Dataflow, which doesn't use the correct URL of an API. Dataflow misses some commas in the URL, so it can't import data. The URL I included is correct, otherwise it wouldn't work at first.
How can I solve this?
5 Replies
Can you post an example of the correct URL and the M code you're using?
Json.Document(Web.Contents("https://api.xxxxxxx.com/public/xxxxxxxx&$select=ijjj&$expand=ddd($select=oooo,uuuu)"), 65001). The comma, betwen oooo and uuuu, sometimes is missed. I cannot share de exactly url, because it is from the company, but the url follows OData format.
Thanks - what do you mean by "sometimes missed" - does this mean it doesn't happen all the time? Can you see a pattern?
Exactly. It doesn't happen all the time. I scheduled, 4 times each day to refresh, but some of refreshs doesn't work.
What is the error message you get when it fails?
