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.

Hi, I’ve created a zap which integrates Shopify new orders with Monday.com.

Shopify Line Items has properties. I am finding it difficult to work with null values in the Line Items Properties array.

Here’s how it looks: 

Line Items Properties Values:
b"M=P&L=153560&D=2020-12-18T14:00:00Z"], null, null, null, u"https://cdn.shopify.com/s/files/1/0499/9980/6623/uploads/4d061b54000c2b93edd371df2f8178aa.jpg"]

I want to add a placeholder for null values so the order remains same for Line Items Properties values.

Zapier ignores null values and output: p"M=P&L=153560&D=2020-12-18T14:00:00Z"],0"https://cdn.shopify.com/s/files/1/0499/9980/6623/uploads/4d061b54000c2b93edd371df2f8178aa.jpg"]

Hi @adilalich 

Unfortunately, Zapier doesn’t have any real way to handle null values. I’ve tried to solve the exact same problem you have and not had any luck.

It’s discussed a little more here:

 

Hi @AndrewJDavison_Luhhu 

Thank you for your reply. I saw this post when I googled the issue, but I thought maybe we need an update on this similar issue that’s why I created this post but looks like it’s an issue we can’t deal with at the moment.

 

Indeed @adilalich - it seems it’s to do with the way null values are interpreted in coding. It’s hard to deal with in a universal way that won’t break things in other situations.

@AndrewJDavison_Luhhu about time Zapier gives us the raw json response us well.

Agreed @adilalich!

@AndrewJDavison_Luhhu about time Zapier gives us the raw json response us well.

I would love this! 

 

@adilalich - I wonder if there’s a way to turn your line items into a string before being parsed as line items, and then turn them back into line items in the code? 

Terms & Conditions