Unable to Extract Contact Custom Fields Value from Cvent

Hi @Troy Tessalone That is the guide I was using. I just got stuck on the Action: Formatter > Utilities > Line Items to Text step because of the way the ‘answer’ portion is outputting.

@Dconnors 

NOTE: From the Guide, use a different separator, carrot ^ instead of comma.

Guide shows:

Your screenshot:

@Dconnors

Can you post screenshots with the DATA OUT that is returned from Cvent for those related fields?

So we can see the original data structure you are trying to use.

It may be that the array is nested, and thus becomes flattened in the Zap, which means a more advanced approach would have to be used.

@Dconnors 

If that is how the data is returned from Cvent in the Zap step, then the data is a comma delimited list rather than an array of items, which is why the guide you followed is not producing the desired results.

Try this workaround:

Add 2 Formatter steps for each data point before using the Formatter > Utilities > Line Items to Text step as instructed by the guide.

Action: Formatter > Utilities > Text to Line Items (Split by comma)

That will turn the strings to line items.

Then map the 2 Formatter step outputs to be the 2 input variables with the | and the ^ Separator.

@Dconnors 

From the screenshots below, something is still amiss with the data because it’s returning an array (1-5) where each array item has an inner array (1).

Likely is a result of how the data is originally output from Cvent.

Hard to tell without seeing more screenshots with all the DATA OUT form the Cvent setp.

Below it’s creating multiple arrays (1, 2) within arrays (1-8).

@Dconnors 

Did you figure it out?

@Dconnors 

If the data comes thru for the Q&A, then it likely have be handled, but may need an advanced approach to do so.

Directory of Certified Zapier Experts available for hire: https://zapier.com/experts