Best answer

Accessing a multidimensional array

  • 21 January 2021
  • 1 reply
  • 131 views

Hi

I am relatively new to Zapier. We have a data source in our first step that includes what looks like a multidimensional array data structure called ‘properties’

 

All fine so far.

However when we try extract this data for inclusion in a CRM database in step 3, this properties variable is combined into a comma separated string (see below) and we are unable to split the values open to use in different fields.

 

 

Is this possible at all? Any help would be very much appreciated.

 

Thanks

Jonathan

 

This post has been modified by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information as this is a public forum. 

icon

Best answer by GetUWired 27 January 2021, 15:08

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +12

@Jonathan Davies 

Just checking in to see if you still need help with this? 

Will the properties always be the same. i.e. an email address and a start time?

Without code, the easiest way to extract the data would be using Zapier’s formatter action. 
https://zapier.com/help/doc/how-get-started-formatter-zapier