Dataset column description mass load
Best Answer
-
You can do this via the API
STEP 1
Create a POST request to
"https://YOURDOMAIN.domo.com/api/query/v1/datasources/YOURDATASETID/wrangle"
in the header include the KEY - x-domo-authentication with the API key you get via POST REQUEST
STEP 2
"https://YOURDOMAIN.domo.com/api/content/v2/authentication" Body of Post will have
{
"method": "password",
"emailAddress": "JOe.Bloggs@MYACOOUNT.com",
"password" :"ROOT!@#$"
}
in the first Post call you will include your 800 columns in JSON you can extract the json via the dom when you change the description of a column and record the network traffic example below.
modify the descriptions and post it. Bit strange that something that takes 3 steps via api cannot be automated in domo
{
"columns": [
{
"name": "Last Date Published",
"id": "Last Date Published",
"type": "DATE",
"description": "Last date available in the data",
"visible": true,
"order": 0,
"referenceDataSourceId": "c7XXXXXXXX5-3ab1-4f45-9253-f9fy6bd094d",
"invalid": false,
"newName": "Last Date Published"
}
]}
0
Answers
-
You can't do a mass update via the UI. If you wanted to write a script to interface with the APIs it would be an option but would require a very technical resource.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@Jmoreno - I would also want you to know, before you update the descriptions for 800+ fields... Those descriptions will not persist through a dataflow. Meaning that if you use that dataset in an ETL or MySQL dataflow, you will need to add the descriptions all over again.
We only add descriptions for certain key fields or for fields that may be named similarly but have different sources or slightly different meanings.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1 -
You can do this via the API
STEP 1
Create a POST request to
"https://YOURDOMAIN.domo.com/api/query/v1/datasources/YOURDATASETID/wrangle"
in the header include the KEY - x-domo-authentication with the API key you get via POST REQUEST
STEP 2
"https://YOURDOMAIN.domo.com/api/content/v2/authentication" Body of Post will have
{
"method": "password",
"emailAddress": "JOe.Bloggs@MYACOOUNT.com",
"password" :"ROOT!@#$"
}
in the first Post call you will include your 800 columns in JSON you can extract the json via the dom when you change the description of a column and record the network traffic example below.
modify the descriptions and post it. Bit strange that something that takes 3 steps via api cannot be automated in domo
{
"columns": [
{
"name": "Last Date Published",
"id": "Last Date Published",
"type": "DATE",
"description": "Last date available in the data",
"visible": true,
"order": 0,
"referenceDataSourceId": "c7XXXXXXXX5-3ab1-4f45-9253-f9fy6bd094d",
"invalid": false,
"newName": "Last Date Published"
}
]}
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
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 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