Forum Discussion
HugoAvell23
2 years agoFrequent Visitor
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 ...
cpwebb
2 years agoMicrosoft Employee
Can you post an example of the correct URL and the M code you're using?
HugoAvell23
2 years agoFrequent Visitor
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.