Salesforce upsert node not working

Describe the problem/error/question

Hi, I crreated a workflow to create/update objects into Salesforce using a Custom Salesforce object of Create/Update kind.
The insert goes well, but the updater returns an error. I’va allready checked on salesforce and it’s all correct.
I resolved using an HTTP node, and it works like a charm. I’m raising the case just to notify you of the problem.
Best regards

What is the error message (if any)?

[
{
“busObPublicId”: “xxx”,
“busObRecId”: “xxx”,
“fields”: {
“ConfigurationItemTypeName”: “Config - Server”,
“Status”: “Active”,
“FriendlyName”: “xxx”,
“Hostname”: “xxx”,
“SerialNumber”: “”,
“CompanyName”: “xxx”,
“Environment”: “”,
“AssetTag”: “56608”,
“Manufacturer”: “”,
“Customer”: “”
},
“errorCode”: null,
“errorMessage”:null,
“hasError”: false,
“error”: “Bad request - please check your parameters”
}
]

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

{
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “2d2f75850d2e216d7609db8ed43a9324b8e1293bf64945ee84172f5256226c10”
},
“nodes”: [
{
“parameters”: {
“resource”: “customObject”,
“operation”: “upsert”,
“customObject”: “Configuration_Items__c”,
“externalId”: “CW_ID__c”,
“externalIdValue”: “={{ $json.busObRecId }}”,
“customFieldsUi”: {
“customFieldsValues”: [
{
“fieldId”: “Name”,
“value”: “={{ $json.busObPublicId }}”
},
{
“fieldId”: “Account__c”,
“value”: “xxx”
}
]
},
“additionalFields”: {}
},
“id”: “25fbd808-0ba2-44ab-b5b8-42812133ec0e”,
“name”: “Salesforce Create/Update Object”,
“type”: “n8n-nodes-base.salesforce”,
“typeVersion”: 1,
“position”: [
700,
-660
],
“credentials”: {
“salesforceOAuth2Api”: {
“id”: “xxx”,
“name”: “Salesforce account”
}
},
“onError”: “continueRegularOutput”
}
],
“connections”: {},
“pinData”: {}
}

Share the output returned by the last node

Information on your n8n setup

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

Hey @Zambot1971,

That is interesting an upsert seems to be working for me on the node :thinking: I wonder if it is an issue with the data we are sending.

I don’t know, but I resolved with an http node.
thank you anyway for your time.
regards