Read data from system tables
Gets data from system tables (e.g. sys_choice, sys_journal_field). Many tables are not listed in the get_tables endpoint and are hidden from UI selection. Use the get_table_rows endpoint to query them directly.
SELECT * FROM get_table_rows WITH(TableName='sys_choice', Query='name=incident^element=close_code')
--SELECT * FROM get_table_rows WITH(TableName='sys_journal_field', Query='name=incident^element=close_code')