I am Sending '_' via http request node but it is sending '-' and that is causing issue in API call, data cannot insert

[haris_raza]

I am Sending ‘_’ via http request node but it is sending ‘-’ and that is causing issue in API call, data cannot insert

04 - “{\n\“error\” : {\n\“code\” : \“NotFoundException\”, \“message\” : {\n\“lang\” : \“en-US\”, \“value\” : \“FunctionImport User doesn’t exist in metadata!\”\n}\n}\n}”

input is

Default Locale en_US

{

“nodes”: [
{
“parameters”: {
“method”: “PUT”,
“url”: “https://api012.successfactors.eu/odata/v2/User”,
“authentication”: “genericCredentialType”,
“genericAuthType”: “httpBasicAuth”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Content-Type”,
“value”: “application/json”
},
{
“name”: “Accept”,
“value”: “application/json”
}
]
},
“sendBody”: true,
“specifyBody”: “json”,
“jsonBody”: “=\n{\n “userId”: “= {{ $(‘Google Sheets Trigger’).item.json.USERID }}”,\n “username”: “= {{ $json.Username }}”,\n “status”: “{{ $(‘Google Sheets Trigger’).item.json.Status }}”,\n “firstName”: “={{ $(‘Google Sheets Trigger’).item.json[‘First Name’] }}”,\n “lastName”: “={{ $(‘Google Sheets Trigger’).item.json[‘Last Name’] }}”,\n “email”: “={{ $(‘Google Sheets Trigger’).item.json.Email }}”\n}”,
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
460,
0
],
“id”: “ac61ffa8-a99f-44fd-aeb9-4d533af68bad”,
“name”: “HTTP Request1”,
“credentials”: {
“httpBasicAuth”: {
“id”: “Bh4KbbiNBvGMSzrP”,
“name”: “Unnamed credential”
}
}
},
{
“parameters”: {
“pollTimes”: {
“item”: [
{
“mode”: “everyHour”
}
]
},
“documentId”: {
“__rl”: true,
“value”: “1dMeSz7MyLbesfwNSHIML5Nx3h4WB9yJksiBtmCnHVvw”,
“mode”: “list”,
“cachedResultName”: “User Data File”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1dMeSz7MyLbesfwNSHIML5Nx3h4WB9yJksiBtmCnHVvw/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “Sheet1”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/1dMeSz7MyLbesfwNSHIML5Nx3h4WB9yJksiBtmCnHVvw/edit#gid=0”
},
“options”: {}
},
“type”: “n8n-nodes-base.googleSheetsTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “eca1be63-8930-4eca-8ede-bd54d899986d”,
“name”: “Google Sheets Trigger”,
“credentials”: {
“googleSheetsTriggerOAuth2Api”: {
“id”: “SZLtLRhomyvuI9PU”,
“name”: “Google Sheets Trigger account”
}
}
}
],
“connections”: {
“Google Sheets Trigger”: {
“main”: [
[
{
“node”: “HTTP Request1”,
“type”: “main”,
“index”: 0
}
]
]
}
},
“pinData”: {},
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “1b27a4674b900a8c77bdb20a51ecaf88c185b96735ec61962c1d4709155d224f”
}
}

(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.)

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:

[Msquare_Automation]

@haris_raza

{{ $(‘Google Sheets Trigger’).item.json.USERID }}

Hi @haris_raza
welcome to community
It looks like the issue is just that your JSON body is in the wrong mode for how n8n expects it. Right now it’s set as a full expression because of the = at the very start, and the extra = signs inside the quotes are making n8n try to evaluate things incorrectly. If you remove that first = and keep only the {{ }} expressions inside standard double quotes.

[haris_raza]

Still I getting the same thing,
Bad request - please check your parameters

400 - “{\n\“error\” : {\n\“code\” : \“BadRequestException\”, \“message\” : {\n\“lang\” : \“en-US\”, \“value\” : \“unknown property Default Locale for User\”\n}\n}\n}”
here is my JSON body
{
“userId”: “{{ $(‘Google Sheets Trigger’).item.json.USERID }}”,
“username”: “{{ $json.Username }}”,
“status”: “{{ $(‘Google Sheets Trigger’).item.json.Status }}”,
“firstName”: “{{ $(‘Google Sheets Trigger’).item.json[‘First Name’] }}”,
“lastName”: “{{ $(‘Google Sheets Trigger’).item.json[‘Last Name’] }}”,
“email”: “{{ $(‘Google Sheets Trigger’).item.json.Email }}”,
“Default Locale”: “{{ $(‘Google Sheets Trigger’).item.json[‘Default Locale’] }}”
}

and result in next window shows correct result but when i send it it converts it into - instead of _

[haris_raza]

any help plz