I can't seem to get the pagination to work correctly so I can grab all the invoices. This is in Power Query / Power BI.
Couple of requirements
1. Call all information till no more records are available
2. Incremental refresh so it only looks for records not present and adds those.
This code loads everything once but If i refresh it, it just keeps loading forever.
let
// Define the function to get invoices for a specific page
fnInvoices = (pageNumber) =>
let
Source = Json.Document(Web.Contents(
"https://api.servicetitan.io/accounting/v2/tenant/xxx/invoices?pageSize=50&pageNumber=" &
Number.ToText(pageNumber),
[Headers=[Authorization="Bearer " & AccessToken, #"ST-App-Key"="xxx"]]
)),
Data = Source[data],
hasMore = Source[hasMore]
in
[Data = Data, hasMore = hasMore],
// Generate the list of invoices
Source = List.Generate(
() => [ pageNumber = 1, result = fnInvoices(1) ],
each [result][hasMore] <> false,
each [ pageNumber = [pageNumber] + 1, result = fnInvoices([pageNumber]) ],
each [result][Data]
)
Anyone help?
