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
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 99 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 728 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive