This repo is documenting the queries i have used and made to bring in a monolithic board with several thousand records
The GetFirst and GetNext queries are originally developed by @hmbouk on their Gist Post and have been adapted for the specific use case i have.
SourceTable is a designed to accept 1 single large board and is specifically written to handle the returns from these queries, if you amend the queries you will need to amend the steps following List.Generate.
1 further note, For all of this to work, GetFirst and GetNext must return the exact same format of data, The first api call returns the object boards where as the cursor api calls retursn the object next_items_page, in the GetFirst and GetNext queries i normalise the returns to be Cursor and Items and nothing else.
Update:
- A issue was raised on the repo that outlined the solution was missing the last page of a board, when the board holds over 1500 items this bug presents. The solution was developed by @tomiapo and can found on their repository, i have updated this repo to reflect their solution and have verified this solution does fix the bug.