Send an HTTP Requet to SharePoint 400 Bad Request Error

[SheltonThompson]

I am trying to follow the example at the following link to build a flow for PowerApps to clear a person field in a SharePoint list however I keep getting a status code 400 and Bad Request error. Theres is not much instructions at the following site and I cannot figure out exactly what I am doing wrong?

https://poszytek.eu/en/microsoft-en/office-365-en/powerapps-en/clear-lookup-and-people-picker-fields...

Here are my settings

 

The field ID per sharepoint is Assigned_x0020_To

Here is the error it returns:

{

"message": "The type of data at position 0 is different than the one expected.\r\nclientRequestId: 54ddf0a6-8204-452b-a0b4-1a031d01adda\r\nserviceRequestId: 2af1ac9e-60f0-7000-7263-38bc33f024ba",

"status": 400,

"source": "https://cargillonline.sharepoint.com/sites/CSSP_team/COE/_api/web/lists/getbytitle('Ariba%20List')/I...)",

"errors": [

"-1",

"System.InvalidOperationException"

]

}

[SheltonThompson]

Update, I found I was missing a bracket however getting a new error

{

"status": 400,

"message": "The parameter __metadata does not exist in method GetById.\r\nclientRequestId: b42bae69-dc50-44c1-82ac-49a47f243f08\r\nserviceRequestId: b5f1ac9e-d096-7000-6f34-48b6d970ccc2",

"source": "https://cargillonline.sharepoint.com/sites/CSSP_team/COE/_api/web/lists/getbytitle('Ariba%20List')/I...)",

"errors": [

"-1",

"Microsoft.SharePoint.Client.InvalidClientQueryException"

]

}

[TomaszPoszytek]

Hi!

When you paste this URL in your browser: https://cargillonline.sharepoint.com/sites/CSSP_team/COE/_api/web/lists/getbytitle('Ariba%20List')/Items/, then what is the value for the "category" (search for "<category term=" element)? Is it SP.Data.Ariba_ListListItem or maybe SP.Data.AribaListListItem?

I'd start with that.

Regarding the bracket - now you have it at the beginning of the "body" content, right?

Regards,

Tomasz

[SheltonThompson]

Correct the bracket is at the beginning of the body.

In regards to the element, on searching as you described, it was SP.Data.AribaListListItem. I updated the body of the Flow however it still results in the same error nessage:

{

"message": "The parameter __metadata does not exist in method GetById.\r\nclientRequestId: ca128ddf-98c7-4a4d-8c75-2ec4991a57f5\r\nserviceRequestId: bff3ac9e-2078-7000-4a32-9ebe3997db2b",

"status": 400,

"source": "https://cargillonline.sharepoint.com/sites/CSSP_team/COE/_api/web/lists/getbytitle('Ariba%20List')/I...)",

"errors": [

"-1",

"Microsoft.SharePoint.Client.InvalidClientQueryException"

]

}

[v-bacao-msft]

Hi @SheltonThompson,

I noticed that the content configured in the Body seems to lack a "{".

Also if the list name contains spaces, the type value should look like "SP.Data.Ariba_x0020_ListListItem". Specifically, you could view it like this, as the method that TomaszPoszytek mentioned.

Open the source in the browser and observe the category of the xml data, which will contain the value of type.

Here is a similar Thread that you could use for reference:

https://powerusers.microsoft.com/t5/Building-Flows/Clear-people-picker-box-in-SharePoint-list-error/...

Please try again.

Best Regards,

Barry

[SheltonThompson]

Yes as mentioned above, I already corrected adding the bracket at the beginning immiediatly after posting and ran into the other error that I mentioned in my last post.

I have looked up the category term=" element) as mentioned by TomaszPoszytek  which resulted in "SP.Data.Ariba_ListListItem" and tried that and it resulted in the same error. I have also tried your solution of "SP.Data.Ariba_x0020_ListListItem" which again resulted in the same error.

I tired the link you provided below, and ensured my flow matched the settings they mentioned that were all resulting in an error and unfortunatly still resulting in the same error.

Here is the error:

{

"status": 400,

"message": "The parameter __metadata does not exist in method GetById.\r\nclientRequestId: 62bbbfd7-ab6e-43b7-81f9-6161b5822c36\r\nserviceRequestId: 1b41ad9e-701a-7000-7263-36f7e9cb15ac",

"source": "https://cargillonline.sharepoint.com/sites/CSSP_team/COE/_api/web/lists/getbytitle('Ariba%20List')/I...)",

"errors": [

"-1",

"Microsoft.SharePoint.Client.InvalidClientQueryException"

]

}

Here is an updated copy of my current flow settings. I am unsure what you wish me to try again? 

[TomaszPoszytek]

**bleep**, I really can't see an issue in your configuration. But I bet this is something regardin the internal names vs. display names. Can you create a test list, without any spaces, dashes, underscores in names and test on it?

Just a seconds ago I run the Flow that was created to PoC what I described in the post and it run sucessfully. This is my actions full configuration:

Do you see any differences?

Regards,

Tomasz

[SheltonThompson · Accepted solution]

No difference. I just really started to flow with the setting and changed the method from POST to PATCH in the method field below the Site Address and upon doing that everything worked. 

Thank you for your help. Much appreciated. 

[TomaszPoszytek]

Maybe you should've typed "PATCH" instead of "Patch" in the request headers?

Can you check if this will work for you?

Regards,
Tomasz