Filter out items with check in external database

Questions
,
1

Hey dear n8n-community,

I tried a lot to do the following:
I get a few items via API which are transformed and enriched and everything works smoothly.
Now I came up with the idea that some items don’t have to be enriched multiple times so I built an Airtable Database where I save all enriched items with key “Name”.

Now I want to do an check, if the json item with variable “Name” is already in the list and if so to kick it out of the workflow.

I used the set Node and my idea was to use the search airtable entry module and find the items that already have an entry.

My example Data were 13 new items in the workflow and 6 of them we’re already enriched.

How do I kick out these 6 items on the condition that the names of the original items is equal to the names of the airtable output?

I got a bit confused with aggregators and tried to do it all in a code node, but I can’t get a hold of the 13 items I had before the 6 Items after the Airtable search.

I think I’m just missing a standard n8n concept, can somebody help me out?

Thanks in Advance!
Best, beninho

2

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:
3

Ah see, I just found the dropdown in the merge module, GG

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.