Extracting Oracle Analytics Cloud metadata using Rest API — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Extracting Oracle Analytics Cloud metadata using Rest API

Received Response
15
Views
1
Comments
User_CAIGP
User_CAIGP Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

Hi there,

My organization has collected OBIEE metadata in DB tables and we plan to migrate to OAC. We aim to continue using the same data structure as much as we can in order to fit into the existing DB tables and accepting OAC metadata. For the solution, I've been exploring the OAC Rest API calls based on the Oracle documentation.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/index.html

I noticed all the API responses has the same data attributes, and the data structure is a lot different from OBIEE metadata extract. For example, I can't see the location (object path) attribute from any API calls while OBIEE provides the object path such as '/shared folder/dashboard - A/report123'. To find out all the parent & child related name path, I checked this call with '…/api/20210901/catalog/folders?search=*', but this didn't return all existing sub folder levels. For each object, if we should extract the complete location path, how can we utilize the available APIs? Can you please share any efficient ways, or anything I'm missing?

Thanks,

K.

Answers

  • Mike Durran-Oracle
    Mike Durran-Oracle Mod

    Hi,

    /api/20210901/catalog/workbooks?search=*

    will give you all workbooks (paged response, see the response header for details). In the response, you will see an id and parentId which are base64 encoded paths to the object and the parent of the object (folder).

    This endpoint, /api/20210901/catalog will give you a list of all the types if you need to recursively go through them to get the metadata you require.

    Mike