{
“name”: “Aspenwood HRIS”,
“nodes”: [
{
“parameters”: {
“schema”: {
“__rl”: true,
“value”: “=thnks_wh”,
“mode”: “name”
},
“tableName”: {
“__rl”: true,
“value”: “=aspenwood_hris_sends”,
“mode”: “name”
},
“additionalFields”: {},
“options”: {}
},
“type”: “n8n-nodes-base.postgresTrigger”,
“typeVersion”: 1,
“position”: [
0,
0
],
“id”: “ecb997cf-32c2-4307-b65e-b5b6cfbdf9b3”,
“name”: “Postgres Trigger”,
“credentials”: {
“postgres”: {
“id”: “haVFrVrZTGCW47fA”,
“name”: “DBT R/W”
}
}
},
{
“parameters”: {
“resume”: “specificTime”,
“dateTime”: “={{ $json.payload.next_scheduled_send }} 8:00 AM EST”
},
“type”: “n8n-nodes-base.wait”,
“typeVersion”: 1.1,
“position”: [
224,
0
],
“id”: “82d9efeb-f439-4309-87f8-3ccf8963c0e6”,
“name”: “Wait”,
“webhookId”: “416456c4-490c-421e-b24c-9f8c6e5a723f”
},
{
“parameters”: {
“method”: “POST”,
“url”: “https://api.thnks.com/api/v1/gift_requests”,
“sendHeaders”: true,
“headerParameters”: {
“parameters”: [
{
“name”: “Authorization”,
“value”: “c04643b86a6691e9386947fa5d7ddc06”
},
{
“name”: “Content-Type”,
“value”: “application/json”
}
]
},
“sendBody”: true,
“contentType”: “raw”,
“rawContentType”: “application/json”,
“body”: “={\n "gift_id": "{{ $(‘Postgres Trigger’).item.json.payload.thnks_id }}",\n "recipients": [\n {\n "email":"{{ $(‘Postgres Trigger’).item.json.payload.work_email }}",\n "first_name":"{{ $(‘Postgres Trigger’).item.json.payload.first_name }}",\n "last_name":"{{ $(‘Postgres Trigger’).item.json.payload.last_name }}",\n "message": "{{ $(‘Postgres Trigger’).item.json.payload.message }}",\n "gift_redeem_type": "email"\n }\n ],\n"utm_campaign_id": "HRIS Send"\n}”,
“options”: {}
},
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4.2,
“position”: [
448,
0
],
“id”: “6cc35084-1ecc-4a44-995a-f05d0c1b6857”,
“name”: “HTTP Request”
}
],
“pinData”: {},
“connections”: {
“Postgres Trigger”: {
“main”: [
[
{
“node”: “Wait”,
“type”: “main”,
“index”: 0
}
]
]
},
“Wait”: {
“main”: [
[
{
“node”: “HTTP Request”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request”: {
“main”: [
]
}
},
“active”: true,
“settings”: {
“executionOrder”: “v1”
},
“versionId”: “2696fb4a-c127-4696-8939-3d238f0338fb”,
“meta”: {
“templateCredsSetupCompleted”: true,
“instanceId”: “15a84e0d37d8b7c97c36c6f8d07c014030dd7bc71ea4227b7eca360f55ad9a41”
},
“id”: “QQGLjFTPO43CYn24”,
“tags”:
}
Describe the problem/error/question
What is the error message (if any)?
Please share your workflow
(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: