Unable to query the HR profile data using scripted rest API on sn_hr_core_profile table? I am always getting response as record not found.

Hi All,

I am trying to update the sn_hr_core_profile table with additional fields for each record using a scripted rest API.

This API will have the logic to get the sys_id of the employee record using the Employee number and then use that sys_id to populate additional fields for each record received from the input JSON(this can have multiple nodes).

I am always stuck at the first point itself where the GlideRecord for sn_hr_core_profile table is not giving me any output for the gr.query().

I am sure this has something to do with the ACL's but I am not able to identify the real cause. Any pointers here are much appreciated.