Extract JSON fields from column of csv for filtering in OAC

Question

Use Case:

I have a CSV file with multiple columns, and one of the columns is called metadata, which contains JSON values like:
{'Architecture': 'x64', 'Vendor': 'One', 'DB Version': None}.

I want to extract each of these values like Architecture, Vendor, and DB Version so I can use them individually as filters or in visualizations.

Is this possible in Oracle Analytics Cloud?

GayathriAnand-Oracle · Answer

You could explore using REST API connector(whose output will be parsed based on json) to create dataset in OAC and then use this dataset  to define workbook and filter. Tagging PM @Avinash Krishnaram-Oracle to see if this suggestion is valid for the use case described.