I have a zap that processes json data into a python script. when I assign the input data you can see that there are null values in the string. This is good and expected, but when it gets to the code the null values are removed. I have tried replacing the “,,” values with “,null,” but because the “,,” values are stripped out before the code runs this does not work. I think this is an issue with the code functions in zapier.
Best answer by Troy Tessalone
Try something like this…
Array with null values.
Formatter > Utilities > Line Items to Text
NOTE: Set a static value to join
Then you can handle the TEXT output how you want into the Code step.
+14Hi
Good question.
Try this workaround…
Use a Formatter > Utilities > Line Items to Text step first.
You can use that to combine arrays into 1.
e.g. [ARRAY1]|||[ARRAY2], which will handle the nulls.
Then you can pass that into the Code step and handle it better.
+14Try something like this…
Array with null values.
Formatter > Utilities > Line Items to Text
NOTE: Set a static value to join
Then you can handle the TEXT output how you want into the Code step.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
