Forum Discussion

russell80's avatar
russell80
Icon for Helper III rankHelper III
3 years ago
Solved

Parsing JSON Using a Schema

I have a table in an SQL database that holds the records of submitted forms. The form fields aren't held in columns in the database, but instead are stored in a JSON string in a column. To get the da...
Need Help
  • jennratten's avatar
    jennratten
    3 years ago

    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.

jennratten's avatar
jennratten
Icon for Super User rankSuper User
3 years ago

Hello - I have worked with simiar data structures and in my opinion, the most reliable solution uses the schema.  Depending on the depth of the json it can get pretty lucrative.  I have attached a sample for you that include many examples.