json data

Jerome_pesso
Jerome_pesso Member
edited January 2023 in Magic ETL

We have a no SQL database, where our data is stored in Json format. Which is nested and has further nesting based on one to many relationships. We need to have a particular tabular form or method to map this dynamically changing data into domo

Answers

  • I use json oAuth connectors. Within the settings configuration there is a section for "Parsing." You can select one of the nested branch heading and expand it to create a dataset based specifically on that branch.

    For example, one of my branches holds "items". Expanding items creates a schema of columns that are the elements of the item branch.


    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • McSQL
    McSQL Domo Employee

    Agree with what ArborRose said. If you need more customization than this, you can use the new Jupyter integration. Within Jupyter, you can write custom python code to parse the information and transform it in to the desired format.

    **Say “Thanks" by clicking the thumbs up in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"