BaseRow Node Get all Rows Problems

Describe the problem/error/question

I´m trying to build an automation that delete all rows from a table in baserow that has a column field empty.
Since there are thousands of lines im trying to create a loop. It works on the first run, i put a limit of 50 results it works ok on the first run, on second run it returns 2500 itens but gives an error on the node to delete the rows, it says that id was not found. When I check , other 50 rows were deleted but the automation stops due to the error.

In summary on second run it returns 2500 instead of 50 it deletes the other 50 rows but return error.

What is the error message (if any)?

Please share your workflow

{
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “7b1a2a66d3e90bfc7aa42d96e295fd40153b4d58451fc70a7bd5753ac50f78e2”
},
“nodes”: [
{
“parameters”: {},
“id”: “7e158b5d-a5de-4e9e-9056-aa88f0c3d2b9”,
“name”: “When clicking "Test workflow"”,
“type”: “n8n-nodes-base.manualTrigger”,
“typeVersion”: 1,
“position”: [
820,
360
]
},
{
“parameters”: {
“conditions”: {
“options”: {
“caseSensitive”: true,
“leftValue”: “”,
“typeValidation”: “strict”
},
“conditions”: [
{
“id”: “25b80d06-2cb1-40d9-9cea-57b4fd92f982”,
“leftValue”: “={{ $item("0").$node["Baserow1"].json["success"] }}”,
“rightValue”: “false”,
“operator”: {
“type”: “boolean”,
“operation”: “false”,
“singleValue”: true
}
}
],
“combinator”: “and”
},
“options”: {}
},
“id”: “3f7d02df-dd48-4ead-8591-6c59985e5b93”,
“name”: “If”,
“type”: “n8n-nodes-base.if”,
“typeVersion”: 2,
“position”: [
1440,
360
]
},
{
“parameters”: {},
“id”: “ca050c2e-d500-4a2f-af10-adbc343c02ec”,
“name”: “No Operation, do nothing”,
“type”: “n8n-nodes-base.noOp”,
“typeVersion”: 1,
“position”: [
1720,
340
]
},
{
“parameters”: {
“databaseId”: 94040,
“tableId”: 259064,
“additionalOptions”: {
“filters”: {
“fields”: [
{
“field”: 1836912,
“operator”: “empty”
}
]
}
}
},
“id”: “48f4dcc3-f14b-481d-af54-d26aa596cd94”,
“name”: “Baserow”,
“type”: “n8n-nodes-base.baserow”,
“typeVersion”: 1,
“position”: [
1040,
360
],
“credentials”: {
“baserowApi”: {
“id”: “Ow8AofQkyGs9A46s”,
“name”: “Baserow account”
}
}
},
{
“parameters”: {
“operation”: “delete”,
“databaseId”: 94040,
“tableId”: 259064,
“rowId”: “={{ $json.id }}”
},
“id”: “3ee56e78-f8bc-45ae-98af-0a8cb446e286”,
“name”: “Baserow1”,
“type”: “n8n-nodes-base.baserow”,
“typeVersion”: 1,
“position”: [
1260,
360
],
“retryOnFail”: false,
“maxTries”: 2,
“credentials”: {
“baserowApi”: {
“id”: “Ow8AofQkyGs9A46s”,
“name”: “Baserow account”
}
}
}
],
“connections”: {
“When clicking "Test workflow"”: {
“main”: [
[
{
“node”: “Baserow”,
“type”: “main”,
“index”: 0
}
]
]
},
“If”: {
“main”: [
[
{
“node”: “No Operation, do nothing”,
“type”: “main”,
“index”: 0
}
],
[
{
“node”: “Baserow”,
“type”: “main”,
“index”: 0
}
]
]
},
“Baserow”: {
“main”: [
[
{
“node”: “Baserow1”,
“type”: “main”,
“index”: 0
}
]
]
},
“Baserow1”: {
“main”: [
[
{
“node”: “If”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {}
}

Information on your n8n setup

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

hello @rafaelxc

The loop is incorrect. You are executing the Baserow on the second run for each of the Baserow’s items from the first run, so you will receive 50x50 - 2500 items (where the first 50 are original and the rest 2450 are duplicates) instead of the next 50 empty items.

Try this one

2 Likes

Thanks for that! Do you mind explaining how this aggregate node works?

it just combines all the items of the previous node into one item. That is needed for the proper loop to work

1 Like

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