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.
