I want to update a field for a record based on if two column values are true for that record.
E.g - Update/Edit 'Complete_Status' to a '1'
IF 'Customer_ID' == '12345' AND && 'Subscriber_Status' == 'Subscribed'
How would I got about doing this? I see that the Edit a record endpoint has the limit stating 'If you choose a field_value that maps to multiple records, then the first one found will be used.'
I have already figured out how to do this on the GET side of things by using Query All but how do I do it on the POST/edit side?
Thank you.