"Unable To Parse JSON Request" in Application logs while executing the below code from mashup

[AP_10343008]

Iam continously getting error: "Unable To Parse JSON Request" in Application logs while executing the below code from mashup but the code providing results successfully while executing directly from Service. Kindly tell me what is the problem in below code.

The code is:

try{

var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({

    infoTableName: "InfoTable",

    dataShapeName: "FabShopIntake.ScheduleTasks-DS"

});

if(editedTable===true){ Users[CurrentUser].SheetMetal_ScheduleTasks = editedTable;}

else if(AssignedToGroup === true) 

            result = griddata;

else{

    result.AddRow({

        Select : true,

        GroupName : "LASER CUTTER Group",

        Order : 1

    });

    result.AddRow({

        Select : true,

        GroupName : "BEND-WELD-SEC OP Group",

        Order : 2

    });

    result.AddRow({

        Select : true,

        GroupName : "PAINT Group",

        Order : 3

    });

    result.AddRow({

        Select : true,

        GroupName : "SHIPPING Group",

        Order : 4

    });

}

}catch(err){

logger.warn("SheetMetalScheduleGroups: error is "+err);

}

[VladimirN]

More about this error:

• ""Unable To Parse JSON Request" is thrown when attempting to store more than 20 digits in Data type Number in ThingWorx Platform": https://www.ptc.com/en/support/article/CS263657 
• ""Unable To Parse JSON Request" error is logged when triggering a Navigation using an empty infotable mashup parameter in Thingworx": https://www.ptc.com/en/support/article/CS370460 
• ""Unable To Parse JSON Request" error returned when passing a null parameter to a ThingWorx Service via REST API": https://www.ptc.com/en/support/article/CS229964 
• "API call with InfoTable input results in "Unable To Parse JSON Request"": https://community.ptc.com/t5/ThingWorx-Developers/API-call-with-InfoTable-input-results-in-quot-Unable-To-Parse/td-p/633778 
• "How to remove "Unable To Parse JSON Request" error?": https://community.ptc.com/t5/ThingWorx-Developers/how-to-remove-quot-Unable-To-Parse-JSON-Request-quot-error/td-p/714781 
• ""Unable to parse json request" error in validation service": https://community.ptc.com/t5/ThingWorx-Developers/quot-Unable-to-parse-json-request-quot-error-in-validation/td-p/718326 

[AP_10343008]

I tried all of the above. Still it is not working.

[DanZ]

I copied the code and added the input params "editedTable" (BOOLEAN) and "AssignedToGroup" (BOOLEAN). I also created a datashape with the same columns as you (but different entity name).

The service is running just fine.

I can only suspect that the "griddata" variable (which seems to be also an input parameter) is invalid somehow. Comment out the "if" cases one by one and see were it throws the error.

[AP_10343008]

Yes when iam including griddata infotable, then iam getting this error.

griddata is a infotable datatype created as one of the field definitions in datatable. 
Iam passing this field value from grid to service in mashup.

[DanZ]

Then I think that the "gridData" does not have the correct format or is not a valid infotable in some sense. Can you log the "gridData" variable in the ScriptLog and post it here?

logger.warn(JSON.stringify(gridData));

[AP_10343008]

The output is below for the code logger.warn(griddata.ToJSON());

JSON:

{"rows":[{"GroupName":"uu"}],"dataShape":{"fieldDefinitions":{"GroupName":{"name":"GroupName","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":2},"Order":{"name":"Order","aspects":{"isPrimaryKey":false},"description":"","baseType":"NUMBER","ordinal":3},"ClosingTime":{"name":"ClosingTime","aspects":{"isPrimaryKey":false},"description":"","baseType":"DATETIME","ordinal":5},"Select":{"name":"Select","aspects":{"isPrimaryKey":false},"description":"","baseType":"BOOLEAN","ordinal":1},"ClosedBy":{"name":"ClosedBy","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":4},"LastScheduledGroup":{"name":"LastScheduledGroup","aspects":{"isPrimaryKey":false},"description":"","baseType":"BOOLEAN","ordinal":6},"Location":{"name":"Location","aspects":{"isPrimaryKey":false},"description":"","baseType":"STRING","ordinal":7}}}}

[Rocko]

"result" variable type is Infotable, but griddata type is JSON.

I don't see a conversion in the code?

[vnamboodheri]

Hello @AP_10343008, 

It looks like you have some responses from some community members. If any of these replies helped you solve your question please mark the appropriate reply as the Accepted Solution. 

Of course, if you have more to share on your issue, please let the Community know so other community members can continue to help you.

Thanks,
Community Moderation Team.

[AP_10343008]

I added default empty row in the datashape of infotable type column present in datatable. It made the service execute when there is no value present in the particular column.

Thanks