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.
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.
No way that I am aware of. though you can look at the developer tab for the dataset
Thanks @Wayne Van Sluys. This may help.
@Marcelo G. Proaño , What "table below?"
…they would like to export what would be the table below.
Yes. Like in a csv or excel file.
@Marcelo G. Proaño ,
It seems that you intended to include a table in your previous post, but I do not see any table.
No, sorry for the confusion. Just look at the screen shot I provided and think of exporting that as a csv or excel file. That's basically it.
That sounds awesome @Gianni Ceresa. I think it's above my wheelhouse though and I'd have to learn how to make those REST API calls. I'm going to put it down as a goal. Thank you.
+ @Bret Grinslade - Oracle Analytics-Oracle - Might be great in the Idea Lab.
Yes this is a good idea lab request.
@Marcelo G. Proaño what is your use case for this metadata?
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?