Accounts Reconciliation

Get Accounts Reconciliation Details.

Definition

URL

GET  https://api-test.instarem.com:4803/api/v1/account/reconciliation

Header Parameters

Parameter	Description	Type	Required
Authorization	Authentication Token	String	Yes
Content-Type	The Content-Type entity header is used to indicate the media type of the resource. Expected value is application/json.	String	Yes
X-CLIENT-ID	Unique id for client generated by Nium, Required only in case of partner based model (E.g. 593feb7c7c52bb2357b2df6c).	String	No

Example Request

Bash
Javascript
C#

curl --location --request GET 'https://api-test.instarem.com:4803/api/v1/account/reconciliation?fromDate=2021-06-04T14:46:44.735Z&toDate=2021-06-04T14:49:49.688Z&pageNo=1&size=100&accountNumber=100251330167' \\
--header 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE2MTkxNjA1MjMsImRhdGEiOnsiY2xpZW50IjoiNTkzZmViN2M3YzUyYmIyMzU3YjJkZjZjIiwic3ViIjoiNTkzZmViZjc3YzUyYmIyMzU3YjJkZjcxIn0sImlhdCI6MTYxOTA3NDEyM30.GfWzkKlCTzjE-l0mcmgVPjC3SmJ336F3wO_EigjUNUk' \\
--header 'Content-Type: application/json'

var data = JSON.stringify({})
var xhr = new XMLHttpRequest();
xhr.addEventListener("readystatechange", function () {
if (this.readyState === this.DONE) {
    console.log(this.responseText);
}
});
xhr.open("get", "https://api-test.instarem.com:4803/api/v1/account/reconciliation?fromDate=2021-06-04T14:46:44.735Z&toDate=2021-06-04T14:49:49.688Z&pageNo=1&size=100&accountNumber=100251330167")
xhr.setRequestHeader("authorization", "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE0OTgxMzQ4OTQsImRhdGEiOnsic3ViIjoiNTk0MjNmMzZjZWEyMTQ2OTI2ODczOWE1IiwiY2xpZW50IjoiNTk0MjNmMzZjZWEyMTQ2OTI2ODczOWExIn0sImlhdCI6MTQ5ODA0ODQ5NH0.pevwSDpk-JDNtVIpqFu_m0Xu1UnDVumrAYStcrxf8sM");
xhr.setRequestHeader("content-type", "application/json");
xhr.send(data);

var client = new RestClient("https://api-test.instarem.com:4803/api/v1/account/reconciliation?fromDate=2021-06-04T14:46:44.735Z&toDate=2021-06-04T14:49:49.688Z&pageNo=1&size=100&accountNumber=100251330167");
var request = new RestRequest(Method.GET);
request.AddHeader("authorization", "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE0OTgxMzQ4OTQsImRhdGEiOnsic3ViIjoiNTk0MjNmMzZjZWEyMTQ2OTI2ODczOWE1IiwiY2xpZW50IjoiNTk0MjNmMzZjZWEyMTQ2OTI2ODczOWExIn0sImlhdCI6MTQ5ODA0ODQ5NH0.pevwSDpk-JDNtVIpqFu_m0Xu1UnDVumrAYStcrxf8sM");
request.AddHeader("content-type", "application/json");
request.AddParameter("application/json", @"{}", ParameterType.RequestBody);
IRestResponse response = client.Execute(request);

Query Parameters

Parameter	Description	Type	Required
fromDate	A string containing start date. e.g. 2021-01-01T00:00:00.000Z(If not provided then it will fetch last three months data)	String	No
toDate	A string containing end date. e.g. 2021-01-30T23:23:23.000Z (If not provided default value will be current date)	String	No
transactionType	One of [ADJUSTMENTS, AUTO_BOOK_FX, BOOK_FX, FEES, FUNDING, INVOICING, PAYOUTS, PREFUNDING, RECEIVE, CARD_FUNDING]. If left empty, this field defaults to All.	String	No
accountNumber	A number containing account number e.g: 101950173983 \n\n(Valid accountNumber length is 12 digit,\n\nIf accountNumber is not provided then it will provide All accounts details)	Number	No
pageNo	Page no to be start from. Will start 1 by default.	Number	No
size	Number of records to be limit. Will limit max 100 by default.	Number	No

Example Response

{
    "totalRecords": 13,
    "recordsFiltered": 13,
    "totalPages": 1,
    "currentPage": 1,
    "data": [
        {
            "_id": "60af2c5a38fd5f64d8cec3ae",
            "amount": 5000,
            "running_balance": 0,
            "account": 195661557164,
            "currency": "INR",
            "transaction_id": "PREPY10530949",
            "transaction_type": "Payouts",
            "remarks": "payment to nikhil to demo",
            "created_at": "2021-05-27T05:21:30.386Z",
            "type": "DEBIT",
            "transaction_reference_no": "1622092886"
        },
        {
            "_id": "60af2c5a38fd5fd8e3cec3ac",
            "amount": 5000,
            "running_balance": 5000,
            "account": 195661557164,
            "currency": "INR",
            "transaction_id": "PREPY10530949",
            "transaction_type": "Auto Book Fx",
            "remarks": "AUTO BOOKFX for PREPY10530949 _ payment to nikhil to demo",
            "created_at": "2021-05-27T05:21:30.258Z",
            "type": "CREDIT",
            "auto_bookfx_id": "PREAB10530951",
            "confirmation_id": "EUR-INR-rkMD3j3tu"
        },
        {
            "_id": "60af2c5a38fd5fa23ecec3aa",
            "amount": 56.37,
            "running_balance": 624.89,
            "account": 195650220864,
            "currency": "EUR",
            "transaction_id": "PREPY10530949",
            "transaction_type": "Auto Book Fx",
            "remarks": "AUTO BOOKFX for PREPY10530949 _ payment to nikhil to demo",
            "created_at": "2021-05-27T05:21:30.187Z",
            "type": "DEBIT",
            "auto_bookfx_id": "PREAB10530950",
            "confirmation_id": "EUR-INR-rkMD3j3tu"
        },
        {
            "_id": "6087a8aef7b8882e1d2dd3e2",
            "amount": 1,
            "running_balance": 160016,
            "account": 138451176819,
            "currency": "VND",
            "transaction_id": "PREPY10500758",
            "transaction_type": "Payouts",
            "remarks": "Transaction has been returned",
            "created_at": "2021-05-27T06:01:18.717Z",
            "type": "CREDIT",
            "transaction_reference_no": "1619499978"
        },
        {
            "_id": "60af2bcd38fd5f1381cec3a0",
            "amount": 10,
            "running_balance": 1068.25,
            "account": 195661629079,
            "currency": "USD",
            "transaction_id": "PREPY10530946",
            "transaction_type": "Deduct Fee",
            "remarks": "Test_20200409",
            "created_at": "2021-05-27T05:19:09.460Z",
            "type": "DEBIT"
        },
        {
            "_id": "60af2a8638fd5f3a46cec38d",
            "amount": 8.12,
            "running_balance": 681.26,
            "account": 195650220864,
            "currency": "EUR",
            "transaction_id": "PREBF10530945",
            "transaction_type": "Book Fx",
            "remarks": "Low balance in account.",
            "created_at": "2021-05-27T05:13:42.355Z",
            "type": "CREDIT",
            "confirmation_id": "USD-EUR-HJ0Kco3Fu"
        },
        {
            "_id": "60af2a8638fd5feaedcec38b",
            "amount": 10,
            "running_balance": 1178.25,
            "account": 195661629079,
            "currency": "USD",
            "transaction_id": "PREBF10530944",
            "transaction_type": "Book Fx",
            "remarks": "Low balance in account.",
            "created_at": "2021-05-27T05:13:42.234Z",
            "type": "DEBIT",
            "confirmation_id": "USD-EUR-HJ0Kco3Fu"
        },
        {
            "_id": "60af285038fd5f0829cec37b",
            "amount": 100,
            "running_balance": 729.51,
            "account": 195650220864,
            "currency": "EUR",
            "transaction_id": "PREIN10530940",
            "transaction_type": "Invoicing",
            "remarks": "test invoicing debit",
            "created_at": "2021-05-27T05:04:16.301Z",
            "type": "DEBIT"
        },
        {
            "_id": "60af282938fd5f5a50cec376",
            "amount": 500,
            "running_balance": 829.51,
            "account": 195650220864,
            "currency": "EUR",
            "transaction_id": "PREIN10530939",
            "transaction_type": "Invoicing",
            "remarks": "test invoicing credit",
            "created_at": "2021-05-27T05:03:37.935Z",
            "type": "CREDIT"
        },
        {
            "_id": "60af27ff38fd5f5fbfcec371",
            "amount": 200,
            "running_balance": 329.51,
            "account": 195650220864,
            "currency": "EUR",
            "transaction_id": "PREAD10530938",
            "transaction_type": "Adjustments",
            "remarks": "test adjustment credit",
            "created_at": "2021-05-27T05:02:55.340Z",
            "type": "CREDIT"
        },
        {
            "_id": "60af27da38fd5f7372cec36f",
            "amount": 100,
            "running_balance": 1188.25,
            "account": 195661629079,
            "currency": "USD",
            "transaction_id": "PREAD10530937",
            "transaction_type": "Adjustments",
            "remarks": "test adjustment debit",
            "created_at": "2021-05-27T05:02:18.031Z",
            "type": "DEBIT"
        },
       
        {
            "_id": "60af27a938fd5fe685cec36d",
            "amount": 200,
            "running_balance": 129.51,
            "account": 195650220864,
            "currency": "EUR",
            "transaction_id": "PREPF10530936",
            "transaction_type": "Funding",
            "remarks": "test funding debit",
            "created_at": "2021-05-27T05:01:29.140Z",
            "type": "DEBIT"
        },
        {
            "_id": "60af277c38fd5f938fcec368",
            "amount": 100,
            "running_balance": 1288.25,
            "account": 195661629079,
            "currency": "USD",
            "transaction_id": "PREPF10530935",
            "transaction_type": "Funding",
            "remarks": "test adjustment credit",
            "created_at": "2021-05-27T05:00:44.984Z",
            "type": "CREDIT"
        }
    ]
}

Response Parameters

Parameter	Description	Type
totalRecords	Returns total number of records.	Number
recordsFiltered	Returns number of filtered records.	Number
totalPages	Returns total number of pages.	Number
currentPage	Returns current page no.	Number
data	Returns array of all accounts data.	Array

Definition​

Header Parameters​

Example Request​

Query Parameters​

Example Response​

Response Parameters​

Definition

Header Parameters

Example Request

Query Parameters

Example Response

Response Parameters