Forum Discussion

justwonderland's avatar
justwonderland
New Member
2 years ago

Extracting data from Time Log extension in Azure DevOps

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} ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    justwonderland
    New Member
    1 year ago

    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