Unanswered

Send HTTP Request to Sharepoint - ERROR: Invalid JSON. A token was not recognized in the JSON content.

(0) Share

Report

Posted on by ZachJayy

I am attempting to use the Send an HTTP Request to Sharepoint action to create a new list on a Sharepoint site. Action below:

It is giving me the following error:

{

"status": 400,

"message": "Invalid JSON. A token was not recognized in the JSON content.\r\nclientRequestId: 4c6da6e2-efaf-4d99-b409-a50257308f2f\r\nserviceRequestId: 8ce0939f-0047-b000-aa93-aaab61487ba1",

"source": "https://<<my site url>>",

"errors": [

"-1",

"Microsoft.SharePoint.Client.InvalidClientQueryException"

]

}

I am new to REST interaction and json, completely. Anyone

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Hello,

Please modify json as below. Basically we dont need the _metadata tag that is there in your json.
{
"AllowContentTypes": true,
"BaseTemplate": 100,
"ContentTypesEnabled": true,
"Description": "",
"Title": ""
}

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

@annajhaveri @My first iteration of this was written exactly how you have it there. I still received this same error. I added the metadata tag hoping it might help (after seeing it on an online guide). I’ll remove it, but this error still persists. Other ideas?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

okay, what is the value of New Hire Name, may be that is creating issue?

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

@annajhaveri New Hire Name is pulling a text string with a space in it. Formatted like 'First Last'
It's a dynamic content coming from a Microsoft Forms submission.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

In the screenshot that you gave, i see that you dont have quotes around the value of title, please put the quotes around value for title.

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

@annajhaveri I've fixed that with single-quotes and removed that metadata line to rerun, now we're just timing out?

Was this reply helpful? Yes No
ZachJayy 81 on at

Like (0)

Report

@annajhaveri my mistake - it looks like that piece is working! A precious attempt had successfully created the list so all subsequent flows were timing out since the name was taken.

A new question, if I can? Again - new to JSON. I need a followup action to send new JSON code to create columns for that list. This one is now failing with a new error:

Invalid JSON. The property name '' is not valid. The name of a property cannot be empty.
clientRequestId: c5843b22-6b07-4f76-a3c2-a0d57f158631
serviceRequestId: d0c2949f-30e8-b000-b1c3-2437da3b1d9c

Screenshot below:

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Hello @ZachJayy ,

I think you need to do a separate Sent HTTP Request action for each column that you need to create.

Thanks,
Anna Jhaveri

Was this reply helpful? Yes No