APIs by Roles

Refer to this table for information which Alation roles can use Alation API.

API Endpoint

Method

Viewer

Composer

Steward

Source Admin

Catalog Admin

Server Admin

Relational Integration APIs (Available from version 2021.2)

Retrieve an object

/integration/v2/schema/

/integration/v2/table/

/integration/v2/column/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Create or update an object

/integration/v2/schema/

/integration/v2/table/

/integration/v2/column/

POST

No

No

No

Yes*

Yes*

Yes

Search API (Available from version 2021.1)

/integration/v1/search/

GET

Yes

Yes

Yes

Yes

Yes

Yes

OTypes API (Available from version 2021.1)

/integration/v1/otypes/

GET

Yes

Yes

Yes

Yes

Yes

Yes

API Tokens Authentication & Management (Available from version 2020.3)

Create a Refresh Token

/integration/v1/createRefreshToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Regenerate a Refresh Token

/integration/v1/regenRefreshToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Create an API Access Token

/integration/v1/createAPIAccessToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Revoke an API Access Token

/integration/v1/revokeAPIAccessTokens/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Validate an API Access Token

/integration/v1/validateAPIAccessToken/

POST

Yes

Yes

Yes

Yes

Yes

Yes

Validate a RefreshToken

/integration/v1/validateRefreshToken/

POST

Yes

Yes

Yes

Yes

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

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

/integration/v2/custom_field_value/

PUT

No

No

No

No

No

Yes

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

/integration/v2/custom_field_value/async/

PUT

No

No

No

No

No

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

Get Built-in Custom Fields

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

GET

No

No

No

No

No

Yes

Get Custom Field by ID

/integration/v2/custom_field/{id}/

GET

No

No

No

No

No

Yes

User API (Available from version 2020.3)

Get all Users

/integration/v1/user/

GET

No

No

No

No

No

Yes

Get a User

/integration/v1/user/{id}/

GET

No

No

No

No

No

Yes

Group API (Available from version 2020.3)

Get all Groups

/integration/v1/group/

GET

No

No

No

No

No

Yes

Get a Group

/integration/v1/group/{id}/

GET

No

No

No

No

No

Yes

Dataflow API (Available from version 2020.3 )

Upload Dataflow

/integration/v2/dataflow/

POST, PATCH

No

No

No

No

No

Yes

Delete Dataflow

/integration/v2/dataflow/?<params>

DELETE

No

No

No

No

No

Yes

Get a Dataflow

/integration/v2/dataflow/?<params>

GET

No

No

No

No

No

Yes

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

Get Lineage API

/integration/v2/lineage/

GET

No

No

No

No

No

Yes

Upload Lineage API

/integration/v2/lineage/

POST

No

No

No

No

No

Yes

Delete Lineage Info API

/integration/v2/lineage/?<params>

DELETE

No

No

No

No

No

Yes

Data Sources API (Available from version 2020.4)

Create a data source

/integration/v1/datasource/

POST

No

No

No

Yes**

Yes**

Yes

Delete a data source

/integration/v1/datasource/<ds_id>/

PUT, DELETE

No

Yes*

Yes*

Yes*

Yes*

Yes

Retrieve data sources

/integration/v1/datasource/

/integration/v1/datasource/<ds_id>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Data Source Config Checks API (Available from version 2020.4)

Verify network connection status

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

GET

No

Yes*

Yes*

Yes*

Yes*

Yes

Verify service account authentication status

/datasource/{datasource_id}/configuration_check/service_account_privileges/

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

GET

No

Yes*

Yes*

Yes*

Yes*

Yes

Verify data source configuration

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

GET

No

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

Yes

Get a list of available schemas

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

GET

No

No

No

No

No

Yes

Kick off metadata extraction job

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

POST

No

No

No

No

No

Yes

Flags API

Create a new Flag

/integration/flag/

POST

No

Yes

Yes

Yes

Yes

Yes

Get Flag details

/integration/flag/<flag_id>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Get All Flags

/integration/flag/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Update a Flag

/integration/flag/<flag_id>/

PUT

No

Yes

Yes

Yes

Yes

Yes

Delete a Flag

/integration/flag/<flag_id>/

DELETE

No

Yes

Yes

Yes

Yes

Yes

Tags API

Create a new Tag

/integration/tag/<tag_name>/subject/

POST

No

Yes

Yes

Yes

Yes

Yes

Get all Tags

/integration/tag/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Get Tag details

/integration/tag/<id>/

GET

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

Delete a Tag

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

DELETE

No

Yes

Yes

Yes

Yes

Yes

Articles API

Create a new Article

/integration/v1/article/

POST

No

Yes

Yes

Yes

Yes

Yes

Article Detail

/integration/v1/article/<article_id>/

GET

Yes

Yes

Yes

Yes

Yes

Yes

Get all Articles

/integration/v1/article/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Update an Article

/integration/v1/article/<article_id>/

PUT

No

Yes

Yes

Yes

Yes

Yes

Delete an Article API

/integration/v1/article/<article_id>/

DELETE

No

Yes

Yes

Yes

Yes

Yes

Restore an Article API

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

POST

No

Yes

Yes

Yes

Yes

Yes

Upload Logical Metadata

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

POST

No

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

Get all Custom Templates

/integration/v1/custom_template/?<params>

GET

Yes

Yes

Yes

Yes

Yes

Yes

Find Objects by Custom Field

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

GET

Yes

Yes

Yes

Yes

Yes

Yes

Data Source Browsing

Get Metadata for an object

/catalog/<otype>/?<params>

GET

No

No

No

No

No

Yes

Get Schemas in a Data Source

Get Schemas in a Data Source

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

GET

No

No

No

No

No

Yes

Accessing Relational Database type Data Objects

Get any data object details or delete a data object

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

GET

DELETE

No

No

No

No

No

Yes

Get all data objects of a type

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

GET

No

No

No

No

No

Yes

Query Log Upload (Push QLI) API

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

POST

No

No

No

No

No

Yes

Upload Virtual Data Source

Add Technical Metadata

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

POST

No

No

No

Yes

No

Yes

Update Technical Metadata Object

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

POST

No

No

No

Yes

No

Yes

Delete Technical Metadata

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

POST

No

No

No

Yes

No

Yes

Table Metadata Sync Trigger API

/api/v1/table/sync/

POST

No

No

No

No

No

Yes

Find Top DB Accounts

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

GET

No

No

No

No

No

Yes

Compose Query API

Create a new Query

/integration/v1/query/

POST

No

Yes

Yes

Yes

Yes

Yes

Get Query SQL

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

GET

No

Yes

Yes

Yes

Yes

Yes

Query Result details

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

GET

No

Yes

Yes

Yes

Yes

Yes

Query latest Result details

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

GET

No

Yes

Yes

Yes

Yes

Yes

Query details

/integration/v1/query/<query_id>/

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Queries

/integration/v1/query/?<params>

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Execution Sessions

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get Execution Session details

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Execution Sessions for a Query

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Execution Batches

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get ExecutionBatch Detail

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Execution Batches for a Query

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Execution Events

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get Execution Event details

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Execution Events for a Query

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Scheduled Runs

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

GET

No

Yes

Yes

Yes

Yes

Yes

Get all Scheduled Runs for a Query

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

GET

No

Yes

Yes

Yes

Yes

Yes

Job Status

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

GET

Yes

Yes

Yes

Yes

Yes

Yes

Upload Virtual File System (Beta)

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

POST

No

No

No

No

No

Yes

API Resource API

Retrieve an API Resource

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

GET

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

Yes

NoSQL API

Upload your Metadata into the NoSQL catalog

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

POST

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

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

Yes

API operations with BI folder objects

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

GET POST PATCH DELETE

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

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

Yes

API operations with BI object permissions

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

GET POST DELETE

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

Yes

API operations with BI user object

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

GET PUT PATCH DELETE

No

No

No

No

No

Yes

Domain API

API operations to create and GET objects in a domain

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

GET POST

No

No

No

No

Yes

Yes


Did this page help you?