About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Remap mySQL JSON Fields into Zoho CRM?

  • 7 March 2020
  • 1 reply
  • 110 views
G
Userlevel 1

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!


icon

Best answer by Danvers 9 March 2020, 18:28

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

1 reply

Danvers
Userlevel 7
Badge +12

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