ServiceNow sys_choice Table Not Syncing Due to Query ACL Restrictions

Issue

The ServiceNow connector connects successfully, but the sys_choice table doesn't sync any rows.

Environment

Connector: ServiceNow

Resolution

To resolve this issue, review and update the ServiceNow Query ACLs for the sys_choice table to grant the service account permission to query and filter it.

Cause

This issue occurs when a ServiceNow Query ACL prevents the service account from querying or filtering the sys_choice table.

The connector uses filtered API requests with sysparm_query for incremental extraction and ordering. In this case:

• The service account had permission to read sys_choice.
• The service account didn't have permission to query or filter it in the same way.