Best answer

Shopify Line Items Properties

  • 7 December 2020
  • 6 replies
  • 469 views

Userlevel 3
Badge +1

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"]

icon

Best answer by adilalich 8 December 2020, 16: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.

6 replies

Userlevel 7
Badge +10

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:

 

Userlevel 3
Badge +1

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.

 

Userlevel 7
Badge +10

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.

Userlevel 3
Badge +1

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

Userlevel 7
Badge +10

Agreed @adilalich!

Userlevel 7
Badge +9

@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?