|
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 between the 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.
- StatementFooter
- StatementHeader
- MarginAccount
- GMT Offset.
- isDemo.
- First name.
Otherwise, an explicit error code is returned.
Type: JSON object as Array of String. |
Sample
<!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://webtrader.hybridsolutions.com/publicweb/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 + "StatementFooter: " + dataResult[11] + "<br/>"
resData = resData + "StatementHeader : " + dataResult[12] + "<br/>"
resData = resData + "MarginAccount : " + dataResult[13] + "<br/>"
resData = resData + "GMTOffset : " + 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))