APIX.XL FAQ
- How to Enable ActiveX controls in Excel
- How to set swagger flag for Excel functions in APIX.XL so that data from functions that return array get rendered into the worksheet instead of displaying as dynamic array
- How to set CacheTimeout in swagger for Excel functions in APIX.XL
- How to set DateFormat in swagger for Excel functions in APIX.XL
- How to set ExcelAsync flag in swagger to create asynchronous functions in Excel
- List of static parameters that can be provided as Options
- Useful tips on naming Functions and Parameters
- How to update config and settings file for APIX
- Determine parameter order for an endpoint
- APIX.XL Licensing Service Options and Workflow
- What should the call to the API Gateway return?
- How to set DeserializerType, DeserializerJPath and ReturnArray in swagger for Excel functions in APIX.XL
- How to clear APIX cache
- Edit swagger metadata to pass table, dictionary, and list data types in body parameter to make API calls
- Edit swagger metadata to pass table, dictionary, and list data types as endpoint parameters to make API calls
- Enable trust access to the VBA project object model
- Installing / Updating the Plugin
- What is apix-xl-vba.xlam?
- How to get log file from APIX?
- What information should be shared with technical teams or Risk Focus to continue escalated triage if needed?
- What log patterns/codes point to specific error ownership?
- Installation Instructions
- What tool needs to be used by a non-technical resource to analyze the log file? i.e. Notepad++ v. Notepad?
- How to enable disabled / inactive APIX.XL addins?
- What is the relationship of Namespace, Shortname and version to an API
- How is the function name generated in APIX.XL
- How to enable "Trust access to VBA project object model"