Forum Discussion
Using a REST API as a data source
Anonymous
I don't know the Blackbaud REST API in your case and it is not in the list of suppported "Online Service".
But according to the content in the link that the API reponses in JSON, you can get the data by using "Get Data"-->"Other"-->"Web". And then extend JSON to a table in query editor.
eg. http://jsonplaceholder.typicode.com/posts/1/comments
You can replace it with a link like "http://[school].myschoolapp.com/api/academics/department/?t=[token returned from previous step]" in your link.
In the query editor,
Done
Regarding refreshing, you can publish it to Power BI Service and schedule refresh.
Eric_Zhang i was looking at using a 3rd party api provider as a data source which is not one of your native PBI connectors (or online Service SaaS connectors as you cal them) so i followed this post with interest.
Obviosuly just a simple api call using http is the answer. Thanks.
I was just reading the API deveoloper doc of the provider and it states
"All access to the API occurs over an TLS-encrypted secure channel, so your API client must support TLS. To ensure data privacy, unencrypted HTTP is not supported."
Does the PBI client satisfy TLS ?
Thnaks for your timely feedback.
David
DavidMoss wrote:
Eric_Zhang i was looking at using a 3rd party api provider as a data source which is not one of your native PBI connectors (or online Service SaaS connectors as you cal them) so i followed this post with interest.
Obviosuly just a simple api call using http is the answer. Thanks.
I was just reading the API deveoloper doc of the provider and it states
"All access to the API occurs over an TLS-encrypted secure channel, so your API client must support TLS. To ensure data privacy, unencrypted HTTP is not supported."
Does the PBI client satisfy TLS ?
Thnaks for your timely feedback.
David
I have no idea about that. Just try and test.