Unable to Retrieve company.parent.sys_id via REST API

u-tec
Tera Contributor

Hi,
I'm using the Table API to retrieve hardware asset data from the alm_hardware table. Most fields are returned correctly, but I can't seem to get the value of the company.parent.sys_id field. Other fields like company.sys_id return as expected.

  • I’ve specified the field in sysparm_fields like so:
    ...&sysparm_fields=company.sys_id,company.parent.sys_id

Is there a known limitation or workaround for accessing this nested reference field?
Any guidance would be appreciated!

Thanks in advance.

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@u-tec 

the API user you are using might not have read access to the parent field on core_company table

Hence the issue.

Check this and see which ACL is blocking and give correct role to your API user.

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

View solution in original post

5 REPLIES 5

@u-tec 

Glad to help.

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