JUMP TODeveloper DashboardGetting StartedAuthenticationGigasheet APIEnd to End ExampleFilter Model Detail GuideBilling and CostsaiSheet Assistant - FacetpostSheet AssistantpostSheet 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.getRun/schedule a connection.postRetrieve connection info.getList available import or export connectors.getGet parameters for connector.getReset a connector.deleteCreate a source.postGet parameters for source.getDelete a source.deleteRun a 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 ColumnsgetAdd 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 formulapostValidate 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 valuespostGet 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 columnsputSet sort modelputSet visible columnsputReturns a file's notegetSets a file's note with a max length of 20K charactersputSave current viewpostList files at the root directory.getList files in the given location.getCopy filepostMove file or folderputCreate an empty filepostCombine filespostValidate combine requestpostCreate folderpostCreate folderpostGet a new handlegetDatasets at rootgetGet 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 commentsgetexportDownload 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.postfilterFilter datapostFilter datapostRow number in filter resultpostList saved filtersgetDescribe saved filtergetCreate or update saved filterputDelete saved filterdeleteGet filter model for saved filtergetAdd a row for inclusion in the timeline report.putGet a report from the current timeline.getuserRequest 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 infogettimelineCreate timelinepostGet timeline datagetDelete timelinedeleteGet timeline row detailsgetExport a report for the given timeline.getGets the rows currently marked for inclusion in the report.getGet timeline metadatagetSet note on a given line.putRebuild timelinepostSet the report nameputuploadRaw data direct uploadpostUpload from URLpostPowered by Create folderpost https://api.gigasheet.com/files/directoryCreate a new folder in your Library.