- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2025 07:09 PM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-26-2025 10:54 PM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-27-2025 02:59 AM
Glad to help.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader