Forum Discussion
bob57
3 years agoHelper IV
Getting Data From Toggle Time Tracker and Pagination
Hello, I've been tasked with getting all time entries from Toggle into Power Bi. Problem: Only 50 records are returned. Does anyone have experience with this and know how to retrieve all records? Or...
ppm1
3 years agoSolution Sage
Looking at the Project page of that site shows at least that API method supports pagination.
Perhaps the Workspaces one does too. You can either try it with pagination and List.Generate, or create a list of ids to be used as a start id for the next 50 records, as described in this video.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
bob57
3 years agoHelper IV
Thank you for taking the time to respond. What I learned:
1) /pagination is not supported with Workspaces.
2) The video was very informative and I learned from viewing it, but I haven't found a way for the total number of records to be returned, so I'm not sure that creating a list of ids in a multiple of 50 would offer benefit.
Again, thank you for your time. My search continues.
Bob