The CreatorCon Call for Content is officially open! Get started here.

Remove sys_domain field and/or logic from Table API results

RikV
Tera Expert

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? 

6 REPLIES 6

Ankur Bawiskar
Tera Patron
Tera Patron

@RikV 

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.

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

@RikV 

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.

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

Yeah i already turned off any acl relateds to the field, but it keeps showing up as a default field unfortunately. 

@RikV 

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.

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