Parse additional info to get key value pair from alert record and store it in a variable

Ash34 · ‎07-01-2021

Hello Folks,
I'm new to service now. I'm trying to create a flow where the trigger is from an alert.

In the additional information of the alert, there is a key/value pair that I want to store as a variable and then use in an Action.

Additional info JSON:

{

name: "ashutosh",

id: "1234"

}

I want to extract the id and store it in a variable. Then, use that variable in an API call (action). If someone can provide me detailed steps as I'm very new to this platform would be nice.

Ash34 · ‎07-01-2021

Here is how I achieved it:

In the sub-flow added an input variable and label as id of type string.
In the action of rest API, I also created input variable and named it the same as the above.
From the flow designer, there was an option to add a script, the key was very hard for me to find. I have highlighted the green box.
After press that button, we need to add the below javascript code provided by @Ankur Bawiskar. But we had to get to our records which were hard to find in the first line. Note: if you are trying to parse some other variable than additional_info, change it accordingly. Try to use auto-completion.
```
var str = fd_data.trigger.current.additional_info;
var obj = JSON.parse(str);
var id = obj.id;
return id;
```
Finally test the flow. It works like a charm.

View solution in original post

Ankur Bawiskar · ‎07-01-2021

Hi,

it is a simple json object

you can parse it like this

var str = {"name":"ashutosh","id":"1234"};

var obj = JSON.parse(str);

var id = obj.id;

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ash34 · ‎07-01-2021

Thanks, Ankur for the reply but I don't know where to add the code you have given above?

Can it come as a variable under the data field?

Ankur Bawiskar · ‎07-01-2021

Hi,

on which field you need to store that id value?

where are you getting the json from?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ash34 · ‎07-01-2021

I'm creating a flow using flow designer. It has a trigger set to alert. That alert has additional info data.

I want to know what action I have to create to get the id variable from the additional info of the alert?