Dynamic URL in path using parameters from previous noed

Describe the issue/error/question

Hey there I am new to n8n and tying to familiarise myself. I am currently hitting a APP to get eCommerce orders, do some stuff with the data while hitting other APIs. As a last step I would like to POST a new object to that initial eCommerce order object. Everything works fine and reuccring except the last POST request.

Let’s say I have 10 orders I would like to add an additional shipping object to. The path is the following:

https:/e-commerce-api.com/orders/{{$node[“Set”].json[“order_id”]}}/fulfillments

whereas {{$node[“Set”].json[“order_id”]}} should be dynamically set for each order I fetched beofer.

I think the error is due to the dynamic path I need to hit.

What is the error message (if any)?

More than one row with the given identifier was found: 2309,

Please share the workflow

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Information on your n8n setup

  • n8n version: 0.197.1
  • Database you’re using (default: SQLite): SQLite
  • Running n8n with the execution process [own(default), main]: own
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: npm

That looks to be an error from your API, not n8n itself. Is there perhaps a different HTTP method you could be using to update instead of create? Like PATCH.

Otherwise you’re best off sharing some example data and your workflow to get some help.