Forum Discussion
API request where each record is counted as a request
I have been using an API to pull data into Power Query and then PowerBI from a task management tool. The API documentation states that they limit requests to 100 request per minute per token. I have the following M that requests a list of the tasks; it only returns 100 records. Is there something in the way I wrote this that is making multiple requests? It only looks like one request to me, not one request per record. Is there a better way for me to do this?
let
token = "XX_YV5JX1DMD5D3CDEVTGO58UT44YXXXXXX",
endpoint = "2232929/task?include_closed=True",
baseUrl = "https://api.clickup.com/api/v2/team/",
url = Text.Combine({baseUrl,endpoint}),
request = Web.Contents(
url,
[
Headers = [
Authorization = token
],
Query = [
]
]
),
requestData = Json.Document(request),
#"Converted to Table" = Record.ToTable(requestData),
#"Expanded Value" = Table.ExpandListColumn(#"Converted to Table", "Value")
in
#"Expanded Value"Judging from discussions on the vendors site, it does not seem that the API limit is really 100 records so I assume it's something I'm doing wrong. Thanks for any insight.
Hi ChristyQV
It loads 100 rows by default.
Please read this thread to find some workarounds.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-juanli-msftCommunity Support
Hi ChristyQV
It loads 100 rows by default.
Please read this thread to find some workarounds.
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.