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
)
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;