Forum Discussion

jfpelletier's avatar
jfpelletier
Contributor
2 years ago
Solved

Converting an array to a JSON payload

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

  • 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.

     

3 Replies

  • 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's avatar
      jfpelletier
      Contributor

      Hello koryknick,

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

      Kind regards,

      JF