HomeGuidesRecipesAPI Reference
Alation Help Center

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

Cross-System Lineage Information API (Available from version 2023.3.5)

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

/api/v1/bulk_metadata/cross_system_lineage/read/

/api/v1/bulk_metadata/cross_system_lineage/create/

/api/v1/bulk_metadata/cross_system_lineage/update/

/api/v1/bulk_metadata/cross_system_lineage/delete/

GET, POST, PATCH, DELETE

No

No

No

No

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 for DataFlow objects and BI objects (GBM V2)

/integration/v2/custom_field_value/

GET

No

No

No

No

No

Yes

Yes

Update Custom Field values for DataFlow objects and BI objects (GBM V2)

/integration/v2/custom_field_value/

PUT

No

No

No

No

No

Yes

Yes

Update Custom Field values for many objects types(GBM V2)

/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

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

Upload data dictionary

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

GET, PUT

No

No

Yes***

Yes***

Yes***

Yes

Yes

Dataflow API (Available from version 2020.3)

Upload Dataflow

/integration/v2/dataflow/

POST, PATCH

No

No

No

No

Yes

No

Yes

Delete Dataflow

/integration/v2/dataflow/?<params>

DELETE

No

No

No

No

Yes

No

Yes

Get a Dataflow

/integration/v2/dataflow/?<params>

GET

No

No

No

No

Yes

No

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

API operations to create and GET objects in a domain

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

GET POST

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

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

Job Status

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

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Lineage API (Lineage V2 and V3) (Available from version 2020.3 (POST, DELETE) and 2020.4 (GET))

Get Lineage API

/integration/v2/lineage/

GET

No

No

No

No

Yes

No

Yes

Upload Lineage API

/integration/v2/lineage/

POST

No

No

No

No

Yes

No

Yes

Delete Lineage Info API

/integration/v2/lineage/?<params>

DELETE

No

No

No

No

Yes

No

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

NoSQL API

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

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/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Yes

Create or update an object

/integration/v2/schema/

/integration/v2/table/

/integration/v2/column/

POST

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

Virtual BI Server Sources APIs (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).