# \#transform-array **URL:** https://community.n8n.io/tag/transform-array/8.md [Latest](https://community.n8n.io/latest.md) · [Categories](https://community.n8n.io/categories.md) · [Tags](https://community.n8n.io/tags.md) --- ## [How to get rid of a few elements in an array?](https://community.n8n.io/t/how-to-get-rid-of-a-few-elements-in-an-array/12251)
**Author:** [@Mikhail](https://community.n8n.io/u/Mikhail)\ **Replies:** 6\ **Last updated:** [January 4, 2026, 8:57pm UTC](https://community.n8n.io/t/how-to-get-rid-of-a-few-elements-in-an-array/12251 "2026-01-04T20:57:47Z")
Hi! Would you please tell me how to get rid of a few elements in an array? Remove unnecessary elements. I have an array: \[ { "Archived": false, "StartISEmpty": true, "DueISEmpty": true, "ClosedISEmpty": true, "Task I… --- ## [Array Mapping Issue: How to Create Single Shopify Order with Multiple Line Items](https://community.n8n.io/t/array-mapping-issue-how-to-create-single-shopify-order-with-multiple-line-items/225995)
**Author:** [@endrust](https://community.n8n.io/u/endrust)\ **Replies:** 9\ **Last updated:** [November 28, 2025, 10:18am UTC](https://community.n8n.io/t/array-mapping-issue-how-to-create-single-shopify-order-with-multiple-line-items/225995 "2025-11-28T10:18:02Z")
Describe the problem/error/question: My incoming data contains a single item with an array of line item objects, accessible at {{ $json.line\_items }}. This array contains all the necessary fields (variant\_id, quantity,… --- ## [Feature Request: Native Support for Mapping Arrays into Single API Requests (Without Auto-Splitting)](https://community.n8n.io/t/feature-request-native-support-for-mapping-arrays-into-single-api-requests-without-auto-splitting/227159)
**Author:** [@endrust](https://community.n8n.io/u/endrust)\ **Replies:** 0\ **Last updated:** [November 26, 2025, 10:29pm UTC](https://community.n8n.io/t/feature-request-native-support-for-mapping-arrays-into-single-api-requests-without-auto-splitting/227159 "2025-11-26T22:29:29Z")
The idea is: Add native support in n8n to map arrays into nested request fields without automatically splitting executions. Users should be able to: Map array fields into request bodies as-is Control whether arrays sh… --- ## [String to Array for API request](https://community.n8n.io/t/string-to-array-for-api-request/148438)
**Author:** [@Robert\_Macku](https://community.n8n.io/u/Robert_Macku)\ **Replies:** 3\ **Last updated:** [July 12, 2025, 10:52pm UTC](https://community.n8n.io/t/string-to-array-for-api-request/148438 "2025-07-12T22:52:51Z")
Hi I want to send API request to Qdrant for hybrid retrieval. To do this, I need to send proper array of vectors, but everytime I upload this {{ $json.data\[0\].embedding }}, even it is an Array in input, it changes to st… --- ## [Why the Microsoft SQL node doesn't pass output for all input items?](https://community.n8n.io/t/why-the-microsoft-sql-node-doesnt-pass-output-for-all-input-items/142167)
**Author:** [@Nematullah\_Hussaini](https://community.n8n.io/u/Nematullah_Hussaini)\ **Replies:** 1\ **Last updated:** [July 3, 2025, 3:00pm UTC](https://community.n8n.io/t/why-the-microsoft-sql-node-doesnt-pass-output-for-all-input-items/142167 "2025-07-03T15:00:21Z")
Here I get all the updated fields, like “Status”, “Name” etc then Create system notification for each. After that I want to send email notification and for that first I should get the template for each, but if the te… --- ## [How to send a list of items via single E-Mail](https://community.n8n.io/t/how-to-send-a-list-of-items-via-single-e-mail/9222)
**Author:** [@mfreudenberg](https://community.n8n.io/u/mfreudenberg)\ **Replies:** 18\ **Last updated:** [May 31, 2025, 3:10pm UTC](https://community.n8n.io/t/how-to-send-a-list-of-items-via-single-e-mail/9222 "2025-05-31T15:10:11Z")
Hi, i’m trying to send a single E-Mail that contains the result of a table query. My flow looks as follows: But when i execute it, the SeaTable node returns 10 items and thus the Send Email node sends 10 E-Mails. Bu… --- ## [Using the awesome jmespath with filter expressions to get a value from an array with a specific key](https://community.n8n.io/t/using-the-awesome-jmespath-with-filter-expressions-to-get-a-value-from-an-array-with-a-specific-key/12721)
**Author:** [@Jelle\_de\_Rijke](https://community.n8n.io/u/Jelle_de_Rijke)\ **Replies:** 3\ **Last updated:** [April 11, 2025, 9:03pm UTC](https://community.n8n.io/t/using-the-awesome-jmespath-with-filter-expressions-to-get-a-value-from-an-array-with-a-specific-key/12721 "2025-04-11T21:03:07Z")
Hi there fellow n8n-ers, So I recently tried the cool addition of jmespath for n8n. It’s awesome! So with a tool like: https://api.gopipeline.io/jmespath-tester you can input some json and try your query. Which works … --- ## [Filtering JSON array](https://community.n8n.io/t/filtering-json-array/70761)
**Author:** [@Asadrz11014](https://community.n8n.io/u/Asadrz11014)\ **Replies:** 2\ **Last updated:** [January 16, 2025, 10:45am UTC](https://community.n8n.io/t/filtering-json-array/70761 "2025-01-16T10:45:29Z")
I have https request node which outputs a JSON array which contains 10 job listing objects. I want to filter out some specific fields like the “image” and “jobProvider” key value pairs. Now i know i could do this by writ… --- ## [Help needed for iterating an array](https://community.n8n.io/t/help-needed-for-iterating-an-array/67575)
**Author:** [@Bisma\_Majeed](https://community.n8n.io/u/Bisma_Majeed)\ **Replies:** 2\ **Last updated:** [December 26, 2024, 7:22pm UTC](https://community.n8n.io/t/help-needed-for-iterating-an-array/67575 "2024-12-26T19:22:00Z")
Hi, so I am trying to iterate over an array and I was previously using make.com but it was pretty simple. im confused how to do that in n8n. So i am getting data from webhook and there is an array of objects called “rec… --- ## [Get value of an item from a Json array by ID and not by order](https://community.n8n.io/t/get-value-of-an-item-from-a-json-array-by-id-and-not-by-order/12146)
**Author:** [@patomi](https://community.n8n.io/u/patomi)\ **Replies:** 4\ **Last updated:** [December 18, 2024, 11:01pm UTC](https://community.n8n.io/t/get-value-of-an-item-from-a-json-array-by-id-and-not-by-order/12146 "2024-12-18T23:01:28Z")
Hello everyone, I’m trying to get a data from a json, and while it works for me most of the time, I think I’m not doing it right. I am receiving a json with several items, like this: For my part I want to extract t… --- ## [OpenAI Assistant Node: Expects String Instead of Array](https://community.n8n.io/t/openai-assistant-node-expects-string-instead-of-array/41827)
**Author:** [@rafaelxc](https://community.n8n.io/u/rafaelxc)\ **Replies:** 3\ **Last updated:** [March 3, 2024, 4:45am UTC](https://community.n8n.io/t/openai-assistant-node-expects-string-instead-of-array/41827 "2024-03-03T04:45:32Z")
Describe the problem/error/question I´m getting messages from a baserow database to send to an OpenAI assistant, since are multiples rows and columns on the DB to send i arregate all on one and then send to openai but it… --- ## [Transfer then split the items from an array of JSON into sheet](https://community.n8n.io/t/transfer-then-split-the-items-from-an-array-of-json-into-sheet/35880)
**Author:** [@mivtool](https://community.n8n.io/u/mivtool)\ **Replies:** 3\ **Last updated:** [January 27, 2024, 5:08pm UTC](https://community.n8n.io/t/transfer-then-split-the-items-from-an-array-of-json-into-sheet/35880 "2024-01-27T17:08:48Z")
Describe the problem/error/question I use the AI for generating the idea from my provided direction. The flow, I give the AI one direction, it will give me ideas for 7 days and all of those ideas have the same properties… --- ## [Combine Multiple Items into one Item. from a list pass only Items that match condition](https://community.n8n.io/t/combine-multiple-items-into-one-item-from-a-list-pass-only-items-that-match-condition/31370)
**Author:** [@0ne](https://community.n8n.io/u/0ne)\ **Replies:** 7\ **Last updated:** [November 3, 2023, 6:30pm UTC](https://community.n8n.io/t/combine-multiple-items-into-one-item-from-a-list-pass-only-items-that-match-condition/31370 "2023-11-03T18:30:41Z")
Hi all, been a while since I wasn’t able to figure out something myself which is good. but I have 2 main request that I need help with. Combine I have a work flow that sends a request to a LLM but its a sheet and it send… --- ## [Import list from Google Sheet - how do](https://community.n8n.io/t/import-list-from-google-sheet-how-do/30086)
**Author:** [@fxholl](https://community.n8n.io/u/fxholl)\ **Replies:** 1\ **Last updated:** [September 4, 2023, 10:25am UTC](https://community.n8n.io/t/import-list-from-google-sheet-how-do/30086 "2023-09-04T10:25:18Z")
I need to import a list of customers from a Google Sheet and send it in batches via HTTPS node to a CRM system. The data from Sheets looks like this: To send it in batch, the JSON needs to look like this: { “consu… --- ## [How to split data from JSON?](https://community.n8n.io/t/how-to-split-data-from-json/28647)
**Author:** [@Panupol\_Sonnuam](https://community.n8n.io/u/Panupol_Sonnuam)\ **Replies:** 1\ **Last updated:** [July 27, 2023, 11:16am UTC](https://community.n8n.io/t/how-to-split-data-from-json/28647 "2023-07-27T11:16:23Z")
I want to separate the meeting room information. myoutput\[ { “response”: { “returncode”: “SUCCESS”, “meetings”: { “meeting”: \[ { “meetingName”: “Home Room”, “meetingID”: “ipjtxxlmof4yskpz… --- ## [Question about splitting and bundles/array](https://community.n8n.io/t/question-about-splitting-and-bundles-array/28459)
**Author:** [@Sabbir\_Ahmed\_C](https://community.n8n.io/u/Sabbir_Ahmed_C)\ **Replies:** 2\ **Last updated:** [July 23, 2023, 5:28pm UTC](https://community.n8n.io/t/question-about-splitting-and-bundles-array/28459 "2023-07-23T17:28:39Z")
I want to understand how n8n handles array, so I have One csv parser, lets assume it creates 3 items HTTP API: It takes 3 items and creates 6 items each My question is it’s not knowable which HTTP item is correlated w… --- ## [Help with transformation](https://community.n8n.io/t/help-with-transformation/28118)
**Author:** [@MaaPer](https://community.n8n.io/u/MaaPer)\ **Replies:** 6\ **Last updated:** [July 17, 2023, 8:00am UTC](https://community.n8n.io/t/help-with-transformation/28118 "2023-07-17T08:00:06Z")
Describe the problem/error/question I need any clue on how to get this transformation form this JSON: \[ { "NIF del contacto": 77971197, "Concepto": "Concepto 1", "Precio unidad": 20 }, { "NIF del c… --- ## [How to send an array as individual rows to Postgres/any DB like Baserow etc](https://community.n8n.io/t/how-to-send-an-array-as-individual-rows-to-postgres-any-db-like-baserow-etc/27372)
**Author:** [@Jayavel](https://community.n8n.io/u/Jayavel)\ **Replies:** 4\ **Last updated:** [June 23, 2023, 11:59am UTC](https://community.n8n.io/t/how-to-send-an-array-as-individual-rows-to-postgres-any-db-like-baserow-etc/27372 "2023-06-23T11:59:37Z")
Describe the problem/error/question I have a node that outputs the dimensional values for pieces of text. The result is an array of different values as mentioned in the sample workflow below. I would like to send the val… --- ## [I am unable to use array functions inside expressions in input fields while mapping data from previous node](https://community.n8n.io/t/i-am-unable-to-use-array-functions-inside-expressions-in-input-fields-while-mapping-data-from-previous-node/26877)
**Author:** [@Bhawesh\_Kumar](https://community.n8n.io/u/Bhawesh_Kumar)\ **Replies:** 5\ **Last updated:** [June 12, 2023, 9:58am UTC](https://community.n8n.io/t/i-am-unable-to-use-array-functions-inside-expressions-in-input-fields-while-mapping-data-from-previous-node/26877 "2023-06-12T09:58:34Z")
Hi, From the previous node i have input like this \[{ "headers": { "host": "103.238.223.37:2291", "authorization": "YOUR\_AUTHORIZATION\_HEADER\_VALUE", "content-type": "application/json", … --- ## [Filter json](https://community.n8n.io/t/filter-json/14044)
**Author:** [@lsoldado](https://community.n8n.io/u/lsoldado)\ **Replies:** 5\ **Last updated:** [May 29, 2023, 9:41am UTC](https://community.n8n.io/t/filter-json/14044 "2023-05-29T09:41:45Z")
I have this json result. I need to get link result. The problem is each time i make a query, json result is not ordered, so the link can be in item0 or in item 10. This is my json: \[ { “id”: “36afbfe8-0741-454a-b81a… --- ## [How to group an array by one item?](https://community.n8n.io/t/how-to-group-an-array-by-one-item/26275)
**Author:** [@Lucas\_Vargas](https://community.n8n.io/u/Lucas_Vargas)\ **Replies:** 2\ **Last updated:** [May 17, 2023, 7:53pm UTC](https://community.n8n.io/t/how-to-group-an-array-by-one-item/26275 "2023-05-17T19:53:16Z")
Hello n8n community! This is my first question, hope you can give me a hand :grinning: I’m using a GET request to retrieve a JSON with all the orders of the business. The output of the request gives me all the orders in… --- ## [Not able to send JSON in correct format](https://community.n8n.io/t/not-able-to-send-json-in-correct-format/26284)
**Author:** [@Rohit\_Mali](https://community.n8n.io/u/Rohit_Mali)\ **Replies:** 1\ **Last updated:** [May 17, 2023, 2:49pm UTC](https://community.n8n.io/t/not-able-to-send-json-in-correct-format/26284 "2023-05-17T14:49:31Z")
Hi Team In one of my workflow I am fetching a array of json objects from code node and sending it to HTTP request node. I am trying to access the output of code node using {{$('Code).all() }} which is returning output … --- ## [Split json to array of items](https://community.n8n.io/t/split-json-to-array-of-items/25825)
**Author:** [@Yossi\_Yhezkel](https://community.n8n.io/u/Yossi_Yhezkel)\ **Replies:** 2\ **Last updated:** [May 3, 2023, 7:52pm UTC](https://community.n8n.io/t/split-json-to-array-of-items/25825 "2023-05-03T19:52:02Z")
Describe the problem/error/question so i have a json that comes as one item and i need to saperate it to multiply items What is the error message (if any)? ERROR: Code doesn’t return items properly Please return an ar… --- ## [API returns JSON object instead of Array - Cannot use items node](https://community.n8n.io/t/api-returns-json-object-instead-of-array-cannot-use-items-node/25381)
**Author:** [@timautomation](https://community.n8n.io/u/timautomation)\ **Replies:** 3\ **Last updated:** [April 24, 2023, 1:03pm UTC](https://community.n8n.io/t/api-returns-json-object-instead-of-array-cannot-use-items-node/25381 "2023-04-24T13:03:33Z")
Describe the problem/error/question I get the following API response from the LastPass API. How can I transform the following JSON to be used in the item node as I get the error that is no Array? I want to split out the … --- ## [Help - consolidate list for slack message](https://community.n8n.io/t/help-consolidate-list-for-slack-message/12049)
**Author:** [@yelsew](https://community.n8n.io/u/yelsew)\ **Replies:** 2\ **Last updated:** [March 10, 2022, 9:21am UTC](https://community.n8n.io/t/help-consolidate-list-for-slack-message/12049 "2022-03-10T09:21:56Z")
Hello! Im looking at getting a list of task that are assigned to a user in asana and have them sent a slack message with the Name and link { "name": "Send Sah Update of Tasks", "nodes": \[ { "parameters": {… --- ## [Array conversion](https://community.n8n.io/t/array-conversion/24716)
**Author:** [@Victor\_Hugo](https://community.n8n.io/u/Victor_Hugo)\ **Replies:** 1\ **Last updated:** [April 4, 2023, 8:55am UTC](https://community.n8n.io/t/array-conversion/24716 "2023-04-04T08:55:05Z")
Good morning Would there be any way to convert items from within an array that are strings to number? I need this to: \[“1”, “2”, “3”, “4”, “5”\] turn \[1, 2, 3, 4, 5\] Would it be using node code? --- ## [Combine Multiple Set Commands Into One Array](https://community.n8n.io/t/combine-multiple-set-commands-into-one-array/24400)
**Author:** [@Irving\_C](https://community.n8n.io/u/Irving_C)\ **Replies:** 1\ **Last updated:** [March 23, 2023, 9:12am UTC](https://community.n8n.io/t/combine-multiple-set-commands-into-one-array/24400 "2023-03-23T09:12:41Z")
I have 3 set commands each with an array of data. How do I combine all these into just one array. I’ve tried Item List and concatenate but it just adds them all into 3 arrays instead of just one. --- ## [Issue extracting data from array code node](https://community.n8n.io/t/issue-extracting-data-from-array-code-node/23588)
**Author:** [@Philip\_Wiggins](https://community.n8n.io/u/Philip_Wiggins)\ **Replies:** 5\ **Last updated:** [March 1, 2023, 3:56pm UTC](https://community.n8n.io/t/issue-extracting-data-from-array-code-node/23588 "2023-03-01T15:56:52Z")
Describe the issue/error/question I have an API that is sending me this JSON. And I’m not sure the following is correct or if there is a better way \[{ "headers": { "host": "stellium.app.n8n.cloud", "x-request-id": … --- ## [How to get two distinct input arrays into a single \`Code\` node and iterate over them both? Merge is not suitable!](https://community.n8n.io/t/how-to-get-two-distinct-input-arrays-into-a-single-code-node-and-iterate-over-them-both-merge-is-not-suitable/23333)
**Author:** [@hdotking](https://community.n8n.io/u/hdotking)\ **Replies:** 1\ **Last updated:** [February 23, 2023, 10:01am UTC](https://community.n8n.io/t/how-to-get-two-distinct-input-arrays-into-a-single-code-node-and-iterate-over-them-both-merge-is-not-suitable/23333 "2023-02-23T10:01:22Z")
Problem I have a list of calendar events, each with an array of attendees. I want to iterate over each attendee in each event and check if their email address exists in our CRM. To do this I need to get a list of airtabl… --- ## [Node HTTP : parameter is expected to be of type "array", but is of type "string"](https://community.n8n.io/t/node-http-parameter-is-expected-to-be-of-type-array-but-is-of-type-string/22399)
**Author:** [@MPO](https://community.n8n.io/u/MPO)\ **Replies:** 1\ **Last updated:** [February 5, 2023, 11:57am UTC](https://community.n8n.io/t/node-http-parameter-is-expected-to-be-of-type-array-but-is-of-type-string/22399 "2023-02-05T11:57:01Z")
Hi everyone ! I try to send a patch/post with http-node to SuiteCRM. I’m able to do that with fix data. For exemple, it’s OK with : {{ {"type": "AOS\_Products", "id": "d56eaa13-b3e5-197f-b060-630a426533cd", "attribu… [Next page](https://community.n8n.io/tag/transform-array/8.md?match_all_tags=true&page=1&tags%5B%5D=transform-array)