GET api/Reconciliation/GetDetailedReportData?StartDate={StartDate}&EndDate={EndDate}&ReconciliationGroupID={ReconciliationGroupID}&StatementEntityID={StatementEntityID}&StatementID={StatementID}
Request Information
URI Parameters
| Name | Description | Type | Additional information |
|---|---|---|---|
| StartDate | string |
Required |
|
| EndDate | string |
Required |
|
| ReconciliationGroupID | string |
None. |
|
| StatementEntityID | integer |
None. |
|
| StatementID | integer |
None. |
Body Parameters
None.
Response Information
Resource Description
Collection of DetailedReportData| Name | Description | Type | Additional information |
|---|---|---|---|
| ReconciliationGroupID | string |
None. |
|
| StatementEntityID | integer |
None. |
|
| ReconciliationGroup | string |
None. |
|
| MerchantName | string |
None. |
|
| CurrentValues | DetailedReportValues |
None. |
|
| OpeningValues | DetailedReportValues |
None. |
|
| Summary | DetailedReportSummary |
None. |
Response Formats
application/json, text/json
Sample:
[
{
"ReconciliationGroupID": "sample string 1",
"StatementEntityID": 2,
"ReconciliationGroup": "sample string 3",
"MerchantName": "sample string 4",
"CurrentValues": {
"ArchivedCount": 1,
"ArchivedValue": 2.0,
"UnreconciledCount": 3,
"UnreconciledValue": 4.0,
"ReconciledCount": 5,
"ReconciledValue": 6.0,
"POLiFeesCount": 7,
"POLiFeesValue": 8.0,
"BankFeesCount": 9,
"BankFeesValue": 10.0,
"BankInterestCount": 11,
"BankInterestValue": 12.0,
"OtherCount": 13,
"OtherValue": 14.0,
"TransferCount": 15,
"TransferValue": 16.0,
"FraudReversalCount": 17,
"FraudReversalValue": 18.0,
"UnknownFundsCount": 19,
"UnknownFundsValue": 20.0,
"UnknownFundsRefundedCount": 21,
"UnknownFundsRefundedValue": 22.0,
"UnknownFundRepaymentsCount": 23,
"UnknownFundRepaymentsValue": 24.0
},
"OpeningValues": {
"ArchivedCount": 1,
"ArchivedValue": 2.0,
"UnreconciledCount": 3,
"UnreconciledValue": 4.0,
"ReconciledCount": 5,
"ReconciledValue": 6.0,
"POLiFeesCount": 7,
"POLiFeesValue": 8.0,
"BankFeesCount": 9,
"BankFeesValue": 10.0,
"BankInterestCount": 11,
"BankInterestValue": 12.0,
"OtherCount": 13,
"OtherValue": 14.0,
"TransferCount": 15,
"TransferValue": 16.0,
"FraudReversalCount": 17,
"FraudReversalValue": 18.0,
"UnknownFundsCount": 19,
"UnknownFundsValue": 20.0,
"UnknownFundsRefundedCount": 21,
"UnknownFundsRefundedValue": 22.0,
"UnknownFundRepaymentsCount": 23,
"UnknownFundRepaymentsValue": 24.0
},
"Summary": {
"OpeningBalance": 1.0,
"ClearedBalance": 2.0,
"ClearedCount": 3,
"UnClearedBalance": 4.0,
"BankFeeAndInterestCount": 5,
"BankFeeAndInterestBalance": 6.0,
"UnClearedCount": 7,
"PaymentsOut": 8.0,
"POLiFees": 9.0,
"FraudReversalBalance": 10.0,
"FraudReversalCount": 11.0,
"UnknownFundsValue": 12.0,
"UnknownFundRepaymentsCount": 13,
"UnknownFundRepaymentsValue": 14.0,
"UnreconciledBalance": 15.0,
"UnreconciledCount": 16,
"Balance": 17.0
}
},
{
"ReconciliationGroupID": "sample string 1",
"StatementEntityID": 2,
"ReconciliationGroup": "sample string 3",
"MerchantName": "sample string 4",
"CurrentValues": {
"ArchivedCount": 1,
"ArchivedValue": 2.0,
"UnreconciledCount": 3,
"UnreconciledValue": 4.0,
"ReconciledCount": 5,
"ReconciledValue": 6.0,
"POLiFeesCount": 7,
"POLiFeesValue": 8.0,
"BankFeesCount": 9,
"BankFeesValue": 10.0,
"BankInterestCount": 11,
"BankInterestValue": 12.0,
"OtherCount": 13,
"OtherValue": 14.0,
"TransferCount": 15,
"TransferValue": 16.0,
"FraudReversalCount": 17,
"FraudReversalValue": 18.0,
"UnknownFundsCount": 19,
"UnknownFundsValue": 20.0,
"UnknownFundsRefundedCount": 21,
"UnknownFundsRefundedValue": 22.0,
"UnknownFundRepaymentsCount": 23,
"UnknownFundRepaymentsValue": 24.0
},
"OpeningValues": {
"ArchivedCount": 1,
"ArchivedValue": 2.0,
"UnreconciledCount": 3,
"UnreconciledValue": 4.0,
"ReconciledCount": 5,
"ReconciledValue": 6.0,
"POLiFeesCount": 7,
"POLiFeesValue": 8.0,
"BankFeesCount": 9,
"BankFeesValue": 10.0,
"BankInterestCount": 11,
"BankInterestValue": 12.0,
"OtherCount": 13,
"OtherValue": 14.0,
"TransferCount": 15,
"TransferValue": 16.0,
"FraudReversalCount": 17,
"FraudReversalValue": 18.0,
"UnknownFundsCount": 19,
"UnknownFundsValue": 20.0,
"UnknownFundsRefundedCount": 21,
"UnknownFundsRefundedValue": 22.0,
"UnknownFundRepaymentsCount": 23,
"UnknownFundRepaymentsValue": 24.0
},
"Summary": {
"OpeningBalance": 1.0,
"ClearedBalance": 2.0,
"ClearedCount": 3,
"UnClearedBalance": 4.0,
"BankFeeAndInterestCount": 5,
"BankFeeAndInterestBalance": 6.0,
"UnClearedCount": 7,
"PaymentsOut": 8.0,
"POLiFees": 9.0,
"FraudReversalBalance": 10.0,
"FraudReversalCount": 11.0,
"UnknownFundsValue": 12.0,
"UnknownFundRepaymentsCount": 13,
"UnknownFundRepaymentsValue": 14.0,
"UnreconciledBalance": 15.0,
"UnreconciledCount": 16,
"Balance": 17.0
}
}
]
application/xml, text/xml
Sample:
<ArrayOfDetailedReportData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.datacontract.org/2004/07/ConsoleAPI.Internal.Models.Reconciliation">
<DetailedReportData>
<CurrentValues>
<ArchivedCount>1</ArchivedCount>
<ArchivedValue>2</ArchivedValue>
<BankFeesCount>9</BankFeesCount>
<BankFeesValue>10</BankFeesValue>
<BankInterestCount>11</BankInterestCount>
<BankInterestValue>12</BankInterestValue>
<FraudReversalCount>17</FraudReversalCount>
<FraudReversalValue>18</FraudReversalValue>
<OtherCount>13</OtherCount>
<OtherValue>14</OtherValue>
<POLiFeesCount>7</POLiFeesCount>
<POLiFeesValue>8</POLiFeesValue>
<ReconciledCount>5</ReconciledCount>
<ReconciledValue>6</ReconciledValue>
<TransferCount>15</TransferCount>
<TransferValue>16</TransferValue>
<UnknownFundRepaymentsCount>23</UnknownFundRepaymentsCount>
<UnknownFundRepaymentsValue>24</UnknownFundRepaymentsValue>
<UnknownFundsCount>19</UnknownFundsCount>
<UnknownFundsRefundedCount>21</UnknownFundsRefundedCount>
<UnknownFundsRefundedValue>22</UnknownFundsRefundedValue>
<UnknownFundsValue>20</UnknownFundsValue>
<UnreconciledCount>3</UnreconciledCount>
<UnreconciledValue>4</UnreconciledValue>
</CurrentValues>
<MerchantName>sample string 4</MerchantName>
<OpeningValues>
<ArchivedCount>1</ArchivedCount>
<ArchivedValue>2</ArchivedValue>
<BankFeesCount>9</BankFeesCount>
<BankFeesValue>10</BankFeesValue>
<BankInterestCount>11</BankInterestCount>
<BankInterestValue>12</BankInterestValue>
<FraudReversalCount>17</FraudReversalCount>
<FraudReversalValue>18</FraudReversalValue>
<OtherCount>13</OtherCount>
<OtherValue>14</OtherValue>
<POLiFeesCount>7</POLiFeesCount>
<POLiFeesValue>8</POLiFeesValue>
<ReconciledCount>5</ReconciledCount>
<ReconciledValue>6</ReconciledValue>
<TransferCount>15</TransferCount>
<TransferValue>16</TransferValue>
<UnknownFundRepaymentsCount>23</UnknownFundRepaymentsCount>
<UnknownFundRepaymentsValue>24</UnknownFundRepaymentsValue>
<UnknownFundsCount>19</UnknownFundsCount>
<UnknownFundsRefundedCount>21</UnknownFundsRefundedCount>
<UnknownFundsRefundedValue>22</UnknownFundsRefundedValue>
<UnknownFundsValue>20</UnknownFundsValue>
<UnreconciledCount>3</UnreconciledCount>
<UnreconciledValue>4</UnreconciledValue>
</OpeningValues>
<ReconciliationGroup>sample string 3</ReconciliationGroup>
<ReconciliationGroupID>sample string 1</ReconciliationGroupID>
<StatementEntityID>2</StatementEntityID>
<Summary>
<Balance>17</Balance>
<BankFeeAndInterestBalance>6</BankFeeAndInterestBalance>
<BankFeeAndInterestCount>5</BankFeeAndInterestCount>
<ClearedBalance>2</ClearedBalance>
<ClearedCount>3</ClearedCount>
<FraudReversalBalance>10</FraudReversalBalance>
<FraudReversalCount>11</FraudReversalCount>
<OpeningBalance>1</OpeningBalance>
<POLiFees>9</POLiFees>
<PaymentsOut>8</PaymentsOut>
<UnClearedBalance>4</UnClearedBalance>
<UnClearedCount>7</UnClearedCount>
<UnknownFundRepaymentsCount>13</UnknownFundRepaymentsCount>
<UnknownFundRepaymentsValue>14</UnknownFundRepaymentsValue>
<UnknownFundsValue>12</UnknownFundsValue>
<UnreconciledBalance>15</UnreconciledBalance>
<UnreconciledCount>16</UnreconciledCount>
</Summary>
</DetailedReportData>
<DetailedReportData>
<CurrentValues>
<ArchivedCount>1</ArchivedCount>
<ArchivedValue>2</ArchivedValue>
<BankFeesCount>9</BankFeesCount>
<BankFeesValue>10</BankFeesValue>
<BankInterestCount>11</BankInterestCount>
<BankInterestValue>12</BankInterestValue>
<FraudReversalCount>17</FraudReversalCount>
<FraudReversalValue>18</FraudReversalValue>
<OtherCount>13</OtherCount>
<OtherValue>14</OtherValue>
<POLiFeesCount>7</POLiFeesCount>
<POLiFeesValue>8</POLiFeesValue>
<ReconciledCount>5</ReconciledCount>
<ReconciledValue>6</ReconciledValue>
<TransferCount>15</TransferCount>
<TransferValue>16</TransferValue>
<UnknownFundRepaymentsCount>23</UnknownFundRepaymentsCount>
<UnknownFundRepaymentsValue>24</UnknownFundRepaymentsValue>
<UnknownFundsCount>19</UnknownFundsCount>
<UnknownFundsRefundedCount>21</UnknownFundsRefundedCount>
<UnknownFundsRefundedValue>22</UnknownFundsRefundedValue>
<UnknownFundsValue>20</UnknownFundsValue>
<UnreconciledCount>3</UnreconciledCount>
<UnreconciledValue>4</UnreconciledValue>
</CurrentValues>
<MerchantName>sample string 4</MerchantName>
<OpeningValues>
<ArchivedCount>1</ArchivedCount>
<ArchivedValue>2</ArchivedValue>
<BankFeesCount>9</BankFeesCount>
<BankFeesValue>10</BankFeesValue>
<BankInterestCount>11</BankInterestCount>
<BankInterestValue>12</BankInterestValue>
<FraudReversalCount>17</FraudReversalCount>
<FraudReversalValue>18</FraudReversalValue>
<OtherCount>13</OtherCount>
<OtherValue>14</OtherValue>
<POLiFeesCount>7</POLiFeesCount>
<POLiFeesValue>8</POLiFeesValue>
<ReconciledCount>5</ReconciledCount>
<ReconciledValue>6</ReconciledValue>
<TransferCount>15</TransferCount>
<TransferValue>16</TransferValue>
<UnknownFundRepaymentsCount>23</UnknownFundRepaymentsCount>
<UnknownFundRepaymentsValue>24</UnknownFundRepaymentsValue>
<UnknownFundsCount>19</UnknownFundsCount>
<UnknownFundsRefundedCount>21</UnknownFundsRefundedCount>
<UnknownFundsRefundedValue>22</UnknownFundsRefundedValue>
<UnknownFundsValue>20</UnknownFundsValue>
<UnreconciledCount>3</UnreconciledCount>
<UnreconciledValue>4</UnreconciledValue>
</OpeningValues>
<ReconciliationGroup>sample string 3</ReconciliationGroup>
<ReconciliationGroupID>sample string 1</ReconciliationGroupID>
<StatementEntityID>2</StatementEntityID>
<Summary>
<Balance>17</Balance>
<BankFeeAndInterestBalance>6</BankFeeAndInterestBalance>
<BankFeeAndInterestCount>5</BankFeeAndInterestCount>
<ClearedBalance>2</ClearedBalance>
<ClearedCount>3</ClearedCount>
<FraudReversalBalance>10</FraudReversalBalance>
<FraudReversalCount>11</FraudReversalCount>
<OpeningBalance>1</OpeningBalance>
<POLiFees>9</POLiFees>
<PaymentsOut>8</PaymentsOut>
<UnClearedBalance>4</UnClearedBalance>
<UnClearedCount>7</UnClearedCount>
<UnknownFundRepaymentsCount>13</UnknownFundRepaymentsCount>
<UnknownFundRepaymentsValue>14</UnknownFundRepaymentsValue>
<UnknownFundsValue>12</UnknownFundsValue>
<UnreconciledBalance>15</UnreconciledBalance>
<UnreconciledCount>16</UnreconciledCount>
</Summary>
</DetailedReportData>
</ArrayOfDetailedReportData>