POST request to invoke REST web service using basic authentication and receive JSON response

[Anonymous]

Hi All,

I am currently facing an issue where I need to invoke a REST web service using basic authorization, sending a POST request with a payload.

I tried to follow the following guide: https://community.fabric.microsoft.com/t5/Service/POST-request-data-sources-that-require-basic-authe...

And modified the following code with the endpoint URL, JSON body, and credentials that I should be sending:

let
    url = "https://api.example.com",
    body = "{""key"":""value""}",
    headers = [
        Authorization = "Basic " & Binary.ToText(Text.ToBinary("username:password"), 0)
    ],
    options = [
        Headers = headers,
        Content = Text.ToBinary(body),
        ManualStatusHandling = {400}
    ],
    result = Web.Contents(url, options)
in
    result

However, I always receive the following error: DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously.

When I go to the data source settings and choose anonymous authorization, I get the following error message: We couldn't authenticate with the credentials provided, please try again.

I am able to successfully pull the data I need using SoapUI, and am only facing this issue in Power BI. Any help would be appreciated.

[Anonymous]

Hi @Anonymous 

Based the information you have offered, you need to get credential first, you can refer to the following link.

How to Authenticate to a REST API with basic Authe... - Microsoft Fabric Community

The link supply the similar problems.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.