Talking to the BigQuery API - Google BigQuery Analytics - page 166

Table 5.9 TableData Resource Fields

Field Type Description

List of fields in the row.

f object

array

Value of the field. Although the field can be of any type,
it will always be rendered as a string .

f.v any

Nested field representation.

f.v.f object
array

TableData.list()

The TableData.list() method reads data from a table. The
TableData.list() method supports both index-based pagination and
page-token-based pagination. Although token-based pagination is usually
preferred, sometimes the actual index of the row is important.
When using index-based pagination, if the table is changing while you page
through it, you always see the latest data, which may not be what you expect.
Token-based pagination always gives you a stable view of the table, so if you
ask for the next page, you get the next page of results as of the time you
started paging through the table. Because this may require extra storage to
keep around old versions of the table, page tokens have a limited lifetime—if
you try to use them after seven days you'll get an error.
In order to see how TableData.list() works on nested data, let's first
load some nested data via the bq tool.

$
bq load \
-- source_format=NEWLINE_DELIMITED_JSON \
scratch.nested nested.json \
nested.schema.json

Here is a curl command that reads data from a small nested table. You can
see all of the funny f s and v s:

$ curl -H "$(python auth.py)" \
- H "Content-Type: application/json" \