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 have a mySQL to Zoho CRM Zap. Everything works great except some of my fields in the mySQL database are JSON formatted. What I need to do is to reformat the JSON data into separate fields for import into Zoho CRM.

This is the json in one of the fields:

{

   "title":"Lifetime",

   "expirationtype":"forever",

   "expiration":"000000000000",

   "recurrence_count":"0",

   "price":"699.00",

   "trial_price_1":"0.00",

   "trial_time_1":"000000000000",

   "trial_price_2":"0.00",

   "trial_time_2":"000000000000"

}

So I need to pull out just the price and remap it to another field in Zoho. Here is what the field looks like:

Createupdate module entry in Zoho CRM when new or updated row in MySQL Zapier 2020-03-06 15-57-02.png

Any ideas? Thanks!


Hi @Garrett It looks like this is coming as a line item array, is that right?

If so, you can use the Formatter app to turn the line items into text. Then you can use another Formatter step to split the text and get the data that you need.

For the Line item to text step, select the Formatter app then choose 'Utilities' as the Action Event. For the Transform, choose Line item to text. That will turn the json array into a text string separated by commas.

You can then use another Formatter step (or probably more than one) to split the text and get the Price from the text.


Terms & Conditions