Mapping the inputs and outputs on your Excel file are a pre-requisite for creating an API. This process doesn't take too long. Just follow along!

Find the Name Manager

  • Open your Excel file

  • Go to the Formulas tab

  • Click on "Define Name" (on a Mac) / "Name Manager" (on a Windows)

  • You will see a dialog box open

To name your API request parameters, select the value cell for your input to name them. There are two ways of mapping your inputs.

Standard Mapping

Syntax: Xinput_[parameter] and Xoutput_[parameter]

  • We used the Name Box in Excel to identify 'a' and 'b' as inputs. The name must be prefixed with Xinput_. In this example, we are using individual cells and range inputs for Spark.

  • Note that the ranged value must have a header row that is completed. It is strongly advised that heading titles begin with with an alphabetic character.

  • Similarly, for outputs, identify your outputs and prefix the name with Xoutput_.

Video Tutorial

Did this answer your question?