API Error: Row having key '<key value>' not found

[njordan]

This is more of an FYI than a question. Posting this as a new topic since I only found old threads about this and I think it'll be helpful.

Problem

I was trying to send a web hook to the AppSheet API from a third party system to update rows on a table with security filters and kept getting a "Row having key '<key value>' not found" error. 

I knew security filters were my problem but couldn't figure out a way around it. The advice on the API troubleshooting page wasn't very helpful and messing with the system provided User Settings table was going to require really tedious changes to my security filters and views. The solution appears to be that the email the API action is executed as must explicitly have access to the rows you want to edit, in the table security filter. It wasn't good enough that the given email could access the table indirectly since its role is admin (see step 1 screenshot). Adding the email explicitly is redundant but apparently necessary.

Solution

1. I had to explicitly allow a given email to view all records in the security filter for the table I wanted to edit via API.

2. I then used the RunAsUserEmail property in my API call, referencing the same email from step 1. 

This allowed me to successfully edit, read, and delete rows.