This is an insane workaround! The worst I have seen in my 4+ years working with Make/Integromat:
I need to use this replace() expression to remove the n’s so they don’t truncate the value:
{{replace(3.notes; "n"; "~")}}
This eliminates the truncating but now I have the pleasure of switching the ~ back to n’s in the resulting array I am aggregating.
[
{
"match": "Requestor Name:\nAlex",
"key": "Requestor Name",
"value": "Alex"
},
{
"match": "Email address of requester:\nalexs@~ewpathco~sulti~g.com",
"key": "Email address of requester",
"value": "alexs@~ewpathco~sulti~g.com"
},
{
"match": "Email Address of Customer Co~tact:\nMary@~ewpathco~sulti~g.com",
"key": "Email Address of Customer Co~tact",
"value": "Mary@~ewpathco~sulti~g.com"
},
{
"match": "First Name of Customer Co~tact:\nMary",
"key": "First Name of Customer Co~tact",
"value": "Mary"
},
{
"match": "What is the I~ve~tory ID for this item?:\nMARY",
"key": "What is the I~ve~tory ID for this item?",
"value": "MARY"
},
{
"match": "Customer Name:\nNewPath",
"key": "Customer Name",
"value": "NewPath"
},
{
"match": "Li~k to Item i~ Acumatica:\nhttps://~ewpathco~sulti~g.com",
"key": "Li~k to Item i~ Acumatica",
"value": "https://~ewpathco~sulti~g.com"
},
{
"match": "Is this pri~ted?:\nYes",
"key": "Is this pri~ted?",
"value": "Yes"
},
{
"match": "Is this pri~t black o~ly?:\nNo",
"key": "Is this pri~t black o~ly?",
"value": "No"
},
{
"match": "Have we pri~ted this color(s) previously for this customer o~ this material?:\nYes",
"key": "Have we pri~ted this color(s) previously for this customer o~ this material?",
"value": "Yes"
},
{
"match": "Is this item diecut?:\nNo",
"key": "Is this item diecut?",
"value": "No"
},
{
"match": "Will we be warehousi~g this item?:\nNo",
"key": "Will we be warehousi~g this item?",
"value": "No"
},
{
"match": "Delivery of first order date?:\nDec 29, 2022",
"key": "Delivery of first order date?",
"value": "Dec 29, 2022"
}
]
And here’s my set variable change from ~ back to n in the key and value, and the resulting arrray aggregator to get all the found key/value pair collections into 1 array:
And finally my beautiful array note “Frank” was not truncated and neither was Link to Item in Acumatica value URL which has an n in Main.
[
{
"array": [
{
"key": "Requestor Name",
"value": "Maggie"
},
{
"key": "Email address of requester",
"value": "maggie@newpath.com"
},
{
"key": "Email Address of Customer Contact",
"value": "yest@google.com"
},
{
"key": "First Name of Customer Contact",
"value": "Frank"
},
{
"key": "What is the Inventory ID for this item?",
"value": "K3319204KN5215"
},
{
"key": "Customer Name",
"value": "Vital"
},
{
"key": "Link to Item in Acumatica",
"value": "https://acumatica.korpack.com/KORPACK_ERP/(W(10042))/Main?ScreenId=PO301000&OrderType=RO&OrderNbr=037108"
},
{
"key": "Is this printed?",
"value": "No"
},
{
"key": "Is this item diecut?",
"value": "Yes"
},
{
"key": "Will we be warehousing this item?",
"value": "No"
},
{
"key": "Delivery of first order date?",
"value": "Nov 14, 2022"
}
],
"__IMTAGGLENGTH__": 11
}
]
The Match Element work around to eliminate truncating values with “n” in them:
