Database Reference
In-Depth Information
}
],
"code": 404,
"message": "Not Found: Table 317752944021:ch06.foo"
}
}
Because the request attempts to insert data into a table that does not exist,
the request fails and returns a 404 response code indicating that the table
does not exist. Now try to insert the same request using the table you
created.
$ curl -H "$(python auth.py)" \
-H 'Content-Type: application/json' \
--data-binary '{
"rows": [
{"json": {"count": "4.2", "ts": 123, "label":
"bad"}}
]
}' $(table_url streamed)/insertAll
{
"kind": "bigquery#tableDataInsertAllResponse",
"insertErrors": [
{
"index": 0,
"errors": [
{
"reason": "invalid",
"message": "Could not convert value to integer."
}
]
}
]
}
When individual records fail the
insertErrors
list is returned, which
contains an entry for every failed record. Each entry contains an
index
(0-based) field that links the errors in the entry to a corresponding record
in the request. Invalid records generate errors similar to the data errors
