Line Itemizer returning values with ", [ and ], which can't be used in add multiple rows in googe sheet

Status: Closed · Asked by Emily Reynolds on Jul 3, 2023 · 0 views

Emily — Question · Jul 3, 2023

Your Workflow URL: https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZkMDYzZjA0MzU1MjY1NTUzNzUxMzIi_pc

I used "Lookup Spreadsheet Rows" and then "Line Itemizer" the result contains ", [ and ]

Can't use these with my next step - add multiple rows in googe sheet. Shows error code 400
Is the only thing I can do is to replace it one by one?

Pabblymember11 — Reply · Jul 4, 2023

Hey @Emily

Regarding your concern, we recommend you to use replace the [" and "] brackets from your array with the help of Text Formatter.

Further, as we can see from your workflow you have already implemented the best possible trick to manage the line item.