Url expression not working. can someone point me where i went wrong please?

Describe the problem/error/question

When trying to patch an item via api I am experiencing an issue when using an expression in the URL.

If I statically set the URL like so, I have no issues updating the WorkOrder 21469
https://myserver.com/myapi/OData.svc/WorkOrders(21469)

Now when I try to use an expression and pull in the work order number I want to update you can see from the expression that it displays correctly however when I execute I receive an error.
It seems that the value of the expression is not being passed?

Error
“name”:
“Error”,
“stack”:
“Error: 405 - “<?xml version=\"1.0\" encoding=\"utf-8\"?><m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\”><m:code /><m:message xml:lang="en-AU">The URI ‘https://myserver/myapi/OData.svc/WorkOrders()’ is not valid for PUT operation. The URI must point to a single resource for PUT operations.</m:message></m:error>” at createError (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/createError.js:16:15) at settle (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/core/settle.js:17:12) at RedirectableRequest.handleResponse (/usr/local/lib/node_modules/n8n/node_modules/axios/lib/adapters/http.js:238:9) at RedirectableRequest.emit (node:events:529:35) at RedirectableRequest.emit (node:domain:489:12) at RedirectableRequest._processResponse (/usr/local/lib/node_modules/n8n/node_modules/follow-redirects/index.js:368:10) at ClientRequest.RedirectableRequest._onNativeResponse (/usr/local/lib/node_modules/n8n/node_modules/follow-redirects/index.js:65:10) at Object.onceWrapper (node:events:632:26) at ClientRequest.emit (node:events:517:28) at ClientRequest.emit (node:domain:489:12)"

Cheers

Information on your n8n setup

On prem
V1.15.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:

Hey @Petero,

Sadly you have cut off some information that might be important, Do you have multiple items coming into that node? My guess would be that one item has the externalId set but one of the others doesn’t and that is why it isn’t being used.

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