Record Node DataDatabase Configuration

Create:

{ "action": "create", "collection": "leads", "data": { "name": "{{customer_name}}", "phone": "{{customer_phone}}", "status": "new" }, "uniqueKey": "phone", "idempotencyKey": "{{conversation_id}}:lead:create", "outputVar": "lead_record" }

Appointment create:

{ "action": "create", "collection": "appointments", "data": { "appointmentId": "{{appointment_id}}", "phone": "{{customer_phone}}", "date": "{{appointment_date}}", "doctor": "{{doctor_name}}", "status": "booked" }, "uniqueKey": "appointmentId", "outputVar": "appointment_record" }

Find:

{ "action": "find", "collection": "leads", "where": { "phone": "{{customer_phone}}" }, "outputVar": "lead_record" }

List:

{ "action": "list", "collection": "leads", "where": { "status": "new" }, "limit": 20, "offset": 0, "sortBy": "updatedAt", "sortOrder": "desc", "outputVar": "lead_rows" }

Update:

{ "action": "update", "collection": "leads", "where": { "phone": "{{customer_phone}}" }, "data": { "status": "qualified" }, "uniqueKey": "phone", "outputVar": "lead_record" }

Upsert:

{ "action": "upsert", "collection": "leads", "where": { "phone": "{{customer_phone}}" }, "data": { "name": "{{customer_name}}", "phone": "{{customer_phone}}", "status": "contacted" }, "uniqueKey": "phone", "idempotencyKey": "{{conversation_id}}:lead:upsert", "outputVar": "lead_record" }

Delete:

{ "action": "delete", "collection": "leads", "where": { "phone": "{{customer_phone}}" }, "softDelete": true, "outputVar": "lead_delete_result" }