Get catalog items

get

/api/20210901/catalog

Without search criteria, returns a list of supported catalog item types. With search criteria, returns catalog items that match the criteria specified. Returned lists have a maximum of 10000 items. For information about the search syntax, see Search Options.

Request

Query Parameters
  • Comma separated list of fields to exclude from response.
  • Comma separated list of fields to include in response.
  • Number of catalog items per page.
  • If true, search is performed in content management mode. You need Manage Content permission to enable content management mode.
  • Page number.
  • Search string.
  • Sort by criteria.
  • Sort order.
    Allowed Values: [ "ASC", "DESC" ]
  • Catalog item type filter. These content filter types are supported
    • folders - Folders containing catalog objects.
    • workbooks - Workbooks.
    • subjectAreas - Subject areas.
    • datasets - Datasets.
    • connections - Objects containing connection details.
    • dataflows - Data flows.
    • models - Predictive and machine learning models.
    • sequences - Sequences.
    • analysis - Analyses.
    • reports - Pixel-perfect reports (BIP reports).
    • dashboards - Dashboards.
    • dashboardpages - Dashboard pages.
    • dashboardgroupfolders - Workbooks and dashboards available from the Navigation menu on the Home page.
    • scripts - Custom scripts for machine learning and data curation.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

200 Response

Successful operation
Headers
Body ()
Root Schema : schema
Match One Schema
Show Source
Nested Schema : CatalogItems
Type: array
Show Source
Nested Schema : TypeInfos
Type: array
Show Source
Nested Schema : CatalogItem
Match All
Show Source
Nested Schema : Discriminator: type
Type: object
Show Source
Nested Schema : CatalogItemIdRef
Type: object
Show Source
Nested Schema : CatalogItemParentIdNameRef
Type: object
Show Source
Nested Schema : TypeInfo
Type: object
Show Source
  • Allowed Values: [ "workbooks", "folders", "datasets", "connections", "dataflows", "models", "sequences", "subjectAreas", "analysis", "reports", "dashboards", "dashboardpages", "dashboardgroupfolders", "scripts" ]

400 Response

Bad Request (invalid query parameters, malformed headers, and so on).
Body ()
Root Schema : Error
Type: object
Show Source

401 Response

Unauthorized (missing or expired credentials, and so on).
Body ()
Root Schema : Error
Type: object
Show Source

500 Response

Internal Server Error. The server encountered an unexpected condition preventing fulfilment of the request.
Body ()
Root Schema : Error
Type: object
Show Source
Back to Top

Examples

This example shows you how to obtain a list of the types of catalog object that the catalog REST API supports.

cURL Example - No Search Criteria

curl -i --header 'Authorization: Bearer <token>' \
--request GET 'https://<hostname>/api/20210901/catalog'

Example of Request Body

Not applicable.

Example of Response Body

Status 200:
[
    {"type": "workbooks"},
    {"type": "folders"},
    {"type": "datasets"},
    {"type": "connections"},
    {"type": "dataflows"},
    {"type": "models"},
    {"type": "sequences"},
    {"type": "subjectAreas"},
    {"type": "analysis"},
    {"type": "reports"},
    {"type": "dashboardgroupfolders"},
    {"type": "dashboardfolders"},
    {"type": "dashboardpages"},
    {"type": "dashboards"},
    {"type": "scripts"}]

cURL Example - With Search Criteria

You can add search query criteria to the search parameter in the cURL command to further refine the results of your search. This example includes search criteria that returns workbooks owned by john.smith@oracle.com that contain the word sales in the name and a column called Product.

curl -i --header 'Authorization: Bearer <token>' \
--request GET 'https://<hostname>/api/20210901/catalog/workbooks?search=owner:john.smith@oracle.com name:sales
      columns:Product'

cURL Example - With Subitem Search Criteria

You can also use the search query parameter to search for items within container objects (such as folders or dashboards). This example returns all the subitems in the shared/Sales folder.

curl -i --header 'Authorization: Bearer <token>' \
--request GET 'https://<hostname>/api/20210901/catalog/folders/c2hhcmVkL1NhbGVz?search=*'

cURL Example - With manageContent Enabled

If you have the appropriate privileges, you can run search queries in content management mode by setting the manageContent parameter set to true. When you search in content management mode, the API can return items not owned by or shared with you. You must have the Manage Content permission or BI Service Administrator role to run the query in content management mode.

This example returns a list of all catalog objects, owned by all users:

curl -i --header 'Authorization: Bearer <token>' \
  --request GET 'https://<hostname>/api/20210901/catalog?manageContent=true&search=*'

This example returns a list of all workbooks, owned by all users:

curl -i --header 'Authorization: Bearer <token>' \
  --request GET 'https://<hostname>/api/20210901/catalog/workbooks?manageContent=true&search=*'

This example returns a list of all folders, owned by a user who left the company (john.smith@example.com):

curl -i --header 'Authorization: Bearer <token>' \
  --request GET 'https://<hostname>/api/20210901/catalog/folders?manageContent=true&search=owner: john.smith@example.com'
Back to Top