Reply
Frequent Visitor
Posts: 4
Registered: ‎09-07-2018

Re: Using a REST API as a data source

In the checklist, we have the Best Water Flosser Waterpik water flosser which is created Water Flosser to provide unbelievable outcomes.

Frequent Visitor
Posts: 4
Registered: ‎09-07-2018

Re: Using a REST API as a data source

In the checklist, we have the Best Water Flosser Waterpik water flosser which is created Water Flosser to provide unbelievable outcomes.

Regular Visitor
Posts: 23
Registered: ‎12-22-2016

Re: Using a REST API as a data source

@Quicky @caseyh @williamdasilva Just wanted to contribute here albeit for Blackbaud's K12 ON Api instead of RE NXT Api. However, if you want to connect to Blackbaud's K12 API with only eight lines of M Code using the preferred POST calls, all you have to do is insert your YOURUSERNAMEHERE, YOURPASSWORDHERE, YOURSCHOOLNAMEHERE, and YOURSLID#HERE (for your Advanced List) in the sample code below. I'm going to put together a blog post and screencast on this, but wanted to share / giveback here: 

 

let
    ONLoginInfo = "{""username"": ""YOURUSERNAMEHERE"", ""password"": ""YOURPASSWORDHERE""}",
    Source = Json.Document(Web.Contents("https://YOURSCHOOLNAMEHERE.myschoolapp.com/api/authentication/login",
[Content = Text.ToBinary(ONLoginInfo), Headers=[#"Content-Type"="application/json"], IsRetry=true])),
T = Source[Token],
GetList = Json.Document(Web.Contents("https://YOURSCHOOLNAMEHERE.myschoolapp.com/api/list/YOURSLID#HERE/?t=", [Query=[t=T, format="json"]]))
in
    GetList
 
Also on @Quicky SKY API connector, now that Microsoft has announced general availability of custom connectors, could this be opened up to anyone? Everyone seems excited about the general availability of custom connectors but if you have to login and API calls are metered I'm not sure what that means for the SKY API. https://powerbi.microsoft.com/en-us/blog/announcing-general-availability-of-custom-and-certified-con...
Regular Visitor
Posts: 23
Registered: ‎12-22-2016

Re: Using a REST API as a data source

@caseyh @Quicky @williamdasilva Just wanted to say that if you've got Grant Quick's custom connector working, you can get a jump start on data modelling and reporting with RE NXT received revenue with a free Power BI template (PBIT) here: https://resolvedllc.com/grab-the-butter/