Help parsing arbitrary-length JSON object formatted as a string into database

Need help Plugins
1

Hi everyone, I’m working with an API that returns a json object with nested string of another json object as such:

{
“example key”: “example value”
“example key”: [
{
“need help here”: “\n\n{\n “example key”: “example value”\n}”,
}
]
}

I want to parse the nested json string into the database, how to do this? I’ve played around with JSON.parse plugin but at best it can only extract one value at a time and requires me to hard code the name of the key I’m trying to access.

A solution would help me parse this string and get it’s data into the database.

2

Just found this response to the same question, so looking into it: Parse string that is JSON object

3

have a look at demo and editor of this plugin. i’ve seen nested parsing

1 Like
4

Thank you. I see the example app here https://getjson.bubbleapps.io/, but do you know how I can inspect the actual bubble settings?

5

Ok, I see you can press the “editor” button in the example.

6

Back for posterity, the editor view was very helpful. Worth noting that modifyJSON can be accessed from the workflow ui in the elements menu not the plugins menu. Happy bubbling all. Happy to help if anyone gets stuck with this plugin.

1 Like