Knowledgebase:
GetAccountStmt
Posted by Mohammad Rahhal, Last modified by Rawan Al Hourani on 13 February 2018 01:23 PM

Syntax 

GetAccountStmt (AccountId As Long,FromDate As String ,ToDate As String)

Description

The GetAccountStatement operation is used to return a JSON object of type string array which contains a given account
statement for a given starting date and ending date.

Request Parameters

Name Description  Required
AccountId
  • The intended account identifier.
  • Type: Long.
  • Default: None.
  • Constraints: Must be a valid account ID, and accessible by logged in client.
Yes
FromDate
  • Starting date for account statement query.
  • Type: String.
  • Default: 01/01/1970.
  • Constraints: Must be in DD/MM/YYYY format.
No
ToDate
  • Ending date for account statement query.
  • Type: String.
  • Default: System date.
  • Constraints: Must be in DD/MM/YYYY format.
No

Response Elements

Name Description 
Result

This operation returns a given account statement upon success.

The returned array will hold the following values for each account ordered as:

  • ClientID.
  • AccountId.
  • Beginning Balance.
  • Margin In/Out.
  • Trading Profit/Loss.
  • Commission.
  • Interest.
  • Margin Requirement.
  • Credit.
  • Account ID Prefix.
  • Account ID Suffix.
  • GMT Offset.
  • isDemo.
  • First name. 

Otherwise an explicit error code is returned.

Type: JSON object as Array of String.


Sample

Download sample as text file.

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>GetAccountStmt</title>
<script src="http://code.jquery.com/jquery-latest.js"></script>
</head>
<script >
$(document).ready(function () {
var urlStr = "http://5.10.64.199/vertexweb10/WebService.svc";
jQuery.support.cors = true;
$("#progress").ajaxStart(function () { $(this).css("display", "block"); });
$("#progress").ajaxComplete(function () { $(this).css("display", "none"); });
function onSuccessResult(response) {
response = eval('(' + response + ')')
if (response.UserId == -1 || response.UserId == -207) {
$("#resultData").html("Invalid username or password");
}
else if (response.UserId == -231) {
$("#resultData").html("You must have at least one account");
}
else if (response == null || response == "" || response.UserId < 0) {
$("#resultData").html("Error while login.Please try later");
}
else {
$("#resultData").html("SuccessResult ... UserId is :" + response.UserId);
}
}
function onErrorResult(result) {
alert('Service call faild : ' + result.status + ' ' + result.statusText);
}
$("#btnLogin").click(function () {
$.ajax({
type: 'Get',
url: urlStr + "/Login",
dataType: "jsonp",
data: { "username": $("#txtusername").val(), "password": $("#txtpassword").val() },
success: onSuccessResult,
error: onErrorResult
});
});
$("#btnAction").click(function () {
$.ajax({
type: 'GET',
url: urlStr + "/GetAccountStmt",
dataType: "jsonp",
data: { "AccountId": $("#txtAccount").val(), "FromDate": $("#date1").val(), "ToDate": $("#date2").val() },
success: function (dataResult) {
dataResult = eval('(' + dataResult + ')');
var resData = "" ;
resData = resData + "ClientID: " + dataResult[0] + "<br/>"
resData = resData + "AccountID: " + dataResult[1] + "<br/>"
resData = resData + "Beginning Balance: ?? " + dataResult[2] + "<br/>"
resData = resData + "Total Deposit: " + dataResult[3] + "<br/>"
resData = resData + "Net profit: " + dataResult[4] + "<br/>"
resData = resData + "Total Commission: " + dataResult[5] + "<br/>"
resData = resData + "Total Interest: " + dataResult[6] + "<br/>"
resData = resData + "Margin Requirement : " + dataResult[7] + "<br/>"
resData = resData + "Total Credit: " + dataResult[8] + "<br/>"
resData = resData + "prefix: " + dataResult[9] + "<br/>"
resData = resData + "Suffix: " + dataResult[10] + "<br/>"
resData = resData + "GMT Offset: " + dataResult[11] + "<br/>"
resData = resData + "Check it ?? : " + dataResult[12] + "<br/>"
resData = resData + "Check it ??? : " + dataResult[13] + "<br/>"
resData = resData + "Check it ?? : " + dataResult[14] + "<br/>"
resData = resData + "Is Demo : " + dataResult[15] + "<br/>"
resData = resData + "First name: " + dataResult[16] + "<br/>"
$("#resultAction").html(resData);
},
error: onErrorResult
});
});
});
</script>
<body>
<table border="1px">
<tbody>
<tr>
<td>
Username: <input type="text" id="txtusername" value=""/>
Password: <input type="text" id="txtpassword" value=""/>
<button id="btnLogin"> Login </button>
</td>
</tr>
<tr >
<td>
AccountId : <input type="text" id="txtAccount" value ="" /> FromDate : <input type="text" id="date1" value=""/> ToDate : <input type="text" id="date2" value="" />
<button id="btnAction"> GetAccountStmt </button>
</td>
</tr>
</tbody>
</table>
<div id="resultData"> </div>
<div id="resultAction"> </div>
<div style="display:none" id="progress">Loading ... </div>
</body>
</html> 

 


See Also


VertexFX WCF Service Index

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Help Desk Software by Hybrid Solutions