Forum Discussion
Helper IIIParsing JSON Using a Schema
You will probably need to have a version that you can make minor modifications to for each schema. You can create a master schema map with an alignment to the required transformations.
Helper IIIThanks jennratten . This looks like a good solution for my example. The trouble I have is, in the real database, there are hundreds of different form templates, all with different levels of nesting and different field names. So I won't be able to type those all out in a query. I think given the "id" field is consistent across all form templates, that should make it easier. But what i'm not sure about is how to handle all the different nesting.
Super UserYou will probably need to have a version that you can make minor modifications to for each schema. You can create a master schema map with an alignment to the required transformations.