You’re offline. This is a read only version of the page.
Announcements
19
In 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
Share
Report{
"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\":\"\"}]"
}
]
}
I tried the below and worked as expected.
Above Parse JSON is as follows:
All responses (
Answers (
