HomeGuidesRecipesAPI ReferencePython SDK
Alation Help Center
Guides

APIs by Roles

Refer to this table for information which Alation roles can use Alation API. See Roles Overview in the Alation documentation for definitions of the user roles.

πŸ“˜

Explorer Role

The Explorer role is available starting in 2023.1, only for Alation Cloud Service customers on the cloud-native architecture.

Explorers can use the Query API (except the CREATE endpoint); otherwise Explorers have the same API permissions as the Viewer role.

API Endpoint

Method

Viewer

Explorer (see note above)

Composer

Steward

Source Admin

Catalog Admin

Server Admin

Alation Agent API (Available from version 2023.1.4)

Get and create Agents

/integration/v1/agent/

GET, POST

No

No

No

No

No

No

Yes

List available Agent installers

/integration/v1/agent/installers/debian/

/integration/v1/agent/installers/rhel/

GET

No

No

No

No

No

No

Yes

Download Agent installers

/integration/v1/agent/installers/debian/{version}/

/integration/v1/agent/installers/rhel/{version}/

GET

No

No

No

No

No

No

Yes

Get the Agent connectivity endpoint

/integration/v1/agent/endpoint/

GET

No

No

No

No

No

No

Yes

Get, update, resync, and delete an Agent

/integration/v1/agent/{agent_id}

/integration/v1/agent/{agent_id}/resync/

GET, POST, PATCH, DELETE

No

No

No

No

No

No

Yes

Revoke or sign an Agent's certificate

/integration/v1/agent/{agent_id}/revoke_certificate/

/integration/v1/agent/{agent_id}/sign_certificate/

POST

No

No

No

No

No

No

Yes

API Tokens Authentication & Management (Available from version 2020.3)

Create a Refresh Token

/integration/v1/createRefreshToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Regenerate a Refresh Token

/integration/v1/regenRefreshToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create an API Access Token

/integration/v1/createAPIAccessToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Revoke an API Access Token

/integration/v1/revokeAPIAccessTokens/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Validate an API Access Token

/integration/v1/validateAPIAccessToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Validate a RefreshToken

/integration/v1/validateRefreshToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

API Resource API

Retrieve an API Resource

/integration/v1/api_resource/<HTTP_method>:<url>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create, update, or delete an API Resource

/integration/v1/api_resource/<HTTP_method>:<url>/

POST, PUT, PATCH, DELETE

No

No

No

No

No

No

Yes

Articles API

Create a new Article

/integration/v1/article/

POST

No

No

Yes

Yes

Yes

Yes

Yes

Article Detail

/integration/v1/article/<article_id>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Get all Articles

/integration/v1/article/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Update an Article

/integration/v1/article/<article_id>/

PUT

No

No

Yes

Yes

Yes

Yes

Yes

Delete an Article API

/integration/v1/article/<article_id>/

DELETE

No

No

Yes

Yes

Yes

Yes

Yes

Restore an Article API

/integration/v1/article/<article_id>/resurrect/

POST

No

No

Yes

Yes

Yes

Yes

Yes

Connectors (OCF) API (Available from version 2022.4)

Get a List of Connectors

/integration/v2/connectors/

GET

No

No

No

No

No

No

Yes

Conversations API (Available from version 2023.1)

Get, create, update, and delete conversations and posts

/integration/v1/conversations/

/integration/v1/conversations/<conversation_id>/posts/

Get, add, and delete assignees to conversation

/integration/v1/conversations/<conversation_id>/assignees/

/integration/v1/conversations/<conversation_id>/assignees/<assignee_otype>/<assignee_id>

GET, POST, PATCH, DELETE

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Custom Field API (Available from version 2020.3)

Get all the active Custom Fields

/integration/v2/custom_field/

GET

No

No

No

No

No

Yes

Yes

Create Custom Fields in Bulk

/integration/v2/custom_field/

POST

No

No

No

No

No

Yes

Yes

Get Built-in Custom Fields

/integration/v2/custom_field/builtin/{builtin_name}/

GET

No

No

No

No

No

Yes

Yes

Get Custom Field by ID

/integration/v2/custom_field/{id}/

GET

No

No

No

No

No

Yes

Yes

Custom Field Values API (Available from version 2020.3)

Get Custom Field values

/integration/v2/custom_field_value/

GET

No

No

No

No

No

Yes

Yes

Update Custom Field values

/integration/v2/custom_field_value/

PUT

No

No

No

No

No

Yes

Yes

Update Custom Field values for many objects types

/integration/v2/custom_field_value/async/

PUT

No

No

No

No

No

Yes

Yes

Custom Fields

/api/v1/bulk_metadata/data_dictionary/<otype>?custom_fields=<fields_json>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Custom Template API

Custom Template details

/integration/v1/custom_template/<custom_template_id>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Get all Custom Templates

/integration/v1/custom_template/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Data Dictionary API (Available from version 2023.3)

Get data dictionary task details and errors

/integration/v1/data_dictionary/tasks/{task_id}/

/integration/v1/data_dictionary/tasks/{task_id}/errors/

Upload data dictionary

/integration/v1/data_dictionary/{object_type}/{object_id}/upload/

GET, PUT

No

No

Yes***

Yes***

Yes***

Yes

Yes

Data Health API (Available from version 2022.3)

Get data health fields or values

/integration/v1/data_quality/fields/

/integration/v1/data_quality/values/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create or delete data health rules

/integration/v1/data_quality/

POST, DELETE

No

No

No

No

Yes

Yes

Yes

Data Sources API (Native) - Data Source (Available from version 2020.4)

Create a data source

/integration/v1/datasource/

POST

No

No

No

No

Yes**

Yes**

Yes

Delete or update a data source

/integration/v1/datasource/<ds_id>/

PUT, DELETE

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Retrieve single or multiple data sources

/integration/v1/datasource/

/integration/v1/datasource/<ds_id>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Data Sources API (Native) - Metadata Extraction (Available from version 2020.4)

Get a list of available schemas

/integration/v1/datasource/<ds_id>/available_schemas/

GET

No

No

No

No

No

No

Yes

Sync schemas

/integration/v2/datasource/{datasource_id}/refresh_available_schemas/

POST

No

No

No

No

No

No

Yes

Kick off metadata extraction job

/integration/v1/datasource/<ds_id>/metadata_extraction_job/

POST

Yes*

Yes*

Yes*

Yes*

Yes*

Yes*

Yes*

Get or update metadata extraction configurations

/integration/v1/datasource/<ds_id>/sync_configuration/metadata_extraction/

GET, PUT, PATCH

No

No

No

No

No

No

Yes

Data Sources API (Native) - Config Checks (Available from version 2020.4)

Verify data source configuration

/integration/v1/datasource/<ds_id>/configuration_check/

GET

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Verify network connection status

/integration/v1/datasource/<ds_id>/configuration_check/network_connection/

GET

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Verify service account authentication status and privileges

/integration/v1/datasource/<ds_id>/configuration_check/service_account_authentication/

/integration/v1/datasource/<ds_id>/configuration_check/service_account_privileges/

GET

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Data Sources API (Native) - Migrate Native to OCF

Bulk migrate data sources to OCF (Available from version 2023.1.5)

/integration/v1/datasource/bulk_migrate

POST

No

No

No

No

No

No

Yes

Get a list of OCF connectors and their native data sources (Available from version 2023.3)

/integration/v1/datasource/{db_type}/connectors

GET

No

No

No

No

Yes**

Yes**

Yes

Data Sources API (OCF) (Available from version 2022.4)

Create a data source

/integration/v2/datasource/

POST

No

No

No

No

Yes**

Yes**

Yes

Delete or update a data source

/integration/v2/datasource/<ds_id>/

PUT, DELETE

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Retrieve data sources

/integration/v2/datasource/

/integration/v2/datasource/<ds_id>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Data Sources API (OCF) - Metadata Extraction (Available from version 2022.4)

Get a list of available schemas

/integration/v2/datasource/{datasource_id}/available_schemas/

GET

No

No

No

No

No

No

Yes

Kick off metadata extraction job

/integration/v2/datasource/{datasource_id}/metadata_extraction_job/

POST

Yes*

Yes*

Yes*

Yes*

Yes*

Yes*

Yes*

Get or update metadata extraction configurations

/integration/v2/datasource/{datasource_id}/sync_configuration/metadata_extraction/

GET, PATCH

No

No

No

No

No

No

Yes

Data Sources API (OCF) - Config Checks (Available from version 2023.1)

Verify data source configuration

/integration/v2/datasource/<ds_id>/configuration_check/

GET

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Verify network connection status

/integration/v2/datasource/<ds_id>/configuration_check/network_connection/

GET

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Verify service account authentication status and privileges

/integration/v2/datasource/<ds_id>/configuration_check/service_account_authentication/

/integration/v2/datasource/<ds_id>/configuration_check/service_account_privileges/

GET

No

No

Yes*

Yes*

Yes*

Yes*

Yes

Data Sources API (OCF) - Configuration (Available from version 2023.1.7)

Get and update general configuration settings for an OCF data source

/integration/v2/datasource/{datasource_id}/configuration/

GET, PATCH

Yes*

Yes*

Yes*

Yes*

Yes*

Yes*

Yes*

Data Source Browsing

Get Metadata for an object

/catalog/<otype>/?<params>

GET

No

No

No

No

No

No

Yes

Data Source Schemas

Get Schemas in a Data Source

/catalog/datasource/<datasource_id>/schema/?<params>

GET

No

No

No

No

No

No

Yes

Documents API (Available from version 2024.1)

Get documents

/integration/v2/document/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create, update, and delete documents

/integration/v2/document/

POST, PUT, DELETE

No

No

No

No

No

Yes

Yes

Domains API

Get, create, update, and delete domains and add objects to domains

https://alation_domain/integration/v2/domain/

https://alation_domain/integration/v2/domain/{domain_id}/

https://alation_domain/integration/v2/domain/membership/

https://alation_domain/integration/v2/domain/membership/view_rules/

GET, POST, PATCH, DELETE

No

No

No

No

No

Yes

Yes

Flags API

Create a new Flag

/integration/flag/

POST

No

No

Yes

Yes

Yes

Yes

Yes

Get Flag details

/integration/flag/<flag_id>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Get All Flags

/integration/flag/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Update a Flag

/integration/flag/<flag_id>/

PUT

No

No

Yes

Yes

Yes

Yes

Yes

Delete a Flag

/integration/flag/<flag_id>/

DELETE

No

No

Yes

Yes

Yes

Yes

Yes

Folder API (Available from version 2024.1.3)

Get folders

/integration/v2/folder/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create, update, and delete folders

/integration/v2/folder/

POST, PUT, DELETE

No

No

No

No

No

Yes

Yes

Groups API (Available from version 2020.3)

Get all Groups

/integration/v1/group/

GET

No

No

No

No

No

No

Yes

Get a Group

/integration/v1/group/{id}/

GET

No

No

No

No

No

No

Yes

Homepage Preferences API

Update group homepage preferences

/integration/v1/home/{homepage_id}/user/preference

PUT

No

No

No

No

No

Yes

Yes

Jobs API

Get job status

/api/v1/bulk_metadata/job/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Lineage API (Lineage V2 and V3)

Get, create, and delete lineage

/integration/v2/lineage/

GET, POST, DELETE

No

No

No

No

Yes

No

Yes

Get, create, update, and delete dataflows

/integration/v2/dataflow/

GET, POST, PATCH, DELETE

No

No

No

No

Yes

No

Yes

Get, create, update, and delete multiple cross-system lineage records

/integration/v2/cross_system_lineage/

Get, update, and delete a specific cross-system lineage record

/integration/v2/cross_system_lineage/{csl_id}

GET, POST, PATCH, DELETE

No

No

No

No

Yes

Yes

Yes

Members Permission API

Add and replace member permissions

/integration/v1/members_permission/

Delete member permissions

/integration/v1/members_permission/{resource_type}/{resource_id}/members/

POST, PUT, DELETE

No

No

No

No

Yes*

Yes*

Yes

My Domains API

Update users and groups assigned to domains

/integration/v1/my_domains/

PUT

No

No

No

No

No

Yes

Yes

NoSQL API v1

Upload your Metadata into the NoSQL catalog

/integration/v1/data/<datasource_id>/parse_docstore/

POST

No

No

No

No

No

No

Yes

Delete sub-objects in a NoSQL catalog

/integration/v1/data/<datasource_id>/parse_docstore/?remove_not_seen=true

POST

No

No

No

No

No

No

Yes

NoSQL API v2

Create, retrieve, update, and delete NoSQL metadata

/integration/v2/doc_schema/{datasource_id}/

GET, POST, PATCH, DELETE

No

No

No

No

No

No

Yes

OAuth 2.0 API v2 (Available from version 2023.3)

/oauth/v2/token/

/oauth/v2/introspect/

/oauth/v2/.well-known/jwks.json/

GET, POST

Yes

Yes

Yes

Yes

Yes

Yes

Yes

OTypes API (Available from version 2021.1)

/integration/v1/otypes/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Policy API (Available from version 2023.1.5)

Get existing policies.

/integration/v1/business_policies/

GET

No

No

No

No

No

Yes

Yes

Create policies in bulk

/integration/v1/business_policies/

POST

No

No

No

No

No

Yes

Yes

Update policies in bulk

/integration/v1/business_policies/

PUT

No

No

No

No

No

Yes

Yes

Delete policies in bulk

/integration/v1/business_policies/

DELETE

No

No

No

No

No

Yes

Yes

Policy Groups API (Available from version 2022.4)

/integration/v1/policy_group

GET

No

No

No

No

No

Yes

Yes

Privacy Settings API

Manage privacy settings

/integration/v1/privacy_settings/

PATCH

No

No

No

No

Yes*

Yes*

Yes

Queriers API (Find Top DB Accounts)

/integration/v1/<otype>/<id>/db_account/?<params>

GET

No

No

No

No

No

No

Yes

Query API (Compose)

Create a new query

/integration/v1/query/

POST

No

No

Yes

Yes

Yes

Yes

Yes

Get query details

/integration/v1/query/?<params>

/integration/v1/query/<query_id>/

/integration/v1/query/<query_id>/sql/

GET

No

Yes

Yes

Yes

Yes

Yes

Yes

Get latest query result details

/integration/v1/query/<query_id>/result/latest/

GET

No

Yes

Yes

Yes

Yes

Yes

Yes

Get query results in CSV

/integration/v1/result/<execution_result_id>/csv/

GET

No

No

Yes

Yes

Yes

Yes

Yes

Get execution session details

/integration/v1/query/execution_session/?<params>

/integration/v1/query/execution_session/<session_id>/

/integration/v1/query/<query_id>/execution_session/?<params>

GET

No

Yes

Yes

Yes

Yes

Yes

Yes

Get execution batch details

/integration/v1/query/execution_batch/?<params>

/integration/v1/query/execution_batch/<batch_id>/

/integration/v1/query/<query_id>/execution_batch/?<params>

GET

No

Yes

Yes

Yes

Yes

Yes

Yes

Get execution event details

/integration/v1/query/execution_event/?<params>

/integration/v1/query/execution_event/<batch_id>/

/integration/v1/query/<query_id>/execution_event/?<params>

GET

No

Yes

Yes

Yes

Yes

Yes

Yes

Get scheduled runs

/integration/v1/query/scheduled_run/?<params>

/integration/v1/query/<query_id>/scheduled_run/?<params>

GET

No

No

Yes

Yes

Yes

Yes

Yes

Query Log Upload API (Push QLI)

/api/v1/bulk_metadata/query_log_ingestion/<ds_id>/

POST

No

No

No

No

No

No

Yes

Relational Integration API (Available from version 2021.2)

Retrieve an object

/integration/v2/schema/

/integration/v2/table/

/integration/v2/column/

/integration/v2/column/{column_id}/children/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create an object

/integration/v2/schema/

/integration/v2/table/

/integration/v2/column/

POST

No

No

No

No

Yes*

Yes*

Yes

Update child columns

/integration/v2/column/children/

PATCH

No

No

No

No

Yes*

Yes*

Yes

Relational Integration v1

Get any data object details or delete a data object

/integration/v1/<otype>/<id>/

GET

DELETE

No

No

No

No

No

No

Yes

Get all data objects of a type

/integration/v1/<otype>/?<params>

GET

No

No

No

No

No

No

Yes

SCIM 2.0 API (Available from version 2023.3.3)

/scim/v2/token/

POST

No

No

No

No

No

No

Yes

Search API (Available from version 2021.1)

/integration/v1/search/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Search Synonym API (Available from version 2023.3.2)

Get the current search synonym list

/integration/v1/search-synonym/

GET

No

No

No

No

No

Yes

Yes

Create search synonyms

/integration/v1/search-synonym/

POST

No

No

No

No

No

Yes

Yes

Delete search synonyms

/integration/v1/search-synonym/

DELETE

No

No

No

No

No

Yes

Yes

Table Metadata Sync Trigger API

/api/v1/table/sync/

POST

No

No

No

No

No

No

Yes

Tags API

Create a new Tag

/integration/tag/<tag_name>/subject/

POST

No

No

Yes

Yes

Yes

Yes

Yes

Get all Tags

/integration/tag/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Get Tag details

/integration/tag/<id>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Get all objects with a certain Tag

/integration/tag/<tag_name>/subject/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Delete a Tag

/integration/tag/<tag_name>/subject/<otype>/<oid>/

DELETE

No

No

Yes

Yes

Yes

Yes

Yes

Terms API (Available from version 2022.3)

Get terms

/integration/v2/term/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create, update, and delete terms

/integration/v2/term/

POST, PUT, DELETE

No

No

No

No

No

Yes

Yes

Upload Logical Metadata

/api/v1/bulk_metadata/custom_fields/<template_name>/<object_type>?<params>

POST

No

No

Yes

Yes

Yes

Yes

Yes

Upload Virtual Data Source

Add Technical Metadata

/api/v1/bulk_metadata/extraction/<ds_id>?<params>

POST

No

No

No

No

Yes

No

Yes

Update Technical Metadata Object

/api/v1/bulk_metadata/extraction/<ds_id>?<params>

POST

No

No

No

No

Yes

No

Yes

Delete Technical Metadata

/api/v1/bulk_metadata/extraction/<ds_id>?remove_not_seen=true

POST

No

No

No

No

Yes

No

Yes

Upload Virtual File System

/api/v1/bulk_metadata/file_upload/<filesystem_id>/

POST

No

No

No

No

No

No

Yes

User API v1 (Available from version 2020.3)

Get multiple Users

/integration/v1/user/

GET

No

No

No

No

No

No

Yes

Get a User

/integration/v1/user/{id}/

GET

No

No

No

No

No

No

Yes

Get authenticated User (Available from version 2022.4)

/integration/v1/userinfo/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Get duplicate user accounts (Available from version 2022.4.3)

/integration/v1/generate_dup_users_accts_csv_file/

GET

No

No

No

No

No

No

Yes

Suspend duplicate user accounts (Available from version 2022.4.3)

/integration/v1/remove_dup_users_accts/

POST

No

No

No

No

No

No

Yes

User API v2 (Available from version 2022.4.3)

Get multiple Users

/integration/v2/user/

GET

No

No

No

No

No

No

Yes

Get a User

/integration/v2/user/{id}/

GET

No

No

No

No

No

No

Yes

Requests API (Available from version 2023.3)

List requests

/integration/v2/workflow_executions/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create request

/integration/v2/workflow_executions/

POST

No

No

Yes

Yes

Yes

Yes

Yes

Show request details

/integration/v2/workflow_executions/{workflow_execution_id}

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Review Requests API (Available from version 2023.1.7)

List review todos

/integration/v2/workflow_stepexecutions/todos/

GET

No

No

Yes

Yes

Yes

Yes

Yes

Approve review

/integration/v2/workflow_stepexecutions/{workflow_stepexecution_id}/approve/

PUT

No

No

Yes

Yes

Yes

Yes

Yes

Reject review

/integration/v2/workflow_stepexecutions/{workflow_stepexecution_id}/reject/

PUT

No

No

Yes

Yes

Yes

Yes

Yes

Workflows API (Available from version 2023.1.4)

Get workflows

/integration/v2/workflows

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

BI Source API (GBM V2)

API operations with BI server objects

/integration/v2/bi/server/

GET POST PATCH

No

No

No

No

No

No

Yes

API operations with BI folder objects

/integration/v2/bi/server/{server_id}/folder/

GET POST PATCH DELETE

No

No

No

No

No

No

Yes

API operations with BI report and column objects

/integration/v2/bi/server/{server_id}/report/

/integration/v2/bi/server/{server_id}/report/column

GET POST PATCH DELETE

No

No

No

No

No

No

Yes

API operations with BI datasource objects

/integration/v2/bi/server/{server_id}/datasource/

/integration/v2/bi/server/{server_id}/datasource/column

GET POST PATCH DELETE

No

No

No

No

No

No

Yes

API operations with BI object permissions

/integration/v2/bi/server/{server_id}/permission

GET POST DELETE

No

No

No

No

No

No

Yes

Fetch, create, or delete Images

/integration/v2/bi/server/{server_id}/report/{id}/image

GET PUT PATCH DELETE

No

No

No

No

No

No

Yes

API operations with BI user object

/integration/v2/bi/server/{server_id}/user

GET PUT PATCH DELETE

No

No

No

No

No

No

Yes

* API user must be given Data Source Admin access to the data source in the Alation catalog.
** When Catalog Admin and Source Admin roles are permitted to add data sources (with the alation_conf flag alation.roles.allow_source_and_catalog_admins_to_create_ds set to true).
*** When the parameter alation.feature_flags.disable_perm_check_on_upload_dd is set to false in alation_conf (false is the default).