how to edit an existing record targeting it by two or more parameters (fields) evaluating to true?

Answered

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.

5 replies