json data
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! **0 -
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"0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 737 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive