Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Call Rest API from Advanced Editor

I'm new to PowerBI and have a simple web API i typically call in python.  I used the Advanced Editor in PowerBI.  It it telling the syntax is good, but then i get the error:  "Expression.Error: We ca...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I've tried to use Web.Contents() like this:

let

    apiUrl = "http://someserver:7979/v1/completed_detail",

    body = "{""submission_id"" :""01-25-2021-15-47-25""}",

    result = Json.Document(Web.Contents(apiUrl, [Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body)]))

in

    #"result"

But getting error:

DataSource.Error: Web.Contents failed to get contents from 'http://someserver:7979/v1/completed_detail' (405): METHOD NOT ALLOWED
Details:
    DataSourceKind=Web
    DataSourcePath=http://someserver:7979/v1/completed_detail
    Url=http://someserver:7979/v1/completed_detail
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

Not certain but the query looks like correct. Seems that could not send post request to the web source. Make sure whether the URL is accessible or need authentication and try it again. 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.