This Card Connect application extension is to implement a feasible solution that accesses the
merchants/ mids funding information from Card Connect via the funding service API and process the
transactions directly into Oracle system.
The idea is to replace the existing ..NET application with an Oracle based application/system.
This system is designed in a way that it will trigger email notification to the users regarding
the every day's transaction data. The program can be run in On Schedule and On Demand to trigger email Notifications
Prerequisites
1. Open port connection must be available for the application server.
2. Server availability while trying to communicate the third party Server availability while trying to communicate the third--party vendor using Funding APIs party vendor using Funding APIs
3. Data must be present in JSON format at the correct location.
Approach
The Funding Service API will fetch the data from third party vendor and insert the data into oracle tables using Java
Concurrent Program.
Extracting the data from oracle interface table into Excel sheet and sent an email to the business users with the excel attachment.
1. Job to get the yesterday’s transactions from card connect Funding API.
a. https://xxcompany.cardconnect.com:8000/ cardconnect / funding?merchid =123121231&date=<Yesterday’s date> (Date Format:MMDD)
b. https://xxcompany.cardconnect.com:8000/ cardconnect / funding?merchid =123121121&date=<Yesterday’s date> (Date Format:MMDD)
2. After getting the response from API inserting the data into oracle temporary table (XX_JSON_TEMP) to hold the JSON data
3. Read the “ txns ” node from the API
4. After performing necessary validations on data insert the data into two oracle tables
a.XX_FIS_AR_PAY_HIST_ALL.
b.XX_FIS_AR_PAYMENTS_INT_ALL.
5. Extracting the interface table data into excel sheet using XML Publisher Report.
6. Send an email to the business user.
7. Run History will be maintained for each run.
a.XX_FIS_AR_RUN_HIST_ALL
No comments:
Post a Comment