can someone and help, why are you giving this error?
I am sending a request for each item of the object
[
{
"cpf": 12345678,
"flag": 1
},
{
"cpf": 12345673,
"flag": 0
},
{
"cpf": 12345671,
"flag": 1
},
{
"cpf": 12345670,
"flag": 0
}
]Can you share the expression you are using in the field customer IDs
Can you share the workflow? Select all the nodes, then copy and paste it here. I cannot get what it’s not working by just looking at the picture.
{
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
-310,
80
]
},
{
"parameters": {
"values": {
"string": [
{
"name": "redash_api_key",
"value": "htuIJUXEJKwvTgQkoNSC92wrd3lr6vTxGZibbgV"
}
]
},
"options": {}
},
"name": "Set Api key redash",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
-60,
80
]
},
{
"parameters": {
"functionCode": "return ([\n{json:\n {\n query_id: 934,\n segment_id: 28,\n category: \"Crm\",\n subcategory: \"CustomerIO\",\n item: \"Segment 28\",\n description: \"Inclusão/Exclusão de clientes que não compram a 7 dias\"\n }\n}\n])"
},
"name": "Set infos",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
190,
80
]
},
{
"parameters": {
"requestMethod": "POST",
"url": "=URL_API/{{$node[\"Set infos\"].json[\"query_id\"]}}/results",
"jsonParameters": true,
"options": {},
"bodyParametersJson": "={\n\t\"parameters\": {\n\t\t\"id\": {{$node[\"Set infos\"].json[\"segment_id\"]}}\n\t}\n}",
"headerParametersJson": "={ \n\t\"Authorization\": \"Key {{$node[\"Set Api key redash\"].json[\"redash_api_key\"]}}\",\n\t\"Content-Type\": \"application/json\"\n}"
},
"name": "Get clients redash",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
440,
80
],
"continueOnFail": true
},
{
"parameters": {
"channel": "test",
"text": "=Ocorreu um erro ao fazer a requisição no redash\nID do segmento: {{$node[\"Set infos\"].json[\"segment_id\"]}}\nQuery ID: {{$node[\"Set infos\"].json[\"query_id\"]}}\nChave de acesso do redash: {{$node[\"Set Api key redash\"].json[\"redash_api_key\"]}}\nErro: {{$node[\"Get clients redash\"].json[\"error\"][\"error\"][\"message\"]}}",
"attachments": [],
"otherOptions": {}
},
"name": "send alert error slack",
"type": "n8n-nodes-base.slack",
"typeVersion": 1,
"position": [
1030,
340
],
"credentials": {
"slackApi": "test-leo"
}
},
{
"parameters": {
"functionCode": "const clients = []\n\nfor (let data of items[0].json.query_result.data.rows) {\n clients.push({\n json: {\n \t\tcpf: data.CPF,\n \t flag: data.FLG_ADD_DEL_IO,\n \t}\n })\n}\n\nreturn clients;\n"
},
"name": "Parse Json",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
1000,
-70
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{Object.keys($node[\"Get clients redash\"].json)}}",
"operation": "contains",
"value2": "query_result"
}
]
}
},
"name": "Request is ok",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
700,
80
]
},
{
"parameters": {},
"name": "NoOp1",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
1870,
340
]
},
{
"parameters": {
"resource": "segment",
"operation": "remove",
"segmentId": "=28",
"customerIds": "={{$node[\"flag not is active\"].json[\"cpf\"]}}"
},
"name": "Remove customer",
"type": "n8n-nodes-base.customerIo",
"typeVersion": 1,
"position": [
1890,
0
],
"credentials": {
"customerIoApi": "Customer.IO"
}
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$node[\"Parse Json\"].json[\"flag\"]}}",
"operation": "equal",
"value2": 1
}
]
}
},
"name": "flag is active",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1370,
-260
],
"alwaysOutputData": false,
"executeOnce": false,
"continueOnFail": true
},
{
"parameters": {
"conditions": {
"number": [
{
"value1": "={{$node[\"Parse Json\"].json[\"flag\"]}}",
"operation": "equal"
}
]
}
},
"name": "flag not is active",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1370,
40
],
"alwaysOutputData": false,
"executeOnce": false,
"continueOnFail": true
},
{
"parameters": {
"resource": "segment",
"segmentId": 28,
"customerIds": "={{$node[\"flag is active\"].json[\"cpf\"]}}"
},
"name": "Add customer",
"type": "n8n-nodes-base.customerIo",
"typeVersion": 1,
"position": [
1930,
-300
],
"credentials": {
"customerIoApi": "Customer.IO"
}
}
],
"connections": {
"Start": {
"main": [
[
{
"node": "Set Api key redash",
"type": "main",
"index": 0
}
]
]
},
"Set Api key redash": {
"main": [
[
{
"node": "Set infos",
"type": "main",
"index": 0
}
]
]
},
"Set infos": {
"main": [
[
{
"node": "Get clients redash",
"type": "main",
"index": 0
}
]
]
},
"Get clients redash": {
"main": [
[
{
"node": "Request is ok",
"type": "main",
"index": 0
}
]
]
},
"send alert error slack": {
"main": [
[
{
"node": "NoOp1",
"type": "main",
"index": 0
}
]
]
},
"Parse Json": {
"main": [
[
{
"node": "flag is active",
"type": "main",
"index": 0
},
{
"node": "flag not is active",
"type": "main",
"index": 0
}
]
]
},
"Request is ok": {
"main": [
[
{
"node": "Parse Json",
"type": "main",
"index": 0
}
],
[
{
"node": "send alert error slack",
"type": "main",
"index": 0
}
]
]
},
"flag is active": {
"main": [
[
{
"node": "Add customer",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp1",
"type": "main",
"index": 0
}
]
]
},
"flag not is active": {
"main": [
[
{
"node": "Remove customer",
"type": "main",
"index": 0
}
],
[
{
"node": "NoOp1",
"type": "main",
"index": 0
}
]
]
}
}
}