Method: tabledata.insertAll

Streams data into BigQuery one record at a time without needing to run a load job.

HTTP request

POST https://bigquery.googleapis.com/bigquery/v2/projects/{projectId}/datasets/{datasetId}/tables/{tableId}/insertAll

The URL uses gRPC Transcoding syntax.

Path parameters

Parameters
projectId

string
datasetId

string
tableId

string

Request body

The request body contains data with the following structure:

JSON representation 
{
  "kind": [
    string
  ],
  "skipInvalidRows": boolean,
  "ignoreUnknownValues": boolean,
  "templateSuffix": string,
  "rows": [
    {
      "insertId": string,
      "json": {
        object
      }
    }
  ]
}
Fields
kind[]

string
skipInvalidRows

boolean
ignoreUnknownValues

boolean
templateSuffix

string
rows[]

object
rows[].insertId

string
rows[].json

object (Struct format)

Response body

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

JSON representation 
{
  "kind": string,
  "insertErrors": [
    {
      "index": number,
      "errors": [
        {
          object (ErrorProto)
        }
      ]
    }
  ]
}
Fields
kind

string
insertErrors[]

object
insertErrors[].index

number (uint32 format)
insertErrors[].errors[]

object (ErrorProto)

Authorization Scopes

Requires one of the following OAuth scopes:

  • https://www.googleapis.com/auth/bigquery
  • https://www.googleapis.com/auth/cloud-platform
  • https://www.googleapis.com/auth/bigquery.insertdata

For more information, see the Authentication Overview.

Try it!