Dataset column description mass load
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.” -Superman
______________________________________________________________________________________________1 -
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": "[email protected]",
"password" :"[email protected]#$"
}
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
- 7.6K All Categories
- Connect
- 913 Connectors
- 241 Workbench
- 470 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 23 Visualize
- 194 Beast Mode
- 2K Charting
- 6 Variables
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- Workflows
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 17 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部