Step 1 : Design Services

First of all, you have to design the service flow and its function. So, the main goal of our service as stated in the previous section is to retrieve the information from the database and export it into an excel file.

Service: Retrieving the information from the database and export it into an excel file  

After you know that you have to create the service. You can fully concentrate on designing how your service functions including. 

  • Service description
  • Interface structure
  • Service flow and external systems integration

See more details at Step 1: Design Services

Design service

This part will design the service that includes what the function is and describe the details.

Service Description :
Service name : testexcelexport
Description : retrieve data from database and export into an excel file
Project : testservices

Interface Structure :

Field NameData Type
InputnumberInteger
Field NamePromote to Front-end
OutputlistYes
Map to FieldColumn Name (DB)
Sub FieldProcessprocess
numbernumber
typetype
teanameteaname
locationlocation

Service flow and external systems integration :
Database : MySQL Database
Database : Name test_apig
Database : Table tea

Design Service Flow

This part will design the function of the service into the flow diagram.

Service Flow