Tag: Cloudflare

  • GraphQL Query For Cloudflare SQL query

    GraphQL Query For Cloudflare SQL query

    0 Any Cloudflare and GraphQL Expert here?? Struggling with converting below SQL query into GraphQL, any help would be appreciated. SELECT m.month_end_date as month_end_date –Account Details , c.account_pubname as account_name , m.user_id as account_id , z.zone_name as zone_name , z.zone_plan as zone_rate_plan –Requests , sum(m.cached_request_count) as monthly_cached_requests , sum(m.request_count) – sum(m.cached_request_count) as monthly_uncached_requests , sum(m.request_count) as monthly_requests –Data Transfer , sum(m.transferred_bytes)/1e9 as monthly_data_transfer_gb FROM `cloudflare-bi.ida.requests_monthly` m JOIN `cloudflare-bi.ida_base.customer` c ON m.user_id = c.account_id JOIN…

  • Filtering by query string and request path in GraphQL via CloudFlare API

    Filtering by query string and request path in GraphQL via CloudFlare API

    0 is it possible to filter the data by path and query string in the GraphQL for CloudFlare request? I want to achieve from the CloudFlare API. What I came up with looks like below: { viewer { zones(filter: { zoneTag: "MY_ZONE_ID" }) { httpRequestsAdaptiveGroups( limit: 10000 filter: { datetime_geq: "2023-10-16T00:00:00Z" datetime_lt: "2023-10-17T00:00:00Z" clientRequestHTTPHost: "my.domain.com"…