EXTERNAL_HTTP

All functions > SOURCE > EXTERNAL_HTTP

Returns the JSON response from a HTTP call

Signatures

Returns: Parsed JSON response from HTTP API

EXTERNAL_HTTP(source: HTTPSOURCE, [method: VARCHAR], [path: VARCHAR], [headers: ROW], [query_params: ROW], [body: ROW], [timeout: DECIMAL]) → JSON
sql
ParameterTypeRequiredDescription
sourceHTTPSOURCEYesHTTPSOURCE connection from SOURCE_HTTP
methodVARCHARNoOptional HTTP method override
pathVARCHARNoOptional path override or extension
headersROWNoOptional headers override or extension
query_paramsROWNoOptional query parameters override or extension
bodyROWNoOptional request body override
timeoutDECIMALNoOptional timeout override

Notes

  • Makes HTTP API call and returns JSON response
  • All parameters can override SOURCE_HTTP defaults
  • Supports dynamic request parameters per query
  • Returns JSON object for field extraction
  • Common use cases: fraud detection APIs, ML model APIs, enrichment services
  • Handles request retries and error responses
  • Online-only restriction (for real-time serving)
Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19