Send an HTTP request to SharePoint Invalid JSON

(3) Share

Report

Posted on by JLS_

Hello community!

I want to update AllDayEvent field with Send an HTTP request to SharePoint action.

I get error:

{
  "status": 400,
  "message": "Invalid JSON. A token was not recognized in the JSON content.,
  "source": "<mySPOSiteUrl>/_api/web/lists/getbytitle('Team%20Calendar')/items(251)",
  "errors": [
    "-1",
    "Microsoft.SharePoint.Client.InvalidClientQueryException"
  ]
}

I think it is matter of formatting, but I checked all options:

"fAllDayEvent": true
"fAllDayEvent": True
"fAllDayEvent": "true"
"fAllDayEvent": "True"
'fAllDayEvent': true
'fAllDayEvent': True
'fAllDayEvent': 'true'
'fAllDayEvent': 'True'

But nothing works. Could you please advise?
Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

why there is JSON keyword here in body field - i think that is causing error

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
JLS_ 23 on at

Like (1)

Report

@Nived_Nambiar, it was partially.

I changed it to:

{
"__metadata": {
"type": "SP.Data.Team_x0020_CalendarListItem"
},
"fAllDayEvent":true
}

and now I get BadGateway error. I am able to update any column on my list with the action, but not the AllDayEvent attribute.

Do you have any ideas?

Was this reply helpful? Yes No
Suggested answer

David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report
The issue may be the URI path that you are using. I use the following with the body formatted as shown. I do not include any headers in the request. I have used this format dozens of times and have not had an issue. Be sure to replace "Display Name of List" with the display name of your list (as if that wasn't obvious). If you are not updating the item from the trigger, you will also need to update the ID to the correct item in the Uri as well.

Uri: _api/web/lists/getByTitle('Display Name of List')/items(@{triggerOutputs()?['body/ID']})/validateUpdateListItem Sample body: { "formValues":[ { "FieldName": "ArchiveDate", "FieldValue": "@{formatDateTime(body('Archive_Date'),'MM/dd/yyyy')}" }, { "FieldName": "Days", "FieldValue": "@{outputs('Compose_Days_to_Complete')}" } ] } Body for multi-choice field: { "formValues": [ { "FieldName": "Animals", "FieldValue": "Dog;Cat;Mouse" } ] } Body to set date field to null: { "formValues":[ { "FieldName": "DateField", "FieldValue": null } ] }

Was this reply helpful? Yes No
Verified answer

JLS_ 23 on at

Like (1)

Report

Answer from MS was:

It looks that the rest API requires has mandatory that start and end date are present when doing a update to an event to set him to all day.

You can simply use like this :

Where the EventDate and the EndDate you can get from your previous step, and keep all working.

And it is working.

Was this reply helpful? Yes No