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

How to get json data in Code step?

  • 2 February 2022
  • 13 replies
  • 4437 views
K 
I have some data coming in in json format with Zap.(Attached "Long Answer")
I want to use that json data in Code Step (JavaScript), but when I do JSON.parse, the test succeeds and the Zap execution fails.(Is the input format different between test and runtime?)
For example, the following code will fail.
// *input data
// {"object":"AAA", "id":"BBB"}

const fixed_json = JSON.parse(inputData.text);

output = {"result" : fixed_json.object};
How can I get the contents of the incoming json data with inputData?
icon

Best answer by mattc526 1 April 2022, 20:47

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.

13 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @kt1111 

This worked when tested.

 

INPUT

 

OUTPUT

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K

Hi @Troy Tessalone ,

Thank you for verifying.Is your result the result of actually launching the Zap scenario, not the test run?
Also, you input the value directly in the inputData, but what if you are referencing the value from another node as in my first figure?
Troy Tessalone
Userlevel 7
Badge +14

@kt1111 

When you see {{placeholder}} it means the mapped variable was blank/null/empty/missing.

Check your Zap Runs for the DATA IN/OUT for each Zap step in a live triggered Zap Run: https://zapier.com/app/history/

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K

@Troy Tessalone 

The data sent from the previous step is:


Is the input empty because the format that can be received by Code Step is different?

ikbelkirasan
Userlevel 7
Badge +12

Hi @kt1111 - You'll need to explicitly map the different values from the Long Answer object in the code step because it can't accept objects.

Ikbel | Building custom Zapier Apps | Want to build a custom Zapier app for an API? Visit our website: https://norapps.com Or email us at info@norapps.net
K

Hi @ikbelkirasan ,

Does the inability to accept an object mean that I can't refer to the value from another step as shown in the image?
Or does it mean that the value entered in the Long Answer field is unacceptable due to the json format?

GetUWired
Userlevel 7
Badge +12

Hi @kt1111 

in your screenshot, it looks like Zapier has already parsed the object Long Answer and in the next zapier steps you will have data fields like Long Answer object, Long Answer id, Long Answer lead_price, etc… 

You will need to map the individual fields unless you rebuild or have access to the raw json from the previous step

M
Userlevel 1

Question - how do we include error checking in that code above? My zap keeps stopping because there is no data in the object. Can you add some code that would just skip it if the data is empty?

Troy Tessalone
Userlevel 7
Badge +14

Hi @mattc526 

Good question.

A Filter step can be used to check if a variable exists: https://zapier.com/apps/filter/help

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
Userlevel 1

I appreciate the speedy reply Troy! Only issue is that I want the zap to run no matter what. Filters are good for stopping the zap if a condition isn’t met.

Basically, sometimes there is data in the object, and sometimes there isn’t. Even if there isn’t data there, I need the zap to continue firing. 

Troy Tessalone
Userlevel 7
Badge +14

@mattc526 

Perhaps Paths: https://zapier.com/paths

Otherwise, you’ll have to add additional logic to the Code to handle if an input data point is null or not.

Check out this help topic:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
M
Userlevel 1

Hi Troy (and anyone else that might need this) I got it!

let myInputData = inputData.text;
let finalData = "";

if (myInputData != null) {
  finalData = {"result" : JSON.parse(inputData.text).name}; 
} else {
  finalData = {"result" : ""};
}

output = finalData;

This code is when metadata comes over from stripe and needs to be parsed ONLY when the metadata is present. If the metadata isn’t there, then the output is empty. If it is there, then we output only the “name” that comes from the json array from stripe. Hope that helps!

christina.d
Userlevel 7
Badge +9

Thanks so much for sharing your solution with the community, @mattc526! I know this is definitely going to help others. 🤗

Terms & Conditions