Help center
Sign inTry for free

Integrate and automate

API Toolkit

In this module, you will learn more about SpreadsheetWeb's API Toolkit, and how to use it efficiently to boost your business.

Start course
Lessons
8
Level
Advanced
Format
Self-paced
Course contents8 lessons
Course overview
  1. 01Create an API based application
  2. 02Set inputs and outputs using API toolkit
  3. 03Input randomization
  4. 04Batch run
  5. 05Save data
  6. 06Formula auditing using Excel Export
  7. 07Document creation
  8. 08Export to Postman

In this course, you’ll learn about creating API-based applications in SpreadsheetWEB. By the end of this section, you’ll be able to set up, manage, and audit your applications using advanced API toolkit features, and effectively handle data and document creation.

Requirements

  • A SpreadsheetWeb Hub account. You can signup for a free account here.
  • Your spreadsheet contains named ranges for all inputs and outputs you would like to use in the web interface of your application.

Course curriculum

What you’ll learn

  1. 01
    Create an API based applicationCreate a published SpreadsheetWeb API application by identifying spreadsheet inputs and outputs, uploading the workbook, and publishing the API.
  2. 02
    Set inputs and outputs using API toolkitConfigure API Toolkit inputs and outputs, test calculations with named ranges or cell references, and interpret response-time metrics.
  3. 03
    Input randomizationUse Excel formulas to randomize API Toolkit inputs and generate varied calculation requests for repeat testing and simulations.
  4. 04
    Batch runRun calculations in batches and test different published workbook versions by transaction sequence ID or transaction date.
  5. 05
    Save dataSave API request and response JSON or selected input and output values in SpreadsheetWeb for backup, review, and auditing.
  6. 06
    Formula auditing using Excel ExportExport the workbook state for a specific API request and use Excel's formula-auditing tools to trace the resulting calculation.
  7. 07
    Document creationGenerate PDF or Word documents from an API request by mapping Word-template placeholders to workbook inputs and calculated outputs.
  8. 08
    Export to PostmanExport a configured API Toolkit request as a Postman collection with authentication settings for testing and code generation.