Request with Positional Parameters

concept

Example 1. A statement containing numbered positional parameters

This request contains the parameters described in the following table.

Parameter Name Value

Parameter Name	Value
`statement`	SELECT airline FROM `travel-sample`.inventory.route WHERE sourceairport = $1 AND distance > $2;
`$1`	"LAX"
`$2`	13000

statement

SELECT airline FROM `travel-sample`.inventory.route WHERE sourceairport = $1 AND distance > $2;

$1

"LAX"

$2

13000

Request

curl -v http://localhost:8093/query/service \
     -d 'statement=SELECT airline FROM `travel-sample`.inventory.route
                   WHERE sourceairport = $1 AND distance > $2
       & args=["LAX", 13000]' \
     -u Administrator:password

Response

{
  "requestID": "6e242629-ebf5-4a58-8db4-62d94974519f",
  "signature": {
    "airline": "json"
  },
  "results": [
    {
      "airline": "B6"
    },
    {
      "airline": "EK"
    },
    {
      "airline": "SV"
    }
  ],
  "status": "success",
  "metrics": {
    "elapsedTime": "86.962678ms",
    "executionTime": "84.35715ms",
    "resultCount": 3,
    "resultSize": 48,
    "serviceLoad": 12
  }
}

Example 2. A statement containing unnumbered positional parameters

Positional parameters can also be specified in a statement using the question mark (?), so the following statement is an alternative way to specify the same query.

Request

curl -v http://localhost:8093/query/service \
     -d 'statement=SELECT airline FROM `travel-sample`.inventory.route
                   WHERE sourceairport = ? AND distance > ?
       & args=["LAX", 13000]' \
     -u Administrator:password

Response

{
  "requestID": "6d77dc41-3cab-4e00-9c54-f60fcc2e0fab",
  "signature": {
    "airline": "json"
  },
  "results": [
    {
      "airline": "B6"
    },
    {
      "airline": "EK"
    },
    {
      "airline": "SV"
    }
  ],
  "status": "success",
  "metrics": {
    "elapsedTime": "86.226474ms",
    "executionTime": "86.072996ms",
    "resultCount": 3,
    "resultSize": 48,
    "serviceLoad": 12
  }
}