Need help with appsheet api to edit row(s)

[gaixixon]

I am using below post query to edit rows in my table:

URL: https://api.appsheet.com/api/v2/apps/xxxxxxxxxxxx/tables/COMPANIES/Action?applicationAccessKey=xxxxxxxxxxxxxxxxxxxxxxx

{
	"Action": "Edit",
	"Properties": {
	   "Locale": "en-US",
	   "Location": "47.623098, -122.330184",
	   "Timezone": "Pacific Standard Time"	   
	},
	"Rows": [{"ID": "<<[_THISROW].[PARTNER ID]>>" , "NOTE":"SOME NOTE"}]
}

 Everything work as expected.

The comlumn NOTE in table COMPANIES is updated whenever the bot is fired.

BUT, it only works when column NOTE is blank!!

Question: How can I use appsheet API to find some row, on some condition, and edit its value?

In my case above, I can only find row ID and edit NOTE column when NOTE column is blank!