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;

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

 

[ArshilAhmad]

IjU3NjYwNTZhMDYzZjA0M2Q1MjY0NTUzMDUxMzci_pc

Thank you for sharing the workflow. You will need to add a Code step to the workflow to achieve your desired use case. There is no other no-code way to consistently map the data to the next steps.

You can use the code that Fagun shared with us and map the data directly from Code (Pabbly) action step.

In this workflow, we have shown how you can add the JS code to the workflow.

Pabbly

connect.pabbly.com