When implementing ServiceNow and SnapLogic integration, you arrange an integration user (in ServiceNow). Making a pipeline validation check from SnapLogic side fails with below error when integration user lacking admin role and works fine with admin role:
Failure: An error occurred while fetching the schema of the incident table (status code: 403), Reason: Forbidden
When making a validation check, SnapLogic try to read the schema of respective table (incident in this case) using SchemaProcessor processor. The way it read the table schema is using below URL:
And, there is an OOB ACL (below link) defined for SchemaProcessor processor allowing only users with soap_query role to access it. Since, Admin overrides is enabled on this ACL there granting admin role to integration user works:
Using one of below approaches fixes the issue:
- Either Grant soap_query role to your integration user (OOB Solution).
- Or create a similar ACL (avoid modifying OOB) with a role of your choice and assign that role to your integration user (custom solution).
schema,incident schema,table schema,snaplogic,SnapLogic,integration,Failure: An error occurred while fetching the schema of the incident table (status code: 403), Reason: Forbidden