Extracting Oracle Analytics Cloud metadata using Rest API

Question

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.

Mike Durran-Oracle · Answer

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