USERROLE not evaluated in security filter when using API add action

[Vincent_Martin]

Hello,

I use the Appsheet API to add a record with a ref field, the security filter of the ref table uses USERROLE()="Admin" test. I'm Admin first because I'm owner of the App, and also because I am in the an Admin Authentification Group. I also verified this by showing the USERROLE() in a virtual column. So all the records from that table show be available for me.

But, the Add api call throws an error because the ref value of a record of that table is not found ("title":"Not Found","status":404,"detail":"REST API invoke request failed: Row having key 'F4F4E068-3199-41A4-ADF1-894360B5DCAB' not found.")

If in the security filter, I add "UserEmail() = [MyEmail]", it works (Exactly this : OR(UserEmail() = [MyEmail], USERROLE()="Admin").

So it seems to me that in this context, the USERROLE() function is not evaluated...

Thanks for any advices