Describe the problem/error/question
Running a check conditions equals in Supabase to check if a GUID is already in there using get many rows
I have an RSS Read (Inoreader) > Supabase Check GUID (this fails on every single field i tried in the supabase table e.g. title, date etc. I need to check the supabase rows to see if the RSS item has already got an entry before i create a new one - theres a GUID thats added by inoreader. It cant recognise any Supabase rows when I check using the equals field it seems?
It seems getmany rows and adding a condition=equals doesnt actually work
I did try connecting via postgres but cant get that working
Have disabled RLS security in supabase
What is the error message (if any)?
No error but the flow doesnt work - i have 2 1 item in the DB and it should then see that the 2 new RSS items are not there and move to the next step
Please share your workflow
See diagram
(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)
{
“meta”: {
“instanceId”: “136b25e693e9dad9fbbfb5b1ebeb1add0798ae332fcc2907e59558bd639040fd”
},
“nodes”: [
{
“parameters”: {},
“id”: “fdf15854-1309-476e-9ad8-7e979dd0b296”,
“name”: “When clicking ‘Test workflow’”,
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
1000,
-1320
]
},
{
“parameters”: {
“url”: “A1Test via The AI Diva on Inoreader”,
“options”: {
“ignoreSSL”: false
}
},
“id”: “dfb3bade-c116-45b2-b152-362d7467ebb4”,
“name”: “RSS TAG Test”,
“type”: “n8n-nodes-base.rssFeedRead”,
“typeVersion”: 1.1,
“position”: [
1260,
-1340
],
“notes”: “This is my RSS Feed Folder Test Auto on INOR - it can be triggered on schedule? or via a webhook”
},
{
“parameters”: {},
“id”: “ebecf4d4-24e2-43c7-8d72-f87f4f3b9dd3”,
“name”: “No Operation, do nothing”,
“type”: “n8n-nodes-base.noOp”,
“typeVersion”: 1,
“position”: [
2140,
-1660
]
},
{
“parameters”: {
“tableId”: “rss_feed”,
“fieldsUi”: {
“fieldValues”: [
{
“fieldId”: “=title”,
“fieldValue”: “={{ $json.title }}”
},
{
“fieldId”: “=pub_date”,
“fieldValue”: “={{ $(‘RSS TAG Test’).item.json.pubDate }}”
},
{
“fieldId”: “content”,
“fieldValue”: “={{ $json.content }}”
},
{
“fieldId”: “description”,
“fieldValue”: “={{ $(‘RSS TAG Test’).item.json.contentSnippet }}”
},
{
“fieldId”: “=link”,
“fieldValue”: “={{ $json.link }}”
},
{
“fieldId”: “=guid”,
“fieldValue”: “={{ $json.guid }}”
},
{
“fieldId”: “=source”,
“fieldValue”: “={{ $json.link }}”
},
{
“fieldId”: “=creator”,
“fieldValue”: “={{ $json.creator }}”
},
{
“fieldId”: “should_draft_article”,
“fieldValue”: “True”
}
]
}
},
“id”: “1893731e-f6d6-4db0-bf1b-24d2327a315c”,
“name”: “Create RSS Item”,
“type”: “n8n-nodes-base.supabase”,
“typeVersion”: 1,
“position”: [
2240,
-1120
],
“credentials”: {
“supabaseApi”: {
“id”: “J2FCOAPIGHw67dUk”,
“name”: “Supabase account”
}
}
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: false,
“leftValue”: “”,
“typeValidation”: “loose”,
“version”: 2
},
“conditions”: [
{
“id”: “ac96abf0-1337-4157-9796-d1afe03e4601”,
“leftValue”: “={{ $json.guid }}”,
“rightValue”: “=1”,
“operator”: {
“type”: “string”,
“operation”: “contains”
}
}
],
“combinator”: “and”
},
“looseTypeValidation”: true,
“options”: {
“ignoreCase”: true
}
},
“id”: “9ee5f24b-2084-47d2-878d-d88295244422”,
“name”: “If SB GUID Does Not Exist”,
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2.2,
“position”: [
1780,
-1440
],
“notes”: “Checks by GUID if the rss item exists laready”
},
{
“parameters”: {
“operation”: “getAll”,
“tableId”: “rss_feed”,
“returnAll”: true,
“matchType”: “allFilters”,
“filters”: {
“conditions”: [
{
“keyName”: “guid”,
“condition”: “eq”,
“keyValue”: “={{ $json.guid }}”
}
]
}
},
“id”: “2a13043a-4658-4b3e-ac54-be59eef59ce8”,
“name”: “Supabase Check GUID”,
“type”: “n8n-nodes-base.supabase”,
“typeVersion”: 1,
“position”: [
1500,
-1300
],
“alwaysOutputData”: true,
“executeOnce”: false,
“credentials”: {
“supabaseApi”: {
“id”: “J2FCOAPIGHw67dUk”,
“name”: “Supabase account”
}
}
}
],
“connections”: {
“When clicking ‘Test workflow’”: {
“main”: [
[
{
“node”: “RSS TAG Test”,
“type”: “main”,
“index”: 0
}
]
]
},
“RSS TAG Test”: {
“main”: [
[
{
“node”: “Supabase Check GUID”,
“type”: “main”,
“index”: 0
}
]
]
},
“If SB GUID Does Not Exist”: {
“main”: [
[
{
“node”: “No Operation, do nothing”,
“type”: “main”,
“index”: 0
}
],
[
{
“node”: “Create RSS Item”,
“type”: “main”,
“index”: 0
}
]
]
},
“Supabase Check GUID”: {
“main”: [
[
{
“node”: “If SB GUID Does Not Exist”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {}
}
Share the output returned by the last node
Information on your n8n setup
- n8n version: Version 1.65.2
- Database (default: SQLite): default install
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): docker self hosted
- Operating system: ubuntu linux
