Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am integrating my API with Zapier and I am faced with a trouble. I am sending data from API in this format:

{
  "email": "player@domain.com",
  "phoneNumber": "+380991234567",
  "fullName": "John Doe",
  "termsAccepted": true,
  "extra": "{\"city\":\"New York\", \"hobby\":\"music\"}",
  "campaignId": 1,
  "createdAt": "2021-03-16T12:36:44.595Z",
  "updatedAt": "2021-06-24T21:18:47.871Z"
}

Every time API send extra field with different structure. For next request data can be in another format:

{
  "email": "player@domain.com",
  "phoneNumber": "+380991234567",
  "fullName": "John Doe",
  "termsAccepted": true,
  "extra": "{\"car\":\"Audi\", \"country\":\"USA\"}",
  "campaignId": 1,
  "createdAt": "2021-03-16T12:36:44.595Z",
  "updatedAt": "2021-06-24T21:18:47.871Z"
}

For the trigger, I added user input data to choose the fields to process from the extra field, but I don't understand how to use fields from json in next steps

The structure of the extra field will vary for different campaigns. I am getting a list of fields for extra from the API, but I don't understand how to add these fields to the output data. I tried adding these fields for the PerformList response, but it didn't help. Extra fields were available, but after processing the event extra fields were empty. I added code for processing Perform:

 return r{ ...bundle.cleanedRequest, ...bundle.cleanedRequest.extra }];

I did a Gmail integration, checked the Zap history and saw this result:

 

 

I expect to see data from country field, but got 139225185__country

I would be grateful for any help @Zane 

 

Your Zap editor message says ‘county’, not ‘country’. Did you perhaps map the wrong field? That’s the first thing I’d look at. 

A general statement about custom fields (you may have sorted this out already, but for others reading this):

The country field needs to be mapped explicitly in the Zap editor. Zap steps only have access to data the user chooses to make available. 

While Zapier supports custom/user-defined fields (where a user sees fields in their result that other users don’t see) it is still expected that each response for that Zap instance is consistent with sample that the user used to map their fields in the Zap editor.  So if fields in the result are changing from response to response to a given Zap instance, it’s not going to work well with Zapier. You’ll probably want to have them choose a specific campaign, and have a single trigger instance only work with that data, so that the shape and content of the data is completely consistent from response to response. 

 

You're right. I just had a typo :(

Terms & Conditions