Working with JSON array

Hello,
My question has a simple answer but I could not find it after searching for hours.
I am using HTTP node with GET and it parses a JSON

JSON structure as is follows:

[
  {
	"data": {
	  "results": [
		{
		  "id": 3700,
		  "created_at": "2024-04-04T09:36:57.228715-04:00",
		  "updated_at": "2024-04-04T09:36:57.228715-04:00",
		  "uuid": "someID,
		  "email": "[email protected]",
		  "name": "some name",
		  "attribs": {},
		  "status": "enabled",
		  "lists": [
			{
			  "subscription_status": "confirmed",
			  "subscription_created_at": "2024-04-04T09:36:57.228715-04:00",
			  "subscription_updated_at": "2024-04-04T09:36:57.228715-04:00",
			  "subscription_meta": {},
			  "id": 8,
			  "uuid": "SomeID",
			  "name": "somename",
			  "type": "private",
			  "optin": "single",
			  "tags": [
				"sometag"
			  ],
			  "description": "",
			  "created_at": "2024-04-04T09:02:41.780219-04:00",
			  "updated_at": "2024-04-04T09:36:57.341805-04:00"
			}
		  ]
		},
		{
		  "id": 3699,
		  "created_at": "2024-04-04T09:36:57.228715-04:00",
		  "updated_at": "2024-04-04T09:36:57.228715-04:00",
		  "uuid": "f991eeda-4bfe-4528-912f-2a8b606fd4ee",
		  "email": "[email protected]",
		  "name": "some name",
		  "attribs": {},
		  "status": "enabled",
		  "lists": [
			{
			  "subscription_status": "confirmed",
			  "subscription_created_at": "2024-04-04T09:36:57.228715-04:00",
			  "subscription_updated_at": "2024-04-04T09:36:57.228715-04:00",
			  "subscription_meta": {},
			  "id": 8,
			  "uuid": "someID",
			  "name": "somename",
			  "type": "private",
			  "optin": "single",
			  "tags": [
				"sometag"
			  ],
			  "description": "",
			  "created_at": "2024-04-04T09:02:41.780219-04:00",
			  "updated_at": "2024-04-04T09:36:57.341805-04:00"
			}
		  ]
		},

You can see the scheme below:

I want to filter this results by using one key within results items by using filter node but filter node works only for 1 item. How can I make it work for each item instead of one.

What I am doing now is:


As you see it works for only one result. I have tried to write and expression but also did not work.

My aim to get some specified email address and and after that change other key value within the result.

Thank you

  • n8n version: 1.36.2
  • Database (default: SQLite): -
  • n8n EXECUTIONS_PROCESS setting (default: own, main): Default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
1 Like

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Just added

1 Like

Hello @No_Name
Use tge split out node before filter node and set it to use data.results field