Extracting data from Time Log extension in Azure DevOps

[justwonderland]

Hi,

I want to extract Time Log data from ADO into Power BI. I use the following REST API URL:

https://boznet-timelogapi-test.azurewebsites.net/api/{organisationid}/timelog/query?code={API Key}

{organisationId} - replaced with my organization ID
{APIKey} - replaced with (for the evaluation version) pfcooS75dcpEekjJvdsOvsY0FIJqrsoWicnyY1GQQVby2PVwVl0KBw==

Additionally, I use FromDate filter:

https://boznet-timelogapi-test.azurewebsites.net/api/{organisationid}/timelog/query?code={API Key}&FromDate=2020-01-01

It gives me the data, however, it doesn't contain the latest entries from the Time Log. I see entries created up to 08/02/2024 although, there are many logs inserted after this date. I'm not Time Log Admin and don't know what might be the reason of this issue.

FAQ – TimeLog (timelogextension.com)

[Anonymous]

Hi @justwonderland ,

Please ensure that the API you're using is the latest version. APIs are periodically updated, and using an outdated version might result in incomplete data retrieval.
Since you mentioned you're not a Time Log Admin, it's possible that your account lacks the necessary permissions to view or extract the latest entries. Permissions in Azure DevOps and extensions can be quite granular. I recommend reaching out to your Azure DevOps administrator or the Time Log Admin within your organization to verify if there are any permission restrictions on your account.
Some APIs have rate limits or use pagination to limit the amount of data returned in a single request. If the number of Time Log entries exceeds this limit, you may need to make multiple requests to retrieve all data.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[justwonderland]

Hi @Anonymous 
Thank you for your suggestions. I had requested Time Log Admin for the latest API Key and finally received it.

I replaced the API Key for evaluation version with the organization one and changed sandbox url

https://boznet-timelogapi-test.azurewebsites.net/api/

 to live url

https://boznet-timelogapi.azurewebsites.net/api/

These both changes solved the issue and I managed to load the correct data from Time Log extension into Power BI.

Many thanks,

Justyna