Sending List Field and Product Data as Arrays to Zapier

Description

A very important change was implemented with Zapier 3.0. The data for List and Product fields is now sent to Zapier as an array. To maintain backwards compatibility, the data continues to be sent as a serialized string for the List field and individual fields for the Product fields as well. This new change should make consuming List and Product Field data much easier by the applications available in Zapier.

List Field

When the List field data is sent to Zapier, the data will be pre-pended with the name of the List field and a ” /”. Below is a sample form using the List field with what the data would look like when sent to Zapier. This List field was set up to have three columns.

Sample List Field Form

Sample Data for List Field Form

This is what the data looks like when sent to Zapier.

[Event Attendees /] =&gt; Array
(
[0] =&gt; Array
(
[Attendee] =&gt; Malcolm Reynolds
[Guest 1] =&gt; Zoe Washburne
[Guest 2] =&gt; Jayne Cobb
)

[1] =&gt; Array
(
[Attendee] =&gt; Inara Serra
[Guest 1] =&gt; Kaylee Frye
[Guest 2] =&gt; Shepherd Book
)

[2] =&gt; Array
(
[Attendee] =&gt; Simon Tam
[Guest 1] =&gt; River Tam
[Guest 2] =&gt; Hoban Washburne
)

)

Sample for List Field Form Submission Data in Zapier

This is how the form submission data from above looks in Zapier. You will notice the List field is still available in the data as a serialized string for backwards compatibility.

Sample for Mapping List Field Form Data in Zapier

This is how the data appears in Zapier when mapping it for an application. You will notice the List field is still available in the data as a serialized string for backwards compatibility.

Product Field

When the Product-related field data is sent to Zapier, the data will be pre-pended with the text “Products /“. Below is a sample form with two Single Product fields with an Option field each, a Shipping field, and a Total field with what the data would look like when sent to Zapier. The Shipping field will be sent as the last “product” in the Products array. In the data example below, each product with its id, name, quantity, price, options, price with options, and subtotal is a separate array within the Products array.

Sample Product Form

Sample Data for Product Form

This is what the product form data looks like when sent to Zapier.

[Products /] =&gt; Array
(
[0] =&gt; Array
(
[product_id] =&gt; 1
[product_name] =&gt; Frankenstein's Monster T-Shirt
[product_quantity] =&gt; 1
[product_price] =&gt; 15
[product_price_with_options] =&gt; 15
[product_subtotal] =&gt; 15
[product_options] =&gt; Blue
)

[1] =&gt; Array
(
[product_id] =&gt; 5
[product_name] =&gt; Creature from the Black Lagoon T-Shirt
[product_quantity] =&gt; 1
[product_price] =&gt; 15
[product_price_with_options] =&gt; 15
[product_subtotal] =&gt; 15
[product_options] =&gt; Grey
)

[2] =&gt; Array
(
[product_id] =&gt; 3
[product_name] =&gt; Shipping
[product_quantity] =&gt; 1
[product_price] =&gt; 7
[product_price_with_options] =&gt; 7
[product_subtotal] =&gt; 7
[product_options] =&gt;
)

)

Sample for Product Form Submission Data in Zapier

This is how the form submission data for the product form looks in Zapier. You will notice the Product information is still available in the data as separate fields for backwards compatibility.

Sample for Mapping Product Form Data in Zapier

This is how the product data appears in Zapier when mapping it for an application.You will notice the Product information is still available in the data as separate fields for backwards compatibility.