clockify-page-size-change

JonParton commented 2 years ago

This pull request does a few things:

Changes the page size in the connector to 5000 instead of 1000 as this has been confirmed as the max by Clockify
Updates the Power BI Template version to use a pagination loop for time entries
Updates the Readme to reflect the need for page size to be below 5,000

closes #2

JonParton commented 2 years ago

@OscarValerock I couldn't build the custom connector from the change I made above to update it to a 5000 page size.

Could you do the honours of building it and pushing the updated .mez file to this pull request before merging?

JonParton commented 2 years ago

Also ... Not sure where I got my original template from, but each query had a separate Fx function that did the API call. Maybe you published a separate example power BI in a blog post? .. Racking my brains.

Anyways to be able to embed the looping logic in the current repo template I had to extract the TimeEntries API logic into a separate function and call it in the Time Entries add column step. I couldn't figure out how to do this in line as I needed to union the results...

Let me know if you are A-OK with the changes or if there is a reason you kept all the logic inline in this template version... feel free to alter!

OscarValerock / Clockify-PowerBI

clockify-page-size-change #3