Fetch data from Auth2.0 API data source

[mohammed_essam]

Hello,

I am trying to add a new Auth2.0 API datasouce to my BI report, however I keep getting an error message says "We encountered an erro while trying to connect" "Details: "Web.Contents failed to get contents from 'https://aisegypt.powerschool.com/ws/schema/query/com.esol.essamx.googleworkspace.students/' (405): "

Attached some screenshots from the error and configuration I am using.

Could you please advise ?

[mohammed_essam · Accepted solution]

I figured out by passing a blank content. 😀

Content = Text.ToBinary("")

Thanks for everyone.

[lbendlin]

Specifying POST won't help you .  You need to provide a payload to switch the request from GET to POST.

405 Method Not Allowed

Which method does your API expect?

[mohammed_essam]

It does expect POST method. kindly find belowall the details for preload. 

POST https://YOURSERVER/ws/schema/query/com.mycompany.mydivision.student.studentnumber
Accept: application/json
Content-Type: application/json
Authorization: Bearer xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx

[lbendlin]

Read about how to use the Content option in Web.Contents()

Web.Contents - PowerQuery M | Microsoft Docs