In this scenario I am building a set of structured data that Zoho CRM expects, I loop over the sub-forms match their product name to the Zoho product ID, then create the structure.
I then save it as a variable. I also have a filter to check if the data passing through contains empty product ID’s as a way to stop it processing empty data.
I then recall the variables in module 130, but I want to output each long string with a comma so it maintains a comma separated structure as needed, data_FS only contained data in this run, so here is the output, it could be all 4, or a combination of them.
{
"data": [
{
"Quoted_Items": [
{
"Product_Name": {
"id": "6685677000000839362"
},
"Quantity": 1,
"Description": "Some text"
},
{
"Product_Name": {
"id": "6685677000000839358"
},
"Quantity": 1,
"Description": "Some text"
},
{
"Product_Name": {
"id": "6685677000000839316"
},
"Quantity": 1,
"Description": "Some text"
}
],
"Subject": "Make Proposal",
"Proposal_Owner": {
"id": "6685677000000502001"
},
"Contact_Name": {
"id": "6685677000001013001"
},
"Company_Name": {
"id": "6685677000001374001"
}
}
]
}
I wasn’t sure if an aggregator was right. So basically stuck after module 130.
blueprint (1).json (432.4 KB)