Oracle Analytics Cloud and Server

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

Is there a way to export the metadata for a dataset?

Accepted answer
74
Views
10
Comments

Been asked if the metadata for a data set can be export from DV. Using the screen shot below they would like to export what would be the table below.

image.png

Best Answer

  • If you see something in DV, there is a Rest API that returned that data.

    It could be documented (datasets have a number of documented APIs), or it's one of the "private" APIs that DV uses that still don't have a documentation. But 100% of DV works on Rest API calls, therefore you can get all that via a Rest API call.

    Look at your browser developer tool screen, in the network you will see all the Fetch/XHR calls for each screen of DV. If you look at that when you open that page for a dataset, you will easily get the service to call, the parameters to pass and everything you need to execute that kind of call yourself with the language or tool of your choice.

    If you want to have "fun", you can even try to create a connection using the Rest API source, and call that service to get the output into a dataset and then you can do whatever you want with it.

Answers