Datalflow failed to get data from API

[HugoAvell23]

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?

[cpwebb]

Thanks - what do you mean by "sometimes missed" - does this mean it doesn't happen all the time? Can you see a pattern?

[HugoAvell23]

Exactly. It doesn't happen all the time. I scheduled, 4 times each day to refresh, but some of refreshs doesn't work.

[cpwebb]

What is the error message you get when it fails?

[cpwebb]

Can you post an example of the correct URL and the M code you're using?

[HugoAvell23]

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.