How do I pull data using Reports API from 10000ft into Power BI

Nisha J.

Hi,

I am trying to import data from the 10000ft reports using the following API link, but I get the message 'Not Found'.

https://api.10000ft.com/api/v1/reports/rows?view=time_fees_hours&time_frame=this_week&auth=<URL-ENCODED-TOKEN>

Can anybody help?

Thanks

Genevieve P.

Hi @Nisha J.

Did you remove the auth parameter for the post for privacy reasons (which I would have suggested), or did you try to use exactly this, letter-for-letter?

https://api.10000ft.com/api/v1/reports/rows?view=time_fees_hours&time_frame=this_week&auth=<URL-ENCODED-TOKEN>

Note that the <URL-ENCODED-TOKEN> needs to be replaced with your API access token.

You can learn more about the 10,000ft API here: https://github.com/10Kft/10kft-api

Here's the section on the Access Token & the auth parameter: https://github.com/10Kft/10kft-api/blob/master/sections/first-things-first.md#authentication

Hope this helps!

Cheers,

Genevieve

Nisha J.

Hi @Genevieve P,

Thanks for your reply. I did replace the <URL-ENCODED-TOKEN> with my API access token. For example, I was able to import all projects using https://api.10000ft.com/api/v1/projects?per_page=1000&auth=<URL-ENCODED-TOKEN>, however this does not work when I try to import the reports API. Not sure what I am missing.

Thanks,

Nisha

Genevieve P.

Hi @Nisha J.

Thank you for clarifying! This is a public supported endpoint and now that I've looked closer at the API docs, this API call expects an HTTP POST.

It looks like you are using an HTTP GET, which is why you are receiving "Not Found".

Here's the example POST request in this API document, which will have the proper formatting for this request: https://github.com/10Kft/10kft-api/blob/master/sections/reports.md

Cheers,

Genevieve

Kalyani Raval

Hi Genevieve,

Could you please help with latest URL for the documentation? as the one you mentioned above is now not available.

I am trying to start from scratch to connect 10000ft with Power BI. Please advise some documentation for the same.

Best Regards,

Kalyani Raval

Genevieve P.

Hi @Kalyani Raval

The Resource Management API docs can be found here: https://10kft.github.io/10kft-api/ and here: https://github.com/10Kft/10kft-api

Cheers,

Genevieve