Remove sys_domain field and/or logic from Table API results
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2024 12:30 PM
Hi,
We are not using domain seperation, so the sys_domain field is not relevant to us at all. However, it keeps showing up in our table api results for CSM tables. Normally i wouldnt mind and just ignore it, but i noticed whenever the sys_domain field is included in results my query takes around 15-20 seconds longer, so i would really like to get this out of the default set of fields (which seem to be sys_id, sys_domain, sys_class_name) the table API returns. Anyone any direction where to do this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-27-2024 06:32 PM
you can have field level READ ACL on sys_domain field on your table and use advanced script and set answer=false;
It won't show anywhere in the instance and also not in the API result
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-29-2024 07:55 PM
Hope you are doing good.
Did my reply answer your question?
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2025 12:57 PM
Yeah i already turned off any acl relateds to the field, but it keeps showing up as a default field unfortunately.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-03-2025 09:47 PM
you should create a new field level READ ACL and hide it using advanced script with answer=false;
Seems you mentioned the other way i.e. you turned off any acl related to that field
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader