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.
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.
Hi
Please can you help me find a solution. I tried what you suggested above, but it does not work for me. Note that I am not very experienced in doing this and this is my first time.
The provider gave me the below details:
When you are ready to begin, use the following URL for the API: https://resellers.accounting.sageone.co.za/api/2.0.0.
We use basic auth for authentication API calls and you would use the same login that you created in the step above.
Your API key for the Sandbox environment is: (they gave me a key).
I entered the URL above into the Web connector box in PowerBi. Then it gave me several options to choose from: Anonymous, Windows Credentials, Basic, Web API and Organisational Account.
I tried, anonymous, Basic and Web API options, none of them worked. Each time I did it, the loading preview window opened, and did not load, even after waiting 15 minutes.
I then also closed the window and tried to look for the “to table” option in your solution, and I could not find this either or it was greyed out.
Please can you help me find out how to get connected. Anonymous , did you get this to work for you? – did this solution work?
Please let me know.
Thanks.