How to map/get specific data from multiple collections within an array (Value)?

Hey all,

Im not necessrily new to Make.com but still learning, and have been able to pull most obscure pieces of meta data from WooCommerce order that I’ve needed to, but this one has me stumped.

These WooCommerce orders come with add-ons (resources) that show up in Make as Line Item - Meta Data items.

I want to be able to pull the highlighted three items our of the order, and populate a custom field (within Lead Connector) with those items as text

I know how I would usually get a value by the key using get/map. But this one is throwing me off because there are 3 values and they have the additional resourceValue label instead of value, and are deeper nested.

Currently I’m just using
{{map(11.lineItems.metaData; “value”; “key”; “ph_bookings_resources_booking_data”)}}

But it’s returning “resourceValue” and “resourceLabel” and ‘yes’ in the custom field as well.

Let me know any ideas for how I can pull just those resourceLabel names into the custom field instead of all the extras.

Thanks in advance!

1 Like

Hi @David_Gilbert

Check out the attached blueprint and let us know if it helps you.

Community.blueprint.json (9.6 KB)
If you could share the output bundle we could further assist you.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

Hello thanks for the reply, what’s the best way to share the output bundle?

1 Like

Hi @David_Gilbert


Copy the output and share

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation

Hello, sorry for the delay, let me know if this is the right way to share it, pasting below. If there’s a better way to share this please let me know. The data I’m trying to bring into a Contact via Make is listed under ID’s 754, 755, 756.

[
{
“id”: 602,
“status”: “processing”,
“currency”: “USD”,
“version”: “9.9.5”,
“total”: “152.49”,
“billing”: {
“company”: null,
“city”: “Brooklyn”,
“state”: “NY”,
“postcode”: “11209”,
“country”: “US”,
“email”: “gilbertdavid32@gmail.com”,
“phone”: “18326284162”,
“firstName”: “Test”,
“lastName”: “Gilbert”,
“address1”: “8005 6th Ave”,
“address2”: null
},
“shipping”: {
“company”: null,
“city”: null,
“state”: null,
“postcode”: null,
“country”: null,
“phone”: null,
“firstName”: null,
“lastName”: null,
“address1”: null,
“address2”: null
},
“number”: “602”,
“refunds”: ,
“parentId”: 0,
“pricesIncludeTax”: false,
“dateCreated”: “2025-06-27T15:04:55.000Z”,
“dateModified”: “2025-06-27T15:04:56.000Z”,
“discountTotal”: “0.00”,
“discountTax”: “0.00”,
“shippingTotal”: “0.00”,
“shippingTax”: “0.00”,
“cartTax”: “12.49”,
“totalTax”: “12.49”,
“customerId”: 0,
“orderKey”: “wc_order_AE4EghOs2lR4z”,
“paymentMethod”: “cod”,
“paymentMethodTitle”: “Unavailable”,
“transactionId”: null,
“customerIpAddress”: “158.222.175.143”,
“customerUserAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36”,
“createdVia”: “checkout”,
“customerNote”: null,
“dateCompleted”: null,
“datePaid”: null,
“cartHash”: “65022e9b87236893714ef08290412de7”,
“metaData”: [
{
“id”: 588,
“key”: “_wc_order_attribution_device_type”,
“value”: “Desktop”
},
{
“id”: 586,
“key”: “_wc_order_attribution_session_count”,
“value”: “1”
},
{
“id”: 583,
“key”: “_wc_order_attribution_session_entry”,
“value”: “https://book.kinecttrailerrentals.com/
},
{
“id”: 585,
“key”: “_wc_order_attribution_session_pages”,
“value”: “7”
},
{
“id”: 584,
“key”: “_wc_order_attribution_session_start_time”,
“value”: “2025-06-27T20:33:30.000Z”
},
{
“id”: 581,
“key”: “_wc_order_attribution_source_type”,
“value”: “typein”
},
{
“id”: 587,
“key”: “_wc_order_attribution_user_agent”,
“value”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36”
},
{
“id”: 582,
“key”: “_wc_order_attribution_utm_source”,
“value”: “(direct)”
},
{
“id”: 578,
“key”: “is_vat_exempt”,
“value”: “no”
}
],
“lineItems”: [
{
“id”: 54,
“name”: “18ft Utility Trailer”,
“quantity”: 1,
“subtotal”: “140.00”,
“total”: “140.00”,
“taxes”: [
{
“id”: 1,
“total”: “12.488”,
“subtotal”: “12.488”
}
],
“sku”: null,
“price”: 140,
“image”: {
“id”: “379”,
“src”: “https://book.kinecttrailerrentals.com/wp-content/uploads/2025/06/18ft-utility-trailer.webp
},
“productId”: 376,
“variationId”: 0,
“taxClass”: null,
“subtotalTax”: “12.49”,
“totalTax”: “12.49”,
“metaData”: [
{
“id”: 753,
“key”: “_phive_booking_product_interval_details”,
“value”: {
“interval”: “1”,
“intervalFormat”: “hour”
},
“displayKey”: “_phive_booking_product_interval_details”,
“displayValue”: {
“interval”: “1”,
“intervalFormat”: “hour”
}
},
{
“id”: 754,
“key”: “2inch Ball and Receiver ($20)”,
“value”: “yes”,
“displayKey”: “2inch Ball and Receiver ($20)”,
“displayValue”: “yes”
},
{
“id”: 755,
“key”: “4 Ratchet Straps ($20)”,
“value”: “yes”,
“displayKey”: “4 Ratchet Straps ($20)”,
“displayValue”: “yes”
},
{
“id”: 756,
“key”: “2 Ratchet Straps ($10)”,
“value”: “yes”,
“displayKey”: “2 Ratchet Straps ($10)”,
“displayValue”: “yes”
},
{
“id”: 757,
“key”: “ph_bookings_resources_booking_data”,
“value”: [
{
“resourceLabel”: “2inch Ball and Receiver ($20)”,
“resourceStatus”: “yes”
},
{
“resourceLabel”: “4 Ratchet Straps ($20)”,
“resourceStatus”: “yes”
},
{
“resourceLabel”: “2 Ratchet Straps ($10)”,
“resourceStatus”: “yes”
}
],
“displayKey”: “ph_bookings_resources_booking_data”,
“displayValue”: [
{
“resourceLabel”: “2inch Ball and Receiver ($20)”,
“resourceStatus”: “yes”
},
{
“resourceLabel”: “4 Ratchet Straps ($20)”,
“resourceStatus”: “yes”
},
{
“resourceLabel”: “2 Ratchet Straps ($10)”,
“resourceStatus”: “yes”
}
]
},
{
“id”: 758,
“key”: “From”,
“value”: [
“2025-08-05 08:00”
],
“displayKey”: “From”,
“displayValue”: [
“2025-08-05 08:00”
]
},
{
“id”: 759,
“key”: “To”,
“value”: [
“2025-08-05 08:00”
],
“displayKey”: “To”,
“displayValue”: [
“2025-08-05 08:00”
]
},
{
“id”: 760,
“key”: “Booked From”,
“value”: “August 5, 2025 8:00 am”,
“displayKey”: “Booked From”,
“displayValue”: “August 5, 2025 8:00 am”
},
{
“id”: 761,
“key”: “phive_display_time_from”,
“value”: [
“August 5, 2025 8:00 am”
],
“displayKey”: “phive_display_time_from”,
“displayValue”: [
“August 5, 2025 8:00 am”
]
},
{
“id”: 762,
“key”: “Booked To”,
“value”: “August 5, 2025 9:00 am”,
“displayKey”: “Booked To”,
“displayValue”: “August 5, 2025 9:00 am”
},
{
“id”: 763,
“key”: “phive_display_time_to”,
“value”: [
“August 5, 2025 9:00 am”
],
“displayKey”: “phive_display_time_to”,
“displayValue”: [
“August 5, 2025 9:00 am”
]
},
{
“id”: 764,
“key”: “Cost”,
“value”: [
140
],
“displayKey”: “Cost”,
“displayValue”: [
140
]
},
{
“id”: 765,
“key”: “booking_status”,
“value”: [
“un-paid”
],
“displayKey”: “booking_status”,
“displayValue”: [
“un-paid”
]
},
{
“id”: 766,
“key”: “Booking Status”,
“value”: “Unpaid”,
“displayKey”: “Booking Status”,
“displayValue”: “Unpaid”
},
{
“id”: 767,
“key”: “buffer_before_id”,
“value”: [
“600”
],
“displayKey”: “buffer_before_id”,
“displayValue”: [
“600”
]
},
{
“id”: 768,
“key”: “buffer_after_id”,
“value”: [
“601”
],
“displayKey”: “buffer_after_id”,
“displayValue”: [
“601”
]
}
],
“parentName”: null
}
],
“taxLines”: [
{
“id”: 55,
“label”: “OK Tax”,
“compound”: true,
“rateCode”: “US-OK TAX-1”,
“rateId”: 1,
“taxTotal”: “12.49”,
“shippingTaxTotal”: “0.00”,
“ratePercent”: 8.92,
“metaData”:
}
],
“shippingLines”: ,
“feeLines”: ,
“couponLines”: ,
“paymentUrl”: “https://book.kinecttrailerrentals.com/checkout/order-pay/602/?pay_for_order=true&key=wc_order_AE4EghOs2lR4z”,
“isEditable”: true,
“needsPayment”: false,
“needsProcessing”: true,
“currencySymbol”: “$”
}
]