Create JSON array of values from an Array Aggregator array

[AdamFeilding]

Hello, I am new to Make and am struggling to correctly format a JSON array.

I have a scenario that parses email text to find all the URLs and uses an Array Aggregator to create an array of objects. It then uses a Create JSON module to put the URL values only into a JSON array, however it only seems to include the first item of the array.

Array aggregator input:

[
    {
        "__IMTMATCH__": "https://www.example.com"
    },
    {
        "__IMTMATCH__": "https://www.example2.com"
    }
]

Array aggregator output:

[
    {
        "array": [
            {
                "__IMTMATCH__": "https://www.example.com"
            },
            {
                "__IMTMATCH__": "https://www.example2.com"
            }
        ],
        "__IMTAGGLENGTH__": 2
    }
]

Relevant field in the JSON data structure:

JSON builder module input:

[
    {
        "body": "Some email text\r\n\r\nhttps://www.example.com\r\nhttps://www.example2.com\r\n",
        "links": [
            "https://www.example.com"
        ],
        "sender": "email@email.com",
        "subject": "Testing",
        "recipient": “email@email.com"
    }
]

Any ideas on how to convert the Array Aggregator array of objects to a complete JSON array of text values would be much appreciated.

[Greatness_Automation]

Hey @AdamFeilding , welcome to make community. The array aggregator returns JSON as output. I believe what you are trying to do access the items in the array, right?

[AdamFeilding]

Yes that’s right, trying to get the JSON builder to access just the specific URL string values to put into an array of strings

[Greatness_Automation]

You can use inline functions. The ones you need are map() and get()

[AdamFeilding]

Thanks. I added the map() funciton to the array field in the JSON builder and it seems to be working correctly:

[Misha-Inactive]

Hello @AdamFeilding

Thank you for coming back and sharing the solution. I believe it will help many other Makers!