Hello All n8n
Just learn the coure of 1. Getting Data From the Data Warehouse, following the course instruction , the correct result must show as below …
this pic show the reponse format shoud set to JSON. but when I set it to JSON, it give me a error " ERROR: Response body is not valid JSON. Change “Response Format” to “String”
2021/12/6 11:33:28
Cause
Data below may contain sensitive information. Proceed with caution when sharing.
{
}
Stack
NodeOperationError: Response body is not valid JSON. Change "Response Format" to "String"
at Object.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/HttpRequest/HttpRequest.node.js:945:35)
at processTicksAndRejections (internal/process/task_queues.js:93:5)
at async /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/src/WorkflowExecute.js:447:47
I check all the setting again and again , if i set the reponse format to string , it works but get the result not the same like the coure instruction , below is the result when i set it to string…
what is the proplem , I coudn’t find it…
waiting your help, thanks in advance!!