I am using the Woocommerce Gift card plugin on my website. The scenario is to get the Giftcard order details in a Google Sheet. There are a few additional fields when a gift card is purchased, like the recipient’s email, message for them etc.
I can see these details as the output of the Watch Orders Woocommerce module. But I do not see these fields in the mapping option for the Add a Row Google sheets module.
I have added screenshots illustrating this point.
How could I get these details from the Watch module to map into a Google Sheet?
It’s probably in the metadata array.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
The data is all there in the array (attachment 1 - Watch Orders)
But I can’t find the corresponding data in the mappable fields for Add a Row module (attachment 2 - Add a Row)
Welcome to the Make community!
You can use the built-in functions map and get (or first) to access variables within an array.
To do this, you can use the built-in function map —
{{ map(complex array; key;[key for filtering];[possible values for filtering separated by a comma]) }}
and the built-in function get —
{{ get(object or array; path) }}
e.g.:
{{ first(map(1.line_items.1.meta_data; "value"; "key"; "wc_gc_giftcard_to_multiple")) }}
For more information, the function’s documentation can be found in the Help Centre. and the “Mapping with Arrays” link below. You should also complete the tutorials in the Make Academy, especially Using get() and map() functions.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
Help Centre Basics
Articles & Videos
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
