Hi All
I want to get Properties from Chart with Op...
# getting-startedq
quaint-oxygen-29266
12/12/2023, 7:11 AMHi All
I want to get Properties from Chart with OpenApi
Is there any example or documentation for doing this?
g
gray-ocean-32209
12/12/2023, 1:51 PM Copy code
curl -X 'GET' \
'<http://localhost:9002/openapi/v2/entity/dataset/{chart_urn}/editabledatasetproperties?systemMetadata=false>' \
-H 'accept: application/json'thanks bear 1
q
quaint-oxygen-29266
12/14/2023, 6:13 AM@gray-ocean-32209 how can i get the chart_urn?
i used datahub 0.10.4
and this chart is from Metabase platform
g
gray-ocean-32209
12/14/2023, 6:37 AMyou can use this GQL to get all URNs in of type “CHART” in given platform
Copy code
query get_urns {
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
}
}
}
}
}q
quaint-oxygen-29266
12/14/2023, 6:46 AMI got this message @gray-ocean-32209
Copy code
{
"servlet": "openapiServlet",
"message": "Not Found",
"url": "/openapi/v2/entity/dataset/urn:li:chart:(metabase,1019)/editabledatasetproperties",
"status": "404"
}g
gray-ocean-32209
12/14/2023, 6:56 AMhey 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
gray-ocean-32209
12/14/2023, 6:56 AMcan’t you use GQL for the same ..?
q
quaint-oxygen-29266
12/14/2023, 6:59 AMoh
@gray-ocean-32209 can you give me an example of GQL to get the same result as
Copy code
curl -X 'GET' \
'<http://localhost:9002/openapi/v2/entity/dataset/{chart_urn}/editabledatasetproperties?systemMetadata=false>' \
-H 'accept: application/json'g
gray-ocean-32209
12/14/2023, 8:11 AMusing chart urn
Copy code
query getChart {
chart(urn: "<urn>") {
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
}
}
}gray-ocean-32209
12/14/2023, 8:13 AMusing search with querying string
Copy code
query get_chart_info {
search(input: { count: 1,type:CHART, query: "<search_str>"}) {
searchResults {
entity {
urn
type
... on Chart {
info {
name
externalUrl
}
platform {
name
}
properties {
name
description
customProperties {
key
value
}
externalUrl
}
editableProperties {
description
}
}
}
}
}
}q
quaint-oxygen-29266
12/15/2023, 7:53 AMits work @gray-ocean-32209
Thank you so much 👍💯