My company is looking at allowing an external vendor to use our instance to Service Now using the Table API with COZYROC SSIS. However we clearly want to limit what data can be accessed via these REST commands for security concerns. What kind of ACL rules are needed so that the vendor can only have access to specific resources?
When using COZYROC SSIS+ to create a REST connection and testing it with our Service-now instance, we get the error message below.
TITLE: COZYROC SSIS+
------------------------------
{"error":{"detail":"2 records constrained due to ACL restrictions","message":"User Not Authorized"},"status":"failure"} (CozyRoc.SSISPlus.2012)