Method: tabledata.insertAll

• HTTP request
• Path parameters
• Request body
  • JSON representation
• Response body
  • JSON representation
• Authorization Scopes
• Try it!

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!