Why can I not see the syslog_transaction table in the Rest API Explorer

[Ash21]

Hello,

I am working on building a script to capture transaction logs and using REST API explorer. I am not sure why but the TABLE API does not show syslog tables in pull down menu.

[Lukasz Bojara]

Hi Ash,

The reason why syslog_transaction is not available in REST API Explorer is the same why it is not available in Reports. System tables are restricted from reporting by default. This is because when someone will query those table with no filters, condition and search patterns it can cause big performance issues.

If you want to be able to use the syslog_transaction table in REST API Explorer you need to add it to the system property glide.ui.permitted_tables, after you will do this, the Transaction Log Entry table will be available to be chosen in the drop-down list. 

System property:

REST API Explorer after adding table to the system property:

Just remember that this will also enable the Transaction Log Entry table in the Reports module.

If my answer helped you in any way, please then mark it as helpful. If this solved your case please mark it as correct answer. Thank You.

Best regards,
Łukasz

[Disha16]

Hi Lukasz Bojara

I am also facing the same issue for sys_user_visibility table(to access/modify the visibility domains of a user). But I could not find glide.ui.permitted_tables in system properties. 

I am not able to create a new one as this table is not mentioned in the drop down menu of 'Name' field. I have admin access to the instance. 

Thank you.

[Ash21]

Thank You. That was helpful