AlchemyJ

Search

Data Validation and Record Merging

May 21, 2020
4 min

Data Validation and Record Merging

We cannot ensure that everyone will submit data according to the requirement we've set and sometimes we are not sure if the records were created or not before. Today we will look into how to solve this issue together. First, we work on ensuring everyone will submit data according to some rules we set by using Data Dictionary. Let's start by using the earlier model that we built on the CRUD process. You can find the tutorial here. Once the file is opened, save the file under a

23 views0 comments

Perform CRUD Operation on Excel - Part 2 of 2

May 5, 2020
5 min

Perform CRUD Operation on Excel - Part 2 of 2

We will work on updating and deleting records in the database today with AlchemyJ. If you notice the pattern on both reading records and creating records, the process is almost the same. The splits into 6 steps as below Configure the ##RestAPI Configure ##RestEndpointGroup Configure the BizLogic Define the IO_Schema Complete the #RestEndpointGroup configuration Generate API and test The above process is a simple way of how you can create an API using AlchemyJ. Let's proceed

25 views0 comments

Perform CRUD Operation on Excel - Part 1 of 2

May 3, 2020
6 min

Perform CRUD Operation on Excel - Part 1 of 2

This tutorial will show you how easy it is to perform CRUD operation to the database using AlchemyJ Our last post on executing SQL command in Excel shows how you can work with databases in Excel. However, the most common operation that we need to perform on database operation is CRUD which also stands for create, read, update and delete. In this tutorial, we are going to perform this process using AlchemyJ. Goals Create entries directly into the database from Excel Read the d

337 views0 comments

Execute SQL Statement in Excel

Apr 30, 2020
3 min

Execute SQL Statement in Excel

In this tutorial, we will execute the SQL Statement in Excel using AlchemyJ. Before we begin, ensure you have your database installed. For this tutorial, we will use the MySQL database. After you've installed the database, try creating a database at the same time. I'm naming this database as 'test'. CREATE DATABASE test; *use this script if you need help. Once you have the database created, let's start by selecting the REST API Sample Model for today's model. Once the new mod

55 views0 comments

Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ

Apr 29, 2020
4 min

Generate OpenAPI (Swagger) Specification Automatically with AlchemyJ

In this tutorial, I'm going to show you how you can enable OpenAPI (Swagger) from API generated by AJ For this tutorial, we are going to use the model we created from our previous post (How to write your first API with AlchemyJ). Open the file you saved previously and if you follow the tutorial exactly, the file name should be SayHello.xlsm. Before we start to change the content, let's save the file under a new name. Go to File -> Save As -> OpenAPI Swagger.xlsm Please ensure

185 views0 comments