curl --request POST \
--url https://api.domo.com/v1/cards/chart/{cardUrn}/drill \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"calculatedFields": [
{
"formula": "<string>",
"id": "<string>",
"name": "<string>",
"saveToDataSet": true
}
],
"chartBody": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"chartType": "<string>",
"chartVersion": "<string>",
"conditionalFormats": [
{
"condition": {
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
},
"format": {
"applyToRow": true,
"color": "<string>",
"textColor": "<string>",
"textStyle": "<string>"
},
"savedToDataSet": true
}
],
"dataSetId": "<string>",
"description": "<string>",
"goal": 123,
"metadataOverrides": {},
"preferredFullHeight": 123,
"preferredFullWidth": 123,
"quickFilters": [
{
"column": "<string>",
"name": "<string>",
"operator": "<string>",
"type": "<string>",
"values": [
"<string>"
]
}
],
"summaryNumber": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"title": "<string>",
"urn": "<string>"
}
'{
"calculatedFields": [
{
"formula": "<string>",
"id": "<string>",
"name": "<string>",
"saveToDataSet": true
}
],
"chartBody": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"chartType": "<string>",
"chartVersion": "<string>",
"conditionalFormats": [
{
"condition": {
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
},
"format": {
"applyToRow": true,
"color": "<string>",
"textColor": "<string>",
"textStyle": "<string>"
},
"savedToDataSet": true
}
],
"dataSetId": "<string>",
"description": "<string>",
"goal": 123,
"metadataOverrides": {},
"preferredFullHeight": 123,
"preferredFullWidth": 123,
"quickFilters": [
{
"column": "<string>",
"name": "<string>",
"operator": "<string>",
"type": "<string>",
"values": [
"<string>"
]
}
],
"summaryNumber": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"title": "<string>",
"urn": "<string>"
}Adds a new drill view definition to an existing Card.
curl --request POST \
--url https://api.domo.com/v1/cards/chart/{cardUrn}/drill \
--header 'Authorization: Bearer <token>' \
--header 'Content-Type: application/json' \
--data '
{
"calculatedFields": [
{
"formula": "<string>",
"id": "<string>",
"name": "<string>",
"saveToDataSet": true
}
],
"chartBody": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"chartType": "<string>",
"chartVersion": "<string>",
"conditionalFormats": [
{
"condition": {
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
},
"format": {
"applyToRow": true,
"color": "<string>",
"textColor": "<string>",
"textStyle": "<string>"
},
"savedToDataSet": true
}
],
"dataSetId": "<string>",
"description": "<string>",
"goal": 123,
"metadataOverrides": {},
"preferredFullHeight": 123,
"preferredFullWidth": 123,
"quickFilters": [
{
"column": "<string>",
"name": "<string>",
"operator": "<string>",
"type": "<string>",
"values": [
"<string>"
]
}
],
"summaryNumber": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"title": "<string>",
"urn": "<string>"
}
'{
"calculatedFields": [
{
"formula": "<string>",
"id": "<string>",
"name": "<string>",
"saveToDataSet": true
}
],
"chartBody": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"chartType": "<string>",
"chartVersion": "<string>",
"conditionalFormats": [
{
"condition": {
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
},
"format": {
"applyToRow": true,
"color": "<string>",
"textColor": "<string>",
"textStyle": "<string>"
},
"savedToDataSet": true
}
],
"dataSetId": "<string>",
"description": "<string>",
"goal": 123,
"metadataOverrides": {},
"preferredFullHeight": 123,
"preferredFullWidth": 123,
"quickFilters": [
{
"column": "<string>",
"name": "<string>",
"operator": "<string>",
"type": "<string>",
"values": [
"<string>"
]
}
],
"summaryNumber": {
"columns": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"dateGrain": {
"column": "<string>",
"dateTimeElement": "<string>"
},
"dateRangeFilter": {
"filterType": "<string>",
"field": "<string>",
"from": 123,
"not": true,
"to": 123
},
"distinct": true,
"filters": [
{
"column": "<string>",
"operand": "<string>",
"values": [
"<string>"
]
}
],
"fiscal": true,
"groupBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"limit": 123,
"offset": 123,
"orderBy": [
{
"aggregation": "<string>",
"alias": "<string>",
"calendar": true,
"column": "<string>",
"format": {
"alignment": "<string>",
"commas": true,
"currency": "<string>",
"dateFormat": "<string>",
"format": "<string>",
"percent": true,
"percentMultiplied": true,
"precision": 123,
"style": "<string>",
"tableColumn": {
"aggregation": "<string>",
"hideSubtotal": true,
"hideTotal": true,
"percentOfTotal": true,
"width": 123
},
"type": "<string>"
},
"mapping": "<string>",
"order": "ASCENDING"
}
],
"projection": true
},
"title": "<string>",
"urn": "<string>"
}The access token received from the authorization server in the OAuth 2.0 flow.
ID of Card
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Show child attributes
OK
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Show child attributes
Show child attributes