case(sn_customerservice_case) table and form is not visible after consumer field is populated on the form.

Sushma Uday C
Tera Contributor

Hi All,

We are calling table API from external source to Case(sn_customerservice_case), it is working as expected we are able to post text to worknotes field , but when ever we fill the consumer field on the form and calling the same API the it's not working. Tried updating the comments from postman and getting the below error.

 "error": {
        "message": "No Record found",
        "detail": "Record doesn't exist or ACL restricts the record retrieval"
    },
    "status": "failure"
So, ACL should be restricting the access to table after filling consumer field, I have tried checking the ACL on table on field consumer read/write and giving the access to the authentication user, but still couldn't figure out which ACL is exactly restricting the access for table.
 
Could someone suggest how do we filter the ACL that is restricting the access to Case(sn_customerservice_case) table when consumer field is populated 
 
Thanks.
Sushma
find_real_file.png
 
cc: @Ankur Bawiskar 
1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

consumer field is reference to some table

Did you check that API user has read access to that table and write access to that field?

Is it working fine with admin user?

Regards
Ankur

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

View solution in original post

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

consumer field is reference to some table

Did you check that API user has read access to that table and write access to that field?

Is it working fine with admin user?

Regards
Ankur

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

Hi,

Yeah consumer field is reference field of the table  Consumers(csm_consumer).

Yeah I have given API user read access to consumer table and on Case(sn_customerservice_case) form and list of the table is visible if the consumer field is not populated once consumer field is populated that record disappears from list view and not able to see the form view as well for API user.

It is working with admin user.

Thanks,

Sushma

Hi,

if it's working with admin then some access issue only

what do you mean by this -> if the consumer field is not populated once consumer field is populated that record disappears from list view and not able to see the form view as well for API user

Regards
Ankur

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

Thanks, I am able to get the role and grant access to API user. It has a counter role which is stopping the form hence I removed it and it working now.