Scripted REST API to fetch all the records with same sys_id and make there isActive flag false

[Pooja Malve1]

I have created a custom attachment table. For a particular record, I am inserting 6 images. I want a scripted rest API to make isActive flag false of all the 6 images of respective record

[Pooja Malve1]

column name as - record number -> which is the reference field from the record table

- image -> stores the actual attachment

-isActive -> whose value is true by default

[Hitoshi Ozawa]

Provided a sample scripted rest api code above.