Home Guides Reference Samples Support Policies Vendors

Method: tables.getInfo

Retrieves columns names and types associated with a specified table

HTTP request

GET https://fullcirclequery.googleapis.com/v2/tables:info

The URL uses gRPC Transcoding syntax.

Query parameters

Parameters
customerId

string (int64 format)

Ads Data Hub ID of customer for which accounts should be listed

fullTableName

string

Fully qualified name of the specified table

adsDataCustomerId

string (int64 format)

Optional. Linked Ads Data Hub customer ID used to determine whether a particular Ads Data Hub table is accessible.

matchDataCustomerId

string (int64 format)

Optional. Linked Ads Data Hub customer ID used to determine whether match data is accessible. Ignored if the requested table is not an Ads Data Hub _match table.

Request body

The request body must be empty.

Response body

If successful, the response body contains data with the following structure:

Response to GetTableRequest. Contains all columns associated with a table

JSON representation 
{
  "columns": [
    {
      object (StructType)
    }
  ]
}
Fields
columns[]

object (StructType)

Columns from a specified table

Authorization Scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/adsdatahub
  • https://www.googleapis.com/auth/xapi.zoo

StructType

A key-value pair that defines one field in the struct.

JSON representation 
{
  "name": string,
  "type": {
    object (ParameterType)
  }
}
Fields
name

string

Name of this struct field.

type

object (ParameterType)

ParameterType of the struct field.

ParameterType

Information about a specific argument.

JSON representation 
{
  "type": string,
  "defaultValue": string,
  "description": string,
  "arrayType": {
    object (ParameterType)
  },
  "structTypes": [
    {
      object (StructType)
    }
  ]
}
Fields
type

string

Type of parameter, e.g. 'STRING' or 'ARRAY'. See https://cloud.google.com/bigquery/docs/reference/standard-sql/data-types.

defaultValue

string

Default parameter value, if any.

description

string

Short description of the parameter type.

arrayType

object (ParameterType)

The type of the array's elements. Only used if type is 'ARRAY'.

structTypes[]

object (StructType)

The types of the struct fields, in order. Only used if type is 'STRUCT'.