- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2023 07:34 AM - edited ‎12-06-2023 08:00 AM
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
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2023 08:53 AM
@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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2023 08:53 AM
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-06-2023 01:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-17-2024 07:22 AM
Classic mapping! - Thanks @koryknick
