Dataset column description mass load

Jmoreno

Is there a way to be able to edit the column description field massively. For example if I have all the descriptions that need to be input but there are datasets that have over 800 columns .... is there a way I can upload these to the dataset?

AnwarBham

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"

    }

]}