Web.Contents failed to get contents from 'https://ausreman.tidywork.com/api/materials' (400)

[drmdodd]

I have tried a number of scenarios for posting data, but I have come up with nothing.  I am trying to write a power query that posts data to a REST API (https://ausreman.tidywork.com/api/materials), it posts data for materials.  The current query I have is:

= Json.Document(Web.Contents("https://ausreman.tidywork.com/api/materials",[Headers=
        [#"Authorization"="Basic ZZZZZZZZZZZZZZZZZ",#"Content-Type"="application/json"],
       Content=Json.FromValue({[projectId="65b6d1fe-ec2e-47c3-9c92-2aad8fdd1d26",userId="67220adb-d5cb-4667-a3ce-ebe3d6248334",materialDateUtc="2015-09-14T07:11:00",materialDate="2015-09-14T17:11:00",materialId="00000000-0000-0000-0000-000000000000",materialLocationId="1aeb9552-a3e9-4804-a7b2-641b290dac8d",materialItemCode="1H3338",materialItemId="f9be8264-81f0-4ae2-a12b-569b3e05d034",costCurrencyId="17709522-6b2e-4b01-9cdf-bb7eb0a43c52",chargeCurrencyId="17709522-6b2e-4b01-9cdf-bb7eb0a43c52",taskId="b2ffc2cf-326a-fc91-eb40-c4ddb4147a35",state="Approved",usageQuantity=1,quantity=1,cost=0.21,charge=0.25]})]), 1252)

The only thoughts I had was that it had something along the lines of the size of the data being post.   Please help me remove this frustration.

[rubayatyasmin]

this site wants authorization with username and password. seems like basic authorization is not applicable in this site. 

Also see if old solution works:

Solved: DataSource.Error: Web.Contents failed to get conte... - Microsoft Fabric Community

Solved: [DataSource.Error] Web.Contents failed to get cont... - Microsoft Fabric Community

Solved: DataSource.Error: Web.Contents failed to get conte... - Microsoft Fabric Community

Solved: DataSource.Error : Web.Contents failed to get cont... - Microsoft Fabric Community

Solved: Web.Contents failed to get contents from (405): - Microsoft Fabric Community

[drmdodd]

I tried applying basic authentication through power query, but I get the error:

DataSource.Error: Web.Contents with the Content option is only supported when connecting anonymously.

See this article:
https://community.fabric.microsoft.com/t5/Desktop/Web-Contents-with-the-Content-option-is-only-suppo...

[Anonymous]

Hi @drmdodd ,

You need to set up the privacy level of your source under data source setting as anonymous. And also make sure update your token because tokens come with a time limit.

Best Regards,

Stephen Tao

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