Share
Report
19In a compose action I get the below JSON values [array] as output and as a next step I use apply to each action by selecting "result" property and then within the loop, I use ParseJSON action to select property (u_json_inputdata) in order to get "RequestDefaultUser" & "BusinessJustification". What happens here is, flow runs fine but within the loop one of the values failing with this error "The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'After parsing a value an unexpected character was encountered: I. Path '[0].BusinessJustification', line 3, position 1.'." please support
{
"result": [
{
"u_executiontarget": "",
"u_planneddatetime": "",
"sys_import_state_comment": "",
"template_import_log": "",
"sys_updated_on": "2023-02-16 08:12:16",
"u_test": "",
"sys_class_name": "u_ih_job_queue",
"sys_target_sys_id": "",
"u_targetapplication": "",
"sys_id": "a51a1aed87092d10bc0784030cbb35c5",
"sys_updated_by": "",
"u_target_record": {
"link": "",
"value": "0e0a16ed87092d10bc0784030cbb3527"
},
"u_retry": "",
"sys_created_on": "2023-02-16 08:12:16",
"sys_import_set": {
"link": "",
"value": "ed1a1aed87092d10bc0784030cbb35c5"
},
"sys_transform_map": "",
"u_status": "Pending",
"sys_created_by": "",
"sys_import_row": "0",
"u_sub_status": "",
"sys_row_error": "",
"u_job_id": "1060",
"sys_target_table": "",
"sys_mod_count": "0",
"import_set_run": "",
"sys_tags": "",
"u_executeddatetime": "",
"sys_import_state": "pending",
"u_json_returndata": "",
"u_json_inputdata": "[{\"RequestDefaultUser\":\"user@contoso.com\",\"BusinessJustification\":\"\"}]"
}
]
}
Categories:
I have the same question (0)
All responses (
Answers (
