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:
So I need to pull out just the price and remap it to another field in Zoho. Here is what the field looks like:
Any ideas? Thanks!
Best answer by Danvers
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.