Build a Money Laundering Risk Assessment API from Excel (Part 2)

Diagram: Money Laundering Risk Assessment API

In part 1, we discussed the Money Laundering Risk Assessment Model in Excel and definitions required to convert the Excel into API.

In this article, we shall show you the tool that converts the Excel model into API and test the API.

Turn the Excel Model into API

With the definitions of API name, input and output cells, we can use COMPASS to convert the Excel into API. The diagram shows the flow of the conversion.

After the API is generated, we can test it with OpenAPI (Swagger), in which you can provide answers to each question. By referring to the first diagram, the OpenAPI

1. Takes the question list from API and shows it to user

2. Takes the answers from users and send it to API

3. Takes the output of the API (MLRS) and shows it to user

Technical Improvement

To make the API have better flexibility and maintainability, and avoid the change of program when new questions are added, you can use JSON as API input. This could be done by changing the API definitions in Excel.

After the API is re-generated, the OpenAPI will get the required JSON format and show it to the user with an input box for JSON input. Then it will send the input JSON to the API and show the output of the API to the user.

Thank you for reading the article. For the details of the Money Laundering Risk Assessment API, please contact us.