How can we access nested JSON array elements in a Zapier Webhook?
Given this incoming JSON structure:
lead_id
user_column_data:[
{column_name:User Email,
string_value:test@example.com,
column_id:EMAIL},
{column_name:First Name,
string_value:FirstName,
column_id:FIRST_NAME},
{column_name:Last Name,
string_value:LastName,
column_id:LAST_NAME},
{column_name:User Phone,
string_value:+16505550123,
column_id:PHONE_NUMBER},
{column_name:Region,
string_value:California,
column_id:REGION}
],
api_version:1.0,
form_id:6849587745,
campaign_id:6544203960,
google_key:J2wp6st683bfTQRcD8l6v36LLfeaoV9fHoHtNRC0HB7tr90PiG,
is_test:true,
adgroup_id:0,
creative_id:0
... we need to access these elements:
lead_id
First Name
Last Name
User Phone
Region
campaign_id
adgroup_id
creative_id
form_id
api_version
I tried wiring up these paths:
lead_id
{{user_column_data[1].string_value}}
{{user_column_data[2].string_value}}
{{user_column_data[3].string_value}}
{{user_column_data[4].string_value}}
{{user_column_data[5].string_value}}
campaign_id
adgroup_id
creative_id
form_id
api_version
... and we do get the outer elements (lead_id, campaign_id, adgroup_id, etc.), but I'm not able to access any individual JSON elements from the array, e.g.:
{{user_column_data[1].string_value}}
... which should represent the email address.
Am I missing something obvious here? I couldn't find any definitive information in your support system for JSON arrays.