Supabase get many rows node not returning all matching rows

[chetanmore669]

Describe the problem/error/question

I am using supabase get many rows node to grab matching rows from supabase table.
instead of 6 rows it is returning 4 rows.

What is the error message (if any)?

Please share your workflow/screenshots/recording

(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.)
⚠️ WARNING ⚠️ If you have sensitive data in your workflow (like API keys), please remove it before sharing.

{
"nodes": [
{
"parameters": {
"amount": 1
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
-8380,
4560
],
"id": "87ed00f2-227b-416c-8d85-9efbc8a26f60",
"name": "Wait7",
"webhookId": "c6f37922-c7e3-4fe7-a289-2334fd878d66",
"executeOnce": true
},
{
"parameters": {
"operation": "getAll",
"tableId": "LLM_UserValues",
"returnAll": true,
"filters": {
"conditions": [
{
"keyName": "Project_RequestID",
"condition": "eq",
"keyValue": "={{ $('Webhook1').first().json.body.ticketNumber }}"
}
]
}
},
"type": "n8n-nodes-base.supabase",
"typeVersion": 1,
"position": [
-8180,
4560
],
"id": "cf4af1a0-f182-4273-8483-c2cc9a0ca17b",
"name": "LLM_USER_Values_Get2",
"executeOnce": false,
"credentials": {
"supabaseApi": {
"id": "zEfyRp62VJnqr6EA",
"name": "Supabase account 2"
}
}
}
],
"connections": {
"Wait7": {
"main": [
[
{
"node": "LLM_USER_Values_Get2",
"type": "main",
"index": 0
}
]
]
},
"LLM_USER_Values_Get2": {
"main": [
[]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "fb0330c12168d8986a25e32969e039658f672faf5d3467655ca2db5a9ecea7e5"
}
}

Share the output returned by the last node

Debug info

core

• n8nVersion: 1.81.4
• platform: docker (cloud)
• nodeJsVersion: 20.18.3
• database: sqlite
• executionMode: regular
• concurrency: 20
• license: community

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: filesystem

pruning

• enabled: true
• maxAge: 720 hours
• maxCount: 25000 executions

client

• userAgent: mozilla/5.0 (windows nt 10.0; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/134.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2025-03-12T20:02:50.561Z}

[Joffcom]

Hey @chetanmore669,

We have created an internal ticket to look into this which we will be tracking as "GHC-1170"

[Joffcom]

Hey @chetanmore669,

If those API keys are valid you may want to change them, I can't see a reason as to why it would only return 4 items is it possible that the records in the database have hidden characters?

If you use the Get All without the filter does it work? Maybe using that we can work out what is going on.

[chetanmore669]

Hello Joffcom,

I copied the same node and used same project ID to grab rows from the table in a new workflow and its returning 6 rows.

But its not happening in the main workflow.

Thanks,

[Joffcom]

Hey @chetanmore669

That is odd but would maybe suggest an issue with the workflow.

Sadly I am not able to reproduce this, what happens if copy the node in the main workflow and try it again?

[chetanmore669]

Hello Joffcom,

I deleted that node & created a new node (with a new name) in its place .
At first try it correctly returned all matching 6 rows.
At second try it returned matching 5 rows and it continues to return 5 rows every time I run it.

[chetanmore669]

Please advice

[Joffcom]

Hey @chetanmore669,

I am not able to reproduce this and I don't know why. Are you using Cloud hosted Supabase or self hosted Supabase? It may be worth trying to make the same API call manually to see what happens.

[Joffcom]

As we haven’t heard back from you, we’re going to close this issue to keep things organized. But don’t worry, if you have more information or need further assistance, you’re welcome to reopen the issue anytime or create a new one. We’re always happy to help!

Thanks for reaching out and have a great day! If this was closed by mistake and you have been waiting for us let me know and I can also re-open it.