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 Modules

This course consists of 8 modules:

  1. Create an API-based application
  2. Set inputs and outputs using the API toolkit
    • Using single-cell named ranges
    • Using cell references
    • Using multi-cell named ranges
  3. Input randomization
  4. Batch run
  5. Save data
    • Request and response JSON messages
    • Select input and output fields
  6. Formula auditing using Excel Export
  7. Document creation
  8. Export to Postman