Dataset column description mass load

Jmoreno
Jmoreno Member
in Magic ETL

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?


image.png


Best Answer

  • AnwarBham
    AnwarBham Contributor
    edited February 2023 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"

        }

    ]}

Answers

  • GrantSmith
    GrantSmith Coach

    @Jmoreno

    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!**
  • ST_-Superman-_
    ST_-Superman-_ Coach

    @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
  • AnwarBham
    AnwarBham Contributor
    edited February 2023 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"

        }

    ]}

Categories