The source data contains several items, but the items are trimmed in the workflow

Questions
1

Describe the problem/error/question

The source data contains several items, but the items are trimmed in the workflow.

A brief description on my workflow:

  • Check Google Sheet
  • If the Sheet is empty, fill it with data from Strapi
  • If the Sheet is not empty, check every row
  • If documentId exist on a row, skip the row
  • If documentId does not exist, GET from Strapi, and fill the documentId if any
  • If it does not exist on Strapi, POST to Strapi, and fill the documentId

What is the error message (if any)?

(N/A)

Please share your workflow

Share the output returned by the last node

There are 7 items from the very beginning, but there are only 2 console.log().

Screenshot From 2024-12-04 10-43-54
Screenshot From 2024-12-04 10-43-541904×535 77.9 KB

Information on your n8n setup

  • n8n version: 1.69.2
  • Database (default: SQLite): PgSQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): ???
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu
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
  • n8n version: 1.69.2
  • Database (default: SQLite): PgSQL
  • n8n EXECUTIONS_PROCESS setting (default: own, main): ???
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Ubuntu
4

Hey @y2kbug , your interpretation of the output is not valid. Yu might notice that “Debug” node has number “2” depicted on the node’s surface. That means it ran twice - two iterations (as the dta came in from two separate inputs) where as all the other nodes ran only once. If you check the number of items for each iteration, they should add up.

Here is just an example how iterations looks like when there is more than one.

image
image662×380 20.8 KB