topic Re: Passing a JSON Value to a JSON API Request in Cortex XSOAR Discussions

Passing a JSON Value to a JSON API Request

vidurasupun — Sat, 25 Mar 2023 15:07:36 GMT

Hi All, I have faced one issue while sending a API call to IVANTI. I need to call one value into this request as below

{
"OrgUnitLink": "${org}",
"Symptom": "${body}",
"Subject": "${incident.labels.Email/subject}",
"Source": "Email",
"Status": "Submitted"
}

${org} gets passed without an issue when I call it since the value is like asda232adadf334d

But when I call an email body(${body}) it gets screwed up since the final call looks like below,

I know that the error is coming because JSON need some characters escaped. But I have no idea how to do this. Any help would be appreciated.

Re: Passing a JSON Value to a JSON API Request

nikoolayy1 — Wed, 29 Mar 2023 07:00:19 GMT

As your issue is so specific and I do not have this integration or I have not had any issue with json escape characters I can give you the advice to search scripts that have json in the name like https://xsoar.pan.dev/docs/reference/scripts/json-unescape as this sounds the reverse of what you want but you can reverse engineer the script 🙂

Other scripts to look:

https://xsoar.pan.dev/docs/reference/scripts/ignore-fields-from-json

https://xsoar.pan.dev/docs/reference/scripts/dump-json

https://xsoar.pan.dev/docs/reference/scripts/parse-json

https://xsoar.pan.dev/docs/reference/scripts/load-json

There are many more.

Re: Passing a JSON Value to a JSON API Request

vidurasupun — Thu, 30 Mar 2023 10:35:42 GMT

Created one of my own scripts to remove conflicting characters. It looks a bit ugly after formatting but better than nothing 🙂

function removeJsonEscapableChars(str) { const escapableChars = /\\["\\\/bfnrt]/g; return str.replace(escapableChars, ''); } var body = args.value; body = JSON.stringify(body); setContext(args.key, removeJsonEscapableChars(body));