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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 10 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive