Connect Claude & ChatGPT to SpreadsheetWeb Hub

196 tools for SpreadsheetWeb Hub

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

• assign_tagsChanges dataAssign tags to applications: `request.workspaceId`, and in `secondary_request` the `tagIds` and `applicationIds`.
• create_a_data_layout_for_the_given_applicationChanges dataCreate a new page. API summary: Create a data layout for the given application.
• create_a_new_print_process_in_an_applicationChanges dataCreate a new page. API summary: Create a new print process in an application.
• create_a_new_script_for_an_applicationChanges dataCreate a new page. API summary: Create a new script for an application.
• create_a_new_stylesheet_for_an_applicationChanges dataCreate a new page. API summary: Create a new stylesheet for an application.
• create_a_runtime_text_override_for_an_applicationChanges dataCreate a new page. API summary: Create a runtime text override for an application.
• create_a_solver_event_on_a_target_applicationChanges dataCreate a new page. API summary: Create a solver event on a target application.
• create_an_application_within_a_workspaceChanges dataCreate a new page. API summary: Create an application within a workspace.
• create_an_email_process_on_a_target_applicationChanges dataCreate a new page. API summary: Create an email process on a target application.
• create_an_excel_export_process_on_an_applicationChanges dataCreate a new page. API summary: Create an Excel export process on an application.
• create_applylayoutChanges dataCreate a new applylayout. API summary: Apply a layout to a set of users and/or user templates.
• create_autorefreshhistoryChanges dataCreate a new autorefreshhistory.
• create_calculateallrecordsasyncChanges dataCreate a new calculateallrecordsasync.
• create_calculatemultipleChanges dataCreate a new calculatemultiple. API summary: Perform a multiple calculation request.
• create_calculatemultipleasyncChanges dataCreate a new calculatemultipleasync. API summary: Perform a multiple calculation request.
• create_calculatesingleChanges dataCreate a new calculatesingle. API summary: Perform a single calculation request.
• create_changecolumnsorderChanges dataCreate a new changecolumnsorder. API summary: Re-order the columns for a database on a specific application.
• create_changedocumentorderChanges dataCreate a new changedocumentorder. API summary: Change the order of the print documents under an existing print process of an application.
• create_changeorderChanges dataCreate a new changeorder. API summary: Change the order of the pages in an application.
• create_changeorder_2Changes dataCreate a new changeorder. API summary: Change the order of stylesheets in an application.
• create_changeorder_postChanges dataCreate a new changeorder. API summary: Change the order of scripts in an application.
• create_checkgooglesheetfileaccessChanges dataCreate a new checkgooglesheetfileaccess.
• create_checkgooglesheetworkbookcompatibilityChanges dataCreate a new checkgooglesheetworkbookcompatibility.
• create_checkworkbookcompatibilityChanges dataCreate a new checkworkbookcompatibility.
• create_clearvalidationmessageChanges dataCreate a new clearvalidationmessage. API summary: Clear the active designer-specific validation messages for the application instance.
• create_createdocumentChanges dataCreate a new createdocument. API summary: Add a print document under an existing print process of an application.
• create_createfromtemplateChanges dataCreate a new createfromtemplate. API summary: Create an application within a workspace from an application template.
• create_createnewcolumnChanges dataCreate a new createnewcolumn. API summary: Create a column on a table on a target application.
• create_createprimarytableChanges dataCreate a new createprimarytable. API summary: Create a primary table on a target application.
• create_createsecondaryonetomanytableChanges dataCreate a new createsecondaryonetomanytable. API summary: Create a secondary one-to-many table on a target application.
• create_createsecondarytableChanges dataCreate a new createsecondarytable. API summary: Create a secondary one-to-one table on a target application.
• create_deleteactivetransactionChanges dataCreate a new deleteactivetransaction. API summary: Delete the work-in-progress active transaction.
• create_deleteallChanges dataCreate a new deleteall.
• create_deletecolumnChanges dataCreate a new deletecolumn. API summary: Delete a column on a table on a target application.
• create_deletedocumentChanges dataCreate a new deletedocument. API summary: Delete an existing print document under an existing print process of an application.
• create_deletemanyChanges dataCreate a new deletemany. API summary: Delete an multiple applications within a workspace.
• create_deletetableChanges dataCreate a new deletetable. API summary: Deletes a table on a target application.
• create_downloadallChanges dataCreate a new downloadall.
• create_downloadfileattachmentChanges dataCreate a new downloadfileattachment.
• create_editconnectionChanges dataCreate a new editconnection.
• create_extractapplicationChanges dataCreate a new extractapplication. API summary: Extract a designer-specific export file to duplicate the application (.des).
• create_extracthistoricalapplicationChanges dataCreate a new extracthistoricalapplication. API summary: Extract a historical designer-specific export file to duplicate the application (.des).
• create_generateChanges dataCreate a new generate. API summary: Generate a document by replacing text and image stubs.
• create_generatedatabasetablesbyusednamedrangeChanges dataCreate a new generatedatabasetablesbyusednamedrange. API summary: Generate all tables on a target application by the named ranges bound to the input controls.
• create_getallnamedrangeChanges dataCreate a new getallnamedrange. API summary: Retrieve a list of all named range metadata under an application.
• create_getapplicationChanges dataCreate a new getapplication. API summary: Retrieve the designer-specific properties of the application instance.
• create_getchangesbetweenrecordChanges dataCreate a new getchangesbetweenrecord.
• create_getcolumnChanges dataCreate a new getcolumn. API summary: Retrieve the column information for a specific column on a table on a target application.
• create_getcolumnstatChanges dataCreate a new getcolumnstat. API summary: Returns some stats info about the given column of Designer Database, e.g. min and max values.
• create_getdatabaseChanges dataCreate a new getdatabase. API summary: Retrieve a list of databases associated with the application.
• create_getdatabase_postChanges dataCreate a new getdatabase. API summary: Retrieve a specific set of database metadata associated with an application.
• create_getdatabaseinternalnameChanges dataCreate a new getdatabaseinternalname. API summary: Retrieve a list of the internal table names associated with each configured table.
• create_gethistoricaldatamarkupChanges dataCreate a new gethistoricaldatamarkup.
• create_getlayoutrelationChanges dataCreate a new getlayoutrelation. API summary: Retrieves a set of relations between this data layout and users/templates throughout the system.
• create_getlistnamedrangeinfoChanges dataCreate a new getlistnamedrangeinfo. API summary: Retrieve a list of list named ranges under an application.
• create_getlistofdefaultvalueswithoverrideChanges dataCreate a new getlistofdefaultvalueswithoverride. API summary: Retrieve a list of default values for a given named ranges from an application.
• create_getmanydocumentChanges dataCreate a new getmanydocument. API summary: Retrieve a list of specific documents under a print process in an application.
• create_getnamedrangesoftypeChanges dataCreate a new getnamedrangesoftype. API summary: Retrieve a filtered list of named ranges from an application.
• create_getprogressstateChanges dataCreate a new getprogressstate.
• create_getpublisheddatabaseChanges dataCreate a new getpublisheddatabase. API summary: Retrieve a list of databases associated with an application that have already been published on a subsequent transaction.
• create_getstatusChanges dataCreate a new getstatus. API summary: Retrieve the status of an application, such as whether it exists, has a published transaction, or has an unpublished transaction.
• create_getstubChanges dataCreate a new getstub. API summary: Retrieve a list of stubs that are detected in the document.
• create_gettablecolumnChanges dataCreate a new gettablecolumn. API summary: Retrieve a list of columns for a database on a specific application.
• create_gettransactionChanges dataCreate a new gettransaction. API summary: Retrieve a list of transactions for the target application.
• create_getusednamedrangeChanges dataCreate a new getusednamedrange. API summary: Retrieve a list of all named ranges that are actually used within the application.
• create_getvalidationmessageChanges dataCreate a new getvalidationmessage. API summary: Retrieve the designer-specific validation messages for the application instance.
• create_getwithattachmentChanges dataCreate a new getwithattachment. API summary: Retrieve a specific email process on a target application including attachment information.
• create_listcustomactionhookChanges dataCreate a new listcustomactionhook. API summary: Retrieve a list of custom action hooks associated with a custom action of an application.
• create_listdocumentChanges dataCreate a new listdocument. API summary: Retrieve a list of the documents under a specific print process in an application.
• create_listdocumentstubChanges dataCreate a new listdocumentstub. API summary: Retrieve a list of the document stubs within a print document of an existing print process of an application.
• create_listrangemapChanges dataCreate a new listrangemap. API summary: Retrieve a list of mapped named ranges from an Excel export process on an application.
• create_listtextresourceChanges dataCreate a new listtextresource. API summary: Retrieve the full set of runtime text resources for the application, including those that are not overridden.
• create_markrecordasactiveChanges dataCreate a new markrecordasactive.
• create_pageChanges dataCreate a new page. API summary: Create a custom action associated with an application.
• create_page_10Changes dataCreate a new page. API summary: Retrieve a specific set of print process information for an application.
• create_page_11Changes dataCreate a new page. API summary: Retrieve a specific list of the runtime text overrides for an application.
• create_page_12Changes dataCreate a new page. API summary: Update an existing runtime text override for an application.
• create_page_13Changes dataCreate a new page. API summary: Update an existing solver event on a target application.
• create_page_14Changes dataCreate a new page. API summary: Create a data share public link for the given application's record.
• create_page_15Changes dataCreate a new page. API summary: Update a data share link for the given application.
• create_page_2Changes dataCreate a new page. API summary: Update an existing email process on a target application.
• create_page_3Changes dataCreate a new page. API summary: Update an existing Excel export process on an application.
• create_page_4Changes dataCreate a new page. API summary: Create a goal seek event on a target application.
• create_page_5Changes dataCreate a new page. API summary: Update an existing goal seek event on a target application.
• create_page_6Changes dataCreate a new page. API summary: Retrieve a specific list of pages for an application.
• create_page_7Changes dataCreate a new page. API summary: Creates a new page for the application.
• create_page_8Changes dataCreate a new page. API summary: Retrieve information for the home page of an application.
• create_page_9Changes dataCreate a new page. API summary: Set a page to the home page for an application.
• create_page_postChanges dataCreate a new page. API summary: Update an existing custom action associated with an application.
• create_pasteclipboarddatatocellChanges dataCreate a new pasteclipboarddatatocell. API summary: Pastes clipboard data to the named range cells.
• create_prepopulateinstanceChanges dataCreate a new prepopulateinstance. API summary: Send a set of values to populate a designer application instance. This will return a URL to access, including a receipt that will allow you….
• create_primmarytableexistChanges dataCreate a new primmarytableexist. API summary: Determine whether a primary table exists for the target application.
• create_refreshgooglesheetfileChanges dataCreate a new refreshgooglesheetfile.
• create_refreshgooglesheetfilefromselectionChanges dataCreate a new refreshgooglesheetfilefromselection.
• create_removedefaultvalueoverrideChanges dataCreate a new removedefaultvalueoverride. API summary: Clears the default value overrides for a named range from an application.
• create_resetconnectionChanges dataCreate a new resetconnection.
• create_selectlayoutChanges dataCreate a new selectlayout. API summary: Select a layout that will be loaded as the default for the current user.
• create_startnewtransactionChanges dataCreate a new startnewtransaction. API summary: Begin a new transaction on a published application.
• create_tagChanges dataCreate a tag in the workspace: in `request` pass the tag `text`, the workspaceId and optional color.
• create_testconnectionChanges dataCreate a new testconnection.
• create_togglecolumnstateChanges dataCreate a new togglecolumnstate. API summary: Toggle the active state of a column on a database for a specific application.
• create_togglenamedrangefavoritedflagChanges dataCreate a new togglenamedrangefavoritedflag. API summary: Toggles favorited flag of namedRange.
• create_togglepersistentoverridesflagChanges dataCreate a new togglepersistentoverridesflag. API summary: Toggles persistent overrides flag of a named range.
• create_togglestateChanges dataCreate a new togglestate. API summary: Enables or disables multiple existing scripts in an application.
• create_togglestate_postChanges dataCreate a new togglestate. API summary: Enables or disables multiple existing stylesheets in an application.
• create_toggletablestateChanges dataCreate a new toggletablestate. API summary: Toggle the active state of a database for a specific application.
• create_unlockrecordChanges dataCreate a new unlockrecord.
• create_updateaccesstypeChanges dataCreate a new updateaccesstype. API summary: Update Access Type of the application.
• create_updateapplicationChanges dataCreate a new updateapplication. API summary: Update the designer-specific properties of the application instance.
• create_updatecolumnChanges dataCreate a new updatecolumn. API summary: Update an existing column on a table on a target application.
• create_updatecolumnmappingChanges dataCreate a new updatecolumnmapping. API summary: Update the column mappings for a secondary one-to-many table. This is used for consolidation when the underlying named range has been change….
• create_updatecustomactionhookChanges dataCreate a new updatecustomactionhook. API summary: Update the properties of a custom action hook.
• create_updatedefaultvaluesoverrideChanges dataCreate a new updatedefaultvaluesoverride. API summary: Update a default value for a named range with an override.
• create_updatedocumentChanges dataCreate a new updatedocument. API summary: Update an existing print document under an existing print process of an application.
• create_updatedocumentstubChanges dataCreate a new updatedocumentstub. API summary: Update the stub binding in a print document of an existing print process of an application.
• create_updaterangemapChanges dataCreate a new updaterangemap. API summary: Update a specific Excel export range binding on an Excel export process of an application.
• create_updaterestrictiontypeChanges dataCreate a new updaterestrictiontype. API summary: Update Restriction Type of the cell references by named range favorited status.
• create_updatesecondaryonetomanytableChanges dataCreate a new updatesecondaryonetomanytable. API summary: Update a secondary one-to-many table.
• create_updateslugChanges dataCreate a new updateslug. API summary: Update the slug for the application.
• create_updatetagsassignmentChanges dataCreate a new updatetagsassignment.
• create_updatewebserviceapplicationChanges dataCreate a new updatewebserviceapplication. API summary: Update the designer-specific properties of the Web Service application instance.
• create_userChanges dataCreate a new user. API summary: Delete the entire designer application, including any stored database data.
• create_user_10Changes dataCreate a new user. API summary: Retrieve a list of goal seek events associated with the application.
• create_user_11Changes dataCreate a new user. API summary: Retrieve a specific goal seek event on a target application.
• create_user_12Changes dataCreate a new user. API summary: Delete a goal seek event on a target application.
• create_user_13Changes dataCreate a new user.
• create_user_14Changes dataCreate a new user.
• create_user_15Changes dataCreate a new user. API summary: Retrieve a list of the print processes for an application.
• create_user_16Changes dataCreate a new user. API summary: Retrieve a list of the runtime text overrides for an application.
• create_user_17Changes dataCreate a new user. API summary: Delete an existing runtime text override for an application.
• create_user_18Changes dataCreate a new user. API summary: Retrieve a list of solver events associated with the application.
• create_user_19Changes dataCreate a new user. API summary: Retrieve a specific solver event on a target application.
• create_user_2Changes dataCreate a new user. API summary: Retrieve information regarding a specific custom action associated with an application.
• create_user_20Changes dataCreate a new user. API summary: Apply a specific rights template to the user of a workspace.
• create_user_3Changes dataCreate a new user. API summary: Delete a specific custom action associated with an application.
• create_user_6Changes dataCreate a new user. API summary: Retrieve a list of email processes associated with the application.
• create_user_7Changes dataCreate a new user. API summary: Retrieve a list of Excel export processes associated with an application.
• create_user_8Changes dataCreate a new user. API summary: Retrieve a specific Excel export process information associated with an application.
• create_user_9Changes dataCreate a new user. API summary: Delete a specific Excel export process on an application.
• create_user_postChanges dataCreate a new user. API summary: Retrieve a list of the custom actions associated with the application.
• delete_a_solver_event_on_a_target_applicationChanges dataCreate a new user. API summary: Delete a solver event on a target application.
• delete_a_specific_data_layoutChanges dataCreate a new user. API summary: Delete a specific data layout.
• delete_a_specific_data_share_linkChanges dataCreate a new user. API summary: Delete a specific data share link.
• delete_a_specific_page_in_an_applicationChanges dataCreate a new user. API summary: Delete a specific page in an application.
• delete_a_specific_tag_in_a_workspaceChanges dataCreate a new user. API summary: Delete a specific tag in a workspace.
• delete_an_email_process_on_a_target_applicationChanges dataCreate a new user. API summary: Delete an email process on a target application.
• delete_an_existing_application_within_a_workspaceChanges dataCreate a new user. API summary: Delete an existing application within a workspace.
• delete_an_existing_invitation_to_a_workspaceChanges dataCreate a new user. API summary: Delete an existing invitation to a workspace.
• delete_an_existing_print_process_in_an_applicationChanges dataCreate a new user. API summary: Delete an existing print process in an application.
• delete_an_existing_script_from_an_applicationChanges dataCreate a new user. API summary: Delete an existing script from an application.
• delete_an_existing_stylesheet_from_an_applicationChanges dataCreate a new user. API summary: Delete an existing stylesheet from an application.
• delete_recordsChanges dataDelete saved records of an application: `keys` with workspaceId and applicationId, and `request` as the list of record IDs. Cannot be undone.
• download_dataChanges dataDownload the document for a data.
• get_applicationGet one application by `application_id`: name, slug, status and settings.
• get_application_availabilityCheck whether an application (`application_id`) is online or offline and its availability schedule.
• get_application_by_slugFind an application by its URL slug (`application_slug`).
• get_downloadGet one download by transaction sequence id. API summary: Retrieve an underlying Excel model file of application within a workspace.
• get_getbyuseridGet one getbyuserid by application id. API summary: Retrieve a list of data layouts that are assigned to or created by the current user.
• get_multiple_applications_within_a_workspaceChanges dataCreate a new page. API summary: Get multiple applications within a workspace.
• get_userGet one workspace user by `user_id`.
• get_user_getGet one user by workspace id. API summary: Retrieve a specific data layout for the given application.
• invite_userChanges dataInvite someone to the workspace: in `request` pass their `email`, the workspaceId, an optional `message` and user template. Sends an invitation email.
• list_application_tagsList the tags assigned to an application (`application_id`).
• list_applicationsChanges dataList the applications (spreadsheet apps) in the workspace, with their IDs and names. Set `only_published_with_databases` to true to see only published apps that store records; filter with `search_phrase` and page with `page_index`/`page_size`.
• list_named_rangesChanges dataList the named ranges (the input and output cells) of an application. Pass `keys` with workspaceId and applicationId; use `request.searchPhrase` to filter. Use this to learn the names needed for calculations.
• list_recordsChanges dataList the saved records (submissions) of an application. Pass `keys` with workspaceId and applicationId; in `request` use searchPhrase, sortByColumnName, pageIndex and pageSize.
• list_tagsChanges dataList the tags in the workspace, used to group applications.
• list_usersChanges dataList the users in the workspace, with their IDs, names and emails; filter with `search_phrase`.
• remove_a_user_from_a_workspaceChanges dataCreate a new user. API summary: Remove a user from a workspace.
• retrieve_a_list_of_pages_for_an_applicationChanges dataCreate a new user. API summary: Retrieve a list of pages for an application.
• retrieve_a_specific_script_from_an_applicationChanges dataCreate a new user. API summary: Retrieve a specific script from an application.
• retrieve_a_specific_stylesheet_from_an_applicationChanges dataCreate a new user. API summary: Retrieve a specific stylesheet from an application.
• retrieve_a_specific_tag_from_the_workspaceGet one user by workspace id. API summary: Retrieve a specific tag from the workspace.
• retrieve_the_list_of_scripts_from_an_applicationChanges dataCreate a new user. API summary: Retrieve the list of scripts from an application.
• retrieve_the_list_of_stylesheets_from_an_applicationChanges dataCreate a new user. API summary: Retrieve the list of stylesheets from an application.
• run_calculationChanges dataRun the spreadsheet calculation of an application: in `request` pass workspaceId, applicationId, `inputs` as named range to value pairs and `outputs` as the named ranges to return. Does not save a record.
• submit_calculationVisible to othersClose a calculation. Has effects visible outside this system. API summary: Close a dedicated calculation session.
• submit_documentVisible to othersMerge a document. Has effects visible outside this system. API summary: Generate a document by merging multiple cached documents.
• submit_emaildesignVisible to othersDuplicate a emaildesign. Has effects visible outside this system. API summary: Duplicate an email process and its attachment references.
• submit_excelexportVisible to othersDuplicate a excelexport. Has effects visible outside this system. API summary: Duplicate an Excel export process with a new event, file, ranges, and range mappings.
• submit_inviteVisible to othersResend a invite. Has effects visible outside this system. API summary: Resend an existing workspace invitation to a user.
• submit_pageVisible to othersDuplicate a page. Has effects visible outside this system. API summary: Duplicate an existing page.
• submit_printdesignVisible to othersDuplicate a printdesign. Has effects visible outside this system. API summary: Duplicate a print process with new event, document, stub, and document file records.
• submit_publishVisible to othersPublish a publish. Has effects visible outside this system. API summary: Publish the current work-in-progress transaction on the application.
• submit_scriptVisible to othersDuplicate a script. Has effects visible outside this system. API summary: Duplicate an existing script and clone its backing file.
• submit_stylesheetVisible to othersDuplicate a stylesheet. Has effects visible outside this system. API summary: Duplicate an existing stylesheet and clone its backing file.
• update_a_data_layout_for_the_given_applicationChanges dataCreate a new page. API summary: Update a data layout for the given application.
• update_a_specific_tag_in_a_workspaceChanges dataCreate a new edit. API summary: Update a specific tag in a workspace.
• update_an_existing_page_for_the_applicationChanges dataCreate a new page. API summary: Update an existing page for the application.
• update_an_existing_print_process_in_an_applicationChanges dataCreate a new page. API summary: Update an existing print process in an application.
• update_an_existing_script_in_an_applicationChanges dataCreate a new page. API summary: Update an existing script in an application.
• update_an_existing_stylesheet_in_an_applicationChanges dataCreate a new page. API summary: Update an existing stylesheet in an application.
• update_applicationChanges dataUpdate an application's settings in `request`, such as name, slug or offline message. Pass its applicationId and workspaceId; changes are visible to the app's users.
• update_user_2Changes dataUpdate an existing user identified by data id. API summary: Retrieve a set of data share public links for the given application's record.
• update_user_postChanges dataUpdate an existing user identified by application id. API summary: Retrieve a set of data layouts for the given application.
• update_workspacelistChanges dataUpdate an existing workspacelist identified by workspace id. API summary: Retrieve a list of workspace invites.

Questions