Catalog APIs

Fabric provides out-of-the-box Web Service APIs for querying a project's Catalog.

Any web service call passes authentication and authorization processes before being executed. For more information - see here.

All APIs are accessed over HTTPS, from the Fabric URL endpoint https://<Domain Name>:<PORT>

Start Crawler Job

GET /api/catalog/start-crawler-job

The API invokes the DISCOVERY_CRAWLER job for a given interface.

Example of an API call:

https://localhost:3213/api/catalog/start-crawler-job?dataPlatform=CRM_DB

Get Catalog

GET /api/catalog

The API retrieves a list of the Catalog's versions and their creations' timestamp.

Example of an API call:

https://localhost:3213/api/catalog

Get Catalog Version Details

GET /api/catalog/{version}

The API retrieves a list of data platforms that belong to a given Catalog version. Each data platform is retrieved with the contains relations to its respective schema nodes.

The API has 2 modes - view and compare - that are interchangeably invoked based on the version input parameter, as explained below:

Component Mandatory Description
version Y

Populate either the version number or the word latest to get the version's data.

Populate {base version}...{compare version} to get the versions comparison. In the response, each node indicates whether it has been added, deleted, updated or unchanged.

In order to see the recent changes, set the {base version} to an older version number and the {compare version} to a more recent version number or to the word latest.

Examples of an API call in view mode:

https://localhost:3213/api/catalog/latest
https://localhost:3213/api/catalog/latest

Examples of an API call in compare mode:

https://localhost:3213/api/catalog/2...5
https://localhost:3213/api/catalog/1...latest

Get Catalog's Data Platform Details

GET /api/catalog/{version}/{dataPlatform}

The API retrieves a list of schemas that belong to the specified Catalog version and data platform. Each schema is retrieved with the contains relations to its respective dataset nodes.

The API has 2 modes - view and compare - that are interchangeably invoked based on the version input parameter, as explained below:

Component Mandatory Description
version Y

Populate either the version number or the word latest to get the version's data.

Populate {base version}...{compare version} to get the versions comparison. In the response, each node indicates whether it has been added, deleted, updated or unchanged.

In order to see the recent changes, set the {base version} to an older version number and the {compare version} to a more recent version number or to the word latest.

dataPlatform Y

The data platform name.

Examples of an API call in the view mode:

https://localhost:3213/api/catalog/latest/CRM_DB
https://localhost:3213/api/catalog/1/CRM_DB

Examples of an API call in the compare mode:

https://localhost:3213/api/catalog/1...5/CRM_DB
https://localhost:3213/api/catalog/1...latest/CRM_DB

Get Catalog's Schema Details

GET /api/catalog/{version}/{dataPlatform}/{schema}

The API retrieves all elements that belong to the specified Catalog version, data platform and schema. The elements include the datasets, fields and their properties, and the refersTo relations between the dataset nodes.

The API has 2 modes - view and compare - that are interchangeably invoked based on the version input parameter, as explained below:

Component Mandatory Description
version Y

Populate either the version number or the word latest to get the version's data.

Populate {base version}...{compare version} to get the versions comparison. In the response, each node indicates whether it has been added, deleted, updated or unchanged.

In order to see the recent changes, set the {base version} to an older version number and the {compare version} to a more recent version number or to the word latest.

dataPlatform Y

The data platform name.

schema Y

The schema name.

propertiesToInclude N

Coma-separated list of properties to be included in the output. When empty, all properties are included. Available in V7.2.2.

E.g.: propertiesToInclude=pii,pk

Examples of an API call in the view mode:

https://localhost:3213/api/catalog/latest/CRM_DB/main
https://localhost:3213/api/catalog/1/CRM_DB/main

Examples of an API call in the compare mode:

https://localhost:3213/api/catalog/1...5/CRM_DB/main
https://localhost:3213/api/catalog/1...latest/CRM_DB/main

Build Catalog Artifacts

POST /api/catalog/{version}/build-catalog-artifacts

The API builds the Catalog artifacts, based on a given version. An artifact includes the details of all Catalog fields with their properties, such as Classification and PII. The artifact is created in a CSV format, saved into the Implementation/SharedObjects/Interfaces/Discovery/MTable folder of the Project tree and is uploaded to the Fabric memory as an MTable.

Example of an API call:

https://localhost:3213/api/catalog/4/build-catalog-artifacts

Search Catalog

POST /api/catalog/{version}/search-graph

The API retrieves all elements that belong to the specified Catalog version, based on the search criteria defined in the request body.

The syntax of the request body definition is as follows:

  • input is an array of keywords

    • Keyword is a string included in the node (or relation) name
  • type defines which object types will be searched

    • The valid values are: dataPlatform, schema, dataset, field, relation
    • Send an empty array in case of no limitation on object type
  • advanced includes a list of additional search parameters, such as:

    • pii is a PII property with either true or false value
    • classification is a Classification property with one of its valid values
    • score is a maximum score of the searched object types (nodes or relations)

At least one of the search parameters must be provided in the request body.

Example of an API call:

https://localhost:3213/api/catalog/4/search-graph

Examples of the request body:

Example 1: When searching for Data Platform and Schema nodes, whose name includes a customer keyword, the request body is:

{
    "input": [
        "customer"
    ],
    "type": [
        "dataPlatform",
        "schema"
    ],
    "advanced": {
    }
}

Example 2: When searching for any node types with PII = true and Classification = EMAIL properties, the request body is:

{
    "input": [],
    "type": [],
    "advanced": {
        "pii": "true",
        "classification": "EMAIL"
    }
}

Previous

Catalog APIs

Fabric provides out-of-the-box Web Service APIs for querying a project's Catalog.

Any web service call passes authentication and authorization processes before being executed. For more information - see here.

All APIs are accessed over HTTPS, from the Fabric URL endpoint https://<Domain Name>:<PORT>

Start Crawler Job

GET /api/catalog/start-crawler-job

The API invokes the DISCOVERY_CRAWLER job for a given interface.

Example of an API call:

https://localhost:3213/api/catalog/start-crawler-job?dataPlatform=CRM_DB

Get Catalog

GET /api/catalog

The API retrieves a list of the Catalog's versions and their creations' timestamp.

Example of an API call:

https://localhost:3213/api/catalog

Get Catalog Version Details

GET /api/catalog/{version}

The API retrieves a list of data platforms that belong to a given Catalog version. Each data platform is retrieved with the contains relations to its respective schema nodes.

The API has 2 modes - view and compare - that are interchangeably invoked based on the version input parameter, as explained below:

Component Mandatory Description
version Y

Populate either the version number or the word latest to get the version's data.

Populate {base version}...{compare version} to get the versions comparison. In the response, each node indicates whether it has been added, deleted, updated or unchanged.

In order to see the recent changes, set the {base version} to an older version number and the {compare version} to a more recent version number or to the word latest.

Examples of an API call in view mode:

https://localhost:3213/api/catalog/latest
https://localhost:3213/api/catalog/latest

Examples of an API call in compare mode:

https://localhost:3213/api/catalog/2...5
https://localhost:3213/api/catalog/1...latest

Get Catalog's Data Platform Details

GET /api/catalog/{version}/{dataPlatform}

The API retrieves a list of schemas that belong to the specified Catalog version and data platform. Each schema is retrieved with the contains relations to its respective dataset nodes.

The API has 2 modes - view and compare - that are interchangeably invoked based on the version input parameter, as explained below:

Component Mandatory Description
version Y

Populate either the version number or the word latest to get the version's data.

Populate {base version}...{compare version} to get the versions comparison. In the response, each node indicates whether it has been added, deleted, updated or unchanged.

In order to see the recent changes, set the {base version} to an older version number and the {compare version} to a more recent version number or to the word latest.

dataPlatform Y

The data platform name.

Examples of an API call in the view mode:

https://localhost:3213/api/catalog/latest/CRM_DB
https://localhost:3213/api/catalog/1/CRM_DB

Examples of an API call in the compare mode:

https://localhost:3213/api/catalog/1...5/CRM_DB
https://localhost:3213/api/catalog/1...latest/CRM_DB

Get Catalog's Schema Details

GET /api/catalog/{version}/{dataPlatform}/{schema}

The API retrieves all elements that belong to the specified Catalog version, data platform and schema. The elements include the datasets, fields and their properties, and the refersTo relations between the dataset nodes.

The API has 2 modes - view and compare - that are interchangeably invoked based on the version input parameter, as explained below:

Component Mandatory Description
version Y

Populate either the version number or the word latest to get the version's data.

Populate {base version}...{compare version} to get the versions comparison. In the response, each node indicates whether it has been added, deleted, updated or unchanged.

In order to see the recent changes, set the {base version} to an older version number and the {compare version} to a more recent version number or to the word latest.

dataPlatform Y

The data platform name.

schema Y

The schema name.

propertiesToInclude N

Coma-separated list of properties to be included in the output. When empty, all properties are included. Available in V7.2.2.

E.g.: propertiesToInclude=pii,pk

Examples of an API call in the view mode:

https://localhost:3213/api/catalog/latest/CRM_DB/main
https://localhost:3213/api/catalog/1/CRM_DB/main

Examples of an API call in the compare mode:

https://localhost:3213/api/catalog/1...5/CRM_DB/main
https://localhost:3213/api/catalog/1...latest/CRM_DB/main

Build Catalog Artifacts

POST /api/catalog/{version}/build-catalog-artifacts

The API builds the Catalog artifacts, based on a given version. An artifact includes the details of all Catalog fields with their properties, such as Classification and PII. The artifact is created in a CSV format, saved into the Implementation/SharedObjects/Interfaces/Discovery/MTable folder of the Project tree and is uploaded to the Fabric memory as an MTable.

Example of an API call:

https://localhost:3213/api/catalog/4/build-catalog-artifacts

Search Catalog

POST /api/catalog/{version}/search-graph

The API retrieves all elements that belong to the specified Catalog version, based on the search criteria defined in the request body.

The syntax of the request body definition is as follows:

  • input is an array of keywords

    • Keyword is a string included in the node (or relation) name
  • type defines which object types will be searched

    • The valid values are: dataPlatform, schema, dataset, field, relation
    • Send an empty array in case of no limitation on object type
  • advanced includes a list of additional search parameters, such as:

    • pii is a PII property with either true or false value
    • classification is a Classification property with one of its valid values
    • score is a maximum score of the searched object types (nodes or relations)

At least one of the search parameters must be provided in the request body.

Example of an API call:

https://localhost:3213/api/catalog/4/search-graph

Examples of the request body:

Example 1: When searching for Data Platform and Schema nodes, whose name includes a customer keyword, the request body is:

{
    "input": [
        "customer"
    ],
    "type": [
        "dataPlatform",
        "schema"
    ],
    "advanced": {
    }
}

Example 2: When searching for any node types with PII = true and Classification = EMAIL properties, the request body is:

{
    "input": [],
    "type": [],
    "advanced": {
        "pii": "true",
        "classification": "EMAIL"
    }
}

Previous