Hi. I want to use Zapier to send an email about orders coming from my food ordering website. I’ve been able to get items (I’m not sure if that’s the right term) from the webhook trigger such us name, email, phone, total price, etc. But I want to also include and list the dishes, quantity, options, etc. I cannot use the same method that I used for the other items because the number of dishes is different everytime. If there’s only one dish ordered then it’s ok. But if there are two or more, I cant list them. Here’s a test order that I made. Hope someone can help me. Thank you!
[
{
"secret": "6ac86b31-ecf4-4240-a9e4-2bb1b5cd6cdb",
"event": "order_new",
"event_id": "kVbJ2TrJgS73WAwaLJ2eZ",
"restaurant_id": "RES5riadRPP6wzmHKpbhiUUB",
"restaurant_name": "Borrowed Kitchen",
"restaurant_address": "Manila",
"order_type": "Pickup",
"data": {
"order": {
"_id": "qHRjBh_zNIZ2PKWzbbv1Q",
"restaurant_id": "RES5riadRPP6wzmHKpbhiUUB",
"organisation_id": "J2-i0ktB_0T5o9KzIQKR_",
"created": 1589622657522,
"status": "unconfirmed",
"seen": false,
"number": 102,
"auto_printed": [],
"notes": "",
"bill": {
"currency": "PHP",
"total": 1633,
"total_cents": 163300,
"cart": 1633,
"discount": 0,
"taxes": [],
"tax_in_prices": false,
"fees": [],
"tip": 0
},
"payment": {
"method": "cash",
"currency": "PHP",
"total": 1633,
"total_cents": 163300,
"status": "pending"
},
"customer": {
"_id": "J2-i0ktB_0T5o9KzIQKR_|kjisq3senPYD8dZ7KBBfk",
"name": "Test Testing",
"phone": "09875698210",
"email": "pambansangulam@gmail.com",
"ip": "130.105.212.235",
"country": "PH",
"region": "00",
"city": "Makati",
"lat": "14.554729",
"lng": "121.024445"
},
"promos": [],
"dishes": [
{
"type": "standard",
"_id": "LGNdIrMgR",
"menu_id": "h2tK12g3N",
"category_id": "G_WJUX-4R",
"name": "Adobo",
"display_name": "",
"subtitle": "",
"price": 173,
"tags": [],
"status": null,
"ingredients": [],
"option_sets": [
{
"_id": "IiSx9Pwn3",
"name": "Add ons",
"display_name": "",
"conditions": {
"required": false,
"multi_select": true,
"quantity_select": true,
"min_options": "",
"max_options": "",
"free_amount": ""
},
"options": [
{
"_id": "wx6y0VjKQ",
"name": "Rice",
"price": "20",
"quantity": 2
},
{
"_id": "ybilWAu8A",
"name": "Papaya",
"price": "10",
"quantity": 1
}
]
}
],
"choices": [],
"price_type": "standard",
"qty": 1,
"notes": "No salt"
},
{
"type": "standard",
"_id": "laHDLAnm4",
"menu_id": "h2tK12g3N",
"category_id": "zNw1sDRuH",
"name": "Soy Chicken",
"display_name": "",
"subtitle": "",
"price": 700,
"tags": [],
"status": null,
"ingredients": [],
"option_sets": [
{
"_id": "5ntk8VPn2",
"name": "Chicken Size",
"display_name": "",
"conditions": {
"required": true,
"multi_select": false,
"quantity_select": false,
"min_options": "",
"max_options": 1,
"free_amount": ""
},
"options": [
{
"_id": "IFZl7HMCn",
"name": "Regular",
"price": "450",
"quantity": 1,
"status": null
}
]
},
{
"_id": "IiSx9Pwn3",
"name": "Add ons",
"display_name": "",
"conditions": {
"required": false,
"multi_select": true,
"quantity_select": true,
"min_options": "",
"max_options": "",
"free_amount": ""
},
"options": []
}
],
"choices": [],
"price_type": "standard",
"qty": 1,
"notes": ""
},
{
"type": "standard",
"_id": "laHDLAnm4",
"menu_id": "h2tK12g3N",
"category_id": "zNw1sDRuH",
"name": "Soy Chicken",
"display_name": "",
"subtitle": "",
"price": 290,
"tags": [],
"status": null,
"ingredients": [],
"option_sets": [
{
"_id": "5ntk8VPn2",
"name": "Chicken Size",
"display_name": "",
"conditions": {
"required": true,
"multi_select": false,
"quantity_select": false,
"min_options": "",
"max_options": 1,
"free_amount": ""
},
"options": [
{
"_id": "kvhu9uOIX",
"name": "Half",
"price": "0",
"quantity": 1,
"status": null
}
]
},
{
"_id": "IiSx9Pwn3",
"name": "Add ons",
"display_name": "",
"conditions": {
"required": false,
"multi_select": true,
"quantity_select": true,
"min_options": "",
"max_options": "",
"free_amount": ""
},
"options": [
{
"_id": "wx6y0VjKQ",
"name": "Rice",
"price": "20",
"quantity": 1
},
{
"_id": "ybilWAu8A",
"name": "Papaya",
"price": "10",
"quantity": 2
}
]
}
],
"choices": [],
"price_type": "standard",
"qty": 1,
"notes": "Chop"
},
{
"type": "standard",
"_id": "vX0TqkWMm",
"menu_id": "h2tK12g3N",
"category_id": "bV2HKjX-W",
"name": "Tapa",
"display_name": "",
"subtitle": "",
"price": 470,
"tags": [],
"status": null,
"ingredients": [],
"option_sets": [
{
"_id": "IiSx9Pwn3",
"name": "Add ons",
"display_name": "",
"conditions": {
"required": false,
"multi_select": true,
"quantity_select": true,
"min_options": "",
"max_options": "",
"free_amount": ""
},
"options": [
{
"_id": "wx6y0VjKQ",
"name": "Rice",
"price": "20",
"quantity": 1
}
]
}
],
"choices": [],
"price_type": "standard",
"qty": 1,
"notes": "Shred"
}
],
"config": {
"service": "pickup",
"due": "later",
"date": "2020-05-18",
"time": "10:30",
"destination": "",
"destination_misc": "",
"lat": -1,
"lng": -1,
"distance": -1,
"driving_time": -1,
"zone": "",
"table": "",
"table_id": "",
"table_password": "",
"number_of_people": "",
"confirmed": true,
"timestamp": 1589769000000
},
"updated": 1589622657522,
"ready_in": {
"timestamp": 1589769000000
},
"delivery_in": null,
"rush_eta_increment": null
},
"customer": {
"_id": "J2-i0ktB_0T5o9KzIQKR_|kjisq3senPYD8dZ7KBBfk",
"manual": false,
"type": "guest",
"organisation_id": "J2-i0ktB_0T5o9KzIQKR_",
"restaurants": [
"RES5riadRPP6wzmHKpbhiUUB"
],
"created": 1589622657533,
"verified": false,
"avatar": "",
"details": {
"name": "Test Testing",
"email": "pambansangulam@gmail.com",
"phone": "09875698210",
"gender": null,
"age_range": ""
},
"delivery": {
"destination": "",
"destination_misc": "",
"driving_time": 0,
"distance": 0,
"lat": 0,
"lng": 0,
"zone": ""
},
"age_verification": {
"images": [],
"status": null
},
"meta": {
"last_ip": "130.105.212.235",
"last_order": 1589622657533,
"last_seen": 1589622657533,
"ip_country": "PH",
"ip_region": "00",
"ip_city": "Makati",
"ip_lat": "14.554729",
"ip_lng": "121.024445"
},
"stats": {
"orders": 1,
"sales": 1633,
"sessions": 1,
"promos_count": 0,
"promos_used": []
}
}
}
}
]
Best answer by ikbelkirasan
View original