deeptable

package module
v0.0.3-beta Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Mar 18, 2026 License: MIT Imports: 21 Imported by: 0

README

DeepTable Go API Library

Go Reference

The DeepTable Go library provides convenient access to the DeepTable REST API from applications written in Go.

It is generated with Stainless.

Installation

import (
	"github.com/deeptable-com/deeptable-go" // imported as deeptable
)

Or to pin the version:

go get -u 'github.com/deeptable-com/deeptable-go@v0.0.3-beta'

Requirements

This library requires Go 1.22+.

Usage

The full API of this library can be found in api.md.

package main

import (
	"context"
	"fmt"

	"github.com/deeptable-com/deeptable-go"
	"github.com/deeptable-com/deeptable-go/option"
)

func main() {
	client := deeptable.NewClient(
		option.WithAPIKey("My API Key"), // defaults to os.LookupEnv("DEEPTABLE_API_KEY")
	)
	structuredSheetResponse, err := client.StructuredSheets.New(context.TODO(), deeptable.StructuredSheetNewParams{
		FileID: "file_01h45ytscbebyvny4gc8cr8ma2",
	})
	if err != nil {
		panic(err.Error())
	}
	fmt.Printf("%+v\n", structuredSheetResponse.ID)
}

Request fields

The deeptable library uses the omitzero semantics from the Go 1.24+ encoding/json release for request fields.

Required primitive fields (int64, string, etc.) feature the tag `json:"...,required"`. These fields are always serialized, even their zero values.

Optional primitive types are wrapped in a param.Opt[T]. These fields can be set with the provided constructors, deeptable.String(string), deeptable.Int(int64), etc.

Any param.Opt[T], map, slice, struct or string enum uses the tag `json:"...,omitzero"`. Its zero value is considered omitted.

The param.IsOmitted(any) function can confirm the presence of any omitzero field.

p := deeptable.ExampleParams{
	ID:   "id_xxx",                // required property
	Name: deeptable.String("..."), // optional property

	Point: deeptable.Point{
		X: 0,                // required field will serialize as 0
		Y: deeptable.Int(1), // optional field will serialize as 1
		// ... omitted non-required fields will not be serialized
	},

	Origin: deeptable.Origin{}, // the zero value of [Origin] is considered omitted
}

To send null instead of a param.Opt[T], use param.Null[T](). To send null instead of a struct T, use param.NullStruct[T]().

p.Name = param.Null[string]()       // 'null' instead of string
p.Point = param.NullStruct[Point]() // 'null' instead of struct

param.IsNull(p.Name)  // true
param.IsNull(p.Point) // true

Request structs contain a .SetExtraFields(map[string]any) method which can send non-conforming fields in the request body. Extra fields overwrite any struct fields with a matching key. For security reasons, only use SetExtraFields with trusted data.

To send a custom value instead of a struct, use param.Override[T](value).

// In cases where the API specifies a given type,
// but you want to send something else, use [SetExtraFields]:
p.SetExtraFields(map[string]any{
	"x": 0.01, // send "x" as a float instead of int
})

// Send a number instead of an object
custom := param.Override[deeptable.FooParams](12)
Request unions

Unions are represented as a struct with fields prefixed by "Of" for each of its variants, only one field can be non-zero. The non-zero field will be serialized.

Sub-properties of the union can be accessed via methods on the union struct. These methods return a mutable pointer to the underlying data, if present.

// Only one field can be non-zero, use param.IsOmitted() to check if a field is set
type AnimalUnionParam struct {
	OfCat *Cat `json:",omitzero,inline`
	OfDog *Dog `json:",omitzero,inline`
}

animal := AnimalUnionParam{
	OfCat: &Cat{
		Name: "Whiskers",
		Owner: PersonParam{
			Address: AddressParam{Street: "3333 Coyote Hill Rd", Zip: 0},
		},
	},
}

// Mutating a field
if address := animal.GetOwner().GetAddress(); address != nil {
	address.ZipCode = 94304
}
Response objects

All fields in response structs are ordinary value types (not pointers or wrappers). Response structs also include a special JSON field containing metadata about each property.

type Animal struct {
	Name   string `json:"name,nullable"`
	Owners int    `json:"owners"`
	Age    int    `json:"age"`
	JSON   struct {
		Name        respjson.Field
		Owner       respjson.Field
		Age         respjson.Field
		ExtraFields map[string]respjson.Field
	} `json:"-"`
}

To handle optional data, use the .Valid() method on the JSON field. .Valid() returns true if a field is not null, not present, or couldn't be marshaled.

If .Valid() is false, the corresponding field will simply be its zero value.

raw := `{"owners": 1, "name": null}`

var res Animal
json.Unmarshal([]byte(raw), &res)

// Accessing regular fields

res.Owners // 1
res.Name   // ""
res.Age    // 0

// Optional field checks

res.JSON.Owners.Valid() // true
res.JSON.Name.Valid()   // false
res.JSON.Age.Valid()    // false

// Raw JSON values

res.JSON.Owners.Raw()                  // "1"
res.JSON.Name.Raw() == "null"          // true
res.JSON.Name.Raw() == respjson.Null   // true
res.JSON.Age.Raw() == ""               // true
res.JSON.Age.Raw() == respjson.Omitted // true

These .JSON structs also include an ExtraFields map containing any properties in the json response that were not specified in the struct. This can be useful for API features not yet present in the SDK.

body := res.JSON.ExtraFields["my_unexpected_field"].Raw()
Response Unions

In responses, unions are represented by a flattened struct containing all possible fields from each of the object variants. To convert it to a variant use the .AsFooVariant() method or the .AsAny() method if present.

If a response value union contains primitive values, primitive fields will be alongside the properties but prefixed with Of and feature the tag json:"...,inline".

type AnimalUnion struct {
	// From variants [Dog], [Cat]
	Owner Person `json:"owner"`
	// From variant [Dog]
	DogBreed string `json:"dog_breed"`
	// From variant [Cat]
	CatBreed string `json:"cat_breed"`
	// ...

	JSON struct {
		Owner respjson.Field
		// ...
	} `json:"-"`
}

// If animal variant
if animal.Owner.Address.ZipCode == "" {
	panic("missing zip code")
}

// Switch on the variant
switch variant := animal.AsAny().(type) {
case Dog:
case Cat:
default:
	panic("unexpected type")
}
RequestOptions

This library uses the functional options pattern. Functions defined in the option package return a RequestOption, which is a closure that mutates a RequestConfig. These options can be supplied to the client or at individual requests. For example:

client := deeptable.NewClient(
	// Adds a header to every request made by the client
	option.WithHeader("X-Some-Header", "custom_header_info"),
)

client.StructuredSheets.New(context.TODO(), ...,
	// Override the header
	option.WithHeader("X-Some-Header", "some_other_custom_header_info"),
	// Add an undocumented field to the request body, using sjson syntax
	option.WithJSONSet("some.json.path", map[string]string{"my": "object"}),
)

The request option option.WithDebugLog(nil) may be helpful while debugging.

See the full list of request options.

Pagination

This library provides some conveniences for working with paginated list endpoints.

You can use .ListAutoPaging() methods to iterate through items across all pages:

iter := client.Files.ListAutoPaging(context.TODO(), deeptable.FileListParams{})
// Automatically fetches more pages as needed.
for iter.Next() {
	file := iter.Current()
	fmt.Printf("%+v\n", file)
}
if err := iter.Err(); err != nil {
	panic(err.Error())
}

Or you can use simple .List() methods to fetch a single page and receive a standard response object with additional helper methods like .GetNextPage(), e.g.:

page, err := client.Files.List(context.TODO(), deeptable.FileListParams{})
for page != nil {
	for _, file := range page.Data {
		fmt.Printf("%+v\n", file)
	}
	page, err = page.GetNextPage()
}
if err != nil {
	panic(err.Error())
}
Errors

When the API returns a non-success status code, we return an error with type *deeptable.Error. This contains the StatusCode, *http.Request, and *http.Response values of the request, as well as the JSON of the error body (much like other response objects in the SDK).

To handle errors, we recommend that you use the errors.As pattern:

_, err := client.StructuredSheets.New(context.TODO(), deeptable.StructuredSheetNewParams{
	FileID: "file_01h45ytscbebyvny4gc8cr8ma2",
})
if err != nil {
	var apierr *deeptable.Error
	if errors.As(err, &apierr) {
		println(string(apierr.DumpRequest(true)))  // Prints the serialized HTTP request
		println(string(apierr.DumpResponse(true))) // Prints the serialized HTTP response
	}
	panic(err.Error()) // GET "/v1/structured-sheets": 400 Bad Request { ... }
}

When other errors occur, they are returned unwrapped; for example, if HTTP transport fails, you might receive *url.Error wrapping *net.OpError.

Timeouts

Requests do not time out by default; use context to configure a timeout for a request lifecycle.

Note that if a request is retried, the context timeout does not start over. To set a per-retry timeout, use option.WithRequestTimeout().

// This sets the timeout for the request, including all the retries.
ctx, cancel := context.WithTimeout(context.Background(), 5*time.Minute)
defer cancel()
client.StructuredSheets.New(
	ctx,
	deeptable.StructuredSheetNewParams{
		FileID: "file_01h45ytscbebyvny4gc8cr8ma2",
	},
	// This sets the per-retry timeout
	option.WithRequestTimeout(20*time.Second),
)
File uploads

Request parameters that correspond to file uploads in multipart requests are typed as io.Reader. The contents of the io.Reader will by default be sent as a multipart form part with the file name of "anonymous_file" and content-type of "application/octet-stream".

The file name and content-type can be customized by implementing Name() string or ContentType() string on the run-time type of io.Reader. Note that os.File implements Name() string, so a file returned by os.Open will be sent with the file name on disk.

We also provide a helper deeptable.NewFile(reader io.Reader, filename string, contentType string) which can be used to wrap any io.Reader with the appropriate file name and content type.

// A file from the file system
file, err := os.Open("/path/to/file")
deeptable.FileUploadParams{
	File: file,
}

// A file from a string
deeptable.FileUploadParams{
	File: strings.NewReader("my file contents"),
}

// With a custom filename and contentType
deeptable.FileUploadParams{
	File: deeptable.NewFile(strings.NewReader(`{"hello": "foo"}`), "file.go", "application/json"),
}
Retries

Certain errors will be automatically retried 2 times by default, with a short exponential backoff. We retry by default all connection errors, 408 Request Timeout, 409 Conflict, 429 Rate Limit, and >=500 Internal errors.

You can use the WithMaxRetries option to configure or disable this:

// Configure the default for all requests:
client := deeptable.NewClient(
	option.WithMaxRetries(0), // default is 2
)

// Override per-request:
client.StructuredSheets.New(
	context.TODO(),
	deeptable.StructuredSheetNewParams{
		FileID: "file_01h45ytscbebyvny4gc8cr8ma2",
	},
	option.WithMaxRetries(5),
)
Accessing raw response data (e.g. response headers)

You can access the raw HTTP response data by using the option.WithResponseInto() request option. This is useful when you need to examine response headers, status codes, or other details.

// Create a variable to store the HTTP response
var response *http.Response
structuredSheetResponse, err := client.StructuredSheets.New(
	context.TODO(),
	deeptable.StructuredSheetNewParams{
		FileID: "file_01h45ytscbebyvny4gc8cr8ma2",
	},
	option.WithResponseInto(&response),
)
if err != nil {
	// handle error
}
fmt.Printf("%+v\n", structuredSheetResponse)

fmt.Printf("Status Code: %d\n", response.StatusCode)
fmt.Printf("Headers: %+#v\n", response.Header)
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 use client.Get, client.Post, and other HTTP verbs. RequestOptions on the client, such as retries, will be respected when making these requests.

var (
    // params can be an io.Reader, a []byte, an encoding/json serializable object,
    // or a "…Params" struct defined in this library.
    params map[string]any

    // result can be an []byte, *http.Response, a encoding/json deserializable object,
    // or a model defined in this library.
    result *http.Response
)
err := client.Post(context.Background(), "/unspecified", params, &result)
if err != nil {
    …
}
Undocumented request params

To make requests using undocumented parameters, you may use either the option.WithQuerySet() or the option.WithJSONSet() methods.

params := FooNewParams{
    ID:   "id_xxxx",
    Data: FooNewParamsData{
        FirstName: deeptable.String("John"),
    },
}
client.Foo.New(context.Background(), params, option.WithJSONSet("data.last_name", "Doe"))
Undocumented response properties

To access undocumented response properties, you may either access the raw JSON of the response as a string with result.JSON.RawJSON(), or get the raw JSON of a particular field on the result with result.JSON.Foo.Raw().

Any fields that are not present on the response struct will be saved and can be accessed by result.JSON.ExtraFields() which returns the extra fields as a map[string]Field.

Middleware

We provide option.WithMiddleware which applies the given middleware to requests.

func Logger(req *http.Request, next option.MiddlewareNext) (res *http.Response, err error) {
	// Before the request
	start := time.Now()
	LogReq(req)

	// Forward the request to the next handler
	res, err = next(req)

	// Handle stuff after the request
	end := time.Now()
	LogRes(res, err, start - end)

    return res, err
}

client := deeptable.NewClient(
	option.WithMiddleware(Logger),
)

When multiple middlewares are provided as variadic arguments, the middlewares are applied left to right. If option.WithMiddleware is given multiple times, for example first in the client then the method, the middleware in the client will run first and the middleware given in the method will run next.

You may also replace the default http.Client with option.WithHTTPClient(client). Only one http client is accepted (this overwrites any previous client) and receives requests after any middleware has been applied.

Semantic versioning

This package generally follows SemVer conventions, though certain backwards-incompatible changes may be released as minor versions:

  1. 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.)
  2. 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 with questions, bugs, or suggestions.

Contributing

See the contributing documentation.

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func Bool

func Bool(b bool) param.Opt[bool]

func BoolPtr

func BoolPtr(v bool) *bool

func DefaultClientOptions

func DefaultClientOptions() []option.RequestOption

DefaultClientOptions read from the environment (DEEPTABLE_API_KEY, DEEPTABLE_BASE_URL). This should be used to initialize new clients.

func Float

func Float(f float64) param.Opt[float64]

func FloatPtr

func FloatPtr(v float64) *float64

func Int

func Int(i int64) param.Opt[int64]

func IntPtr

func IntPtr(v int64) *int64

func NewFile

func NewFile(rdr io.Reader, filename string, contentType string) file

func Opt

func Opt[T comparable](v T) param.Opt[T]

func Ptr

func Ptr[T any](v T) *T

func String

func String(s string) param.Opt[string]

func StringPtr

func StringPtr(v string) *string

func Time

func Time(t time.Time) param.Opt[time.Time]

func TimePtr

func TimePtr(v time.Time) *time.Time

Types

type Client

type Client struct {

	// Upload and manage spreadsheet files. Files must be Excel (.xlsx) format.
	Files FileService
	// Convert uploaded spreadsheets into structured data. Creates relational tables
	// from messy spreadsheet data.
	StructuredSheets StructuredSheetService
	// contains filtered or unexported fields
}

Client creates a struct with services and top level methods that help with interacting with the deeptable API. You should not instantiate this client directly, and instead use the NewClient method instead.

func NewClient

func NewClient(opts ...option.RequestOption) (r Client)

NewClient generates a new client with the default option read from the environment (DEEPTABLE_API_KEY, DEEPTABLE_BASE_URL). The option passed in as arguments are applied after these default arguments, and all option will be passed down to the services and requests that this client makes.

func (*Client) Delete

func (r *Client) Delete(ctx context.Context, path string, params any, res any, opts ...option.RequestOption) error

Delete makes a DELETE request with the given URL, params, and optionally deserializes to a response. See [Execute] documentation on the params and response.

func (*Client) Execute

func (r *Client) Execute(ctx context.Context, method string, path string, params any, res any, opts ...option.RequestOption) error

Execute makes a request with the given context, method, URL, request params, response, and request options. This is useful for hitting undocumented endpoints while retaining the base URL, auth, retries, and other options from the client.

If a byte slice or an io.Reader is supplied to params, it will be used as-is for the request body.

The params is by default serialized into the body using encoding/json. If your type implements a MarshalJSON function, it will be used instead to serialize the request. If a URLQuery method is implemented, the returned url.Values will be used as query strings to the url.

If your params struct uses param.Field, you must provide either [MarshalJSON], [URLQuery], and/or [MarshalForm] functions. It is undefined behavior to use a struct uses param.Field without specifying how it is serialized.

Any "…Params" object defined in this library can be used as the request argument. Note that 'path' arguments will not be forwarded into the url.

The response body will be deserialized into the res variable, depending on its type:

  • A pointer to a *http.Response is populated by the raw response.
  • A pointer to a byte array will be populated with the contents of the request body.
  • A pointer to any other type uses this library's default JSON decoding, which respects UnmarshalJSON if it is defined on the type.
  • A nil value will not read the response body.

For even greater flexibility, see option.WithResponseInto and option.WithResponseBodyInto.

func (*Client) Get

func (r *Client) Get(ctx context.Context, path string, params any, res any, opts ...option.RequestOption) error

Get makes a GET request with the given URL, params, and optionally deserializes to a response. See [Execute] documentation on the params and response.

func (*Client) Patch

func (r *Client) Patch(ctx context.Context, path string, params any, res any, opts ...option.RequestOption) error

Patch makes a PATCH request with the given URL, params, and optionally deserializes to a response. See [Execute] documentation on the params and response.

func (*Client) Post

func (r *Client) Post(ctx context.Context, path string, params any, res any, opts ...option.RequestOption) error

Post makes a POST request with the given URL, params, and optionally deserializes to a response. See [Execute] documentation on the params and response.

func (*Client) Put

func (r *Client) Put(ctx context.Context, path string, params any, res any, opts ...option.RequestOption) error

Put makes a PUT request with the given URL, params, and optionally deserializes to a response. See [Execute] documentation on the params and response.

type Error

type Error = apierror.Error

type File

type File struct {
	// The unique identifier for this file.
	ID string `json:"id" api:"required"`
	// The MIME type of the file.
	ContentType string `json:"content_type" api:"required"`
	// The timestamp when the file was uploaded.
	CreatedAt time.Time `json:"created_at" api:"required" format:"date-time"`
	// The original filename of the uploaded file.
	FileName string `json:"file_name" api:"required"`
	// The object type, which is always 'file'.
	Object constant.File `json:"object" api:"required"`
	// The size of the file in bytes.
	Size int64 `json:"size" api:"required"`
	// JSON contains metadata for fields, check presence with [respjson.Field.Valid].
	JSON struct {
		ID          respjson.Field
		ContentType respjson.Field
		CreatedAt   respjson.Field
		FileName    respjson.Field
		Object      respjson.Field
		Size        respjson.Field
		ExtraFields map[string]respjson.Field
		// contains filtered or unexported fields
	} `json:"-"`
}

Response representing an uploaded file.

This is returned from POST (upload), GET (retrieve), and list endpoints.

func (File) RawJSON

func (r File) RawJSON() string

Returns the unmodified JSON received from the API

func (*File) UnmarshalJSON

func (r *File) UnmarshalJSON(data []byte) error

type FileDeleteResponse

type FileDeleteResponse struct {
	// The unique identifier of the deleted file.
	ID string `json:"id" api:"required"`
	// Whether the file was successfully deleted.
	Deleted bool `json:"deleted" api:"required"`
	// The object type, which is always 'file'.
	Object constant.File `json:"object" api:"required"`
	// JSON contains metadata for fields, check presence with [respjson.Field.Valid].
	JSON struct {
		ID          respjson.Field
		Deleted     respjson.Field
		Object      respjson.Field
		ExtraFields map[string]respjson.Field
		// contains filtered or unexported fields
	} `json:"-"`
}

Response from deleting a file.

Following the OpenAI API convention for delete responses.

func (FileDeleteResponse) RawJSON

func (r FileDeleteResponse) RawJSON() string

Returns the unmodified JSON received from the API

func (*FileDeleteResponse) UnmarshalJSON

func (r *FileDeleteResponse) UnmarshalJSON(data []byte) error

type FileListParams

type FileListParams struct {
	// A cursor for pagination. Use the `last_id` from a previous response to fetch the
	// next page.
	After param.Opt[string] `query:"after,omitzero" json:"-"`
	// Maximum number of files to return.
	Limit param.Opt[int64] `query:"limit,omitzero" json:"-"`
	// contains filtered or unexported fields
}

func (FileListParams) URLQuery

func (r FileListParams) URLQuery() (v url.Values, err error)

URLQuery serializes FileListParams's query parameters as `url.Values`.

type FileService

type FileService struct {
	// contains filtered or unexported fields
}

Upload and manage spreadsheet files. Files must be Excel (.xlsx) format.

FileService contains methods and other services that help with interacting with the deeptable API.

Note, unlike clients, this service does not read variables from the environment automatically. You should not instantiate this service directly, and instead use the NewFileService method instead.

func NewFileService

func NewFileService(opts ...option.RequestOption) (r FileService)

NewFileService generates a new service that applies the given options to each request. These options are applied after the parent client's options (if there is one), and before any request-specific options.

func (*FileService) Delete

func (r *FileService) Delete(ctx context.Context, fileID string, opts ...option.RequestOption) (res *FileDeleteResponse, err error)

Delete a file. This cannot be undone.

func (*FileService) Download

func (r *FileService) Download(ctx context.Context, fileID string, opts ...option.RequestOption) (res *http.Response, err error)

Download the original uploaded file content.

func (*FileService) Get

func (r *FileService) Get(ctx context.Context, fileID string, opts ...option.RequestOption) (res *File, err error)

Get metadata for a specific file.

func (*FileService) List

func (r *FileService) List(ctx context.Context, query FileListParams, opts ...option.RequestOption) (res *pagination.CursorIDPage[File], err error)

List all files uploaded by the current user.

func (*FileService) ListAutoPaging

List all files uploaded by the current user.

func (*FileService) Upload

func (r *FileService) Upload(ctx context.Context, body FileUploadParams, opts ...option.RequestOption) (res *File, err error)

Upload an Excel spreadsheet file for later processing.

Supported formats:

- Excel (.xlsx)

Maximum file size: 100 MB

type FileUploadParams

type FileUploadParams struct {
	// The spreadsheet file to upload
	File io.Reader `json:"file,omitzero" api:"required" format:"binary"`
	// contains filtered or unexported fields
}

func (FileUploadParams) MarshalMultipart

func (r FileUploadParams) MarshalMultipart() (data []byte, contentType string, err error)

type StructuredSheetDeleteResponse

type StructuredSheetDeleteResponse struct {
	// The unique identifier of the deleted structured sheet.
	ID string `json:"id" api:"required"`
	// Whether the structured sheet was successfully deleted.
	Deleted bool `json:"deleted" api:"required"`
	// The object type, which is always 'structured_sheet'.
	Object constant.StructuredSheet `json:"object" api:"required"`
	// JSON contains metadata for fields, check presence with [respjson.Field.Valid].
	JSON struct {
		ID          respjson.Field
		Deleted     respjson.Field
		Object      respjson.Field
		ExtraFields map[string]respjson.Field
		// contains filtered or unexported fields
	} `json:"-"`
}

Response from deleting a structured sheet.

Following the OpenAI API convention for delete responses.

func (StructuredSheetDeleteResponse) RawJSON

Returns the unmodified JSON received from the API

func (*StructuredSheetDeleteResponse) UnmarshalJSON

func (r *StructuredSheetDeleteResponse) UnmarshalJSON(data []byte) error

type StructuredSheetDownloadParams

type StructuredSheetDownloadParams struct {
	// The export format to download.
	//
	// Any of "sqlite", "cell_labels".
	Format StructuredSheetDownloadParamsFormat `query:"format,omitzero" json:"-"`
	// contains filtered or unexported fields
}

func (StructuredSheetDownloadParams) URLQuery

func (r StructuredSheetDownloadParams) URLQuery() (v url.Values, err error)

URLQuery serializes StructuredSheetDownloadParams's query parameters as `url.Values`.

type StructuredSheetDownloadParamsFormat

type StructuredSheetDownloadParamsFormat string

The export format to download.

const (
	StructuredSheetDownloadParamsFormatSqlite     StructuredSheetDownloadParamsFormat = "sqlite"
	StructuredSheetDownloadParamsFormatCellLabels StructuredSheetDownloadParamsFormat = "cell_labels"
)

type StructuredSheetListParams

type StructuredSheetListParams struct {
	// A cursor for pagination. Use the `last_id` from a previous response to fetch the
	// next page of results.
	After param.Opt[string] `query:"after,omitzero" json:"-"`
	// Maximum number of results to return per page.
	Limit param.Opt[int64] `query:"limit,omitzero" json:"-"`
	// contains filtered or unexported fields
}

func (StructuredSheetListParams) URLQuery

func (r StructuredSheetListParams) URLQuery() (v url.Values, err error)

URLQuery serializes StructuredSheetListParams's query parameters as `url.Values`.

type StructuredSheetNewParams

type StructuredSheetNewParams struct {
	// The unique identifier of the file to convert.
	FileID string `json:"file_id" api:"required"`
	// List of sheet names to convert. If None, all sheets will be converted.
	SheetNames []string `json:"sheet_names,omitzero"`
	// contains filtered or unexported fields
}

func (StructuredSheetNewParams) MarshalJSON

func (r StructuredSheetNewParams) MarshalJSON() (data []byte, err error)

func (*StructuredSheetNewParams) UnmarshalJSON

func (r *StructuredSheetNewParams) UnmarshalJSON(data []byte) error

type StructuredSheetResponse

type StructuredSheetResponse struct {
	// The unique identifier for this structured sheet conversion.
	ID string `json:"id" api:"required"`
	// The timestamp when the conversion was started.
	CreatedAt time.Time `json:"created_at" api:"required" format:"date-time"`
	// The unique identifier for the source file.
	FileID string `json:"file_id" api:"required"`
	// The object type, which is always 'structured_sheet'.
	Object constant.StructuredSheet `json:"object" api:"required"`
	// The current processing status.
	//
	// Any of "queued", "in_progress", "completed", "failed", "cancelled".
	Status StructuredSheetResponseStatus `json:"status" api:"required"`
	// The timestamp when the conversion was last updated.
	UpdatedAt time.Time `json:"updated_at" api:"required" format:"date-time"`
	// Error information when processing fails.
	LastError StructuredSheetResponseLastError `json:"last_error" api:"nullable"`
	// List of sheet names included in this conversion.
	SheetNames []string `json:"sheet_names"`
	// Number of tables extracted from the workbook. Only present when status is
	// 'completed'.
	TableCount int64 `json:"table_count" api:"nullable"`
	// JSON contains metadata for fields, check presence with [respjson.Field.Valid].
	JSON struct {
		ID          respjson.Field
		CreatedAt   respjson.Field
		FileID      respjson.Field
		Object      respjson.Field
		Status      respjson.Field
		UpdatedAt   respjson.Field
		LastError   respjson.Field
		SheetNames  respjson.Field
		TableCount  respjson.Field
		ExtraFields map[string]respjson.Field
		// contains filtered or unexported fields
	} `json:"-"`
}

Response representing a structured sheet conversion job.

This is returned from POST (create), GET (retrieve), and list endpoints.

func (StructuredSheetResponse) RawJSON

func (r StructuredSheetResponse) RawJSON() string

Returns the unmodified JSON received from the API

func (*StructuredSheetResponse) UnmarshalJSON

func (r *StructuredSheetResponse) UnmarshalJSON(data []byte) error

type StructuredSheetResponseLastError

type StructuredSheetResponseLastError struct {
	// A machine-readable error code.
	Code string `json:"code" api:"required"`
	// A human-readable description of the error.
	Message string `json:"message" api:"required"`
	// JSON contains metadata for fields, check presence with [respjson.Field.Valid].
	JSON struct {
		Code        respjson.Field
		Message     respjson.Field
		ExtraFields map[string]respjson.Field
		// contains filtered or unexported fields
	} `json:"-"`
}

Error information when processing fails.

func (StructuredSheetResponseLastError) RawJSON

Returns the unmodified JSON received from the API

func (*StructuredSheetResponseLastError) UnmarshalJSON

func (r *StructuredSheetResponseLastError) UnmarshalJSON(data []byte) error

type StructuredSheetResponseStatus

type StructuredSheetResponseStatus string

The current processing status.

const (
	StructuredSheetResponseStatusQueued     StructuredSheetResponseStatus = "queued"
	StructuredSheetResponseStatusInProgress StructuredSheetResponseStatus = "in_progress"
	StructuredSheetResponseStatusCompleted  StructuredSheetResponseStatus = "completed"
	StructuredSheetResponseStatusFailed     StructuredSheetResponseStatus = "failed"
	StructuredSheetResponseStatusCancelled  StructuredSheetResponseStatus = "cancelled"
)

type StructuredSheetService

type StructuredSheetService struct {

	// Convert uploaded spreadsheets into structured data. Creates relational tables
	// from messy spreadsheet data.
	Tables StructuredSheetTableService
	// contains filtered or unexported fields
}

Convert uploaded spreadsheets into structured data. Creates relational tables from messy spreadsheet data.

StructuredSheetService contains methods and other services that help with interacting with the deeptable API.

Note, unlike clients, this service does not read variables from the environment automatically. You should not instantiate this service directly, and instead use the NewStructuredSheetService method instead.

func NewStructuredSheetService

func NewStructuredSheetService(opts ...option.RequestOption) (r StructuredSheetService)

NewStructuredSheetService generates a new service that applies the given options to each request. These options are applied after the parent client's options (if there is one), and before any request-specific options.

func (*StructuredSheetService) Cancel

func (r *StructuredSheetService) Cancel(ctx context.Context, structuredSheetID string, opts ...option.RequestOption) (res *StructuredSheetResponse, err error)

Cancel a structured sheet conversion that is in progress. Only jobs with status 'queued' or 'in_progress' can be cancelled.

func (*StructuredSheetService) Delete

func (r *StructuredSheetService) Delete(ctx context.Context, structuredSheetID string, opts ...option.RequestOption) (res *StructuredSheetDeleteResponse, err error)

Delete a structured sheet conversion and its associated exports. This action cannot be undone.

func (*StructuredSheetService) Download

func (r *StructuredSheetService) Download(ctx context.Context, structuredSheetID string, query StructuredSheetDownloadParams, opts ...option.RequestOption) (res *http.Response, err error)

Download the structured data in the specified format. Only available when conversion status is 'completed'.

Available formats:

- `sqlite`: SQLite database containing all extracted tables - `cell_labels`: CSV file with cell-level semantic labels

func (*StructuredSheetService) Get

func (r *StructuredSheetService) Get(ctx context.Context, structuredSheetID string, opts ...option.RequestOption) (res *StructuredSheetResponse, err error)

Get the status and details of a structured sheet conversion.

func (*StructuredSheetService) List

List all structured sheets conversions for the authenticated user. Results are paginated using cursor-based pagination.

func (*StructuredSheetService) ListAutoPaging

List all structured sheets conversions for the authenticated user. Results are paginated using cursor-based pagination.

func (*StructuredSheetService) New

Start converting a spreadsheet workbook into structured data. This initiates an asynchronous conversion process. Poll the returned resource using the `id` to check completion status.

type StructuredSheetTableDownloadParams

type StructuredSheetTableDownloadParams struct {
	// The unique identifier of the structured sheet conversion.
	StructuredSheetID string `path:"structured_sheet_id" api:"required" json:"-"`
	// The format to download the table data in.
	//
	// Any of "parquet", "csv".
	Format StructuredSheetTableDownloadParamsFormat `query:"format,omitzero" api:"required" json:"-"`
	// contains filtered or unexported fields
}

func (StructuredSheetTableDownloadParams) URLQuery

func (r StructuredSheetTableDownloadParams) URLQuery() (v url.Values, err error)

URLQuery serializes StructuredSheetTableDownloadParams's query parameters as `url.Values`.

type StructuredSheetTableDownloadParamsFormat

type StructuredSheetTableDownloadParamsFormat string

The format to download the table data in.

const (
	StructuredSheetTableDownloadParamsFormatParquet StructuredSheetTableDownloadParamsFormat = "parquet"
	StructuredSheetTableDownloadParamsFormatCsv     StructuredSheetTableDownloadParamsFormat = "csv"
)

type StructuredSheetTableGetParams

type StructuredSheetTableGetParams struct {
	// The unique identifier of the structured sheet conversion.
	StructuredSheetID string `path:"structured_sheet_id" api:"required" json:"-"`
	// contains filtered or unexported fields
}

type StructuredSheetTableListParams

type StructuredSheetTableListParams struct {
	// A cursor for pagination. Use the `last_id` from a previous response to fetch the
	// next page of results.
	After param.Opt[string] `query:"after,omitzero" json:"-"`
	// Maximum number of tables to return per page.
	Limit param.Opt[int64] `query:"limit,omitzero" json:"-"`
	// contains filtered or unexported fields
}

func (StructuredSheetTableListParams) URLQuery

func (r StructuredSheetTableListParams) URLQuery() (v url.Values, err error)

URLQuery serializes StructuredSheetTableListParams's query parameters as `url.Values`.

type StructuredSheetTableService

type StructuredSheetTableService struct {
	// contains filtered or unexported fields
}

Convert uploaded spreadsheets into structured data. Creates relational tables from messy spreadsheet data.

StructuredSheetTableService contains methods and other services that help with interacting with the deeptable API.

Note, unlike clients, this service does not read variables from the environment automatically. You should not instantiate this service directly, and instead use the NewStructuredSheetTableService method instead.

func NewStructuredSheetTableService

func NewStructuredSheetTableService(opts ...option.RequestOption) (r StructuredSheetTableService)

NewStructuredSheetTableService generates a new service that applies the given options to each request. These options are applied after the parent client's options (if there is one), and before any request-specific options.

func (*StructuredSheetTableService) Download

Download the table data in the specified format.

Available formats:

- `parquet`: Apache Parquet columnar format (recommended for data analysis) - `csv`: Comma-separated values (compatible with any spreadsheet application)

func (*StructuredSheetTableService) Get

Get details of a specific table extracted from the structured sheet. Only available when conversion status is 'completed'.

func (*StructuredSheetTableService) List

List all tables extracted from the structured sheet. Only available when conversion status is 'completed'.

func (*StructuredSheetTableService) ListAutoPaging

List all tables extracted from the structured sheet. Only available when conversion status is 'completed'.

type TableResponse

type TableResponse struct {
	// The unique identifier for this table.
	ID string `json:"id" api:"required"`
	// The timestamp when this table was created.
	CreatedAt time.Time `json:"created_at" api:"required" format:"date-time"`
	// Composite table name: {normalized_sheet_name}**{table_name}. Uses lowercase
	// snake_case. Aggregation tables end with '**aggregations'. Two special metadata
	// tables exist per structured sheet: '**deeptable_workbook_metadata' (workbook
	// provenance info) and '**deeptable_table_overview' (summary of all tables).
	// Example: 'staffing**head_count' or 'staffing**head_count\_\_aggregations'.
	Name string `json:"name" api:"required"`
	// The object type, which is always 'table'.
	Object constant.Table `json:"object" api:"required"`
	// The original Excel sheet name this table came from.
	SheetName string `json:"sheet_name" api:"required"`
	// The ID of the structured sheet this table belongs to.
	StructuredSheetID string `json:"structured_sheet_id" api:"required"`
	// The type of table (relational, aggregation, tableless, or metadata).
	//
	// Any of "relational", "aggregation", "tableless", "metadata".
	Type TableResponseType `json:"type" api:"required"`
	// JSON contains metadata for fields, check presence with [respjson.Field.Valid].
	JSON struct {
		ID                respjson.Field
		CreatedAt         respjson.Field
		Name              respjson.Field
		Object            respjson.Field
		SheetName         respjson.Field
		StructuredSheetID respjson.Field
		Type              respjson.Field
		ExtraFields       map[string]respjson.Field
		// contains filtered or unexported fields
	} `json:"-"`
}

Response representing a table extracted from a structured sheet.

This is returned from GET (retrieve) and list table endpoints. Table names use a composite format: {normalized_sheet_name}\_\_{table_name}.

func (TableResponse) RawJSON

func (r TableResponse) RawJSON() string

Returns the unmodified JSON received from the API

func (*TableResponse) UnmarshalJSON

func (r *TableResponse) UnmarshalJSON(data []byte) error

type TableResponseType

type TableResponseType string

The type of table (relational, aggregation, tableless, or metadata).

const (
	TableResponseTypeRelational  TableResponseType = "relational"
	TableResponseTypeAggregation TableResponseType = "aggregation"
	TableResponseTypeTableless   TableResponseType = "tableless"
	TableResponseTypeMetadata    TableResponseType = "metadata"
)

Directories

Path Synopsis
encoding/json
Package json implements encoding and decoding of JSON as defined in RFC 7159.
Package json implements encoding and decoding of JSON as defined in RFC 7159.
encoding/json/shims
This package provides shims over Go 1.2{2,3} APIs which are missing from Go 1.22, and used by the Go 1.24 encoding/json package.
This package provides shims over Go 1.2{2,3} APIs which are missing from Go 1.22, and used by the Go 1.24 encoding/json package.
packages
shared

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL