Converting an array to a JSON payload

[jfpelletier]

Hello all,

I need to convert an array of ID values into a JSON payload, and I cannot find any array function that can iterate the values of the list to generate what I need.

My array of IDs looks like this: ["r4ige6rwgvnr", "4nkmdoijydfj9", "6ashbd99w3"]

The payload that I need is:

{
    "ids": [
        {
            "id": "r4ige6rwgvnr"
        },
        {
            "id": "4nkmdoijydfj9"
        },
        {
            "id": "6ashbd99w3"
        }
    ]
}

Is there a way (ideally built-in method) to iterate each ID from the array and generate the JSON format that I need?

Thanks a lot in advance!

JF

[koryknick · Accepted solution]

@jfpelletier - assuming this input document:

{"ids":["r4ige6rwgvnr","4nkmdoijydfj9","6ashbd99w3"]}

Configure a Mapper expression as follows:

Should provide the desired output.  Take a look at the Array.map() documentation for description.  The Javascript documentation linked in the SnapLogic documentation has some excellent details and examples.  Basically the statement shown above is turning each string value in the array to an object.

[jfpelletier]

Hello @koryknick,

Thanks a lot for this, it works exactly as you suggested! 🙂

Kind regards,

JF