Hye all…i need get “3451 from this value” from this json but keep fail…i try split out but fail if i drop new order…anyone can help how to always get value _booking_id any get data from woocommerce?
{
"id": 590,
"key": "_booking_id",
"value": [
3451
],
"display_key": "_booking_id",
"display_value": [
3451
]
}
Information on your n8n setup
[
{
“id”: 3452,
“parent_id”: 0,
“status”: “completed”,
“currency”: “MYR”,
“version”: “9.2.3”,
“prices_include_tax”: true,
“date_created”: “2024-09-04T00:16:43”,
“date_modified”: “2024-09-04T00:16:48”,
“discount_total”: “0.00”,
“discount_tax”: “0.00”,
“shipping_total”: “0.00”,
“shipping_tax”: “0.00”,
“cart_tax”: “0.00”,
“total”: “310.00”,
“total_tax”: “0.00”,
“customer_id”: 1,
“order_key”: “wc_order_h8C7z8U0ZhNnO”,
“billing”: {
“first_name”: “Aminnurden”,
“last_name”: “Test”,
“company”: “”,
“address_1”: “”,
“address_2”: “”,
“city”: “”,
“state”: “”,
“postcode”: “”,
“country”: “MY”,
“email”: “[email protected]”,
“phone”: “+60167892545”
},
“shipping”: {
“first_name”: “”,
“last_name”: “”,
“company”: “”,
“address_1”: “”,
“address_2”: “”,
“city”: “”,
“state”: “”,
“postcode”: “”,
“country”: “”,
“phone”: “”
},
“payment_method”: “wc_gateway_chip”,
“payment_method_title”: “Online Banking (FPX)”,
“transaction_id”: “6f26b1b1-e537-4657-ae78-d5cb3fa23b25”,
“customer_ip_address”: “172.226.44.174”,
“customer_user_agent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Safari/605.1.15”,
“created_via”: “checkout”,
“customer_note”: “”,
“date_completed”: “2024-09-04T00:16:47”,
“date_paid”: “2024-09-04T00:16:47”,
“cart_hash”: “32941520a54239f0eb6dab5046e4a264”,
“number”: “3452”,
“meta_data”: [
{
“id”: 435,
“key”: “_billing_info”,
“value”: “”
},
{
“id”: 447,
“key”: “_wc_gateway_chip_purchase”,
“value”: {
“client”: {
“client_type”: null,
“email”: “[email protected]”,
“phone”: “+60167892545”,
“full_name”: “Aminnurden Test”,
“personal_code”: “”,
“legal_name”: “”,
“brand_name”: “”,
“registration_number”: “”,
“tax_number”: “”,
“bank_account”: “”,
“bank_code”: “”,
“street_address”: “”,
“city”: “”,
“zip_code”: “”,
“country”: “MY”,
“state”: “”,
“shipping_street_address”: “”,
“shipping_city”: “”,
“shipping_zip_code”: “”,
“shipping_country”: “”,
“shipping_state”: “”,
“cc”: ,
“bcc”: ,
“delivery_methods”: [
{
“method”: “email”,
“options”:
},
{
“method”: “text_message”,
“options”: {
“custom_message”: “”
}
}
]
},
“purchase”: {
“currency”: “MYR”,
“products”: [
{
“name”: “Big Room”,
“price”: 31000,
“quantity”: “1.0000”,
“discount”: 0,
“tax_percent”: “0.00”,
“category”: “”
}
],
“language”: “en”,
“notes”: “”,
“debt”: 0,
“subtotal_override”: null,
“total_tax_override”: null,
“total_discount_override”: null,
“total_override”: 31000,
“total”: 31000,
“request_client_details”: ,
“timezone”: “Asia/Kuala_Lumpur”,
“due_strict”: true,
“email_message”: “”,
“shipping_options”: ,
“payment_method_details”: ,
“has_upsell_products”: false
},
“payment”: {
“is_outgoing”: false,
“payment_type”: “purchase”,
“amount”: 31000,
“currency”: “MYR”,
“net_amount”: 24800,
“fee_amount”: 3100,
“pending_amount”: 3100,
“pending_unfreeze_on”: 1725639406,
“description”: “”,
“paid_on”: 1725380206,
“remote_paid_on”: 1725380206,
“owned_bank_account_id”: null,
“owned_bank_account”: null,
“owned_bank_code”: null
},
“issuer_details”: {
“brand_name”: “SULAP SDN. BHD.”,
“website”: “https://sulap.com.my”,
“legal_name”: “SULAP SDN. BHD.”,
“registration_number”: “201901006470 (1315797-X)”,
“tax_number”: “”,
“legal_street_address”: “UNIT F-2-2, 2ND FLOOR, PLAZA TANJUNG ARU, JALAN MAT SALLEH”,
“legal_country”: “MY”,
“legal_city”: “KOTA KINABALU, SABAH”,
“legal_zip_code”: “88100”,
“bank_accounts”: [
{
“bank_account”: “560269016745”,
“bank_code”: “MBBEMYKL”
}
]
},
“transaction_data”: {
“payment_method”: “fpx”,
“flow”: “woocommerce”,
“extra”: ,
“country”: “MY”,
“attempts”: [
{
“type”: “execute”,
“successful”: true,
“payment_method”: “fpx”,
“flow”: “woocommerce”,
“extra”: ,
“country”: “MY”,
“client_ip”: “”,
“processing_time”: 1725380206,
“fee_amount”: 3100,
“error”: null
}
]
},
“status”: “paid”,
“status_history”: [
{
“status”: “created”,
“timestamp”: 1725380204
},
{
“status”: “viewed”,
“timestamp”: 1725380204
},
{
“status”: “paid”,
“timestamp”: 1725380206
}
],
“viewed_on”: 1725380204,
“force_recurring”: false,
“company_id”: “3846adf3-f7b5-4636-99d1-81c7c76fbbe9”,
“is_test”: true,
“user_id”: null,
“brand_id”: “f79b968d-941c-4468-b9d7-b63f6b6ec16f”,
“billing_template_id”: null,
“order_id”: null,
“client_id”: “41638af0-9acc-4d7a-996b-85da893dbf17”,
“send_receipt”: false,
“is_recurring_token”: false,
“recurring_token”: null,
“skip_capture”: false,
“reference_generated”: “CH16”,
“reference”: “3452”,
“issued”: “2024-09-04”,
“due”: 1725383803,
“refund_availability”: “all”,
“refundable_amount”: 31000,
“currency_conversion”: null,
“payment_method_whitelist”: [
“fpx”
],
“success_redirect”: “Checkout – Sulap Homestay”,
“failure_redirect”: “Checkout – Sulap Homestay”,
“cancel_redirect”: “Checkout – Sulap Homestay”,
“success_callback”: “Checkout – Sulap Homestay”,
“marked_as_paid”: false,
“upsell_campaigns”: ,
“referral_campaign_id”: null,
“referral_code”: null,
“referral_code_details”: null,
“referral_code_generated”: null,
“retain_level_details”: null,
“can_retrieve”: false,
“can_chargeback”: false,
“creator_agent”: “WooCommerce: v1.6.4”,
“platform”: “woocommerce”,
“product”: “purchases”,
“created_from_ip”: “15.235.193.81”,
“invoice_url”: null,
“checkout_url”: “Invoice #3452”,
“direct_post_url”: null,
“created_on”: 1725380204,
“updated_on”: 1725380206,
“type”: “purchase”,
“id”: “6f26b1b1-e537-4657-ae78-d5cb3fa23b25”
}
},
{
“id”: 446,
“key”: “_wc_order_attribution_device_type”,
“value”: “Desktop”
},
{
“id”: 444,
“key”: “_wc_order_attribution_session_count”,
“value”: “15”
},
{
“id”: 441,
“key”: “_wc_order_attribution_session_entry”,
“value”: “https://reservation.sulap.com.my/”
},
{
“id”: 443,
“key”: “_wc_order_attribution_session_pages”,
“value”: “11”
},
{
“id”: 442,
“key”: “_wc_order_attribution_session_start_time”,
“value”: “2024-08-30 11:01:03”
},
{
“id”: 439,
“key”: “_wc_order_attribution_source_type”,
“value”: “typein”
},
{
“id”: 445,
“key”: “wc_order_attribution_user_agent",
“value”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.6 Safari/605.1.15”
},
{
“id”: 440,
“key”: “wc_order_attribution_utm_source",
“value”: “(direct)”
},
{
“id”: 436,
“key”: “is_vat_exempt”,
“value”: “no”
}
],
“line_items”: [
{
“id”: 57,
“name”: “Big Room”,
“product_id”: 3030,
“variation_id”: 0,
“quantity”: 1,
“tax_class”: “”,
“subtotal”: “310.00”,
“subtotal_tax”: “0.00”,
“total”: “310.00”,
“total_tax”: “0.00”,
“taxes”: [],
“meta_data”: [
{
“id”: 584,
“key”: “tmcartepo_data",
“value”: [
{
“mode”: “builder”,
“cssclass”: “”,
“hidelabelincart”: “”,
“hidevalueincart”: “”,
“hidelabelinorder”: “”,
“hidevalueinorder”: “”,
“shippingmethodsenable”: “”,
“shippingmethodsenablelogicrules”: “”,
“shippingmethodsdisable”: “”,
“shippingmethodsdisablelogicrules”: “”,
“element”: {
“type”: “checkbox”,
“rules”: {
“Extra Towel_0”: [
“5”
],
“Extra Pillow_1”: [
“5”
],
“Extra Blanket_2”: [
“10”
],
“Extra Bed_3”: [
“35”
],
“BBQ Tools_4”: [
“20”
],
“BBQ Tools+ Tablewar_5”: [
“50”
]
},
“rules_type”: {
“Extra Towel_0”: [
“”
],
“Extra Pillow_1”: [
“”
],
“Extra Blanket_2”: [
“”
],
“Extra Bed_3”: [
“”
],
“BBQ Tools_4”: [
“”
],
“BBQ Tools+ Tablewar_5”: [
“”
]
},
"”: {
“price_type”: false
}
},
“name”: “Extra Amenities”,
“value”: “Extra Pillow”,
“post_name”: “tmcp_checkbox_0_1”,
“price”: 5,
“section”: “66d46a8d353464.08952471”,
“section_label”: “Extra Amenities”,
“percentcurrenttotal”: 0,
“fixedcurrenttotal”: 0,
“currencies”: [],
“price_per_currency”: {
“MYR”: 5
},
“quantity”: 1,
“quantity_selector”: “”,
“multiple”: “1”,
“key”: “Extra Pillow_1”,
“use_images”: “”,
“use_colors”: “”,
“changes_product_image”: “”,
“imagesp”: “”,
“images”: “”,
“imagesc”: “”,
“color”: “”,
“key_id”: 0,
“keyvalue_id”: 0,
“weight”: 0
},
{
“mode”: “builder”,
“cssclass”: “”,
“hidelabelincart”: “”,
“hidevalueincart”: “”,
“hidelabelinorder”: “”,
“hidevalueinorder”: “”,
“shippingmethodsenable”: “”,
“shippingmethodsenablelogicrules”: “”,
“shippingmethodsdisable”: “”,
“shippingmethodsdisablelogicrules”: “”,
“element”: {
“type”: “checkbox”,
“rules”: {
“Extra Towel_0”: [
“5”
],
“Extra Pillow_1”: [
“5”
],
“Extra Blanket_2”: [
“10”
],
“Extra Bed_3”: [
“35”
],
“BBQ Tools_4”: [
“20”
],
“BBQ Tools+ Tablewar_5”: [
“50”
]
},
“rules_type”: {
“Extra Towel_0”: [
“”
],
“Extra Pillow_1”: [
“”
],
“Extra Blanket_2”: [
“”
],
“Extra Bed_3”: [
“”
],
“BBQ Tools_4”: [
“”
],
“BBQ Tools+ Tablewar_5”: [
“”
]
},
"”: {
“price_type”: “”
}
},
“name”: “Extra Amenities”,
“value”: “Extra Blanket”,
“post_name”: “tmcp_checkbox_0_2”,
“price”: 10,
“section”: “66d46a8d353464.08952471”,
“section_label”: “Extra Amenities”,
“percentcurrenttotal”: 0,
“fixedcurrenttotal”: 0,
“currencies”: [],
“price_per_currency”: {
“MYR”: 10
},
“quantity”: 1,
“quantity_selector”: “”,
“multiple”: “1”,
“key”: “Extra Blanket_2”,
“use_images”: “”,
“use_colors”: “”,
“changes_product_image”: “”,
“imagesp”: “”,
“images”: “”,
“imagesc”: “”,
“color”: “”,
“key_id”: 0,
“keyvalue_id”: 0,
“weight”: 0
}
],
“display_key”: “tmcartepo_data",
“display_value”: [
{
“mode”: “builder”,
“cssclass”: “”,
“hidelabelincart”: “”,
“hidevalueincart”: “”,
“hidelabelinorder”: “”,
“hidevalueinorder”: “”,
“shippingmethodsenable”: “”,
“shippingmethodsenablelogicrules”: “”,
“shippingmethodsdisable”: “”,
“shippingmethodsdisablelogicrules”: “”,
“element”: {
“type”: “checkbox”,
“rules”: {
“Extra Towel_0”: [
“5”
],
“Extra Pillow_1”: [
“5”
],
“Extra Blanket_2”: [
“10”
],
“Extra Bed_3”: [
“35”
],
“BBQ Tools_4”: [
“20”
],
“BBQ Tools+ Tablewar_5”: [
“50”
]
},
“rules_type”: {
“Extra Towel_0”: [
“”
],
“Extra Pillow_1”: [
“”
],
“Extra Blanket_2”: [
“”
],
“Extra Bed_3”: [
“”
],
“BBQ Tools_4”: [
“”
],
“BBQ Tools+ Tablewar_5”: [
“”
]
},
"”: {
“price_type”: false
}
},
“name”: “Extra Amenities”,
“value”: “Extra Pillow”,
“post_name”: “tmcp_checkbox_0_1”,
“price”: 5,
“section”: “66d46a8d353464.08952471”,
“section_label”: “Extra Amenities”,
“percentcurrenttotal”: 0,
“fixedcurrenttotal”: 0,
“currencies”: [],
“price_per_currency”: {
“MYR”: 5
},
“quantity”: 1,
“quantity_selector”: “”,
“multiple”: “1”,
“key”: “Extra Pillow_1”,
“use_images”: “”,
“use_colors”: “”,
“changes_product_image”: “”,
“imagesp”: “”,
“images”: “”,
“imagesc”: “”,
“color”: “”,
“key_id”: 0,
“keyvalue_id”: 0,
“weight”: 0
},
{
“mode”: “builder”,
“cssclass”: “”,
“hidelabelincart”: “”,
“hidevalueincart”: “”,
“hidelabelinorder”: “”,
“hidevalueinorder”: “”,
“shippingmethodsenable”: “”,
“shippingmethodsenablelogicrules”: “”,
“shippingmethodsdisable”: “”,
“shippingmethodsdisablelogicrules”: “”,
“element”: {
“type”: “checkbox”,
“rules”: {
“Extra Towel_0”: [
“5”
],
“Extra Pillow_1”: [
“5”
],
“Extra Blanket_2”: [
“10”
],
“Extra Bed_3”: [
“35”
],
“BBQ Tools_4”: [
“20”
],
“BBQ Tools+ Tablewar_5”: [
“50”
]
},
“rules_type”: {
“Extra Towel_0”: [
“”
],
“Extra Pillow_1”: [
“”
],
“Extra Blanket_2”: [
“”
],
“Extra Bed_3”: [
“”
],
“BBQ Tools_4”: [
“”
],
“BBQ Tools+ Tablewar_5”: [
“”
]
},
"”: {
“price_type”: “”
}
},
“name”: “Extra Amenities”,
“value”: “Extra Blanket”,
“post_name”: “tmcp_checkbox_0_2”,
“price”: 10,
“section”: “66d46a8d353464.08952471”,
“section_label”: “Extra Amenities”,
“percentcurrenttotal”: 0,
“fixedcurrenttotal”: 0,
“currencies”: ,
“price_per_currency”: {
“MYR”: 10
},
“quantity”: 1,
“quantity_selector”: “”,
“multiple”: “1”,
“key”: “Extra Blanket_2”,
“use_images”: “”,
“use_colors”: “”,
“changes_product_image”: “”,
“imagesp”: “”,
“images”: “”,
“imagesc”: “”,
“color”: “”,
“key_id”: 0,
“keyvalue_id”: 0,
“weight”: 0
}
]
},
{
“id”: 585,
“key”: “_tm_epo_product_original_price”,
“value”: [
“280”
],
“display_key”: “_tm_epo_product_original_price”,
“display_value”: [
“280”
]
},
{
“id”: 586,
“key”: “_tm_epo_options_prices”,
“value”: [
30
],
“display_key”: “_tm_epo_options_prices”,
“display_value”: [
30
]
},
{
“id”: 587,
“key”: “_tm_epo”,
“value”: [
1
],
“display_key”: “_tm_epo”,
“display_value”: [
1
]
},
{
“id”: 588,
“key”: “_tmdata”,
“value”: [
{
“tmcp_post_fields”: {
“tmcp_checkbox_0_1”: “Extra Pillow_1”,
“tmcp_checkbox_0_2”: “Extra Blanket_2”
},
“product_id”: 3030,
“per_product_pricing”: true,
“cpf_product_price”: “250”,
“variation_id”: false,
“form_prefix”: “”,
“tc_added_in_currency”: “MYR”,
“tc_default_currency”: “MYR”,
“tmcartepo_data”: [
{
“key”: “Extra Pillow_1”,
“attribute”: “tmcp_checkbox_0_1”
},
{
“key”: “Extra Blanket_2”,
“attribute”: “tmcp_checkbox_0_2”
}
]
}
],
“display_key”: “_tmdata”,
“display_value”: [
{
“tmcp_post_fields”: {
“tmcp_checkbox_0_1”: “Extra Pillow_1”,
“tmcp_checkbox_0_2”: “Extra Blanket_2”
},
“product_id”: 3030,
“per_product_pricing”: true,
“cpf_product_price”: “250”,
“variation_id”: false,
“form_prefix”: “”,
“tc_added_in_currency”: “MYR”,
“tc_default_currency”: “MYR”,
“tmcartepo_data”: [
{
“key”: “Extra Pillow_1”,
“attribute”: “tmcp_checkbox_0_1”
},
{
“key”: “Extra Blanket_2”,
“attribute”: “tmcp_checkbox_0_2”
}
]
}
]
},
{
“id”: 589,
“key”: “_tmpost_data”,
“value”: [
{
“wc_bookings_field_duration”: “1”,
“wc_bookings_field_persons”: “1”,
“wc_bookings_field_start_date_day”: “05”,
“wc_bookings_field_start_date_month”: “09”,
“wc_bookings_field_start_date_year”: “2024”,
“wc_bookings_field_start_date_to_day”: “06”,
“wc_bookings_field_start_date_to_month”: “09”,
“wc_bookings_field_start_date_to_year”: “2024”,
“tm-epo-counter”: “1”,
“tcaddtocart”: “3030”,
“tmcp_checkbox_0_1”: “Extra Pillow_1”,
“tmcp_checkbox_0_2”: “Extra Blanket_2”,
“cpf_product_price”: “250”,
“dynamic_product_price”: “”,
“override_product_price”: “”,
“tc_form_prefix”: “”,
“add-to-cart”: “3030”,
“min_date”: “2024-09-04”,
“max_date”: “2024-10-11”,
“timezone_offset”: “0”
}
],
“display_key”: “_tmpost_data”,
“display_value”: [
{
“wc_bookings_field_duration”: “1”,
“wc_bookings_field_persons”: “1”,
“wc_bookings_field_start_date_day”: “05”,
“wc_bookings_field_start_date_month”: “09”,
“wc_bookings_field_start_date_year”: “2024”,
“wc_bookings_field_start_date_to_day”: “06”,
“wc_bookings_field_start_date_to_month”: “09”,
“wc_bookings_field_start_date_to_year”: “2024”,
“tm-epo-counter”: “1”,
“tcaddtocart”: “3030”,
“tmcp_checkbox_0_1”: “Extra Pillow_1”,
“tmcp_checkbox_0_2”: “Extra Blanket_2”,
“cpf_product_price”: “250”,
“dynamic_product_price”: “”,
“override_product_price”: “”,
“tc_form_prefix”: “”,
“add-to-cart”: “3030”,
“min_date”: “2024-09-04”,
“max_date”: “2024-10-11”,
“timezone_offset”: “0”
}
]
},
{
“id”: 590,
“key”: “_booking_id”,
“value”: [
3451
],
“display_key”: “_booking_id”,
“display_value”: [
3451
]
}
],
“sku”: “”,
“price”: 310,
“image”: {
“id”: “3032”,
“src”: “https://reservation.sulap.com.my/wp-content/uploads/2024/08/IMG_9043-1-scaled-2.jpg”
},
“parent_name”: null
}
],
“tax_lines”: ,
“shipping_lines”: ,
“fee_lines”: ,
“coupon_lines”: ,
“refunds”: ,
“payment_url”: “Checkout – Sulap Homestay”,
“is_editable”: false,
“needs_payment”: false,
“needs_processing”: true,
“date_created_gmt”: “2024-09-03T16:16:43”,
“date_modified_gmt”: “2024-09-03T16:16:48”,
“date_completed_gmt”: “2024-09-03T16:16:47”,
“date_paid_gmt”: “2024-09-03T16:16:47”,
“currency_symbol”: “RM”,
“_links”: {
“self”: [
{
“href”: “https://reservation.sulap.com.my/wp-json/wc/v3/orders/3452”
}
],
“collection”: [
{
“href”: “https://reservation.sulap.com.my/wp-json/wc/v3/orders”
}
],
“customer”: [
{
“href”: “https://reservation.sulap.com.my/wp-json/wc/v3/customers/1”
}
]
}
}
]
- **n8n version:v1.56.2
- **Database (default: SQLite):SQLite
- **n8n EXECUTIONS_PROCESS setting (default: own, main):own
- **Running n8n via (Docker, npm, n8n cloud, desktop app):docker
- **Operating system:ubuntu