NAiOS IconNAiOS Logo
Contacto
Volver al catálogo

Gigasheet

gigasheet

Gigasheet is a big data automation platform that offers a spreadsheet-like interface for analyzing and managing large datasets, enabling users to automate tasks, integrate with various data sources, and streamline data workflows.

SpreadsheetsAnalyticsWeb del proveedor
Acciones
29
Triggers
0
Autenticación
—
OAuth gestionado
No
Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

Acciones disponibles (29)

Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.

Delete sheet or folder by handleGIGASHEET_DELETE_DELETE_HANDLEAcción

Tool to delete a sheet or folder by handle. Use after obtaining the handle of a sheet or empty folder. Set recursive=True to delete all children of a folder.

Parámetros de entrada

  • handlestringObligatorio

    Unique handle (identifier) of the sheet or folder to delete

  • recursiveboolean

    If true, deletes a folder and all its children. Only applicable when handle refers to a folder

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Client State Current VersionGIGASHEET_GET_CLIENT_STATE_CURRENT_VERSIONAcción

Tool to fetch the current client-state version metadata for a sheet. Use after obtaining a sheet handle to determine the current version identifier for creating views.

Parámetros de entrada

  • handlestringObligatorio

    Unique identifier (handle) of the sheet whose client state version to retrieve.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Connector ConnectionsGIGASHEET_GET_CONNECTORS_CONNECTIONSAcción

Tool to list connector connections. Use after setting a valid Gigasheet API token.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Dataset by HandleGIGASHEET_GET_DATASET_HANDLEAcción

Tool to get dataset metadata. Use after you have obtained the dataset handle.

Parámetros de entrada

  • handlestringObligatorio

    Unique identifier (handle) of the dataset to retrieve.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Dataset ColumnsGIGASHEET_GET_DATASET_HANDLE_COLUMNSAcción

Tool to list all column metadata (IDs, names, types) for a dataset. Use after obtaining a dataset handle.

Parámetros de entrada

  • handlestringObligatorio

    Unique identifier (handle) of the dataset whose columns to list.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Dataset Export Download URLGIGASHEET_GET_DATASET_HANDLE_DOWNLOAD_EXPORTAcción

Tool to retrieve the download URL for an exported dataset. Use after initiating an export and obtaining its handle.

Parámetros de entrada

  • handlestringObligatorio

    Export handle returned by the Create Export endpoint (not the sheet handle).

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Dataset ViewsGIGASHEET_GET_DATASET_HANDLE_VIEWSAcción

Tool to list all views associated with a specific dataset. Use after confirming the dataset handle and its status.

Parámetros de entrada

  • handlestringObligatorio

    Unique identifier (handle) of the dataset for which to list views.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Docs Formulas FunctionsGIGASHEET_GET_DOCS_FORMULAS_FUNCTIONSAcción

Tool to retrieve all supported formula functions. Use after authenticating with a valid API token.

Parámetros de entrada

  • acceptstring

    Accept header value to request response format

  • flattenboolean

    If true, attempt to coerce dictionary responses into a list of functions

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Apply Filter Template On SheetGIGASHEET_GET_FILTER_TEMPLATE_ON_SHEETAcción

Tool to fetch a saved filter template's model for a given sheet. Use when you need the exact filter structure for a specific sheet and template.

Parámetros de entrada

  • handlestringObligatorio

    The unique handle (ID) of the target sheet/dataset.

  • filter_handlestringObligatorio

    The unique handle (ID) of the saved filter template to apply.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Filter TemplatesGIGASHEET_GET_FILTER_TEMPLATESAcción

Tool to retrieve all saved filter templates. Use after authentication is confirmed.

Parámetros de entrada

  • pageinteger

    Page number for paginated results (>= 1).

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Generate New HandleGIGASHEET_GET_GENERATE_HANDLEAcción

Tool to generate a new unique dataset handle. Use when you need a fresh FileUuid before creating or referencing datasets.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get User Autofill InfoGIGASHEET_GET_USERS_AUTOFILLAcción

Tool to fetch autofill info for the authenticated user. Use after setting a valid Gigasheet API token.

Parámetros de entrada

  • filtersobject

    Optional query parameters as key-value pairs to filter which users' autofill details are returned

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Authenticated User InfoGIGASHEET_GET_USER_WHOAMIAcción

Tool to fetch the authenticated user's details. Use after setting a valid Gigasheet API token.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Append Rows to Sheet by NameGIGASHEET_POST_DATASET_HANDLE_APPEND_BY_NAMEAcción

Tool to append rows to a sheet by column names. Use after verifying the sheet handle and column names.

Parámetros de entrada

  • handlestringObligatorio

    Dataset (sheet) handle to append rows to

  • recordsobject[]Obligatorio

    List of row objects to append; each object must use column names as keys

Parámetros de salida

  • dataobjectObligatorio

    Complete JSON response from GigaSheet API

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Initiate Dataset ExportGIGASHEET_POST_DATASET_HANDLE_EXPORTAcción

Tool to initiate an export of a dataset. Use when you need to queue an export job with optional filtering. Use after preparing any filter state. Example: Initiate export for sheet `sheet_abc123` with filters: `{"gridState": {"filterModel": { ... }}}`

Parámetros de entrada

  • handlestringObligatorio

    Dataset (sheet) handle to export

  • gridStateobject

    Optional export state object containing filtering and view state. Should follow Gigasheet Filter Model structure.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Insert Blank Row in DatasetGIGASHEET_POST_DATASET_HANDLE_INSERT_BLANK_ROWAcción

Tool to insert a blank row with null values into a dataset. Use after determining the insertion index.

Parámetros de entrada

  • indexintegerObligatorio

    Zero-based index where the new blank row will be inserted.

  • handlestringObligatorio

    Dataset handle identifying the target dataset.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Rename Columns to UniqueGIGASHEET_POST_DATASET_HANDLE_RENAME_COLUMNS_TO_UNIQUEAcción

Tool to rename all columns in a dataset to unique names. Use when duplicate column names could cause conflicts in downstream processing.

Parámetros de entrada

  • handlestringObligatorio

    Dataset handle for which to ensure unique column names.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Save Current ViewGIGASHEET_POST_DATASET_HANDLE_SAVE_CURRENT_VIEWAcción

Tool to persist the current view in a Gigasheet dataset. Use after configuring a view to ensure the current layout and filters are saved on the server.

Parámetros de entrada

  • handlestringObligatorio

    Unique dataset handle under which to save the current view.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Get Filtered Row IndexGIGASHEET_POST_FILE_HANDLE_FILTER_SHEET_ROW_NRAcción

Tool to retrieve the filtered-set row index for a given unfiltered row number. Use after applying filters when you need the row's position in the filtered view.

Parámetros de entrada

  • handlestringObligatorio

    Unique sheet handle (as returned by other Gigasheet file endpoints)

  • row_nrintegerObligatorio

    Unfiltered row number (1-based) to translate into its index in the filtered view

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Combine Files by NameGIGASHEET_POST_FILES_COMBINE_BY_NAMEAcción

Tool to combine multiple files by a shared column name. Use when you need to merge several Gigasheet files based on a common header.

Parámetros de entrada

  • columnNamestringObligatorio

    Column header name to use as the key when combining files

  • outputNamestring

    Optional name for the newly combined file.

  • fileHandlesstring[]Obligatorio

    List of Gigasheet file handles to combine

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Export Gigasheet to S3GIGASHEET_POST_MAVEN_EXPORTAcción

Tool to export Gigasheet data to AWS S3. Use after generating an export handle and ensuring the S3 bucket has correct permissions.

Parámetros de entrada

  • paramsobjectObligatorio

    Connector-specific parameters for the export.

  • connectorstringObligatorio

    Must be 'S3' to use the AWS S3 export connector.

  • exportHandlestringObligatorio

    Handle of the pre-created Gigasheet export to deliver to S3.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Import from S3GIGASHEET_POST_MAVEN_IMPORTAcción

Tool to import data from AWS S3 into your Gigasheet Library. Use when you need to pull objects or prefixes from an S3 bucket into Gigasheet.

Parámetros de entrada

  • paramsobjectObligatorio

    Container for S3 import-specific settings

  • connectorstringObligatorio

    Connector type, must be 'S3' for S3 import

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Request API AccessGIGASHEET_POST_REQUEST_API_ACCESSAcción

Tool to request access to the Gigasheet API. Use when you need to obtain an API key.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Unroll Delimited ColumnGIGASHEET_POST_UNROLL_DELIMITED_COLUMN_HANDLE_COLUMNAcción

Tool to explode a column containing delimited data into multiple rows. Use after confirming dataset handle and target column.

Parámetros de entrada

  • columnstringObligatorio

    Name or identifier of the column to unroll.

  • handlestringObligatorio

    Unique sheet handle/identifier.

  • splitBystring

    Delimiter to split the column values by (e.g., ',' or '|'). If not provided, the column must already be of an array type.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Upload from URLGIGASHEET_POST_UPLOAD_URLAcción

Tool to upload data to Gigasheet from a specified URL. Use when you have a public or pre-signed link and want to ingest it directly.

Parámetros de entrada

  • urlstringObligatorio

    Public or pre-signed URL of the file to ingest.

  • namestring

    Optional friendly filename to display in Gigasheet.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Set Dataset Client State VersionGIGASHEET_PUT_DATASET_HANDLE_CLIENTSTATE_VERSIONAcción

Tool to set the client state version of a dataset. Use when you need to apply or revert to a saved client state version after data updates.

Parámetros de entrada

  • handlestringObligatorio

    Unique identifier for the dataset handle.

  • versionstringObligatorio

    Client state version identifier to apply.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Update cell by column name and rowGIGASHEET_PUT_DATASET_HANDLE_COL_ROW_BY_NAMEAcción

Tool to update a cell in a dataset by specifying column name and row number. Use after dataset is loaded and column name uniqueness is ensured.

Parámetros de entrada

  • rowintegerObligatorio

    Row number to update (1-based index).

  • valueanyObligatorio

    New value to set for the specified cell. Can be any valid JSON value.

  • columnstringObligatorio

    Name of the column to update. Must uniquely match an existing column.

  • handlestringObligatorio

    Unique identifier (handle) of the dataset.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Share fileGIGASHEET_PUT_FILE_HANDLE_SHARE_FILEAcción

Tool to share a Gigasheet file with specified recipients. Use after creating or updating a sheet to grant email-based access.

Parámetros de entrada

  • emailsstring[]Obligatorio

    List of recipient email addresses to invite

  • handlestringObligatorio

    Unique file handle to share

  • messagestring

    Optional message to include in the share invitation

  • permissionsinteger[]Obligatorio

    List of permission codes to grant (e.g., [0] for view)

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not

Create/Update Filter TemplateGIGASHEET_PUT_FILTER_TEMPLATES_FILTER_HANDLEAcción

Tool to create or update a saved filter template. Use when you need to persist or modify filter criteria by providing a filter handle and the filter model.

Parámetros de entrada

  • sheetstring

    Optional sheet/dataset handle to associate the saved filter template with. Required by API when creating a new saved filter.

  • filterModelobjectObligatorio

    Arbitrary JSON object defining the filter conditions per the Gigasheet Filter Model schema. Must include a top-level `_cnf_` array of OR groups.

  • filter_handlestringObligatorio

    Handle of the saved filter to create or update. Must be lowercase hex + digits + underscores.

Parámetros de salida

  • dataobjectObligatorio

    Data from the action execution

  • errorstring

    Error if any occurred during the execution of the action

  • successfulbooleanObligatorio

    Whether or not the action execution was successful or not