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?
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
There is no option for legend title in many visualization types.