Map multiple values from one Array to another

How To
1

I have an output bundle where a portion of the output looks like this:

[
        "data": {
            "custom_data": [
                {
                    "answer": [
                        "example 1"
                    ],
                    "custom_data_id": 554,
                },
                {
                    "answer": [
                        "example 1",
                        "example 2"
                    ],
                    "custom_data_id": 555,
                }
            ]
        },
        "fileSize": 35170
    }
]

If custom_data_id = 555, I would like to map the string values to ids, e,g:

{
  "example 1": 1234567,
  "example 2": 7890123,
  "example n": 6576878
}

Ideally, I then recreate the original object with the updated values so that the output becomes:

[
        "data": {
            "custom_data": [
                {
                    "answer": [
                        "example 1"
                    ],
                    "custom_data_id": 554,
                },
                {
                    "answer": [
                        "1234567",
                        "7890123"
                    ],
                    "custom_data_id": 555,
                }
            ]
        },
        "fileSize": 35170
    }
]

What is a good pattern (or any pattern really) to use when the number of possible strings is relatively high (e.g. 50+)?

2

Welcome to the Make community!

Yes, that is possible. You’ll need a minimum of one module:

Screenshot_2025-04-01_170437
Screenshot_2025-04-01_170437633×842 47.2 KB

This is just an example. Your final solution may or may not look like this depending on your requirements.

You can get this free custom app from this topic: Is there a way to count tokens?

Module Export - quick import into your scenario

You can copy and paste this module export into your scenario. This will import the modules (with fields/settings/filters) shown in my screenshots above.

  1. Move your mouse over the line of code below. Copy the JSON by clicking the copy button on the right of the code, which looks like this:

  2. Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the editor.

  3. Click on each imported module and re-save it for validation. There may be some errors prompting you to remap some variables and connections.

JSON module export — paste this directly in your scenario

{"subflows":[{"flow":[{"id":254,"module":"json:ParseJSON","version":1,"parameters":{"type":""},"mapper":{"json":"{\"mappings\": {\"example 1\":1234567,\"example 2\":7890123,\"example n\":6576878}}"},"metadata":{"designer":{"x":1072,"y":-1916,"name":"Mappings"},"parameters":[{"name":"type","type":"udt","label":"Data structure"}]}},{"id":252,"module":"json:ParseJSON","version":1,"parameters":{"type":""},"mapper":{"json":"[{\"data\":{\"custom_data\":[{\"answer\":[\"example 1\"],\"custom_data_id\":554},{\"answer\":[\"example 1\",\"example 2\"],\"custom_data_id\":555}]},\"fileSize\":35170}]"},"metadata":{"designer":{"x":1315,"y":-1917,"name":"HTTP module output"},"parameters":[{"name":"type","type":"udt","label":"Data structure"}]}},{"id":255,"module":"app#sams-toolbox-mls54z:basicjs","version":1,"parameters":{},"mapper":{"code":"// Define functions here\nconst mapAnswersToIds = (obj) => {\n  return obj.map((v, i) => {\n    if (v.custom_data_id == 555)\n      obj[i].answer = obj[i].answer.map(v => mappings[v] ?? v);\n    return obj[i];\n  });\n}\n\n// Call function with module input, and store result in variable\nconst mappings = input.mappings;\nconst custom_data = mapAnswersToIds(input.custom_data);\n\n// Module output. Variable names separated by commas\n({ custom_data })","input":[{"key":"mappings","value":"{{254.mappings}}"},{"key":"custom_data","value":"{{252.data.custom_data}}"}]},"metadata":{"designer":{"x":1557,"y":-1913}}}]}],"metadata":{"version":1}}

Note: Did you know you can reduce the size of blueprints and module export code like the above, using the Make Blueprint Scrubber?

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

2 Likes
3

Appreciate this! I managed to solve this using a few cumbersome steps, but will keep an eye out for your custom apps in the future.

1 Like