Connecting API with Active Demand

[Anonymous]

Hi PBI'ers,

Could anyone specify how I can integrate a web api(Active demand) in PowerBI?

Here's a reference for the specific API:

https://support.activedemand.com/support/solutions/articles/5000539684-the-web-api-for-activedemand

Thanks already!

Kind regards,

MrNelsch

[ZappySys · Accepted solution]

Hi,

Not sure if you are open for 3rd party driver but ZappySys has very easy to use ODBC Drivers for REST API which can connect to any APi and it has many Pagination / Authentication options.

You can write queries like below

SELECT * FROM $
LIMIT 25
WITH(
	 src='https://api.activedemand.com/v1/forms.json?api-key={API_KEY}'
)

Here is an article you can start with.

https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

Check below link for more articles reklated to Power BI and Rest API Integration.

https://zappysys.com/blog/category/odbc-powerpack/odbc-app-integration/bi-reporting-power-bi/