Not able to get field "internal_type" from sys_dictionary" table via Postman.

Neelavathi M
Tera Contributor

Hi , 

from postman making a GET API call ,trying to get internal_type field from sys_dictionary table but we couldnt get it from response and 
as internal_type is referrencing to sys_glide_object table - we tried creating ACL on sys_glide_object table tried giving admin role but still no luck , can anyone please suggest on this.

 

 

Thanks in Advance.

3 REPLIES 3

Naveen20
ServiceNow Employee
The internal_type field gets removed from the response when the calling user lacks read ACLs on the referenced metadata tables — granting admin on sys_glide_object alone isn't enough, and with OAuth Client Credentials the request doesn't run as your interactive admin user.

Two things to check:

1. ACLs — A community-verified fix is to grant read on all four:
- sys_dictionary (record) and sys_dictionary. (field)
- sys_db_object (record) and sys_db_object. (field)
 
Add sys_glide_object / sys_glide_object. read ACLs as well, since internal_type references that table.

2. OAuth Client Credentials user — Client Credentials grant runs as the user configured on the OAuth Application Registry (or the OAuth Entity Profile), not the admin who created it. Open the OAuth app record, confirm the associated user, and verify that user actually has admin (or the role on the ACLs above). Impersonate that user and open sys_dictionary.list — if the Type column is blank there too, it's an ACL/role gap on that user, not a REST issue.

Ankur Bawiskar
Tera Patron

@Neelavathi M 

but why you want that?

Exposing sys_dictionary with OOTB Table API is not good practice and not recommended.

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

Tanushree Maiti
Giga Patron

Hi @Neelavathi M 

 

For Get API, You need Read ACL on sys_glide_object table. using api , you are not at all recommended to created dictionary.

 

 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin: