Skip to main content
Best answer

Shopify Line Items Properties

  • December 7, 2020
  • 6 replies
  • 499 views

adilalich
Forum|alt.badge.img+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"]

Best answer by adilalichBest answer by adilalich

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.

 

View original
Did this topic help you find an answer to your question?
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

AndrewJDavison_Luhhu
Forum|alt.badge.img+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:

 


adilalich
Forum|alt.badge.img+1
  • Author
  • Zapier Expert
  • 25 replies
  • Answer
  • December 8, 2020

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.

 


AndrewJDavison_Luhhu
Forum|alt.badge.img+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.


adilalich
Forum|alt.badge.img+1
  • Author
  • Zapier Expert
  • 25 replies
  • December 19, 2020

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


AndrewJDavison_Luhhu
Forum|alt.badge.img+10

Agreed @adilalich!


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • January 4, 2021
adilalich wrote:

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