SnapLogic - Altering array elements in Mapper

Question

I currently have an incoming .json file that I am routing through a Mapper snap. In that mapper snap, I need to take an array of names bob.jones, eric.smith, etc, and add the string @email.com to each of them. The path for these names in the schema is:

jsonPath($, "$response.entity[*].target.name")

And the structure looks like this:

{
    "entity": [
        {
            "target": {
                "name": "bob.jones"
            }
        },
        {
            "target": {
                "name": "eric.smith"
            }
        },
        ...
    ]
}

Just mapping the path jsonPath($, "$response.entity[*].target.name") will pass the names and output bob.jones and eric.smith. I tried to use .concat() on the array but all that did was add @email.com into the list so I got bob.jones, eric.smith, @email.com. I am trying to figure out an expression that can edit the array items without changing their structure.

Can you also share the expected output JSON? – Bilesh Ganguly Nov 26 '19 at 22:32 — Bilesh Ganguly, Nov 26 '19 at 22:32

score 3 · Accepted Answer · answered Nov 26 '19 at 22:49

Based on the JSON path provided by you - jsonPath($, "$response.entity[*].target.name") - I created the following JSON.

{
    "response": {
        "entity": [
            {
                "target": {
                    "name": "bob.jones"
                }
            },
            {
                "target": {
                    "name": "eric.smith"
                }
            }
        ]
    }
}

And I put it in a JSON Generator so that I can get it as documents. Refer to the following screenshot.

If your desired output is as follows:

Then use the following expression in the mapper.

$response.entity.map(e => e.target.name + '@email.com')

Else if your desired output is as follows:

Then use the following setting in your mapper.

SnapLogic - Altering array elements in Mapper

1 Answers1