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

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().

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

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

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

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