API Reference

Execute Custom SQL Query

post
https://api.triplewhale.com/api/v2/orcabase/api/sql

Run custom SQL queries for structured data retrieval. The response returns the query results in a JSON format. To use this endpoint with a Triple Whale API key instead of an Orcabase token, see here.

Body Params
string
required

The SQL query string to execute. To test your query in the in-app SQL Builder interface, use @start_date and @end_date instead of @startDate and @endDate.

string

The currency for data aggregation (e.g., USD, EUR). Defaults to the currency provided during user account registration.

period
object
required

The date range for the query period.

Responses

Updated 11 months ago

Language
Credentials
Bearer
JWT
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 11 months ago