SQS not accepting json

Garrett_Sergeant · January 15, 2024, 11:20pm

I’ve been trying to submit a json payload to SQS, but I keep getting a 400 error:

NodeApiError: Bad request - please check your parameters
    at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Aws/SQS/AwsSqs.node.js:316:27)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:696:19)
    at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:656:53

If I submit the same message outside of an array or object it submits without issue. Examples I see on n8n indicate it should be fine to pass along an array to SQS. Here’s an example array:

[
{
“user_id”: “-------”,
“system_domain_id”: “-------”,
“assetID”: “2bab039e-a9ca-11ee-8675-3e8e6ebdf7dc”,
“workflowID”: “b67b7a4d-9767-4899-8fc1-38c52ca7abec”,
“date_created”: “2024-01-15T23:19:28.651888”,
“auth_token”: “-------”
}
]

n8n · January 15, 2024, 11:20pm

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:

Garrett_Sergeant · January 16, 2024, 3:55am

n8n version: Version 1.22.6
Database: SQLite
n8n Executions Process: ?? default
Running on: Docker
OS: Ubuntu 22.04

Thiago_Goveia · January 16, 2024, 3:38pm

Same issue here

n8n version: Version 1.22.6
Database: SQLite
n8n default
Running on: Docker
OS: Ubuntu 22.04

Thiago_Goveia · January 16, 2024, 3:48pm

Downgrading to v1.21.1 seems to fix the issue for now

Garrett_Sergeant · January 16, 2024, 5:50pm

Yeah, that seems to have done the trick

Thiago_Goveia · January 16, 2024, 11:40pm

To whoever finds this, I found a work around. The issue goes away if you URI encode your object before sending it.

{{ encodeURIComponent(JSON.stringify($json)) }}

Jon · January 17, 2024, 11:10am

Hey @Thiago_Goveia,

Nice find, I was about to start looking into this one.

Jon · January 18, 2024, 12:25pm

I have just put in a fix for this which can be found below, Once reviewed and merged it will be available in a future release.

github.com/n8n-io/n8n

fix(AWS SQS Node): Fix issue preventing data from being sent correctly

n8n-io:master ← n8n-io:gh/8353

opened 12:15PM - 18 Jan 24 UTC

Joffcom

+9 -3

## Summary This fixes multiple issues with the data not being sent correctly in… the AWS SQS Node. - We were failing to send JSON input data - resulted in a 400 response - We were sending Expression JSON as [object Object] - We were failing to send JSON strings / anything string with certain characters in it - resulted in a 400 response ## Related tickets and issues https://github.com/n8n-io/n8n/issues/8353 https://community.n8n.io/t/sqs-not-accepting-json/35340 ## Review / Merge checklist Test workflow ``` { "meta": { "templateCredsSetupCompleted": true, "instanceId": "8c8c5237b8e37b006a7adce87f4369350c58e41f3ca9de16196d3197f69eabcd" }, "nodes": [ { "parameters": {}, "id": "382e8930-16ba-4cb6-83b0-7ce0009667bb", "name": "When clicking \"Test Workflow\"", "type": "n8n-nodes-base.manualTrigger", "typeVersion": 1, "position": [ 720, 300 ] }, { "parameters": { "fields": { "values": [ { "name": "test", "stringValue": "test" } ] }, "options": {} }, "id": "1fd6165f-7b7d-4afd-acd8-84316990e8f4", "name": "Edit Fields", "type": "n8n-nodes-base.set", "typeVersion": 3.2, "position": [ 980, -20 ] }, { "parameters": { "queue": "https://sqs.eu-west-1.amazonaws.com/551799878281/test", "options": {} }, "id": "0b47666a-e285-483e-be65-b2ea7494b167", "name": "Send Input Data", "type": "n8n-nodes-base.awsSqs", "typeVersion": 1, "position": [ 1260, -20 ], "credentials": { "aws": { "id": "qkJnhArcHAVcCB2t", "name": "AWS account" } }, "onError": "continueErrorOutput" }, { "parameters": { "queue": "https://sqs.eu-west-1.amazonaws.com/551799878281/test", "sendInputData": false, "message": "={{ { \"my_field_1\": \"value\", \"my_field_2\": 1 } }}", "options": {} }, "id": "9f20ec7d-3fad-4ab2-a630-480aba558ee1", "name": "Send Expression JSON", "type": "n8n-nodes-base.awsSqs", "typeVersion": 1, "position": [ 1260, 160 ], "credentials": { "aws": { "id": "qkJnhArcHAVcCB2t", "name": "AWS account" } }, "onError": "continueErrorOutput" }, { "parameters": { "queue": "https://sqs.eu-west-1.amazonaws.com/551799878281/test", "sendInputData": false, "message": "{ \"my_field_1\": \"value\", \"my_field_2\": 1 }", "options": {} }, "id": "e6b6bc73-a8b6-4f45-a40a-90b0b2d94032", "name": "Send String JSON", "type": "n8n-nodes-base.awsSqs", "typeVersion": 1, "position": [ 1260, 360 ], "credentials": { "aws": { "id": "qkJnhArcHAVcCB2t", "name": "AWS account" } }, "onError": "continueErrorOutput" }, { "parameters": { "queue": "https://sqs.eu-west-1.amazonaws.com/551799878281/test", "sendInputData": false, "message": "This is a test", "options": {} }, "id": "10f99cf6-7da1-4ab5-bc85-d3ad30107ce6", "name": "Send String", "type": "n8n-nodes-base.awsSqs", "typeVersion": 1, "position": [ 1260, 540 ], "credentials": { "aws": { "id": "qkJnhArcHAVcCB2t", "name": "AWS account" } }, "onError": "continueErrorOutput" } ], "connections": { "When clicking \"Test Workflow\"": { "main": [ [ { "node": "Send Expression JSON", "type": "main", "index": 0 }, { "node": "Send String JSON", "type": "main", "index": 0 }, { "node": "Send String", "type": "main", "index": 0 }, { "node": "Edit Fields", "type": "main", "index": 0 } ] ] }, "Edit Fields": { "main": [ [ { "node": "Send Input Data", "type": "main", "index": 0 } ] ] } }, "pinData": {} } ```

jan · January 22, 2024, 2:49pm

New version [email protected] got released which includes the GitHub PR 8382.

system · April 21, 2024, 2:49pm

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