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:
["M=P&L=153560&D=2020-12-18T14:00:00Z"], null, null, null, ["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: ["M=P&L=153560&D=2020-12-18T14:00:00Z"],["https://cdn.shopify.com/s/files/1/0499/9980/6623/uploads/4d061b54000c2b93edd371df2f8178aa.jpg"]
Best answer by adilalichView original
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:
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.
@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.
I would love this!