Question

Can we parse values extracted from MetForm?

  • 23 January 2023
  • 6 replies
  • 114 views

Userlevel 1

Hi Zapmates!

 

I am getting this value from a MetForm:

{"mf-email":"bruce@wayneenterprises.com","mf-listing-fname":"Bruce","mf-listing-lname":"Wayne"}

Any ideas how to parse or extract the data on these? Like First Name, Last Name and Email. The CRM we are using is SalesPype.

 

Looking forward to your help.

 

Thanks!


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

6 replies

Userlevel 7
Badge +14

Hi @nikocena 

Good question.

Easiest is to use a JavaScript Code step: https://zapier.com/apps/code/help

 

 

let PARSED = JSON.parse(inputData.RAW);

output = [{PARSED}];

 

Userlevel 1

Hi @nikocena 

Good question.

Easiest is to use a Code step: https://zapier.com/apps/code/help

Hi, Troy! Thank you so much for your response. This would be Javascript, correct?

This seem to work. Thanks!

Would split-text work on the ‘mf-email?’

Userlevel 7
Badge +14

@nikocena 

Would split-text work on the ‘mf-email?’

Please explain further what you are trying to do?

Userlevel 1

@nikocena

Would split-text work on the ‘mf-email?’

Please explain further what you are trying to do?

I’m trying to extract just ‘Bruce.’ The code step was helpful but the value it returns has mf-fname with it.

Example: mf-fname: Bruce

Userlevel 7
Badge +14

@nikocena 

These are separate variables that can be mapped in following Zap steps.

 

 

Userlevel 1

@nikocena

These are separate variables that can be mapped in following Zap steps.

 

 

Hey, Troy. Thanks a lot with your help. I got it to work and clean up my data :)