Forum Discussion
Connect to Dyflexis API
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
2 Replies
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,
LydiaHi,
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/
