Features

• Added AlchemyJ Extended Function: ajDBExportToWorkbook which retrieves data from a database and exports it directly to a Microsoft Excel workbook.
• Added AlchemyJ Extended Function: ajDBImportFromWorkbook which retrieves data from an Excel workbook and inserts it into a database table.
• Added AlchemyJ Extended Function: ajDBRunSPToWorkbook which exports the result of a stored procedure directly to an Excel workbook.
• Added AlchemyJ Extended Function: ajWebService which is an enhancement over ajWebServiceREST and ajWebServiceSOAP. It supports getting header and cookie values from the response, SSL certificate check, and more.
• Added AlchemyJ Extended Functions for folder operations: ajCopyFolder, ajDeleteFolder, ajFolderExists, ajMoveFolder, ajRenameFolder, ajFolderList, ajFileProperty and ajCreateFolder.
• Added support for 39 Excel functions.
• ajCheckDataItem has been modified to ignore empty records.
• ajJsonPath has a new Run by Function Point parameter which prevents it from running every time a workbook is calculated.

Features

• You can now sign AlchemyJ Studio with the latest code signing certificate.
• Improved performance of ajBigStrTrim.

Fixes

• Some minor bug fixes.

Features

• Added AlchemyJ Extended Function: ajXMLToTable which extracts data from an XML.
• Added AlchemyJ Extended Function: ajTextSplit and ajBigStrTextSplit which split text around a delimiter.
• Improved performance of ajJSONTable function.
• Released AlchemyJ Excel Library which provides AlchemyJ Extended Functions as a stand-alone Excel Add-in. It is a lite download version for users who want to use AlchemyJ to power up Excel but do not need to turn Excel models into APIs.

Fixes

• Improved ajCheckDataItemempty header and error value handling.
• ajLDAPUserList will now return an empty string instead of an error when the inputted attribute does not exist in the LDAP directory.
• Fixed a problem in ajJSONTable when it is used with ajWebServiceREST.

Features

• 47 new AlchemyJ Extended Functions.
• Big number and big string support.
• 4 new UDFs for LDAP operations.
• New AlchemyJ Extended Function, ajEnviron, which helps you retrieve environment variables.
• More Microsoft Excel functions support.
• You can now create APIs that accept and return a file.
• PostgreSQL support.
• One API may have multiple database connections.
• Support for Jetty as an embedded web server for REST API.
• Added 7 more snippets to make using AlchemyJ Extended Function much easier.
• You can now trigger a function point directly after a login and logout request.
• Token-based server-to-server authentication.
• In-memory password support in AlchemyJ Studio so database passwords are not exposed in the connection string.
• An encryption tool for generating encrypted value for application configuration files.
• Added an auto-save option during API generation.
• More options for handling array overflow in input arrays, output arrays, and arrays returned by AlchemyJ Extended Functions.
• Buttons to Run REST API and Open OpenAPI specification directly.
• Context-sensitive help which brings you to the relevant help page based on the currently focused cell content.
• Filter Type 1 supports OR operation between filter rows.
• Shortened API generation time.
• Improved API run-time performance.
• AjCheckDataItem will automatically convert a value to the defined type if it can be converted.