Skip to main content

I’m working on a zap that pulls data from an online order form into my project manager smartsuite. 

When I load up the test data (from Rela), it shows my service intake questions, neatly formatted with product ID, the question, and the client response.

 

Once I’m in the later steps, Zapier appears to have grouped together all of the questions and responses, separated by commas. Even if I use formatter to split these, I still can’t identify which question they are answering, because the answers are always unique. 

How can I access the data in its original form? Ideally I would use the Product ID to identify and map the answer to the correct field in Smartsuite. 

 

Service Intake Data as received from Rela. Q&A’s ​​are separated by Order ID

 

Service Intake Data as formatted by Zapier. Q&A’s are grouped now.
Formatting to split text won’t work because the responses can be unique.

 

Hi ​@reggie_sc 

The data is being returned as an array of objects.

Array means a set of items. (notice the 1, 2, 3)

Object means a set of data points. (e.g. id, question, answer, etc.)

 

Follow this guide to add Zap steps to convert each into it’s own variable that you can map.

 


Hi there ​@reggie_sc 👋

Did the guide Troy shared help you to map the relevant data from Rela as needed?

Let us know how it went, want to make sure this gets sorted!