How to add sys_choice table on Rest API Explorer ?

Bhaskar · ‎01-31-2023

Here i am not able to see the sys_choice table Please help me out .

Thanks

Tony Chatfield1 · ‎01-31-2023

Hi, looking at an OOB PDI (tokyo)
sys_choice 'Allow access to this table via web services' == true

so you should be able to access the table via webservcies.

If you are trying to access via REST API Explorer (your screenshot) then I believe that the table is hidden by the same sys property that hides system tables for reporting.
https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportO...

So adding sys_choice to 'glide.ui.permitted_tables'
/nav_to.do?uri=sys_properties.do?sys_id=c3dee8670a0a0aa70064b48de5ad973e
should allow it to be selected in REST API Explorer

but will also allow the table to be selecatble (by other users) in other places like reporting, so probably best not to enable this in a Production environment.

View solution in original post

Tony Chatfield1 · ‎01-31-2023

Hi, looking at an OOB PDI (tokyo)
sys_choice 'Allow access to this table via web services' == true

so you should be able to access the table via webservcies.

If you are trying to access via REST API Explorer (your screenshot) then I believe that the table is hidden by the same sys property that hides system tables for reporting.
https://docs.servicenow.com/en-US/bundle/tokyo-now-intelligence/page/use/reporting/concept/c_ReportO...

So adding sys_choice to 'glide.ui.permitted_tables'
/nav_to.do?uri=sys_properties.do?sys_id=c3dee8670a0a0aa70064b48de5ad973e
should allow it to be selected in REST API Explorer

but will also allow the table to be selecatble (by other users) in other places like reporting, so probably best not to enable this in a Production environment.