Neested API call and merge results


I’m currently trying to achieve a “simple in my mind” workflow against magento 2 using the default node.

My goal is to make a questo to “get all order” from today, loop over results and make a query to get customer for each orders to retrieve customer specific attributes in custom_attributes key.

but i’m struggle on how to merge the two results from api call.

Ultimate goal is to make a spredsheet with few fields from Orders and customer like

Order : created_at, updated_at,customer_firstname, customer_lastname, customer_email,increment_id
Customer : custom_attributes[‘backend_number’]

This is what I start but i struggle a little bit…
Any help is much appreciated :slight_smile:

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

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:

@mitchum , as I have no idea how the Magento data looks like, I am showing just how to merge orders and customers when the Loop node is engaged generally. You would have to add the actual merging criteria yourself in the Merge node.

1 Like

Thanks you so much it’s what i needed !!

(combined with edit fields + rename key) and i got the expected results.

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