Retrieve SQL from segment rule

Request

Retrieve a SQL from a segment rule.

Security

TdApikeyAuth

Path

audienceIdinteger, (int64)required

Master Segment id of the segment

Bodyapplication/jsonrequired

Segment parameters to create

formatstring

Value:"sql"

kindinteger

0: batch, 1: realtime, 2: funnel_stage

rulepartial_v5_rule.yaml-v5IonRule-ionRule (object) or (object or null)(partial_v5_rule.yaml-v5IonRule)

One of:

funnel_stageobject

required if creating segment as a rule of funnel_stage

realtimebooleanDeprecated

use kind instead

curl -i -X POST \
  'https://api-cdp.treasuredata.com/audiences/{audienceId}/segments/query' \
  -H 'Authorization: YOUR_API_KEY_HERE' \
  -H 'Content-Type: application/json' \
  -d '{
    "format": "sql",
    "realtime": true,
    "kind": 0,
    "rule": {
      "conditions": [
        {
          "conditions": [
            {
              "exclude": true,
              "id": "string",
              "type": "FunnelStageReference"
            }
          ],
          "description": "string",
          "expr": "string",
          "type": "Or"
        }
      ],
      "expr": "string",
      "limit": {
        "number": 0,
        "orderColumns": [
          {
            "column": "string",
            "order": "ascending",
            "type": "Column"
          }
        ],
        "type": "Count"
      },
      "type": "Or"
    },
    "funnel_stage": {
      "funnel_id": 0,
      "stage_id": 0
    }
  }'

Responses

batch segment query

Bodyapplication/json

One of:

batch segment query; return if the requestBody is realtime=false

sqlstring

Response

{
  "sql": "string"
}