Trigger: Detect & correct App Service web apps with FTP deployment enabled

select
  concat(
    app.id,
    ' [',
    app.subscription_id,
    '/',
    app.resource_group,
    ']'
  ) as title,
  app.id as id,
  app.name,
  app.resource_group,
  app.subscription_id,
  app._ctx ->> 'connection_name' as conn
from
  azure_app_service_web_app as app
where
  configuration -> 'properties' ->> 'ftpsState' = 'AllAllowed';