Hmmm…
The plugin can handle a list of things in bubble and returns an array of javascript objects. If I understand what you are asking for then it does not have that capability. I’ve proposed a workaround solution below.
Simple solution:
Store the text value of multiple child Items as a single list of texts inside parent Order. Do this just prior to running the JSONator workflow action.
Workflow
Step 1 Update thing
This Order
List of Customization Texts = Order's Item's Text (returns a list of texts)
Step 2 Run Jsonator
Input Thing:
This Order
Output JSON:
Order{
"list_of_customization_texts":[
"Initials = A.S.",
"Initials = "J.S.",
"Initials = n/a"]
}
Advanced Solution
If you don’t want to write to your db or have other needs that the above cannot provide, try this.
In JSONator you can delete any key:value pairs from your output JSON by including the line new_id : null to your configuration JSON for that key. The most succinct JSON expression you’ll be able to get from the plugin (by individually selecting every other key and deleting it) is an array of objects expressed as:
"Items":[
{"customization_text":"Initials = A.S."},
{"customization_text":"Initials = "J.S."},
{"customization_text":"Initials = n/a"}
]
I’d say give the below a try since I don’t know when I’ll get to adding this feature.
How to take an array of simple JSON objects and convert into an array of strings:
Once you’ve cleaned up your JSON to only show the field you want to turn into an array of texts, you’ll have a predicable string to work with in bubble using find/replace.
Example:
“Items”:[
{customization_text":“Initials = A.S.”},
{“customization_text”:"Initials = “J.S.”},
{“customization_text”:“Initials = n/a”}]
First, find your beginning text
{customization_text":
and replace with nothing
Find your delimiter text
},{"customization_text":
and replace with ,
Finally, find your end text
"}]
and replace with
"]
Your resulting text should be:
"Items":["Initials = A.S.","Initials = "J.S.","Initials = n/a"]
Which is a valid array of strings you generated from your array of JS objects.
Be careful with find/replace to avoid changing similar keys and syntax. The more specific, the better. You may also give regex a try as this provides more programatic control over find/replace
