Forum Discussion
API multiple call to return all data (paging)
I don't have a lot of M Query experience, and I'm working on calling all data points for an API call. In order to get where I want, I have to make 2 seperate calls above this (asking for a list of all company projects and a second asking for those project's inspections). The goal is to get all checklist itmes from those inspections.
How can I go through and page to get all data? My current M query looks something like this:
ChecklistItems =
Table.AddColumn(
#"Filtered Rows1",
"New",
each
Json.Document(
Web.Contents(
"https://api.WEBSITE.com/rest/v1.0/",
[
RelativePath =
"projects/"
& Text.From([Project Id])
& "/checklist/list_items?filters[inspection_type_id]=98634",
Query = [
per_page = "1000"
],
Headers = [
Authorization = AuthToken
]
]
)
)
),
1 Reply
Hello thomazinh ,
This blogpost shows a simple paging semantics and also gives you a solution to not miss the last page when paging in Power Query: How not to miss the last page when paging with Power BI and Power Query (thebiccountant.com)
