Extracting specific values from a JSON string

[JoshBeall]

In one of my workflows, I am processing a JSON object that looks something like this:


"custom_fields": [
{
"custom_field_definition_id": 426105,
"value": 1754952120
},
{
"custom_field_definition_id": 453167,
"value": false
},
{
"custom_field_definition_id": 458425,
"value": 1537890
},
{
"custom_field_definition_id": 617774,
"value": 1755230400
},
{
"custom_field_definition_id": 424495,
"value": null
}

I want to get the "value" number for the objects that have "custom_field_definition_id" 426105 and 617774.

Is there a no-code way to do this, or do I need to use a JavaScript to parse and return these values? I'm trying to embrace the "no-code" way of doing things, but haven't been able to figure out how to do this without using code.

When I initially built out this workflow, I used an iterator to inspect every one of the objects--but further on in the workflow I want to be able to perform operations that inspect both values (for custom_field_definition_id's 426105 and 617774). The iterator only gives you access to one (the current value in iteration) at a time.

 

[ArshilAhmad]

Hi @JoshBeall,

Could you please share the Workflow URL where you have this concern?

 

[JoshBeall]

IjU3NjYwNTZhMDYzZjA0M2Q1MjY0NTUzMDUxMzci_pc

 

[Fagun Shah]

Here is the code that you can use with Code - Run Javascript action

const data = [
{ "custom_field_definition_id": 426105, "value": 1754952120 },
{ "custom_field_definition_id": 453167, "value": false },
{ "custom_field_definition_id": 458425, "value": 1537890 },
{ "custom_field_definition_id": 617774, "value": 1755230400 },
{ "custom_field_definition_id": 424495, "value": null }
];

const result = data.reduce((acc, item) => {
acc[item.custom_field_definition_id] = item.value;
return acc;
}, {});

return result;

-----------------------------------------------