APIX.XL™

  1. Home
  2. Docs
  3. APIX.XL™
  4. APIX.XL™ User Guide
  5. Loading an API Locally

Loading an API Locally

The following steps allow the user to load an API locally.

  1. On the APIX.XL ribbon, click the Load API button.
  1. API definitions can be loaded from a URL, by uploading a Swagger file, or by entering the Swagger definition as text.
  1. To load from a URL, select the URL tab and enter the URL for the API definition in the text box.
  1. To load from a file, select the FILE tab and then click the BROWSE button to select the file that contains the API definition.
  1. To load from text, select the TEXT tab and enter the API definition as JSON into the text box.
  1. Once the appropriate selection is made, click the REVIEW button.
  2. The screen that appears will list all available endpoints in the form of Excel function names and will allow various values to be edited before creating the functions. Enter desired category name in the XL CATEGORY field.
  1. To add a prefix to function names, enter the desired prefix in the FN Prefix field and click the UPDATE button. The function names will update. This step is optional.
  1. Function names can be edited as needed. To exclude a function from being created, un-check the INCLUDE IN EXCEL checkbox next to it.
  2. Once edits have been made, click the ADD FUNCTIONS TO EXCEL button to create the functions.
  1. The following message will indicate that the functions were created successfully.
  1. To verify that the functions were created, select an empty cell and click the fx symbol next to the formula bar.
  2. Once the Insert Function window appears, click the category drop-down and look for the category entered in Step 8. Selecting a category will display all the functions included in the category.

How can we help?