Hi there,

I’m looking into the bulk profile importation method via SFTP and it seems straightforward enough.

The challenge I currently have is with importing custom properties that have JSON values, for example a checklist of multiple values will be rendered as JSON within Klaviyo: ["example 1","example 2"]

It seems that the SFTP CSV interprets double-quotes and commas as special characters, so adding those same characters in a JSON field is tricky. I tried something like:

"Email","Custom Property"
"example@example.com","[\"example 1\",\"example 2\"]"

I can only assume that this is not currently supported by the SFTP import method, or that there’s some way to format the JSON data that is not visibly documented (I haven’t been able to find anything yet that covers this specific use case).

I’ve tried encoding using \uXXXX notation for the double quotes and commas as well, however it just imports in the same value I give it (which makes sense).

Could it be possible to change the content and column delimiters for interpreting the CSV file? It could even be based on the file extension (e.g. TSV for tab-separated values instead of CSV). Using a backtick (`) as an optional content delimiter could help too, e.g.
`["example 1","example 2"]`