Executes a SQL statement which can be any of - SELECT - SHOW - DESCRIBE

Scopes

You will need authorization for at least one of the following scopes to make a valid call:

  • https://www.googleapis.com/auth/fusiontables
  • https://www.googleapis.com/auth/fusiontables.readonly

If unset, the scope for this method defaults to https://www.googleapis.com/auth/fusiontables.readonly. You can set the scope for this method like this: fusiontables2 --scope <scope> query sql-get ...

Required Scalar Argument

  • <sql> (string)
    • A SQL statement which can be any of
      • SELECT
      • SHOW
      • DESCRIBE

Optional Output Flags

The method's return value a JSON encoded structure, which will be written to standard output by default.

As this method supports media download, you may specify the -p alt=media flag to set the output to be an octet stream of the underlying media. In that case, you will not receive JSON output anymore.

  • -o out
    • out specifies the destination to which to write the server's result to. It will either be a JSON-encoded structure, or the media file you are downloading. The destination may be - to indicate standard output, or a filepath that is to contain the received bytes. If unset, it defaults to standard output.

Optional Method Properties

You may set the following properties to further configure the call. Please note that -p is followed by one or more key-value-pairs, and is called like this -p k1=v1 k2=v2 even though the listing below repeats the -p for completeness.

  • -p hdrs=boolean

    • Whether column names are included (in the first row). Default is true.

  • -p typed=boolean

    • Whether typed values are returned in the (JSON) response: numbers for numeric values and parsed geometries for KML values. Default is true.

Optional General Properties

The following properties can configure any call, and are not specific to this method.

  • -p alt=string

    • Data format for the response.

  • -p fields=string

    • Selector specifying which fields to include in a partial response.

  • -p key=string

    • API key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.

  • -p oauth-token=string

    • OAuth 2.0 token for the current user.

  • -p pretty-print=boolean

    • Returns response with indentations and line breaks.

  • -p quota-user=string

    • An opaque string that represents a user for quota purposes. Must not exceed 40 characters.

  • -p user-ip=string

    • Deprecated. Please use quotaUser instead.