File size: 76,655 Bytes
93dd899
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
---
title: API Reference
hide_title: true
sidebar_position: 10
---

import { Alert } from 'antd';

## REST API Reference

Superset exposes a comprehensive **REST API** that follows the [OpenAPI specification](https://swagger.io/specification/).
You can use this API to programmatically interact with Superset for automation, integrations, and custom applications.

<Alert
  type="info"
  showIcon
  message="Code Samples & Schema Documentation"
  description={
    <span>
      Each endpoint includes ready-to-use code samples in <strong>cURL</strong>,{' '}
      <strong>Python</strong>, and <strong>JavaScript</strong>. The sidebar
      includes <strong>Schema definitions</strong> for detailed data model
      documentation.
    </span>
  }
  style={{ marginBottom: '24px' }}
/>

---

### Authentication

Most API endpoints require authentication via JWT tokens.

#### Quick Start

```bash
# 1. Get a JWT token
curl -X POST http://localhost:8088/api/v1/security/login \
  -H "Content-Type: application/json" \
  -d '{"username": "admin", "password": "admin", "provider": "db"}'

# 2. Use the access_token from the response
curl -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \
  http://localhost:8088/api/v1/dashboard/
```

#### Security Endpoints

| Method | Endpoint                                                               | Description                     |
| ------ | ---------------------------------------------------------------------- | ------------------------------- |
| `GET`  | [Get the CSRF token](/developer-docs/api/get-the-csrf-token)           | `/api/v1/security/csrf_token/`  |
| `POST` | [Get a guest token](/developer-docs/api/get-a-guest-token)             | `/api/v1/security/guest_token/` |
| `POST` | [Create security login](/developer-docs/api/create-security-login)     | `/api/v1/security/login`        |
| `POST` | [Create security refresh](/developer-docs/api/create-security-refresh) | `/api/v1/security/refresh`      |

---

### API Endpoints

#### Core Resources

<details>
<summary><strong>Dashboards</strong> (28 endpoints) β€” Create, read, update, and delete dashboards.</summary>

| Method   | Endpoint                                                                                                                                                               | Description                                          |
| -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------------- |
| `DELETE` | [Bulk delete dashboards](/developer-docs/api/bulk-delete-dashboards)                                                                                                   | `/api/v1/dashboard/`                                 |
| `GET`    | [Get a list of dashboards](/developer-docs/api/get-a-list-of-dashboards)                                                                                               | `/api/v1/dashboard/`                                 |
| `POST`   | [Create a new dashboard](/developer-docs/api/create-a-new-dashboard)                                                                                                   | `/api/v1/dashboard/`                                 |
| `GET`    | [Get metadata information about this API resource (dashboard--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-dashboard-info)              | `/api/v1/dashboard/_info`                            |
| `GET`    | [Get a dashboard detail information](/developer-docs/api/get-a-dashboard-detail-information)                                                                           | `/api/v1/dashboard/{id_or_slug}`                     |
| `GET`    | [Get a dashboard's chart definitions.](/developer-docs/api/get-a-dashboards-chart-definitions)                                                                         | `/api/v1/dashboard/{id_or_slug}/charts`              |
| `POST`   | [Create a copy of an existing dashboard](/developer-docs/api/create-a-copy-of-an-existing-dashboard)                                                                   | `/api/v1/dashboard/{id_or_slug}/copy/`               |
| `GET`    | [Get dashboard's datasets](/developer-docs/api/get-dashboards-datasets)                                                                                                | `/api/v1/dashboard/{id_or_slug}/datasets`            |
| `DELETE` | [Delete a dashboard's embedded configuration](/developer-docs/api/delete-a-dashboards-embedded-configuration)                                                          | `/api/v1/dashboard/{id_or_slug}/embedded`            |
| `GET`    | [Get the dashboard's embedded configuration](/developer-docs/api/get-the-dashboards-embedded-configuration)                                                            | `/api/v1/dashboard/{id_or_slug}/embedded`            |
| `POST`   | [Set a dashboard's embedded configuration](/developer-docs/api/set-a-dashboards-embedded-configuration)                                                                | `/api/v1/dashboard/{id_or_slug}/embedded`            |
| `PUT`    | [Update dashboard by id_or_slug embedded](/developer-docs/api/update-dashboard-by-id-or-slug-embedded)                                                                 | `/api/v1/dashboard/{id_or_slug}/embedded`            |
| `GET`    | [Get dashboard's tabs](/developer-docs/api/get-dashboards-tabs)                                                                                                        | `/api/v1/dashboard/{id_or_slug}/tabs`                |
| `DELETE` | [Delete a dashboard](/developer-docs/api/delete-a-dashboard)                                                                                                           | `/api/v1/dashboard/{pk}`                             |
| `PUT`    | [Update a dashboard](/developer-docs/api/update-a-dashboard)                                                                                                           | `/api/v1/dashboard/{pk}`                             |
| `POST`   | [Compute and cache a screenshot (dashboard-pk-cache-dashboard-screenshot)](/developer-docs/api/compute-and-cache-a-screenshot-dashboard-pk-cache-dashboard-screenshot) | `/api/v1/dashboard/{pk}/cache_dashboard_screenshot/` |
| `PUT`    | [Update chart customizations configuration for a dashboard.](/developer-docs/api/update-chart-customizations-configuration-for-a-dashboard)                            | `/api/v1/dashboard/{pk}/chart_customizations`        |
| `PUT`    | [Update colors configuration for a dashboard.](/developer-docs/api/update-colors-configuration-for-a-dashboard)                                                        | `/api/v1/dashboard/{pk}/colors`                      |
| `GET`    | [Export dashboard as example bundle](/developer-docs/api/export-dashboard-as-example-bundle)                                                                           | `/api/v1/dashboard/{pk}/export_as_example/`          |
| `DELETE` | [Remove the dashboard from the user favorite list](/developer-docs/api/remove-the-dashboard-from-the-user-favorite-list)                                               | `/api/v1/dashboard/{pk}/favorites/`                  |
| `POST`   | [Mark the dashboard as favorite for the current user](/developer-docs/api/mark-the-dashboard-as-favorite-for-the-current-user)                                         | `/api/v1/dashboard/{pk}/favorites/`                  |
| `PUT`    | [Update native filters configuration for a dashboard.](/developer-docs/api/update-native-filters-configuration-for-a-dashboard)                                        | `/api/v1/dashboard/{pk}/filters`                     |
| `GET`    | [Get a computed screenshot from cache (dashboard-pk-screenshot-digest)](/developer-docs/api/get-a-computed-screenshot-from-cache-dashboard-pk-screenshot-digest)       | `/api/v1/dashboard/{pk}/screenshot/{digest}/`        |
| `GET`    | [Get dashboard's thumbnail](/developer-docs/api/get-dashboards-thumbnail)                                                                                              | `/api/v1/dashboard/{pk}/thumbnail/{digest}/`         |
| `GET`    | [Download multiple dashboards as YAML files](/developer-docs/api/download-multiple-dashboards-as-yaml-files)                                                           | `/api/v1/dashboard/export/`                          |
| `GET`    | [Check favorited dashboards for current user](/developer-docs/api/check-favorited-dashboards-for-current-user)                                                         | `/api/v1/dashboard/favorite_status/`                 |
| `POST`   | [Import dashboard(s) with associated charts/datasets/databases](/developer-docs/api/import-dashboard-s-with-associated-charts-datasets-databases)                      | `/api/v1/dashboard/import/`                          |
| `GET`    | [Get related fields data (dashboard-related-column-name)](/developer-docs/api/get-related-fields-data-dashboard-related-column-name)                                   | `/api/v1/dashboard/related/{column_name}`            |

</details>

<details>
<summary><strong>Charts</strong> (20 endpoints) β€” Create, read, update, and delete charts (slices).</summary>

| Method   | Endpoint                                                                                                                                                             | Description                               |
| -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------- |
| `DELETE` | [Bulk delete charts](/developer-docs/api/bulk-delete-charts)                                                                                                         | `/api/v1/chart/`                          |
| `GET`    | [Get a list of charts](/developer-docs/api/get-a-list-of-charts)                                                                                                     | `/api/v1/chart/`                          |
| `POST`   | [Create a new chart](/developer-docs/api/create-a-new-chart)                                                                                                         | `/api/v1/chart/`                          |
| `GET`    | [Get metadata information about this API resource (chart--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-chart-info)                    | `/api/v1/chart/_info`                     |
| `GET`    | [Get a chart detail information](/developer-docs/api/get-a-chart-detail-information)                                                                                 | `/api/v1/chart/{id_or_uuid}`              |
| `DELETE` | [Delete a chart](/developer-docs/api/delete-a-chart)                                                                                                                 | `/api/v1/chart/{pk}`                      |
| `PUT`    | [Update a chart](/developer-docs/api/update-a-chart)                                                                                                                 | `/api/v1/chart/{pk}`                      |
| `GET`    | [Compute and cache a screenshot (chart-pk-cache-screenshot)](/developer-docs/api/compute-and-cache-a-screenshot-chart-pk-cache-screenshot)                           | `/api/v1/chart/{pk}/cache_screenshot/`    |
| `GET`    | [Return payload data response for a chart](/developer-docs/api/return-payload-data-response-for-a-chart)                                                             | `/api/v1/chart/{pk}/data/`                |
| `DELETE` | [Remove the chart from the user favorite list](/developer-docs/api/remove-the-chart-from-the-user-favorite-list)                                                     | `/api/v1/chart/{pk}/favorites/`           |
| `POST`   | [Mark the chart as favorite for the current user](/developer-docs/api/mark-the-chart-as-favorite-for-the-current-user)                                               | `/api/v1/chart/{pk}/favorites/`           |
| `GET`    | [Get a computed screenshot from cache (chart-pk-screenshot-digest)](/developer-docs/api/get-a-computed-screenshot-from-cache-chart-pk-screenshot-digest)             | `/api/v1/chart/{pk}/screenshot/{digest}/` |
| `GET`    | [Get chart thumbnail](/developer-docs/api/get-chart-thumbnail)                                                                                                       | `/api/v1/chart/{pk}/thumbnail/{digest}/`  |
| `POST`   | [Return payload data response for the given query (chart-data)](/developer-docs/api/return-payload-data-response-for-the-given-query-chart-data)                     | `/api/v1/chart/data`                      |
| `GET`    | [Return payload data response for the given query (chart-data-cache-key)](/developer-docs/api/return-payload-data-response-for-the-given-query-chart-data-cache-key) | `/api/v1/chart/data/{cache_key}`          |
| `GET`    | [Download multiple charts as YAML files](/developer-docs/api/download-multiple-charts-as-yaml-files)                                                                 | `/api/v1/chart/export/`                   |
| `GET`    | [Check favorited charts for current user](/developer-docs/api/check-favorited-charts-for-current-user)                                                               | `/api/v1/chart/favorite_status/`          |
| `POST`   | [Import chart(s) with associated datasets and databases](/developer-docs/api/import-chart-s-with-associated-datasets-and-databases)                                  | `/api/v1/chart/import/`                   |
| `GET`    | [Get related fields data (chart-related-column-name)](/developer-docs/api/get-related-fields-data-chart-related-column-name)                                         | `/api/v1/chart/related/{column_name}`     |
| `PUT`    | [Warm up the cache for the chart](/developer-docs/api/warm-up-the-cache-for-the-chart)                                                                               | `/api/v1/chart/warm_up_cache`             |

</details>

<details>
<summary><strong>Datasets</strong> (19 endpoints) β€” Manage datasets (tables) used for building charts.</summary>

| Method   | Endpoint                                                                                                                                                   | Description                                    |
| -------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------------------------------------- |
| `DELETE` | [Bulk delete datasets](/developer-docs/api/bulk-delete-datasets)                                                                                           | `/api/v1/dataset/`                             |
| `GET`    | [Get a list of datasets](/developer-docs/api/get-a-list-of-datasets)                                                                                       | `/api/v1/dataset/`                             |
| `POST`   | [Create a new dataset](/developer-docs/api/create-a-new-dataset)                                                                                           | `/api/v1/dataset/`                             |
| `GET`    | [Get metadata information about this API resource (dataset--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-dataset-info)      | `/api/v1/dataset/_info`                        |
| `GET`    | [Get a dataset](/developer-docs/api/get-a-dataset)                                                                                                         | `/api/v1/dataset/{id_or_uuid}`                 |
| `GET`    | [Get charts and dashboards count associated to a dataset](/developer-docs/api/get-charts-and-dashboards-count-associated-to-a-dataset)                     | `/api/v1/dataset/{id_or_uuid}/related_objects` |
| `DELETE` | [Delete a dataset](/developer-docs/api/delete-a-dataset)                                                                                                   | `/api/v1/dataset/{pk}`                         |
| `PUT`    | [Update a dataset](/developer-docs/api/update-a-dataset)                                                                                                   | `/api/v1/dataset/{pk}`                         |
| `DELETE` | [Delete a dataset column](/developer-docs/api/delete-a-dataset-column)                                                                                     | `/api/v1/dataset/{pk}/column/{column_id}`      |
| `GET`    | [Get dataset drill info](/developer-docs/api/get-dataset-drill-info)                                                                                       | `/api/v1/dataset/{pk}/drill_info/`             |
| `DELETE` | [Delete a dataset metric](/developer-docs/api/delete-a-dataset-metric)                                                                                     | `/api/v1/dataset/{pk}/metric/{metric_id}`      |
| `PUT`    | [Refresh and update columns of a dataset](/developer-docs/api/refresh-and-update-columns-of-a-dataset)                                                     | `/api/v1/dataset/{pk}/refresh`                 |
| `GET`    | [Get distinct values from field data (dataset-distinct-column-name)](/developer-docs/api/get-distinct-values-from-field-data-dataset-distinct-column-name) | `/api/v1/dataset/distinct/{column_name}`       |
| `POST`   | [Duplicate a dataset](/developer-docs/api/duplicate-a-dataset)                                                                                             | `/api/v1/dataset/duplicate`                    |
| `GET`    | [Download multiple datasets as YAML files](/developer-docs/api/download-multiple-datasets-as-yaml-files)                                                   | `/api/v1/dataset/export/`                      |
| `POST`   | [Retrieve a table by name, or create it if it does not exist](/developer-docs/api/retrieve-a-table-by-name-or-create-it-if-it-does-not-exist)              | `/api/v1/dataset/get_or_create/`               |
| `POST`   | [Import dataset(s) with associated databases](/developer-docs/api/import-dataset-s-with-associated-databases)                                              | `/api/v1/dataset/import/`                      |
| `GET`    | [Get related fields data (dataset-related-column-name)](/developer-docs/api/get-related-fields-data-dataset-related-column-name)                           | `/api/v1/dataset/related/{column_name}`        |
| `PUT`    | [Warm up the cache for each chart powered by the given table](/developer-docs/api/warm-up-the-cache-for-each-chart-powered-by-the-given-table)             | `/api/v1/dataset/warm_up_cache`                |

</details>

<details>
<summary><strong>Database</strong> (30 endpoints) β€” Manage database connections and metadata.</summary>

| Method   | Endpoint                                                                                                                                                                                     | Description                                                     |
| -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------------------------------- |
| `GET`    | [Get a list of databases](/developer-docs/api/get-a-list-of-databases)                                                                                                                       | `/api/v1/database/`                                             |
| `POST`   | [Create a new database](/developer-docs/api/create-a-new-database)                                                                                                                           | `/api/v1/database/`                                             |
| `GET`    | [Get metadata information about this API resource (database--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-database-info)                                      | `/api/v1/database/_info`                                        |
| `DELETE` | [Delete a database](/developer-docs/api/delete-a-database)                                                                                                                                   | `/api/v1/database/{pk}`                                         |
| `GET`    | [Get a database](/developer-docs/api/get-a-database)                                                                                                                                         | `/api/v1/database/{pk}`                                         |
| `PUT`    | [Change a database](/developer-docs/api/change-a-database)                                                                                                                                   | `/api/v1/database/{pk}`                                         |
| `GET`    | [Get all catalogs from a database](/developer-docs/api/get-all-catalogs-from-a-database)                                                                                                     | `/api/v1/database/{pk}/catalogs/`                               |
| `GET`    | [Get a database connection info](/developer-docs/api/get-a-database-connection-info)                                                                                                         | `/api/v1/database/{pk}/connection`                              |
| `GET`    | [Get function names supported by a database](/developer-docs/api/get-function-names-supported-by-a-database)                                                                                 | `/api/v1/database/{pk}/function_names/`                         |
| `GET`    | [Get charts and dashboards count associated to a database](/developer-docs/api/get-charts-and-dashboards-count-associated-to-a-database)                                                     | `/api/v1/database/{pk}/related_objects/`                        |
| `GET`    | [The list of the database schemas where to upload information](/developer-docs/api/the-list-of-the-database-schemas-where-to-upload-information)                                             | `/api/v1/database/{pk}/schemas_access_for_file_upload/`         |
| `GET`    | [Get all schemas from a database](/developer-docs/api/get-all-schemas-from-a-database)                                                                                                       | `/api/v1/database/{pk}/schemas/`                                |
| `GET`    | [Get database select star for table (database-pk-select-star-table-name)](/developer-docs/api/get-database-select-star-for-table-database-pk-select-star-table-name)                         | `/api/v1/database/{pk}/select_star/{table_name}/`               |
| `GET`    | [Get database select star for table (database-pk-select-star-table-name-schema-name)](/developer-docs/api/get-database-select-star-for-table-database-pk-select-star-table-name-schema-name) | `/api/v1/database/{pk}/select_star/{table_name}/{schema_name}/` |
| `POST`   | [Re-sync all permissions for a database connection](/developer-docs/api/re-sync-all-permissions-for-a-database-connection)                                                                   | `/api/v1/database/{pk}/sync_permissions/`                       |
| `GET`    | [Get table extra metadata (database-pk-table-extra-table-name-schema-name)](/developer-docs/api/get-table-extra-metadata-database-pk-table-extra-table-name-schema-name)                     | `/api/v1/database/{pk}/table_extra/{table_name}/{schema_name}/` |
| `GET`    | [Get table metadata](/developer-docs/api/get-table-metadata)                                                                                                                                 | `/api/v1/database/{pk}/table_metadata/`                         |
| `GET`    | [Get table extra metadata (database-pk-table-metadata-extra)](/developer-docs/api/get-table-extra-metadata-database-pk-table-metadata-extra)                                                 | `/api/v1/database/{pk}/table_metadata/extra/`                   |
| `GET`    | [Get database table metadata](/developer-docs/api/get-database-table-metadata)                                                                                                               | `/api/v1/database/{pk}/table/{table_name}/{schema_name}/`       |
| `GET`    | [Get a list of tables for given database](/developer-docs/api/get-a-list-of-tables-for-given-database)                                                                                       | `/api/v1/database/{pk}/tables/`                                 |
| `POST`   | [Upload a file to a database table](/developer-docs/api/upload-a-file-to-a-database-table)                                                                                                   | `/api/v1/database/{pk}/upload/`                                 |
| `POST`   | [Validate arbitrary SQL](/developer-docs/api/validate-arbitrary-sql)                                                                                                                         | `/api/v1/database/{pk}/validate_sql/`                           |
| `GET`    | [Get names of databases currently available](/developer-docs/api/get-names-of-databases-currently-available)                                                                                 | `/api/v1/database/available/`                                   |
| `GET`    | [Download database(s) and associated dataset(s) as a zip file](/developer-docs/api/download-database-s-and-associated-dataset-s-as-a-zip-file)                                               | `/api/v1/database/export/`                                      |
| `POST`   | [Import database(s) with associated datasets](/developer-docs/api/import-database-s-with-associated-datasets)                                                                                | `/api/v1/database/import/`                                      |
| `GET`    | [Receive personal access tokens from OAuth2](/developer-docs/api/receive-personal-access-tokens-from-o-auth-2)                                                                               | `/api/v1/database/oauth2/`                                      |
| `GET`    | [Get related fields data (database-related-column-name)](/developer-docs/api/get-related-fields-data-database-related-column-name)                                                           | `/api/v1/database/related/{column_name}`                        |
| `POST`   | [Test a database connection](/developer-docs/api/test-a-database-connection)                                                                                                                 | `/api/v1/database/test_connection/`                             |
| `POST`   | [Upload a file and returns file metadata](/developer-docs/api/upload-a-file-and-returns-file-metadata)                                                                                       | `/api/v1/database/upload_metadata/`                             |
| `POST`   | [Validate database connection parameters](/developer-docs/api/validate-database-connection-parameters)                                                                                       | `/api/v1/database/validate_parameters/`                         |

</details>

#### Data Exploration

<details>
<summary><strong>Explore</strong> (1 endpoints) β€” Chart exploration and data querying endpoints.</summary>

| Method | Endpoint                                                                                                                                   | Description        |
| ------ | ------------------------------------------------------------------------------------------------------------------------------------------ | ------------------ |
| `GET`  | [Assemble Explore related information in a single endpoint](/developer-docs/api/assemble-explore-related-information-in-a-single-endpoint) | `/api/v1/explore/` |

</details>

<details>
<summary><strong>SQL Lab</strong> (7 endpoints) β€” Execute SQL queries and manage SQL Lab sessions.</summary>

| Method | Endpoint                                                                                                             | Description                          |
| ------ | -------------------------------------------------------------------------------------------------------------------- | ------------------------------------ |
| `GET`  | [Get the bootstrap data for SqlLab page](/developer-docs/api/get-the-bootstrap-data-for-sql-lab-page)                | `/api/v1/sqllab/`                    |
| `POST` | [Estimate the SQL query execution cost](/developer-docs/api/estimate-the-sql-query-execution-cost)                   | `/api/v1/sqllab/estimate/`           |
| `POST` | [Execute a SQL query](/developer-docs/api/execute-a-sql-query)                                                       | `/api/v1/sqllab/execute/`            |
| `POST` | [Export SQL query results to CSV with streaming](/developer-docs/api/export-sql-query-results-to-csv-with-streaming) | `/api/v1/sqllab/export_streaming/`   |
| `GET`  | [Export the SQL query results to a CSV](/developer-docs/api/export-the-sql-query-results-to-a-csv)                   | `/api/v1/sqllab/export/{client_id}/` |
| `POST` | [Format SQL code](/developer-docs/api/format-sql-code)                                                               | `/api/v1/sqllab/format_sql/`         |
| `GET`  | [Get the result of a SQL query execution](/developer-docs/api/get-the-result-of-a-sql-query-execution)               | `/api/v1/sqllab/results/`            |

</details>

<details>
<summary><strong>Queries</strong> (17 endpoints) β€” View and manage SQL Lab query history.</summary>

| Method   | Endpoint                                                                                                                                                           | Description                                  |
| -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | -------------------------------------------- |
| `GET`    | [Get a list of queries](/developer-docs/api/get-a-list-of-queries)                                                                                                 | `/api/v1/query/`                             |
| `GET`    | [Get query detail information](/developer-docs/api/get-query-detail-information)                                                                                   | `/api/v1/query/{pk}`                         |
| `GET`    | [Get distinct values from field data (query-distinct-column-name)](/developer-docs/api/get-distinct-values-from-field-data-query-distinct-column-name)             | `/api/v1/query/distinct/{column_name}`       |
| `GET`    | [Get related fields data (query-related-column-name)](/developer-docs/api/get-related-fields-data-query-related-column-name)                                       | `/api/v1/query/related/{column_name}`        |
| `POST`   | [Manually stop a query with client_id](/developer-docs/api/manually-stop-a-query-with-client-id)                                                                   | `/api/v1/query/stop`                         |
| `GET`    | [Get a list of queries that changed after last_updated_ms](/developer-docs/api/get-a-list-of-queries-that-changed-after-last-updated-ms)                           | `/api/v1/query/updated_since`                |
| `DELETE` | [Bulk delete saved queries](/developer-docs/api/bulk-delete-saved-queries)                                                                                         | `/api/v1/saved_query/`                       |
| `GET`    | [Get a list of saved queries](/developer-docs/api/get-a-list-of-saved-queries)                                                                                     | `/api/v1/saved_query/`                       |
| `POST`   | [Create a saved query](/developer-docs/api/create-a-saved-query)                                                                                                   | `/api/v1/saved_query/`                       |
| `GET`    | [Get metadata information about this API resource (saved-query--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-saved-query-info)      | `/api/v1/saved_query/_info`                  |
| `DELETE` | [Delete a saved query](/developer-docs/api/delete-a-saved-query)                                                                                                   | `/api/v1/saved_query/{pk}`                   |
| `GET`    | [Get a saved query](/developer-docs/api/get-a-saved-query)                                                                                                         | `/api/v1/saved_query/{pk}`                   |
| `PUT`    | [Update a saved query](/developer-docs/api/update-a-saved-query)                                                                                                   | `/api/v1/saved_query/{pk}`                   |
| `GET`    | [Get distinct values from field data (saved-query-distinct-column-name)](/developer-docs/api/get-distinct-values-from-field-data-saved-query-distinct-column-name) | `/api/v1/saved_query/distinct/{column_name}` |
| `GET`    | [Download multiple saved queries as YAML files](/developer-docs/api/download-multiple-saved-queries-as-yaml-files)                                                 | `/api/v1/saved_query/export/`                |
| `POST`   | [Import saved queries with associated databases](/developer-docs/api/import-saved-queries-with-associated-databases)                                               | `/api/v1/saved_query/import/`                |
| `GET`    | [Get related fields data (saved-query-related-column-name)](/developer-docs/api/get-related-fields-data-saved-query-related-column-name)                           | `/api/v1/saved_query/related/{column_name}`  |

</details>

<details>
<summary><strong>Datasources</strong> (2 endpoints) β€” Query datasource metadata and column values.</summary>

| Method | Endpoint                                                                                                             | Description                                                                         |
| ------ | -------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------- |
| `GET`  | [Get possible values for a datasource column](/developer-docs/api/get-possible-values-for-a-datasource-column)       | `/api/v1/datasource/{datasource_type}/{datasource_id}/column/{column_name}/values/` |
| `POST` | [Validate a SQL expression against a datasource](/developer-docs/api/validate-a-sql-expression-against-a-datasource) | `/api/v1/datasource/{datasource_type}/{datasource_id}/validate_expression/`         |

</details>

<details>
<summary><strong>Advanced Data Type</strong> (2 endpoints) β€” Advanced data type operations and conversions.</summary>

| Method | Endpoint                                                                                                             | Description                          |
| ------ | -------------------------------------------------------------------------------------------------------------------- | ------------------------------------ |
| `GET`  | [Return an AdvancedDataTypeResponse](/developer-docs/api/return-an-advanced-data-type-response)                      | `/api/v1/advanced_data_type/convert` |
| `GET`  | [Return a list of available advanced data types](/developer-docs/api/return-a-list-of-available-advanced-data-types) | `/api/v1/advanced_data_type/types`   |

</details>

#### Organization & Customization

<details>
<summary><strong>Tags</strong> (15 endpoints) β€” Organize assets with tags.</summary>

| Method   | Endpoint                                                                                                                 | Description                                    |
| -------- | ------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------- |
| `DELETE` | [Bulk delete tags](/developer-docs/api/bulk-delete-tags)                                                                 | `/api/v1/tag/`                                 |
| `GET`    | [Get a list of tags](/developer-docs/api/get-a-list-of-tags)                                                             | `/api/v1/tag/`                                 |
| `POST`   | [Create a tag](/developer-docs/api/create-a-tag)                                                                         | `/api/v1/tag/`                                 |
| `GET`    | [Get metadata information about tag API endpoints](/developer-docs/api/get-metadata-information-about-tag-api-endpoints) | `/api/v1/tag/_info`                            |
| `POST`   | [Add tags to an object](/developer-docs/api/add-tags-to-an-object)                                                       | `/api/v1/tag/{object_type}/{object_id}/`       |
| `DELETE` | [Delete a tagged object](/developer-docs/api/delete-a-tagged-object)                                                     | `/api/v1/tag/{object_type}/{object_id}/{tag}/` |
| `DELETE` | [Delete a tag](/developer-docs/api/delete-a-tag)                                                                         | `/api/v1/tag/{pk}`                             |
| `GET`    | [Get a tag detail information](/developer-docs/api/get-a-tag-detail-information)                                         | `/api/v1/tag/{pk}`                             |
| `PUT`    | [Update a tag](/developer-docs/api/update-a-tag)                                                                         | `/api/v1/tag/{pk}`                             |
| `DELETE` | [Delete tag by pk favorites](/developer-docs/api/delete-tag-by-pk-favorites)                                             | `/api/v1/tag/{pk}/favorites/`                  |
| `POST`   | [Create tag by pk favorites](/developer-docs/api/create-tag-by-pk-favorites)                                             | `/api/v1/tag/{pk}/favorites/`                  |
| `POST`   | [Bulk create tags and tagged objects](/developer-docs/api/bulk-create-tags-and-tagged-objects)                           | `/api/v1/tag/bulk_create`                      |
| `GET`    | [Get tag favorite status](/developer-docs/api/get-tag-favorite-status)                                                   | `/api/v1/tag/favorite_status/`                 |
| `GET`    | [Get all objects associated with a tag](/developer-docs/api/get-all-objects-associated-with-a-tag)                       | `/api/v1/tag/get_objects/`                     |
| `GET`    | [Get related fields data (tag-related-column-name)](/developer-docs/api/get-related-fields-data-tag-related-column-name) | `/api/v1/tag/related/{column_name}`            |

</details>

<details>
<summary><strong>Annotation Layers</strong> (14 endpoints) β€” Manage annotation layers and annotations for charts.</summary>

| Method   | Endpoint                                                                                                                                                                 | Description                                                |
| -------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ---------------------------------------------------------- |
| `DELETE` | [Delete multiple annotation layers in a bulk operation](/developer-docs/api/delete-multiple-annotation-layers-in-a-bulk-operation)                                       | `/api/v1/annotation_layer/`                                |
| `GET`    | [Get a list of annotation layers (annotation-layer)](/developer-docs/api/get-a-list-of-annotation-layers-annotation-layer)                                               | `/api/v1/annotation_layer/`                                |
| `POST`   | [Create an annotation layer (annotation-layer)](/developer-docs/api/create-an-annotation-layer-annotation-layer)                                                         | `/api/v1/annotation_layer/`                                |
| `GET`    | [Get metadata information about this API resource (annotation-layer--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-annotation-layer-info)  | `/api/v1/annotation_layer/_info`                           |
| `DELETE` | [Delete annotation layer (annotation-layer-pk)](/developer-docs/api/delete-annotation-layer-annotation-layer-pk)                                                         | `/api/v1/annotation_layer/{pk}`                            |
| `GET`    | [Get an annotation layer (annotation-layer-pk)](/developer-docs/api/get-an-annotation-layer-annotation-layer-pk)                                                         | `/api/v1/annotation_layer/{pk}`                            |
| `PUT`    | [Update an annotation layer (annotation-layer-pk)](/developer-docs/api/update-an-annotation-layer-annotation-layer-pk)                                                   | `/api/v1/annotation_layer/{pk}`                            |
| `DELETE` | [Bulk delete annotation layers](/developer-docs/api/bulk-delete-annotation-layers)                                                                                       | `/api/v1/annotation_layer/{pk}/annotation/`                |
| `GET`    | [Get a list of annotation layers (annotation-layer-pk-annotation)](/developer-docs/api/get-a-list-of-annotation-layers-annotation-layer-pk-annotation)                   | `/api/v1/annotation_layer/{pk}/annotation/`                |
| `POST`   | [Create an annotation layer (annotation-layer-pk-annotation)](/developer-docs/api/create-an-annotation-layer-annotation-layer-pk-annotation)                             | `/api/v1/annotation_layer/{pk}/annotation/`                |
| `DELETE` | [Delete annotation layer (annotation-layer-pk-annotation-annotation-id)](/developer-docs/api/delete-annotation-layer-annotation-layer-pk-annotation-annotation-id)       | `/api/v1/annotation_layer/{pk}/annotation/{annotation_id}` |
| `GET`    | [Get an annotation layer (annotation-layer-pk-annotation-annotation-id)](/developer-docs/api/get-an-annotation-layer-annotation-layer-pk-annotation-annotation-id)       | `/api/v1/annotation_layer/{pk}/annotation/{annotation_id}` |
| `PUT`    | [Update an annotation layer (annotation-layer-pk-annotation-annotation-id)](/developer-docs/api/update-an-annotation-layer-annotation-layer-pk-annotation-annotation-id) | `/api/v1/annotation_layer/{pk}/annotation/{annotation_id}` |
| `GET`    | [Get related fields data (annotation-layer-related-column-name)](/developer-docs/api/get-related-fields-data-annotation-layer-related-column-name)                       | `/api/v1/annotation_layer/related/{column_name}`           |

</details>

<details>
<summary><strong>CSS Templates</strong> (8 endpoints) β€” Manage CSS templates for custom dashboard styling.</summary>

| Method   | Endpoint                                                                                                                                                        | Description                                  |
| -------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------------- |
| `DELETE` | [Bulk delete CSS templates](/developer-docs/api/bulk-delete-css-templates)                                                                                      | `/api/v1/css_template/`                      |
| `GET`    | [Get a list of CSS templates](/developer-docs/api/get-a-list-of-css-templates)                                                                                  | `/api/v1/css_template/`                      |
| `POST`   | [Create a CSS template](/developer-docs/api/create-a-css-template)                                                                                              | `/api/v1/css_template/`                      |
| `GET`    | [Get metadata information about this API resource (css-template--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-css-template-info) | `/api/v1/css_template/_info`                 |
| `DELETE` | [Delete a CSS template](/developer-docs/api/delete-a-css-template)                                                                                              | `/api/v1/css_template/{pk}`                  |
| `GET`    | [Get a CSS template](/developer-docs/api/get-a-css-template)                                                                                                    | `/api/v1/css_template/{pk}`                  |
| `PUT`    | [Update a CSS template](/developer-docs/api/update-a-css-template)                                                                                              | `/api/v1/css_template/{pk}`                  |
| `GET`    | [Get related fields data (css-template-related-column-name)](/developer-docs/api/get-related-fields-data-css-template-related-column-name)                      | `/api/v1/css_template/related/{column_name}` |

</details>

#### Sharing & Embedding

<details>
<summary><strong>Dashboard Permanent Link</strong> (2 endpoints) β€” Permanent links to dashboard states.</summary>

| Method | Endpoint                                                                                              | Description                         |
| ------ | ----------------------------------------------------------------------------------------------------- | ----------------------------------- |
| `POST` | [Create a new dashboard's permanent link](/developer-docs/api/create-a-new-dashboards-permanent-link) | `/api/v1/dashboard/{pk}/permalink`  |
| `GET`  | [Get dashboard's permanent link state](/developer-docs/api/get-dashboards-permanent-link-state)       | `/api/v1/dashboard/permalink/{key}` |

</details>

<details>
<summary><strong>Explore Permanent Link</strong> (2 endpoints) β€” Permanent links to chart explore states.</summary>

| Method | Endpoint                                                                                                             | Description                       |
| ------ | -------------------------------------------------------------------------------------------------------------------- | --------------------------------- |
| `POST` | [Create a new permanent link (explore-permalink)](/developer-docs/api/create-a-new-permanent-link-explore-permalink) | `/api/v1/explore/permalink`       |
| `GET`  | [Get chart's permanent link state](/developer-docs/api/get-charts-permanent-link-state)                              | `/api/v1/explore/permalink/{key}` |

</details>

<details>
<summary><strong>SQL Lab Permanent Link</strong> (2 endpoints) β€” Permanent links to SQL Lab states.</summary>

| Method | Endpoint                                                                                                           | Description                      |
| ------ | ------------------------------------------------------------------------------------------------------------------ | -------------------------------- |
| `POST` | [Create a new permanent link (sqllab-permalink)](/developer-docs/api/create-a-new-permanent-link-sqllab-permalink) | `/api/v1/sqllab/permalink`       |
| `GET`  | [Get permanent link state for SQLLab editor.](/developer-docs/api/get-permanent-link-state-for-sql-lab-editor)     | `/api/v1/sqllab/permalink/{key}` |

</details>

<details>
<summary><strong>Embedded Dashboard</strong> (1 endpoints) β€” Configure embedded dashboard settings.</summary>

| Method | Endpoint                                                                                                                     | Description                         |
| ------ | ---------------------------------------------------------------------------------------------------------------------------- | ----------------------------------- |
| `GET`  | [Get a report schedule log (embedded-dashboard-uuid)](/developer-docs/api/get-a-report-schedule-log-embedded-dashboard-uuid) | `/api/v1/embedded_dashboard/{uuid}` |

</details>

<details>
<summary><strong>Dashboard Filter State</strong> (4 endpoints) β€” Manage temporary filter state for dashboards.</summary>

| Method   | Endpoint                                                                                              | Description                                 |
| -------- | ----------------------------------------------------------------------------------------------------- | ------------------------------------------- |
| `POST`   | [Create a dashboard's filter state](/developer-docs/api/create-a-dashboards-filter-state)             | `/api/v1/dashboard/{pk}/filter_state`       |
| `DELETE` | [Delete a dashboard's filter state value](/developer-docs/api/delete-a-dashboards-filter-state-value) | `/api/v1/dashboard/{pk}/filter_state/{key}` |
| `GET`    | [Get a dashboard's filter state value](/developer-docs/api/get-a-dashboards-filter-state-value)       | `/api/v1/dashboard/{pk}/filter_state/{key}` |
| `PUT`    | [Update a dashboard's filter state value](/developer-docs/api/update-a-dashboards-filter-state-value) | `/api/v1/dashboard/{pk}/filter_state/{key}` |

</details>

<details>
<summary><strong>Explore Form Data</strong> (4 endpoints) β€” Manage temporary form data for chart exploration.</summary>

| Method   | Endpoint                                                                         | Description                       |
| -------- | -------------------------------------------------------------------------------- | --------------------------------- |
| `POST`   | [Create a new form_data](/developer-docs/api/create-a-new-form-data)             | `/api/v1/explore/form_data`       |
| `DELETE` | [Delete a form_data](/developer-docs/api/delete-a-form-data)                     | `/api/v1/explore/form_data/{key}` |
| `GET`    | [Get a form_data](/developer-docs/api/get-a-form-data)                           | `/api/v1/explore/form_data/{key}` |
| `PUT`    | [Update an existing form_data](/developer-docs/api/update-an-existing-form-data) | `/api/v1/explore/form_data/{key}` |

</details>

#### Scheduling & Alerts

<details>
<summary><strong>Report Schedules</strong> (11 endpoints) β€” Configure scheduled reports and alerts.</summary>

| Method   | Endpoint                                                                                                                                            | Description                            |
| -------- | --------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------------------------- |
| `DELETE` | [Bulk delete report schedules](/developer-docs/api/bulk-delete-report-schedules)                                                                    | `/api/v1/report/`                      |
| `GET`    | [Get a list of report schedules](/developer-docs/api/get-a-list-of-report-schedules)                                                                | `/api/v1/report/`                      |
| `POST`   | [Create a report schedule](/developer-docs/api/create-a-report-schedule)                                                                            | `/api/v1/report/`                      |
| `GET`    | [Get metadata information about this API resource (report--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-report-info) | `/api/v1/report/_info`                 |
| `DELETE` | [Delete a report schedule](/developer-docs/api/delete-a-report-schedule)                                                                            | `/api/v1/report/{pk}`                  |
| `GET`    | [Get a report schedule](/developer-docs/api/get-a-report-schedule)                                                                                  | `/api/v1/report/{pk}`                  |
| `PUT`    | [Update a report schedule](/developer-docs/api/update-a-report-schedule)                                                                            | `/api/v1/report/{pk}`                  |
| `GET`    | [Get a list of report schedule logs](/developer-docs/api/get-a-list-of-report-schedule-logs)                                                        | `/api/v1/report/{pk}/log/`             |
| `GET`    | [Get a report schedule log (report-pk-log-log-id)](/developer-docs/api/get-a-report-schedule-log-report-pk-log-log-id)                              | `/api/v1/report/{pk}/log/{log_id}`     |
| `GET`    | [Get related fields data (report-related-column-name)](/developer-docs/api/get-related-fields-data-report-related-column-name)                      | `/api/v1/report/related/{column_name}` |
| `GET`    | [Get slack channels](/developer-docs/api/get-slack-channels)                                                                                        | `/api/v1/report/slack_channels/`       |

</details>

#### Security & Access Control

<details>
<summary><strong>Security Roles</strong> (11 endpoints) β€” Manage security roles and their permissions.</summary>

| Method   | Endpoint                                                                                                         | Description                                     |
| -------- | ---------------------------------------------------------------------------------------------------------------- | ----------------------------------------------- |
| `GET`    | [Get security roles](/developer-docs/api/get-security-roles)                                                     | `/api/v1/security/roles/`                       |
| `POST`   | [Create security roles](/developer-docs/api/create-security-roles)                                               | `/api/v1/security/roles/`                       |
| `GET`    | [Get security roles info](/developer-docs/api/get-security-roles-info)                                           | `/api/v1/security/roles/_info`                  |
| `DELETE` | [Delete security roles by pk](/developer-docs/api/delete-security-roles-by-pk)                                   | `/api/v1/security/roles/{pk}`                   |
| `GET`    | [Get security roles by pk](/developer-docs/api/get-security-roles-by-pk)                                         | `/api/v1/security/roles/{pk}`                   |
| `PUT`    | [Update security roles by pk](/developer-docs/api/update-security-roles-by-pk)                                   | `/api/v1/security/roles/{pk}`                   |
| `PUT`    | [Update security roles by role_id groups](/developer-docs/api/update-security-roles-by-role-id-groups)           | `/api/v1/security/roles/{role_id}/groups`       |
| `POST`   | [Create security roles by role_id permissions](/developer-docs/api/create-security-roles-by-role-id-permissions) | `/api/v1/security/roles/{role_id}/permissions`  |
| `GET`    | [Get security roles by role_id permissions](/developer-docs/api/get-security-roles-by-role-id-permissions)       | `/api/v1/security/roles/{role_id}/permissions/` |
| `PUT`    | [Update security roles by role_id users](/developer-docs/api/update-security-roles-by-role-id-users)             | `/api/v1/security/roles/{role_id}/users`        |
| `GET`    | [List roles](/developer-docs/api/list-roles)                                                                     | `/api/v1/security/roles/search/`                |

</details>

<details>
<summary><strong>Security Users</strong> (6 endpoints) β€” Manage user accounts.</summary>

| Method   | Endpoint                                                                       | Description                    |
| -------- | ------------------------------------------------------------------------------ | ------------------------------ |
| `GET`    | [Get security users](/developer-docs/api/get-security-users)                   | `/api/v1/security/users/`      |
| `POST`   | [Create security users](/developer-docs/api/create-security-users)             | `/api/v1/security/users/`      |
| `GET`    | [Get security users info](/developer-docs/api/get-security-users-info)         | `/api/v1/security/users/_info` |
| `DELETE` | [Delete security users by pk](/developer-docs/api/delete-security-users-by-pk) | `/api/v1/security/users/{pk}`  |
| `GET`    | [Get security users by pk](/developer-docs/api/get-security-users-by-pk)       | `/api/v1/security/users/{pk}`  |
| `PUT`    | [Update security users by pk](/developer-docs/api/update-security-users-by-pk) | `/api/v1/security/users/{pk}`  |

</details>

<details>
<summary><strong>Security Permissions</strong> (3 endpoints) β€” View available permissions.</summary>

| Method | Endpoint                                                                             | Description                          |
| ------ | ------------------------------------------------------------------------------------ | ------------------------------------ |
| `GET`  | [Get security permissions](/developer-docs/api/get-security-permissions)             | `/api/v1/security/permissions/`      |
| `GET`  | [Get security permissions info](/developer-docs/api/get-security-permissions-info)   | `/api/v1/security/permissions/_info` |
| `GET`  | [Get security permissions by pk](/developer-docs/api/get-security-permissions-by-pk) | `/api/v1/security/permissions/{pk}`  |

</details>

<details>
<summary><strong>Security Resources (View Menus)</strong> (6 endpoints) β€” Manage security resources (view menus).</summary>

| Method   | Endpoint                                                                               | Description                        |
| -------- | -------------------------------------------------------------------------------------- | ---------------------------------- |
| `GET`    | [Get security resources](/developer-docs/api/get-security-resources)                   | `/api/v1/security/resources/`      |
| `POST`   | [Create security resources](/developer-docs/api/create-security-resources)             | `/api/v1/security/resources/`      |
| `GET`    | [Get security resources info](/developer-docs/api/get-security-resources-info)         | `/api/v1/security/resources/_info` |
| `DELETE` | [Delete security resources by pk](/developer-docs/api/delete-security-resources-by-pk) | `/api/v1/security/resources/{pk}`  |
| `GET`    | [Get security resources by pk](/developer-docs/api/get-security-resources-by-pk)       | `/api/v1/security/resources/{pk}`  |
| `PUT`    | [Update security resources by pk](/developer-docs/api/update-security-resources-by-pk) | `/api/v1/security/resources/{pk}`  |

</details>

<details>
<summary><strong>Security Permissions on Resources (View Menus)</strong> (6 endpoints) β€” Permission-resource mappings.</summary>

| Method   | Endpoint                                                                                                       | Description                                    |
| -------- | -------------------------------------------------------------------------------------------------------------- | ---------------------------------------------- |
| `GET`    | [Get security permissions resources](/developer-docs/api/get-security-permissions-resources)                   | `/api/v1/security/permissions-resources/`      |
| `POST`   | [Create security permissions resources](/developer-docs/api/create-security-permissions-resources)             | `/api/v1/security/permissions-resources/`      |
| `GET`    | [Get security permissions resources info](/developer-docs/api/get-security-permissions-resources-info)         | `/api/v1/security/permissions-resources/_info` |
| `DELETE` | [Delete security permissions resources by pk](/developer-docs/api/delete-security-permissions-resources-by-pk) | `/api/v1/security/permissions-resources/{pk}`  |
| `GET`    | [Get security permissions resources by pk](/developer-docs/api/get-security-permissions-resources-by-pk)       | `/api/v1/security/permissions-resources/{pk}`  |
| `PUT`    | [Update security permissions resources by pk](/developer-docs/api/update-security-permissions-resources-by-pk) | `/api/v1/security/permissions-resources/{pk}`  |

</details>

<details>
<summary><strong>Row Level Security</strong> (8 endpoints) β€” Manage row-level security rules for data access.</summary>

| Method   | Endpoint                                                                                                                                                                | Description                                      |
| -------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------ |
| `DELETE` | [Bulk delete RLS rules](/developer-docs/api/bulk-delete-rls-rules)                                                                                                      | `/api/v1/rowlevelsecurity/`                      |
| `GET`    | [Get a list of RLS](/developer-docs/api/get-a-list-of-rls)                                                                                                              | `/api/v1/rowlevelsecurity/`                      |
| `POST`   | [Create a new RLS rule](/developer-docs/api/create-a-new-rls-rule)                                                                                                      | `/api/v1/rowlevelsecurity/`                      |
| `GET`    | [Get metadata information about this API resource (rowlevelsecurity--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-rowlevelsecurity-info) | `/api/v1/rowlevelsecurity/_info`                 |
| `DELETE` | [Delete an RLS](/developer-docs/api/delete-an-rls)                                                                                                                      | `/api/v1/rowlevelsecurity/{pk}`                  |
| `GET`    | [Get an RLS](/developer-docs/api/get-an-rls)                                                                                                                            | `/api/v1/rowlevelsecurity/{pk}`                  |
| `PUT`    | [Update an RLS rule](/developer-docs/api/update-an-rls-rule)                                                                                                            | `/api/v1/rowlevelsecurity/{pk}`                  |
| `GET`    | [Get related fields data (rowlevelsecurity-related-column-name)](/developer-docs/api/get-related-fields-data-rowlevelsecurity-related-column-name)                      | `/api/v1/rowlevelsecurity/related/{column_name}` |

</details>

#### Import/Export & Administration

<details>
<summary><strong>Import/export</strong> (2 endpoints) β€” Import and export Superset assets.</summary>

| Method | Endpoint                                                             | Description              |
| ------ | -------------------------------------------------------------------- | ------------------------ |
| `GET`  | [Export all assets](/developer-docs/api/export-all-assets)           | `/api/v1/assets/export/` |
| `POST` | [Import multiple assets](/developer-docs/api/import-multiple-assets) | `/api/v1/assets/import/` |

</details>

<details>
<summary><strong>CacheRestApi</strong> (1 endpoints) β€” Cache management and invalidation operations.</summary>

| Method | Endpoint                                                                                                                                 | Description                   |
| ------ | ---------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------- |
| `POST` | [Invalidate cache records and remove the database records](/developer-docs/api/invalidate-cache-records-and-remove-the-database-records) | `/api/v1/cachekey/invalidate` |

</details>

<details>
<summary><strong>LogRestApi</strong> (4 endpoints) β€” Access audit logs and activity history.</summary>

| Method | Endpoint                                                                                       | Description                    |
| ------ | ---------------------------------------------------------------------------------------------- | ------------------------------ |
| `GET`  | [Get a list of logs](/developer-docs/api/get-a-list-of-logs)                                   | `/api/v1/log/`                 |
| `POST` | [Create log](/developer-docs/api/create-log)                                                   | `/api/v1/log/`                 |
| `GET`  | [Get a log detail information](/developer-docs/api/get-a-log-detail-information)               | `/api/v1/log/{pk}`             |
| `GET`  | [Get recent activity data for a user](/developer-docs/api/get-recent-activity-data-for-a-user) | `/api/v1/log/recent_activity/` |

</details>

#### User & System

<details>
<summary><strong>Current User</strong> (3 endpoints) β€” Get information about the authenticated user.</summary>

| Method | Endpoint                                                               | Description         |
| ------ | ---------------------------------------------------------------------- | ------------------- |
| `GET`  | [Get the user object](/developer-docs/api/get-the-user-object)         | `/api/v1/me/`       |
| `PUT`  | [Update the current user](/developer-docs/api/update-the-current-user) | `/api/v1/me/`       |
| `GET`  | [Get the user roles](/developer-docs/api/get-the-user-roles)           | `/api/v1/me/roles/` |

</details>

<details>
<summary><strong>User</strong> (1 endpoints) β€” User profile and preferences.</summary>

| Method | Endpoint                                                       | Description                         |
| ------ | -------------------------------------------------------------- | ----------------------------------- |
| `GET`  | [Get the user avatar](/developer-docs/api/get-the-user-avatar) | `/api/v1/user/{user_id}/avatar.png` |

</details>

<details>
<summary><strong>Menu</strong> (1 endpoints) β€” Get the Superset menu structure.</summary>

| Method | Endpoint                                 | Description     |
| ------ | ---------------------------------------- | --------------- |
| `GET`  | [Get menu](/developer-docs/api/get-menu) | `/api/v1/menu/` |

</details>

<details>
<summary><strong>Available Domains</strong> (1 endpoints) β€” Get available domains for the Superset instance.</summary>

| Method | Endpoint                                                                   | Description                  |
| ------ | -------------------------------------------------------------------------- | ---------------------------- |
| `GET`  | [Get all available domains](/developer-docs/api/get-all-available-domains) | `/api/v1/available_domains/` |

</details>

<details>
<summary><strong>AsyncEventsRestApi</strong> (1 endpoints) β€” Real-time event streaming via Server-Sent Events (SSE).</summary>

| Method | Endpoint                                                                                       | Description            |
| ------ | ---------------------------------------------------------------------------------------------- | ---------------------- |
| `GET`  | [Read off of the Redis events stream](/developer-docs/api/read-off-of-the-redis-events-stream) | `/api/v1/async_event/` |

</details>

<details>
<summary><strong>OpenApi</strong> (1 endpoints) β€” Access the OpenAPI specification.</summary>

| Method | Endpoint                                                                     | Description               |
| ------ | ---------------------------------------------------------------------------- | ------------------------- |
| `GET`  | [Get api by version openapi](/developer-docs/api/get-api-by-version-openapi) | `/api/{version}/_openapi` |

</details>

#### Other

<details>
<summary><strong>Security Groups</strong> (6 endpoints) β€” Endpoints related to Security Groups.</summary>

| Method   | Endpoint                                                                         | Description                     |
| -------- | -------------------------------------------------------------------------------- | ------------------------------- |
| `GET`    | [Get security groups](/developer-docs/api/get-security-groups)                   | `/api/v1/security/groups/`      |
| `POST`   | [Create security groups](/developer-docs/api/create-security-groups)             | `/api/v1/security/groups/`      |
| `GET`    | [Get security groups info](/developer-docs/api/get-security-groups-info)         | `/api/v1/security/groups/_info` |
| `DELETE` | [Delete security groups by pk](/developer-docs/api/delete-security-groups-by-pk) | `/api/v1/security/groups/{pk}`  |
| `GET`    | [Get security groups by pk](/developer-docs/api/get-security-groups-by-pk)       | `/api/v1/security/groups/{pk}`  |
| `PUT`    | [Update security groups by pk](/developer-docs/api/update-security-groups-by-pk) | `/api/v1/security/groups/{pk}`  |

</details>

<details>
<summary><strong>Themes</strong> (14 endpoints) β€” Manage UI themes for customizing Superset's appearance.</summary>

| Method   | Endpoint                                                                                                                                          | Description                             |
| -------- | ------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------------------------- |
| `DELETE` | [Bulk delete themes](/developer-docs/api/bulk-delete-themes)                                                                                      | `/api/v1/theme/`                        |
| `GET`    | [Get a list of themes](/developer-docs/api/get-a-list-of-themes)                                                                                  | `/api/v1/theme/`                        |
| `POST`   | [Create a theme](/developer-docs/api/create-a-theme)                                                                                              | `/api/v1/theme/`                        |
| `GET`    | [Get metadata information about this API resource (theme--info)](/developer-docs/api/get-metadata-information-about-this-api-resource-theme-info) | `/api/v1/theme/_info`                   |
| `DELETE` | [Delete a theme](/developer-docs/api/delete-a-theme)                                                                                              | `/api/v1/theme/{pk}`                    |
| `GET`    | [Get a theme](/developer-docs/api/get-a-theme)                                                                                                    | `/api/v1/theme/{pk}`                    |
| `PUT`    | [Update a theme](/developer-docs/api/update-a-theme)                                                                                              | `/api/v1/theme/{pk}`                    |
| `PUT`    | [Set a theme as the system dark theme](/developer-docs/api/set-a-theme-as-the-system-dark-theme)                                                  | `/api/v1/theme/{pk}/set_system_dark`    |
| `PUT`    | [Set a theme as the system default theme](/developer-docs/api/set-a-theme-as-the-system-default-theme)                                            | `/api/v1/theme/{pk}/set_system_default` |
| `GET`    | [Download multiple themes as YAML files](/developer-docs/api/download-multiple-themes-as-yaml-files)                                              | `/api/v1/theme/export/`                 |
| `POST`   | [Import themes from a ZIP file](/developer-docs/api/import-themes-from-a-zip-file)                                                                | `/api/v1/theme/import/`                 |
| `GET`    | [Get related fields data (theme-related-column-name)](/developer-docs/api/get-related-fields-data-theme-related-column-name)                      | `/api/v1/theme/related/{column_name}`   |
| `DELETE` | [Clear the system dark theme](/developer-docs/api/clear-the-system-dark-theme)                                                                    | `/api/v1/theme/unset_system_dark`       |
| `DELETE` | [Clear the system default theme](/developer-docs/api/clear-the-system-default-theme)                                                              | `/api/v1/theme/unset_system_default`    |

</details>

<details>
<summary><strong>UserRegistrationsRestAPI</strong> (8 endpoints) β€” Endpoints related to UserRegistrationsRestAPI.</summary>

| Method   | Endpoint                                                                                                                                                                                           | Description                                                  |
| -------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------ |
| `GET`    | [Get security user registrations](/developer-docs/api/get-security-user-registrations)                                                                                                             | `/api/v1/security/user_registrations/`                       |
| `POST`   | [Create security user registrations](/developer-docs/api/create-security-user-registrations)                                                                                                       | `/api/v1/security/user_registrations/`                       |
| `GET`    | [Get security user registrations info](/developer-docs/api/get-security-user-registrations-info)                                                                                                   | `/api/v1/security/user_registrations/_info`                  |
| `DELETE` | [Delete security user registrations by pk](/developer-docs/api/delete-security-user-registrations-by-pk)                                                                                           | `/api/v1/security/user_registrations/{pk}`                   |
| `GET`    | [Get security user registrations by pk](/developer-docs/api/get-security-user-registrations-by-pk)                                                                                                 | `/api/v1/security/user_registrations/{pk}`                   |
| `PUT`    | [Update security user registrations by pk](/developer-docs/api/update-security-user-registrations-by-pk)                                                                                           | `/api/v1/security/user_registrations/{pk}`                   |
| `GET`    | [Get distinct values from field data (security-user-registrations-distinct-column-name)](/developer-docs/api/get-distinct-values-from-field-data-security-user-registrations-distinct-column-name) | `/api/v1/security/user_registrations/distinct/{column_name}` |
| `GET`    | [Get related fields data (security-user-registrations-related-column-name)](/developer-docs/api/get-related-fields-data-security-user-registrations-related-column-name)                           | `/api/v1/security/user_registrations/related/{column_name}`  |

</details>

---

### Additional Resources

- [Superset REST API Blog Post](https://preset.io/blog/2020-10-01-superset-api/)
- [Accessing APIs with Superset](https://preset.io/blog/accessing-apis-with-superset/)