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,

so the alert is created and it has that JSON string in one of it's field

You need to parse that and store in which field or which record?

Regards
Ankur

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

Ash34 · ‎07-01-2021

I want to create a new field and store it in that.

Ash34 · ‎07-01-2021

In the field shown below named additional information, there is a JSON which contains key-value pair, I want to extract it and store it in a variable to use it elsewhere.

Ankur Bawiskar · ‎07-01-2021

Hi,

you can use script but where do you wish to store?

in which record and which field?

you cannot store it in some global variable just like workflow scratchpad variable

Regards
Ankur

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

Ash34 · ‎07-01-2021

I don't know how to use the script feature in SNOW.

As long as I can use that variable to pass to Action for the rest API, I can store it anywhere.