Get the list of ACLs created in the system along with the role mapping

khushnan · ‎07-14-2017

For my application , I want to get the list of ACLs created in my system , along with the role mapping.

How can I get this information? Is there any API available to fetch the list of ACLs ?

Thanks in advance

Harsh Vardhan · ‎07-15-2017

it should be because you have given security_admin role already. i am not sure why this table is not accessible in the REST API Explorer. but you can try with "security_acl_detail" . it will also give you the same result.

by the way check with thread below.

I'm trying to create an access role record using serivcenow REST API. The response code is 201 but t...

just try with soap web services . pass the below wsdl url in end point.

https://<your instance>.service-now.com/sys_security_acl.do?wsdl

by using get or getRecords check if you are able to get the records or not.

From the left navigation pane, select System Definition > Tables and Columns. Click tables

Name has all the tables/views. You can check with schema map also there.

View solution in original post

Harsh Vardhan · ‎07-14-2017

Hi Khushboo,

if you want to get the details you can do the report on security_acl_detail to get the data with roles name. then export it in excel file.

Harsh Vardhan · ‎07-14-2017

type in application navigator security_acl_detail.list

khushnan · ‎07-14-2017

Hello Harsh Vardhan,

Thanks for the response.

Is there a way to do it programmatically? Using APIs like Table API or something, which can fetch me the list?

Harsh Vardhan · ‎07-14-2017

Yes that's possible . but the result will either retrieved as JSON or XML format.

you can try it in REST API Explorer.

Or you can select "sys_security_acl_role" table as antin.s has already mentioned in above reply. both will give you the result.