{
"name": "order to shipment ofn logcica",
"nodes": [
{
"parameters": {},
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
100,
310
]
},
{
"parameters": {
"functionCode": "return items[0].json.orders.map(item => {\n return {\n json: item\n }\n})\n"
},
"name": "Map list",
"type": "n8n-nodes-base.function",
"typeVersion": 1,
"position": [
620,
220
]
},
{
"parameters": {
"triggerTimes": {
"item": [
{
"mode": "everyMinute"
}
]
}
},
"name": "Time trigger",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
100,
150
]
},
{
"parameters": {
"sheetId": "14UW1VPd6AMLknrcV-nzJyN82QdZBuwDYFvq5y40si_w",
"range": "order-to-shipment-ofn-purplship!A:B",
"options": {}
},
"name": "Get subscriptions",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
280,
220
],
"credentials": {
"googleApi": {
"id": "3",
"name": "Digicirco Google"
}
}
},
{
"parameters": {
"authentication": "headerAuth",
"url": "https://openfoodnetwork.be/api/v0/orders",
"options": {
"splitIntoItems": false
},
"queryParametersUi": {
"parameter": [
{
"name": "q[created_at_gt]",
"value": "={{new Date(new Date().setDate(new Date().getDate()-1)).toISOString().slice(0, 10)}}"
},
{
"name": "q[distributor_id_eq]",
"value": "={{$json[\"enterpriseId\"]}}"
},
{
"name": "q[state_eq]",
"value": "complete"
}
]
}
},
"name": "Get orders",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
450,
220
],
"credentials": {
"httpHeaderAuth": {
"id": "8",
"name": "ofn be demo account"
}
}
},
{
"parameters": {
"authentication": "headerAuth",
"url": "=https://openfoodnetwork.be/api/v0/orders/{{$json[\"number\"]}}",
"options": {}
},
"name": "Get order",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 1,
"position": [
1260,
270
],
"credentials": {
"httpHeaderAuth": {
"id": "8",
"name": "ofn be demo account"
}
}
},
{
"parameters": {
"channel": "logcica-bot-test",
"text": "=",
"jsonParameters": true,
"attachments": [],
"otherOptions": {
"unfurl_links": false,
"unfurl_media": false
},
"blocksJson": "=[\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"section\",\n \"text\": {\n \"type\": \"mrkdwn\",\n \"text\": \"*Commande* <https://openfoodnetwork.be/admin/orders/{{$json[\"number\"]}}/edit|{{$json[\"number\"]}}> pour {{$json[\"distributor_name\"]}} via OFN\"\n }\n },\n {\n \"type\": \"context\",\n \"elements\": [\n {\n \"type\": \"mrkdwn\",\n \"text\": \"*Livraison :* {{$json[\"shipping_method\"][\"name\"]}}\\n\"\n },\n {\n \"type\": \"mrkdwn\",\n \"text\": \"*Destination :* {{$json[\"full_name\"]}}, <https://maps.google.com/?q={{$json[\"ship_address\"][\"mapsSearchQuery\"]}}|{{$json[\"ship_address\"][\"address1\"]}}, {{$json[\"ship_address\"][\"address2\"]}}, {{$json[\"ship_address\"][\"zipcode\"]}} {{$json[\"ship_address\"][\"city\"]}}>\\n\"\n }\n ]\n }\n]"
},
"name": "Slack",
"type": "n8n-nodes-base.slack",
"typeVersion": 1,
"position": [
1570,
270
],
"credentials": {
"slackApi": {
"id": "7",
"name": "Slack account 2"
}
}
},
{
"parameters": {
"functionCode": "const a = item.ship_address\nitem.ship_address.mapsSearchQuery = encodeURI(`${a.address1},${a.address2},${a.city},${a.state_name},${a.country_name}`);\nreturn item;"
},
"name": "Enrich",
"type": "n8n-nodes-base.functionItem",
"typeVersion": 1,
"position": [
1420,
270
]
},
{
"parameters": {
"sheetId": "1mP7r4GhvB5TLV8KLtdKi7LW21wk2fL0IRrA2V1uc3Is",
"range": "orders!A:A",
"options": {}
},
"name": "Latest orders",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
620,
400
],
"alwaysOutputData": true,
"credentials": {
"googleApi": {
"id": "3",
"name": "Digicirco Google"
}
}
},
{
"parameters": {
"mode": "removeKeyMatches",
"propertyName1": "number",
"propertyName2": "number"
},
"name": "Keep new",
"type": "n8n-nodes-base.merge",
"typeVersion": 1,
"position": [
780,
270
]
},
{
"parameters": {
"functionCode": "const newItem = {\n number: item.number,\n createdTime: new Date().toISOString()\n}\n\nreturn newItem;"
},
"name": "Latest order",
"type": "n8n-nodes-base.functionItem",
"typeVersion": 1,
"position": [
940,
270
]
},
{
"parameters": {
"operation": "append",
"sheetId": "1mP7r4GhvB5TLV8KLtdKi7LW21wk2fL0IRrA2V1uc3Is",
"range": "orders!A:B",
"options": {
"valueInputMode": "RAW"
}
},
"name": "Append to latest orders",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 1,
"position": [
1100,
270
],
"alwaysOutputData": false,
"credentials": {
"googleApi": {
"id": "3",
"name": "Digicirco Google"
}
}
}
],
"connections": {
"Time trigger": {
"main": [
[
{
"node": "Get subscriptions",
"type": "main",
"index": 0
}
]
]
},
"Get subscriptions": {
"main": [
[
{
"node": "Get orders",
"type": "main",
"index": 0
}
]
]
},
"Get order": {
"main": [
[
{
"node": "Enrich",
"type": "main",
"index": 0
}
]
]
},
"Enrich": {
"main": [
[
{
"node": "Slack",
"type": "main",
"index": 0
}
]
]
},
"Latest orders": {
"main": [
[
{
"node": "Keep new",
"type": "main",
"index": 1
}
]
]
},
"Get orders": {
"main": [
[
{
"node": "Map list",
"type": "main",
"index": 0
}
]
]
},
"Map list": {
"main": [
[
{
"node": "Keep new",
"type": "main",
"index": 0
}
]
]
},
"Keep new": {
"main": [
[
{
"node": "Latest order",
"type": "main",
"index": 0
}
]
]
},
"Latest order": {
"main": [
[
{
"node": "Append to latest orders",
"type": "main",
"index": 0
}
]
]
},
"Append to latest orders": {
"main": [
[
{
"node": "Get order",
"type": "main",
"index": 0
}
]
]
}
},
"active": true,
"settings": {},
"id": 5
}