Tuesday, June 11, 2024

Oracle ADB Pre-Authenticated URL - Part II

One of the recent enhancements to the Autonomous database is to show the JSON payload returned from accessing the PAR URL in Table format.
 
This table format display supports scrolling, filtering , sorting and colouring of cell values.
 
The PAR URL when accessed, shows the default JSON payload data format.
 
https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/eRNq_pPDTvnMYUp81rnCBWe05Nfxp9X2WmvYqyNi-D7jAc0dKJv1Fy7-rxsg0Z3nbUQaSpBgvCM/data
 


 
 
To return data in table format, we need to append ?view=table query parameter to the PAR URL.
 
When appended ?VIEW=TABLE
to the PAR URL, the sample response was like below.
 
 

We can even filter the data based on this field.
 

We also have the option to colour the columns, by default none of the columns are coloured, we can select the column that needs to be coloured based on column values. To specify which columns, need to be coloured, provide the column names as COLORED_COLUMN_NAMES query parameter.
 
Here is the PAR URL when added the colored_column_names query parameter, will return the sample response like below.
 
https://dataaccess.adb.us-ashburn-1.oraclecloudapps.com/adb/p/eRNq_pPDTvnMYUp81rnCBWe05Nfxp9X2WmvYqyNi-D7jAc0dKJv1Fy7-rxsg0Z3nbUQaSpBgvCM/data?view=table&colored_column_names=ENAME,HIREDATE
 
 


No comments:

Post a Comment