Google BigQuery

Tabledata: insertAll

Requires authorization

Inserts the supplied rows into the table. Try it now.

Request

HTTP request

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

Parameters

Parameter name Value Description
Path parameters
datasetId string Dataset ID of the destination table.
projectId string Project ID of the destination table.
tableId string Table ID of the destination table.

Authorization

This request requires authorization with at least one of the following scopes (read more about authentication and authorization).

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

Request body

In the request body, supply data with the following structure:

{
  "kind": "bigquery#tableDataInsertAllRequest",
  "rows": [
    {
      "insertId": string,
      "json": {
        (key): (value)
      }
    }
  ]
}
Property name Value Description Notes
kind string The resource type of the response.
rows[] list The rows to insert.
rows[].insertId string [Optional] A unique ID for each row. BigQuery uses this property to detect duplicate insertion requests on a best-effort basis.
rows[].json nested object [Required] A JSON object that contains a row of data. The object's properties and values must match the destination table's schema.
rows[].json.(key) nested object

Response

If successful, this method returns a response body with the following structure:

{
  "kind": "bigquery#tableDataInsertAllResponse",
  "insertErrors": [
    {
      "index": unsigned integer,
      "errors": [
        {
          "reason": string,
          "location": string,
          "debugInfo": string,
          "message": string
        }
      ]
    }
  ]
}
Property name Value Description Notes
kind string The resource type of the response.
insertErrors[] list An array of errors for rows that were not inserted.
insertErrors[].index unsigned integer The index of the row that error applies to.
insertErrors[].errors[] list Error information for the row indicated by the index property.
insertErrors[].errors[].reason string A short error code that summarizes the error.
insertErrors[].errors[].location string Specifies where the error occurred, if present.
insertErrors[].errors[].debugInfo string Debugging information. This property is internal to Google and should not be used.
insertErrors[].errors[].message string A human-readable description of the error.

Try it!

Use the APIs Explorer below to call this method on live data and see the response.

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.