let say i have data structure like this {“first_name”: “asep”, “last_name”: “yana”, “age”: 12}. i want to make it to two array like this [“first_name”, “last_name”, “age”] and [“asep”, “yana”, 12]. how to do that in make.com?
If you have a collection,
You can use the built-in function keys to get the keys, and toArray and map to get the values:
e.g.:
Output
For more information, see the function documentation in the Help Center.
Module Export
You can copy and paste this module export into your scenario. This will paste the modules shown in my screenshots above.
-
Copy the JSON code below by clicking the copy button when you mouseover the top-right of the code block
-
Enter your scenario editor. Press ESC to close any dialogs. Press CTRLV (paste keyboard shortcut for Windows) to paste directly in the canvas.
-
Click on each imported module and save it for validation. You may be prompted to remap some variables and connections.
Click to Expand Module Export Code
JSON - Copy and Paste this directly in the scenario editor
{
"subflows": [
{
"flow": [
{
"id": 164,
"module": "json:ParseJSON",
"version": 1,
"parameters": {
"type": ""
},
"mapper": {
"json": "{ \"myObject\": \n {\"first_name\": \"asep\", \"last_name\": \"yana\", \"age\": 12}\n}"
},
"metadata": {
"designer": {
"x": 2795,
"y": -1786
},
"restore": {
"parameters": {
"type": {
"label": "Choose a data structure"
}
}
},
"parameters": [
{
"name": "type",
"type": "udt",
"label": "Data structure"
}
],
"expect": [
{
"name": "json",
"type": "text",
"label": "JSON string",
"required": true
}
]
}
},
{
"id": 165,
"module": "util:SetVariables",
"version": 1,
"parameters": {},
"mapper": {
"variables": [
{
"name": "keys",
"value": "{{keys(164.myObject)}}"
},
{
"name": "values",
"value": "{{map(toArray(164.myObject); \"value\")}}"
}
],
"scope": "roundtrip"
},
"metadata": {
"designer": {
"x": 3040,
"y": -1784
},
"restore": {
"expect": {
"variables": {
"items": [
null,
null
]
},
"scope": {
"label": "One cycle"
}
}
},
"expect": [
{
"name": "variables",
"type": "array",
"label": "Variables",
"spec": [
{
"name": "name",
"label": "Variable name",
"type": "text",
"required": true
},
{
"name": "value",
"label": "Variable value",
"type": "any"
}
]
},
{
"name": "scope",
"type": "select",
"label": "Variable lifetime",
"required": true,
"validate": {
"enum": [
"roundtrip",
"execution"
]
}
}
],
"interface": [
{
"name": "keys",
"label": "keys",
"type": "any"
},
{
"name": "values",
"label": "values",
"type": "any"
}
]
}
}
]
}
],
"metadata": {
"version": 1
}
}
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
3 Likes
thank u so much for helping
1 Like