Unanswered

How to find the error column in Parse JSON error message 'Parse_JSON' inputs at line '1' and column '36737'

(0) Share

Report

Posted on by phanks01

I need some help to find an error in my JSON schema. THe background is this flow is triggered on changes to identify which columns have changed and notifiy the users. I need to send them the current value as well as the prvious value. In the flow I use the'Get changes for an item or a file (properties only)' action followed by the 'Send an HTTP request to SharePoint for Changes' which in turn I use the output to the Parse JSON. Here is where the problem is.

I took the output from the 'Send an HTTP request to SharePoint for Changes' action to create the schema in the Parse JSON. At times it would fail due to a column being empty. I searched the form and found several threads which explained to use type: ["string","null"] to prevent this. This worked for a while but I am now getting the error below.

InvalidTemplate. Unable to process template language expressions in action 'Parse_JSON' inputs at line '1' and column '36737': 'Required property 'content' expects a value but got null. Path ''.'.

I have edited all the values I can in the schema to include the null reference but still getting this. How can I identfy the location of the error? Using Notepad++ I tried to go to that offset, but it placed me at the end of the schema. I would post the schema but it is rather long (800 lines).

The only itms in the schema I can't use the null reference are a couple of system values such as the below that do return null from the 'Send an HTTP request to SharePoint for Changes' action.

"OData__x005f_ModerationComments": {},
"File_x005f_x0020_x005f_Type": {},
"ComplianceAssetId": {},

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

v-siky-msft on at

Like (0)

Report
Hi @phanks01 ，

Just like ["string","null"] , modify the type for above three values in JSON schema to "type": ["object","null"] to allow null value.

For instance:

{ "type": "object", "properties": { "OData__x005f_ModerationComments": { "type": ["object","null"], "properties": {} }, "File_x005f_x0020_x005f_Type": { "type": ["object","null"], "properties": {} }, "ComplianceAssetId": { "type": ["object","null"], "properties": {} } } }

Hope this helps.

Sik

Was this reply helpful? Yes No
phanks01 29 on at

Like (0)

Report

Thanks for the tip. But I edited every type line and added the null statement. However, I still get the same error. Is there a way to identify the actual column causing the error? The error is still pointing to Parse_JSON' inputs at line '1' and column '36737'. I created a new Parson JSON action and performed the Generate from sample as a test without any edits and it was successful. SO I need to figure out where the error is occurring.

Thanks

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @phanks01 ,

If you don't mind, could you please share the sample JSON and JSON schema you used with us to help you investigate the issue .

Sik

Was this reply helpful? Yes No
phanks01 29 on at

Like (0)

Report

These are fairly long. Is there somewhere I could upload the files?

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report

Hi @phanks01 ,

attach the file to post from here:

Sik

Was this reply helpful? Yes No
phanks01 29 on at

Like (0)

Report

Sorry but I don't have that option. When I expand the Additional options all I have is Associated Products & Message Tags. Am I missing something? When I try to drag files I get a file type is not supported. I tried as .txt, .json & even 7z/zip
files.

Was this reply helpful? Yes No