Building API in 4 Steps

Step 1 - Define Business Model in MS Excel and validate the model.

Step 2 - Define API Configuration with AlchemyJ templates.

Step 3 - Map Input/Output Cells to API parameters.

Step 4 - Launch AlchemyJ to build the API. 

Completing Programming in Minutes

Previously, your team using months to write a few hundred pages of specifications and develop the programs. Throughout the project, inaccurate information is being passed around, this ends up with tremendous bugs, quality issues, project delay, over-budget and user complaints.

With AlchemyJ, your analyst can work with users to model the system with the native language of business modelling - MS Excel. Users can instantly validate and change the business model..

AlchemyJ can write Java programs for the business model. This eliminates the development work and turns months of development work into minutes.

Database Integration

Lack of database integration functionality from MS Excel makes it incapable in building database related models, which are one of the most important requirements in commercial systems. 

AlchemyJ provides database related functions in MS Excel, from the most powerful native SQL execution, to user-friendly abstracted database operations for CRUD (Create, Read, Update and Delete).

Data Dictionary

AlchemyJ provides Data Dictionary to define behaviors of data item, such as validation or transformation. It could serve the purpose of requirements analysis framework as well as the documentation. 

With the Data Dictionary, AlchemyJ embeds data operation logic in the generated API, then write the logic in Java or Javascript for the deployment of the logic in UI Channels or Application Server.

Security and Session

AlchemyJ security framework contains two key concepts - Authentication and Authorization. Authentication is to verify user. Authorization is to grant the access of the requested API to user.

Various Authentication standards are supported, such as LDAP or JWT. 


To support stateful API operation, AlchemyJ stores cell values as well as network related information in session variables in clean or encrypted format, so that this information could be passed between client and server.

Interactive Debugger

Since API is running as an back-end service, API debugging is always a challenge. AlchemyJ Debugger allows developers watching the internal variables of API during its execution.  

Developers could also specify which variables or what operations to be checked. In addition, they could also amend the valuables content for what-if analysis. 

Copyright © 2020 Axisoft (Asia Pacific) Limited. All Rights Reserved.