name: Cancel double opt-in activities if contact opted out
description: >
  Daily cron to cascade email unsubscribes to double opt-in statuses.
  Finds all contacts who opted out within the last 24 hours and disables their double opt-in activities to ensure compliance.
command:
  echo '{"join":[["Contact AS target","INNER","ActivityContact",["target.record_type_id","=",3]]],"where":[["target.Communication.opt_in","=",0],["activity_type_id:name","=","Double Opt-In"],["status_id:name","=","Completed"]],"chain":{"name_me_0":["Activity","update",{"where":[["id","=","$id"]],"values":{"status_id:name":"Cancelled"}}]},"checkPermissions":0}' | cv api4 Activity.get --in=json
schedule: "30 20 * * *"
timeout: 5