Notifications

43 views

Description

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

Cause

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:

https://instance.service-now.com/incident.do?SCHEMA

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:

https://instance.service-now.com/nav_to.do?uri=sys_security_acl.do?sys_id=ca0e80b047a1010092297dc04dde27ba

Resolution

Using one of below approaches fixes the issue:

  1. Either Grant soap_query role to your integration user (OOB Solution).
  2. Or create a similar ACL (avoid modifying OOB) with a role of your choice and assign that role to your integration user (custom solution).

Additional Information

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

Article Information

Last Updated:2019-09-09 06:18:03
Published:2019-09-09