1## API Reference
2 
3### GraphQL Analytics API
4 
5**Endpoint**: `https://api.cloudflare.com/client/v4/graphql`
6 
7**Query Workers Metrics**:
8```graphql
9query {
10  viewer {
11    accounts(filter: { accountTag: $accountId }) {
12      workersInvocationsAdaptive(
13        limit: 100
14        filter: {
15          datetime_geq: "2025-01-01T00:00:00Z"
16          datetime_leq: "2025-01-31T23:59:59Z"
17          scriptName: "my-worker"
18        }
19      ) {
20        sum {
21          requests
22          errors
23          subrequests
24        }
25        quantiles {
26          cpuTimeP50
27          cpuTimeP99
28          wallTimeP50
29          wallTimeP99
30        }
31      }
32    }
33  }
34}
35```
36 
37### Analytics Engine SQL API
38 
39**Endpoint**: `https://api.cloudflare.com/client/v4/accounts/{account_id}/analytics_engine/sql`
40 
41**Authentication**: `Authorization: Bearer <API_TOKEN>` (Account Analytics Read permission)
42 
43**Common Queries**:
44 
45```sql
46-- List all datasets
47SHOW TABLES;
48 
49-- Time-series aggregation (5-minute buckets)
50SELECT
51  intDiv(toUInt32(timestamp), 300) * 300 AS time_bucket,
52  blob1 AS endpoint,
53  SUM(_sample_interval) AS total_requests,
54  AVG(double1) AS avg_response_time_ms
55FROM api_metrics
56WHERE timestamp >= NOW() - INTERVAL '24' HOUR
57GROUP BY time_bucket, endpoint
58ORDER BY time_bucket DESC;
59 
60-- Top customers by usage
61SELECT
62  index1 AS customer_id,
63  SUM(_sample_interval * double1) AS total_api_calls,
64  AVG(double2) AS avg_response_time_ms
65FROM api_usage
66WHERE timestamp >= NOW() - INTERVAL '7' DAY
67GROUP BY customer_id
68ORDER BY total_api_calls DESC
69LIMIT 100;
70 
71-- Error rate analysis
72SELECT
73  blob1 AS error_type,
74  COUNT(*) AS occurrences,
75  MAX(timestamp) AS last_seen
76FROM error_tracking
77WHERE timestamp >= NOW() - INTERVAL '1' HOUR
78GROUP BY error_type
79ORDER BY occurrences DESC;
80```
81 
82### Console Logging API
83 
84**Methods**:
85```typescript
86// Standard methods (all appear in Workers Logs)
87console.log('info message');
88console.info('info message');
89console.warn('warning message');
90console.error('error message');
91console.debug('debug message');
92 
93// Structured logging (recommended)
94console.log({
95  level: 'info',
96  user_id: '123',
97  action: 'checkout',
98  amount: 99.99,
99  currency: 'USD'
100});
101```
102 
103**Log Levels**: All console methods produce logs; use structured fields for filtering:
104```typescript
105console.log({ 
106  level: 'error', 
107  message: 'Payment failed', 
108  error_code: 'CARD_DECLINED' 
109});
110```
111 
112### Analytics Engine Binding Types
113 
114```typescript
115interface AnalyticsEngineDataset {
116  writeDataPoint(event: AnalyticsEngineDataPoint): void;
117}
118 
119interface AnalyticsEngineDataPoint {
120  // Indexed strings (use for filtering/grouping)
121  indexes?: string[];
122  
123  // Non-indexed strings (metadata, IDs, URLs)
124  blobs?: string[];
125  
126  // Numeric values (counts, durations, amounts)
127  doubles?: number[];
128}
129```
130 
131**Field Limits**:
132- Max 20 indexes
133- Max 20 blobs
134- Max 20 doubles
135- Max 25 `writeDataPoint` calls per request
136 
137### Tail Consumer Event Type
138 
139```typescript
140interface TraceItem {
141  event: TraceEvent;
142  logs: TraceLog[];
143  exceptions: TraceException[];
144  scriptName?: string;
145}
146 
147interface TraceEvent {
148  outcome: 'ok' | 'exception' | 'exceededCpu' | 'exceededMemory' | 'unknown';
149  cpuTime: number; // microseconds
150  wallTime: number; // microseconds
151}
152 
153interface TraceLog {
154  timestamp: number;
155  level: 'log' | 'info' | 'debug' | 'warn' | 'error';
156  message: any; // string or structured object
157}
158 
159interface TraceException {
160  name: string;
161  message: string;
162  timestamp: number;
163}
164```