API 1:10 video

How to add inputs and outputs to an API request

Define the input and output fields for a SpreadsheetWeb API request so callers can send workbook values and receive the required calculation results.

  • Click API Toolkit.
  • From the Inputs menu, select the named areas you want to add.
  • From the Outputs menu, select the outputs you want to add.
  • To assign a new value to an input, click on the named range you selected, shown in the menu, and define a new value. You can also load the default value from the worksheet.
  • Finally, to complete the process, click the Calculate button. This will ensure that all your actions are processed and the desired outputs are generated.