Query: api_management_for_network_public_ip

with public_ip_api_management as (
  select
    id,
    title,
    name,
    provisioning_state,
    subscription_id,
    resource_group,
    region,
    jsonb_array_elements_text(public_ip_addresses) as pid
  from
    azure_api_management
  where
    subscription_id = split_part($1, '/', 3)
)
select
  lower(a.id) as api_management_id
from
  public_ip_api_management as a
  left join azure_public_ip as p on (a.pid)::inet = p.ip_address
where
  lower(p.id) = $1;