Question

Return a value based on building key value pairs from two comma separated lists

  • 25 July 2022
  • 2 replies
  • 72 views

I have an array thats coming into Zapier as two separate comma separated lists (see screenshot):

 

 

I want to be able to isolate the corresponding value for ‘google-clientID’ to use in another part of my Zap, what’s the best way for going about this? i.e. in the above example the value i’d want would be ‘814952396.1658487709’.

 

Any help greatly appreciated!

 

Cheers,


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

2 replies

Userlevel 7
Badge +14

Hi @fussy_matt 

Good question.

Check out this related topic:

 

Userlevel 7
Badge +9

Hey @fussy_matt is the ‘google-clientID’ always the first value in that list? If so, you should be able to convert those line items into text strings as separate fields using our Formatter app: https://zapier.com/help/create/format/convert-line-items-into-text-strings

Let us know which solution you end up trying and how it goes!