JSON Converter Output to Array Variable

bbrennen

I'm thinking this should be something simple but can't find any help with this on the internet.

I'm using Landmark Admin node to do a dbexport to a variable, then taking that output to a JSON Converter using CSV→JSON and then a JSON Parser node to create an array variable.

When the variable is populated and I try to access it like an array, it returns each letter/number as a separate value instead of recognizing the columns of the array.
array[1][1]

Thanks in advance for any help.

Maureen

It sounds like your overall flow is correct (DB Export → CSV→JSON → JSON Parser), but the issue is usually with how the JSON Parser is configured to map the data into an array variable.

When you convert CSV to JSON, make sure the output format is actually a JSON array (e.g., [ {...}, {...} ]). If the converter is producing individual objects instead of a proper array, the JSON Parser won’t automatically create the array variable the way you expect. In that case, try wrapping the objects in an array before passing them to the parser, or configure the parser’s path to the root array (often something like $ depending on the node).

Also double-check that the variable type you’re assigning in the JSON Parser is set to Array and not String or Object, otherwise it will just store the raw JSON.

I ran into something similar before and found a couple of troubleshooting ideas online — you might want to check this as well since it helped me understand how the conversion pipeline behaves between nodes.

Hope that helps!