The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Guys,
I'm trying to make a call via API, but some records (IDs) are giving the following error: "API Blocked - Exceeded number of accesses to API, wait a few minutes and try again". Can anyone help me how I would solve this request problem?
Below is the code I implemented for the call:
(id)=>
let
Source =
Json.Document(
Web.Contents(
"https://api.tiny.com.br/",
[
RelativePath = "api2/produto.obter.estoque.php",
Query =
[
token = "tokentokentokentokentokentokentokentokentoken",
id = Text.From(id),
formato = "json"
]
]
)
),
Delay = Function.InvokeAfter(Source, #duration(0,0,0,20)),
Table = Source{0}[table]
in
Source