AroFlo data via API

[RikW]

Hello,

We currently use AroFlo as out job management system and would like to pull some data into PowerBI via the API but so far have not been able to get PBI to connect, anyone able to assist?

AroFlo API Documentation - https://apidocs.aroflo.com/

TIA

[myusernameisjon]

I've managed to get data in to Power BI but not via Power Query. Used their API to land the data in a cloud database and then connect Power BI to that. It meant that I could also use the database for any data manipulation and grunt prior to Power BI anyway. Loading all of your historical data is a pain because of their API limits so can take awhile depending on your situation!

[Zerbe]

Hey Rik,

Did you have any luck with this? I'm trying the same thing, but get the error - Authentication Failed - Required headers are missing

[RikW]

Not as yet, i have the same issues

[Zerbe]

Did you try connecting via Zapier? You can use the free trial to test it out.

I’ve given Zapier a go but keep getting the same authentication error. AroFlo suggested trying Zapier again – I just want to see if anyone else has had the same issue connecting it. I’ve been back and forth with AroFlo support, and they keep saying it’s to do with the API keys not being copied properly, but I definitely know what I’m doing there.

[RikW]

Update

I have the login working now but so far unable to get any data to show in Power BI.

Any tips?

[Owenwhitehead]

Hi Rik, did you work out how to do this?

[RikW]

No not as yet.

I havent been able to get the login to work as yet.

[Owenwhitehead]

Following

[Anonymous]

Hi @RikW 

You can use a Web connection to the AroFlo API in Power BI.

Make sure you have obtained the correct access and key for the AroFlo API.

In the "Basic" option, you need to enter the URL of the API.

Regards,

Nono Chen

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

[RikW]

Hi Nono,

Thank you for your reply.

I have done as you said above but get the below error.