Parsing JSON from a CSV upload

I’m bulk uploading data via CSV file and one of the columns has JSON data in it…

Anyway to parse this?

I tried the JSON Machine plugin but I couldn’t get it to work, and in their example they manually type the key, which in my case it will be dynamic.

CleanShot 2021-05-06 at 18.37.52@2x

Thank you :pray:

@marius, the JSON is missing a } at the end to close off the object so is not valid which is why you are not able to parse it.

It should look like this:

"{\"Power Supply\": {\"some_other_key\":\"some value\", \"some_key\":\"another value\", \"Focal Length\":\"150.0-500.0\"}}"

Thank you so much @Eli. Unfortunately, that didn’t fix my issue with using the JSON Machine plugin.

I’m just not even sure where to start with that plugin, it’s incredibly confusing to me… but I’ll keep trying to figure it out. Thank you.

This topic was automatically closed after 70 days. New replies are no longer allowed.