Connect to Dyflexis API

[Rapportage]

Hi everyone,

Our company uses the application Dyflexis for scheduling the employees. They have an API available and I have access to it with my API token. When I want to add a new data source to my dashboard as 'web' and I fill in the api link and my token, I can't connect because it gives me a message 'A web API key can only be sepcified when a web API key name is provided.

Can someone help my connect to the API? I have no idea what to do or try..

Thank you,

Tim

[ZappySys]

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://wordpress.org/news/wp-json/wp/v2/categories?per_page=10'
	,PagingMode='ByResponseHeaderRfc5988'
	,WaitTimeMs='200' --//wait 200 ms after each request
)

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/

[Anonymous]

@Rapportage,

Which authentication method do you use in Access web content dialog? Since you have filled in the api link with your token, please choose Anonymous authentication and check if you get any error message.

Regards,
Lydia