Compare the data: if it doesn't exist, add it; if it does, skip it, but it keeps failing

Questions
1

Describe the problem/error/question

I tried to read the quotations created today in Odoo using n8n, and then compare them with the opportunities to see if there is an opportunity with the same customer name. If there isn’t an opportunity with the same name, create one; if there is, then skip it. However, the IF NODE never reaches TRUE. Why is that?

What is the error message (if any)?

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

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

You need to put the workflow json between a pair of triple backticks for it to get rendered properly:
```
Workflow json goes here
```

The </> button in post formatting bar creates such placeholder for you.

3

thank you.

4

If you could also pin some output data from the both of Odoo nodes this would be really helpful to understand the data structure and format.
You can also edit pinned data to obscure any sensitive data points.
You will need to pin the data in your actual workflow and then repost the workflow again.
Here is how to pin data: Google sheet: data is replaced in the existing row instead of adding new row - #8 by Olek

5

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