grid-api 1.10.0
The official Python library for the GRID API
License: Apache-2.0
Requires Python: >=3.9

# GRID Spreadsheet API library

<!-- prettier-ignore -->
[![PyPI version](https://img.shields.io/pypi/v/grid_api.svg?label=pypi%20(stable))](https://pypi.org/project/grid_api/)

This library provides convenient access to the Grid REST API from any Python 3.9+
application. The library includes type definitions for all request params and response fields,
and offers both synchronous and asynchronous clients powered by [httpx](https://github.com/encode/httpx).

It is generated with [Stainless](https://www.stainless.com/).

## Documentation

The REST API documentation can be found on [docs.grid.is](https://docs.grid.is/). The full API of this library can be found in [api.md](https://github.com/GRID-is/api-sdk-py/tree/main/api.md). Your spreadsheets dashboard can be found at [app.grid.is](https://app.grid.is/).

## Installation

```sh
# install from PyPI
pip install grid_api
```

## Usage

The full API of this library can be found in [api.md](https://github.com/GRID-is/api-sdk-py/tree/main/api.md).

```python
import os
from grid_api import Grid

client = Grid(
    api_key=os.environ.get("GRID_API_TOKEN"),  # This is the default and can be omitted
)

response = client.workbooks.query(
    id="YOUR_WORKBOOK_ID",
    read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
)
print(response.read)
```

While you can provide a `api_key` keyword argument,
we recommend using [python-dotenv](https://pypi.org/project/python-dotenv/)
to add `GRID_API_TOKEN="My API Key"` to your `.env` file
so that your API Key is not stored in source control.

## Async usage

Simply import `AsyncGrid` instead of `Grid` and use `await` with each API call:

```python
import os
import asyncio
from grid_api import AsyncGrid

client = AsyncGrid(
    api_key=os.environ.get("GRID_API_TOKEN"),  # This is the default and can be omitted
)


async def main() -> None:
    response = await client.workbooks.query(
        id="YOUR_WORKBOOK_ID",
        read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
    )
    print(response.read)


asyncio.run(main())
```

Functionality between the synchronous and asynchronous clients is otherwise identical.

### With aiohttp

By default, the async client uses `httpx` for HTTP requests. However, for improved concurrency performance you may also use `aiohttp` as the HTTP backend.

You can enable this by installing `aiohttp`:

```sh
# install from PyPI
pip install grid_api[aiohttp]
```

Then you can enable it by instantiating the client with `http_client=DefaultAioHttpClient()`:

```python
import os
import asyncio
from grid_api import DefaultAioHttpClient
from grid_api import AsyncGrid


async def main() -> None:
    async with AsyncGrid(
        api_key=os.environ.get("GRID_API_TOKEN"),  # This is the default and can be omitted
        http_client=DefaultAioHttpClient(),
    ) as client:
        response = await client.workbooks.query(
            id="YOUR_WORKBOOK_ID",
            read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
        )
        print(response.read)


asyncio.run(main())
```

## Using types

Nested request parameters are [TypedDicts](https://docs.python.org/3/library/typing.html#typing.TypedDict). Responses are [Pydantic models](https://docs.pydantic.dev) which also provide helper methods for things like:

- Serializing back into JSON, `model.to_json()`
- Converting to a dictionary, `model.to_dict()`

Typed requests and responses provide autocomplete and documentation within your editor. If you would like to see type errors in VS Code to help catch bugs earlier, set `python.analysis.typeCheckingMode` to `basic`.

## Pagination

List methods in the Grid API are paginated.

This library provides auto-paginating iterators with each list response, so you do not have to request successive pages manually:

```python
from grid_api import Grid

client = Grid()

all_workbooks = []
# Automatically fetches more pages as needed.
for workbook in client.workbooks.list(
    limit=50,
):
    # Do something with workbook here
    all_workbooks.append(workbook)
print(all_workbooks)
```

Or, asynchronously:

```python
import asyncio
from grid_api import AsyncGrid

client = AsyncGrid()


async def main() -> None:
    all_workbooks = []
    # Iterate through items across all pages, issuing requests as needed.
    async for workbook in client.workbooks.list(
        limit=50,
    ):
        all_workbooks.append(workbook)
    print(all_workbooks)


asyncio.run(main())
```

Alternatively, you can use the `.has_next_page()`, `.next_page_info()`, or `.get_next_page()` methods for more granular control working with pages:

```python
first_page = await client.workbooks.list(
    limit=50,
)
if first_page.has_next_page():
    print(f"will fetch next page using these details: {first_page.next_page_info()}")
    next_page = await first_page.get_next_page()
    print(f"number of items we just fetched: {len(next_page.items)}")

# Remove `await` for non-async usage.
```

Or just work directly with the returned data:

```python
first_page = await client.workbooks.list(
    limit=50,
)

print(f"next page cursor: {first_page.pagination.next_cursor}")  # => "next page cursor: ..."
for workbook in first_page.items:
    print(workbook.id)

# Remove `await` for non-async usage.
```

## Nested params

Nested parameters are dictionaries, typed using `TypedDict`, for example:

```python
from grid_api import Grid

client = Grid()

response = client.workbooks.query(
    id="id",
    read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
    goal_seek={
        "control_cell": "Sheet1!A1:B2",
        "target_cell": "Sheet1!A1:B2",
        "target_value": 0,
    },
)
print(response.goal_seek)
```

## File uploads

Request parameters that correspond to file uploads can be passed as `bytes`, or a [`PathLike`](https://docs.python.org/3/library/os.html#os.PathLike) instance or a tuple of `(filename, contents, media type)`.

```python
from pathlib import Path
from grid_api import Grid

client = Grid()

client.workbooks.upload(
    file=Path("/path/to/file"),
)
```

The async client uses the exact same interface. If you pass a [`PathLike`](https://docs.python.org/3/library/os.html#os.PathLike) instance, the file contents will be read asynchronously automatically.

## Handling errors

When the library is unable to connect to the API (for example, due to network connection problems or a timeout), a subclass of `grid_api.APIConnectionError` is raised.

When the API returns a non-success status code (that is, 4xx or 5xx
response), a subclass of `grid_api.APIStatusError` is raised, containing `status_code` and `response` properties.

All errors inherit from `grid_api.APIError`.

```python
import grid_api
from grid_api import Grid

client = Grid()

try:
    client.workbooks.query(
        id="YOUR_WORKBOOK_ID",
        read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
    )
except grid_api.APIConnectionError as e:
    print("The server could not be reached")
    print(e.__cause__)  # an underlying Exception, likely raised within httpx.
except grid_api.RateLimitError as e:
    print("A 429 status code was received; we should back off a bit.")
except grid_api.APIStatusError as e:
    print("Another non-200-range status code was received")
    print(e.status_code)
    print(e.response)
```

Error codes are as follows:

| Status Code | Error Type                 |
| ----------- | -------------------------- |
| 400         | `BadRequestError`          |
| 401         | `AuthenticationError`      |
| 403         | `PermissionDeniedError`    |
| 404         | `NotFoundError`            |
| 422         | `UnprocessableEntityError` |
| 429         | `RateLimitError`           |
| >=500       | `InternalServerError`      |
| N/A         | `APIConnectionError`       |

### Retries

Certain errors are automatically retried 2 times by default, with a short exponential backoff.
Connection errors (for example, due to a network connectivity problem), 408 Request Timeout, 409 Conflict,
429 Rate Limit, and >=500 Internal errors are all retried by default.

You can use the `max_retries` option to configure or disable retry settings:

```python
from grid_api import Grid

# Configure the default for all requests:
client = Grid(
    # default is 2
    max_retries=0,
)

# Or, configure per-request:
client.with_options(max_retries=5).workbooks.query(
    id="YOUR_WORKBOOK_ID",
    read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
)
```

### Timeouts

By default requests time out after 1 minute. You can configure this with a `timeout` option,
which accepts a float or an [`httpx.Timeout`](https://www.python-httpx.org/advanced/timeouts/#fine-tuning-the-configuration) object:

```python
from grid_api import Grid

# Configure the default for all requests:
client = Grid(
    # 20 seconds (default is 1 minute)
    timeout=20.0,
)

# More granular control:
client = Grid(
    timeout=httpx.Timeout(60.0, read=5.0, write=10.0, connect=2.0),
)

# Override per-request:
client.with_options(timeout=5.0).workbooks.query(
    id="YOUR_WORKBOOK_ID",
    read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
)
```

On timeout, an `APITimeoutError` is thrown.

Note that requests that time out are [retried twice by default](https://github.com/GRID-is/api-sdk-py/tree/main/#retries).

## Default Headers

We automatically send the `X-Client-Name` header set to `api-sdk`.

If you need to, you can override it by setting default headers per-request or on the client object.

```python
from grid_api import Grid

client = Grid(
    default_headers={"X-Client-Name": "My-Custom-Value"},
)
```

## Advanced

### Logging

We use the standard library [`logging`](https://docs.python.org/3/library/logging.html) module.

You can enable logging by setting the environment variable `GRID_LOG` to `info`.

```shell
$ export GRID_LOG=info
```

Or to `debug` for more verbose logging.

### How to tell whether `None` means `null` or missing

In an API response, a field may be explicitly `null`, or missing entirely; in either case, its value is `None` in this library. You can differentiate the two cases with `.model_fields_set`:

```py
if response.my_field is None:
  if 'my_field' not in response.model_fields_set:
    print('Got json like {}, without a "my_field" key present at all.')
  else:
    print('Got json like {"my_field": null}.')
```

### Accessing raw response data (e.g. headers)

The "raw" Response object can be accessed by prefixing `.with_raw_response.` to any HTTP method call, e.g.,

```py
from grid_api import Grid

client = Grid()
response = client.workbooks.with_raw_response.query(
    id="YOUR_WORKBOOK_ID",
    read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
)
print(response.headers.get('X-My-Header'))

workbook = response.parse()  # get the object that `workbooks.query()` would have returned
print(workbook.read)
```

These methods return an [`APIResponse`](https://github.com/GRID-is/api-sdk-py/tree/main/src/grid_api/_response.py) object.

The async client returns an [`AsyncAPIResponse`](https://github.com/GRID-is/api-sdk-py/tree/main/src/grid_api/_response.py) with the same structure, the only difference being `await`able methods for reading the response content.

#### `.with_streaming_response`

The above interface eagerly reads the full response body when you make the request, which may not always be what you want.

To stream the response body, use `.with_streaming_response` instead, which requires a context manager and only reads the response body once you call `.read()`, `.text()`, `.json()`, `.iter_bytes()`, `.iter_text()`, `.iter_lines()` or `.parse()`. In the async client, these are async methods.

```python
with client.workbooks.with_streaming_response.query(
    id="YOUR_WORKBOOK_ID",
    read=["A1", "Sheet2!B3", "=SUM(A1:A4)"],
) as response:
    print(response.headers.get("X-My-Header"))

    for line in response.iter_lines():
        print(line)
```

The context manager is required so that the response will reliably be closed.

### Making custom/undocumented requests

This library is typed for convenient access to the documented API.

If you need to access undocumented endpoints, params, or response properties, the library can still be used.

#### Undocumented endpoints

To make requests to undocumented endpoints, you can make requests using `client.get`, `client.post`, and other
http verbs. Options on the client will be respected (such as retries) when making this request.

```py
import httpx

response = client.post(
    "/foo",
    cast_to=httpx.Response,
    body={"my_param": True},
)

print(response.headers.get("x-foo"))
```

#### Undocumented request params

If you want to explicitly send an extra param, you can do so with the `extra_query`, `extra_body`, and `extra_headers` request
options.

#### Undocumented response properties

To access undocumented response properties, you can access the extra fields like `response.unknown_prop`. You
can also get all the extra fields on the Pydantic model as a dict with
[`response.model_extra`](https://docs.pydantic.dev/latest/api/base_model/#pydantic.BaseModel.model_extra).

### Configuring the HTTP client

You can directly override the [httpx client](https://www.python-httpx.org/api/#client) to customize it for your use case, including:

- Support for [proxies](https://www.python-httpx.org/advanced/proxies/)
- Custom [transports](https://www.python-httpx.org/advanced/transports/)
- Additional [advanced](https://www.python-httpx.org/advanced/clients/) functionality

```python
import httpx
from grid_api import Grid, DefaultHttpxClient

client = Grid(
    # Or use the `GRID_BASE_URL` env var
    base_url="http://my.test.server.example.com:8083",
    http_client=DefaultHttpxClient(
        proxy="http://my.test.proxy.example.com",
        transport=httpx.HTTPTransport(local_address="0.0.0.0"),
    ),
)
```

You can also customize the client on a per-request basis by using `with_options()`:

```python
client.with_options(http_client=DefaultHttpxClient(...))
```

### Managing HTTP resources

By default the library closes underlying HTTP connections whenever the client is [garbage collected](https://docs.python.org/3/reference/datamodel.html#object.__del__). You can manually close the client using the `.close()` method if desired, or with a context manager that closes when exiting.

```py
from grid_api import Grid

with Grid() as client:
  # make requests here
  ...

# HTTP client is now closed
```

## Versioning

This package generally follows [SemVer](https://semver.org/spec/v2.0.0.html) conventions, though certain backwards-incompatible changes may be released as minor versions:

1. Changes that only affect static types, without breaking runtime behavior.
2. Changes to library internals which are technically public but not intended or documented for external use. _(Please open a GitHub issue to let us know if you are relying on such internals.)_
3. Changes that we do not expect to impact the vast majority of users in practice.

We take backwards-compatibility seriously and work hard to ensure you can rely on a smooth upgrade experience.

We are keen for your feedback; please open an [issue](https://www.github.com/GRID-is/api-sdk-py/issues) with questions, bugs, or suggestions.

### Determining the installed version

If you've upgraded to the latest version but aren't seeing any new features you were expecting then your python environment is likely still using an older version.

You can determine the version that is being used at runtime with:

```py
import grid_api
print(grid_api.__version__)
```

## Requirements

Python 3.9 or higher.

## Contributing

See [the contributing documentation](https://github.com/GRID-is/api-sdk-py/tree/main/./CONTRIBUTING.md).