JUMP TODeveloper DashboardGetting StartedAuthenticationGigasheet APIEnd to End ExampleFilter Model Detail GuideBilling and CostsaiSheet AssistantpostFormula BuilderpostSheet Assistant HistorygetDelete Sheet Assistant historydeletebillingList available Gigasheet plans.getdataChange column data typepostChanges a string's case based on payloadpostClean company names.postCombine columnspostCreate a connection.postGet parameters for connection.getGet the relevant parameters to start an import.postGet connection.getGet headers.postRetrieve connection infos.getRun/schedule a connection.postGet parameters for export.getGet parameters for export given parameters provided by user.postPause a connector.patchReset a connector.deleteGet connected data source information.getCreate a source.postGet parameters for source.getGet parameters for source.postDelete a source.deleteCheck if source is available.postGet source status.getUnpause a connector.patchInitiate export of a dataset to the given connector.postGet sheet statistics.postReturn the number of unique tuple values in a list of columnspostGet column statistics.postDescribe datasetgetAppend to a sheetpostAppend to a sheetpostAppend to a sheet data from another sheetpostGenerate tipspostGet ColumnsgetSet currency for a columnputUnset currency for a columndeleteAdd conditional labels to rowspostDelete rowsdeleteDelete rows matching a filterdeleteDelete rows not matching a filterdeleteGenerate descriptionpostFind and replace values in a sheetpostRun a given formula.postEdit a formulapostFormula sample result.postValidate a given formula.postAdd iterator columnpostGet operation statusgetEnsure column names are uniquepostRename columns by namepostSelect columns by namepostUpdates a single cellputUpsert rows in a sheetputDescribe dataset versiongetInsert a new row with empty/null valuespostDelete sheetdeleteGet all supported formulas functions.getExplode the column with JSONpostExtract domain from URL column.postGet AggregationspostDelete columndeleteDelete multiple columns in a sheetpostCross file lookuppostSplit columnpostTrims a column's whitespacepostfileSet aggregate filter modelputSet aggregationsputSet column stateputGet current sheet state versiongetSet filter modelputSet group columnsputReset client stateputSet sort modelputSet visible columnsputSet client stateputSet client state by version idputReturns a file's notegetSets a file's note with a max length of 20K charactersputSave current viewpostList viewsgetCreate viewpostGet viewgetDelete viewdeleteUpdate viewpatchList files at the root directory.getList files in the given location.getCopy filepostMove file or folderputCreate an empty filepostCombine filespostCombine files by namepostValidate combine by name requestpostValidate combine requestpostCreate folderpostCreate folderpostGet a new handlegetDatasets at rootgetList exportsgetGet home page datasetsgetGet pathgetSearch LibrarypostShared files at rootgetShared files in dirgetShared with my team files at rootgetShared with my team files in dirgetDatasets in dirgetRename filepostGet enrichment creditsgetGet space usedgetshareDelete a live share of a filedeleteCreates a Share ID for a sheetpostCreates a string of CSV data representing a sheetgetLists all liveshares and their details for a provided sheetgetGet organization permissions for filegetSet organization permissions on fileputShare a file with othersputOpt out of file that has been shared with youputRequest access to a filepostcommentsGet all commentsgetAdd a column commentpostDelete a column commentdeleteGet column commentsgetAdd a cell commentpostDelete a cell commentdeleteGet cell commentsgetfilterGet filtered group countpostGet filtered data row countpostFilter datapostFilter datapostRow number in filter resultpostList saved filtersgetDescribe saved filtergetCreate or update saved filterputDelete saved filterdeleteGet filter model for saved filtergetexportDownload exportgetCreate exportpostCreates and saves a file state so as to also contain any applied filters and groupingpostauditGet action historygetTotal activity countpostSearch action historypostdata_cleanupDelete duplicated rowsdeleteCount duplicated rowspostenrichEnrich datapostEnrich datapostEnrich datapostEnrich data on demandpostLists active enrichment tasks.getApply generic HTTP enrichmentpostPreview of a generic HTTP enrichmentpostGet status for the given generic enrichment task.getCancels the given enrichment task.postuserRequest access to Gigasheet APIpostSends an email invitation to the list of email addresses to join the GigasheetpostRevoke API keysdeleteIssue API keypostDetailed user infogetUser metadatagetUpdates user metadatapatchRemove user from the teampostUser infogetGet users autofill infogetuploadRaw data direct uploadpostUpload from URLpostPowered by Set sort modelput https://api.gigasheet.com/client-state/{handle}/sort-modelSet sort model in the client state of a sheet.