Convert Simple Array to Array Collection

How To
, ,
1

I am working with an array and I’m wondering if there is a way to convert it to array collection using text functions.

This is the current array

"Equipment List Array": [
                        "Two-Way Zoom",
                        "75'' TV Screen with stand",
                        "Post-it Flip Chart",
                        "Laptop",
                        "Platinum Corporate Reception"
                    ]

This is what I would like to have it look like.

"Equipment List": [
                        {
                            "Type": null,
                            "Name": "Two-Way Zoom",
                            "Description": null,
                            "Make ID": null,
                            "Xero ID": null,
                            "bigin ID": null,
                            "CUID": null,
                            "Cost": null,
                            "Xero Account": null
                        },
                        {
                            "Type": null,
                            "Name": "75'' TV Screen with stand",
                            "Description": null,
                            "Make ID": null,
                            "Xero ID": null,
                            "bigin ID": null,
                            "CUID": null,
                            "Cost": null,
                            "Xero Account": null
                        },
                        {
                            "Type": null,
                            "Name": "Post-it Flip Chart",
                            "Description": null,
                            "Make ID": null,
                            "Xero ID": null,
                            "bigin ID": null,
                            "CUID": null,
                            "Cost": null,
                            "Xero Account": null
                        },
                        {
                            "Type": null,
                            "Name": "Laptop",
                            "Description": null,
                            "Make ID": null,
                            "Xero ID": null,
                            "bigin ID": null,
                            "CUID": null,
                            "Cost": null,
                            "Xero Account": null
                        },
                        {
                            "Type": null,
                            "Name": "Platinum Corporate Reception",
                            "Description": null,
                            "Make ID": null,
                            "Xero ID": null,
                            "bigin ID": null,
                            "CUID": null,
                            "Cost": null,
                            "Xero Account": null
                        }
                    ]

This is the current text function to create the simple array

Screenshot 2024-05-11 at 16.09.39
Screenshot 2024-05-11 at 16.09.39916×1868 119 KB

And the blueprint if anyone wants to see it. I’m working on building out the data store to reduce the number of modules and to be able to access information on different routes that currently have a problem because of the iterators and aggregators.
blueprint-2.json (268.9 KB)

3

Hi @cre8iongroup,

You should be able to use an Iterator followed by JSON Aggregator for this.
Iterate your array, then use a JSON Aggregator to pop the items from the Equipment List Array into the “Name” for the equipment list collection.
For the JSON aggregator Data Structure, use the Generate option to build that based on the sample Equipment List you provided.

3 Likes