I am running into an issue where I am using Parabola to import Shopify order data.
I use a third party app to gather extra variants like Height, Cape Color, Top Color, Top Size, etc. All of this data gets combined and imported into a column called “Line Items: Properties”.
I have been using JSON Expand to turn these parameters into individual columns and have figured out how to recombine them and stack them in a beautiful way and export to google sheets.
Everything has been working smoothly, UNTIL I imported an order that had a few items that don’t have these extra parameters. (a ring instead of a set of clothes)
Because there is no data in the “Line Items: Properties” for this item, it is causing the flow to expand BLANK space into all of the subsequent rows, where the items DO have “Line Items: Properties” data.
This is causing my flow to fail miserably. and I cant seem to figure out how to fix it.
When I go back a step in the flow, the information is all there. But when I try to expand, it creates blank space for all rows in this column.