How to Get Properties from Chart with OpenAPI and GQL in DataHub

getting-started
1

Original Slack Thread

Hi All
I want to get Properties from Chart with OpenApi
Is there any example or documentation for doing this?

attachment
attachment1911×873 85 KB

2 
  curl -X 'GET' \
  '<http://localhost:9002/openapi/v2/entity/dataset/{chart_urn}/editabledatasetproperties?systemMetadata=false>' \
  -H 'accept: application/json'```
3

<@U0445MUD81W> how can i get the chart_urn?
i used datahub 0.10.4
and this chart is from Metabase platform

4

you can use this GQL to get all URNs in of type “CHART” in given platform

              search(input: {type: CHART, 
               query: "*", start: 0, count: 10
                  orFilters: [
                  {
                    and: [
                    {
                          field: "platform"
                          values: ["tableau"]
                          condition: CONTAIN
                      }
                    ]
                  }
                ]
              }
              ){
                start
                count
                total
                searchResults {
                  entity {
                    urn
                    ... on Dataset {
                      urn
                      }
                    }
                  }
                }
            }```
5

I got this message <@U0445MUD81W>

    "servlet": "openapiServlet",
    "message": "Not Found",
    "url": "/openapi/v2/entity/dataset/urn:li:chart:(metabase,1019)/editabledatasetproperties",
    "status": "404"
}```
6

hey it looks this this openapi is not supported in v0.10.4
it is available in later releases
https://demo.datahubproject.io/openapi/swagger-ui/index.html#/editableDatasetProperties%20Aspect/getEditableDatasetProperties

7

can’t you use GQL for the same …?

8

oh
<@U0445MUD81W> can you give me an example of GQL to get the same result as

  '<http://localhost:9002/openapi/v2/entity/dataset/{chart_urn}/editabledatasetproperties?systemMetadata=false>' \
  -H 'accept: application/json'```
9

using chart urn

  chart(urn: "&lt;urn&gt;") {
    urn
    type
    exists
    lastIngested
    tool
    chartId
    platform {
     name
    }
    properties {
      name
      description
      externalUrl
      type
      access
      lastRefreshed
      lastModified {
        time

      }
      created {
        time

      }
      customProperties {
        key
        value

      }
      __typename
    }
    editableProperties {
      description
      __typename
    }
}
}```
10

using search with querying string

        search(input: { count: 1,type:CHART, query: "&lt;search_str&gt;"}) {
          searchResults {
            entity {
              urn
              type
              ... on Chart {
                info {
                  name
                  externalUrl
                }
                platform {
                  name
                }
                 properties {
                name
                description
                customProperties {
                key
                value
                }
                externalUrl
              
            }
            editableProperties {
                description
            }
              }
            }
          }
        }
      }```
11

its work <@U0445MUD81W>
Thank you so much :+1::100: