Download OpenAPI specification:Download
Api guide to integrate with Optimus platform
This API is designed to upload files; that needs to be ingested in Optimus.
fileContent required | string <binary> Input file needs to be uploaded |
[- {
- "code": "981",
- "description": "File should not be empty "
}
]
This API is designed to create a job in Optimus. This job can be a 'data ingestion', 'reconciliation', 'report generation' job. Response of this API is a job id; which can be further used to track job status.
Job parameters
serviceName required | string serviceName for which this job needs to run |
object input parameters required for this job, For file based DI it will contain filename |
File based DI job request
{- "serviceName": "Paypal-Data-DI",
- "jobRunParams": {
- "filePath": "Paypal-20240101.csv"
}
}
{- "id": "c6a86398-460d-4632-9186-e63420f0cd66"
}
This API is designed to get job info from Optimus. This job can be a 'data ingestion', 'reconciliation', 'report generation' job.
jobId required | string Example: c6a86398-460d-4632-9186-e63420f0cd66 job id |
{- "id": "c6a86398-460d-4632-9186-e63420f0cd66",
- "status": "COMPLETED",
- "serviceName": "Paypal-Data-DI",
- "createdAt": "23-05-2024T18:30:00Z",
- "endTime": "24-05-2024T18:29:59Z",
- "jobInitiator": {
- "by": "ganesh@tmobile",
- "type": "MANUAL"
}
}
This API is designed to ingest data into a source.
sourceName required | string Example: Paypal source name |
recordType required | string Example: Data record type of a given source |
Request for data ingestion into source
required | object records that needs to be ingested into a source |
{- "records": [
- {
- "APPLICATION_ID": "ARPHPP",
- "RecordCount_CF": 10000,
- "PYM_SUB_METHOD": "MC",
- "Currency": "INR",
- "ACTV_DATE": "2022-07-21T00:00:00+05:30",
- "PYM_METHOD": "CK",
- "ACTV_CODE": "BCK",
- "SYS_CREATION_DATE": "2022-07-21T00:00:00+05:30",
- "ACTV_AMT": 2000,
- "ORIGINAL_BAN": "474346805",
- "DL_SERVICE_CODE": "AR003",
- "SOURCE_ID": "JPAY_RT",
- "BAN": "282886531",
- "DEPOSIT_DATE": "2022-07-21T00:00:00+05:30",
- "PRODUCT_TYPE": "G",
- "TodayDate_CF": "2022-07-22T16:11:19.453+05:30",
- "ACTV_REASON_CODE": "DCK",
- "RECEIPT_ID": "324532825",
- "ENT_SEQ_NO": "20000098",
- "INTERNAL_ACTV_AMT": 2000
}, - {
- "RecordCount_CF": 12000,
- "PYM_SUB_METHOD": "MC",
- "Currency": "INR",
- "ACTV_DATE": "2022-07-21T00:00:00+05:30",
- "PYM_METHOD": "CK",
- "ACTV_CODE": "BCK",
- "SYS_CREATION_DATE": "2022-07-21T00:00:00+05:30",
- "ACTV_AMT": 2000,
- "ORIGINAL_BAN": "474346805",
- "DL_SERVICE_CODE": "AR003",
- "SOURCE_ID": "JPAY_RT",
- "DEPOSIT_DATE": "2022-07-21T00:00:00+05:30",
- "PRODUCT_TYPE": "G",
- "TodayDate_CF": "2022-07-22T16:11:19.453+05:30",
- "ACTV_REASON_CODE": "DCK",
- "RECEIPT_ID": "324532825",
- "ENT_SEQ_NO": "20000098",
- "INTERNAL_ACTV_AMT": 2000
}, - {
- "APPLICATION_ID": "ARPHPP",
- "RecordCount_CF": 10000,
- "PYM_SUB_METHOD": "MC",
- "Currency": "INR",
- "ACTV_DATE": "2022-07-21T00:00:00+05:30",
- "PYM_METHOD": "CK",
- "ACTV_CODE": "BCK",
- "SYS_CREATION_DATE": "2022-07-21T00:00:00+05:30",
- "ACTV_AMT": 1500,
- "ORIGINAL_BAN": "474346805",
- "DL_SERVICE_CODE": "AR003",
- "SOURCE_ID": "JPAY_RT",
- "BAN": "282886531",
- "DEPOSIT_DATE": "2022-07-21T00:00:00+05:30",
- "PRODUCT_TYPE": "G",
- "TodayDate_CF": "2022-07-22T16:11:19.453+05:30",
- "ACTV_REASON_CODE": "DCK",
- "RECEIPT_ID": "324532825",
- "ENT_SEQ_NO": "20000098",
- "INTERNAL_ACTV_AMT": 1500
}
]
}
{- "id": "c6a86398-460d-4632-9186-e63420f0cd66",
- "sourceName": "Paypal",
- "recordType": "Data",
- "runDate": "23-05-2024T18:30:00Z",
- "ingestedCount": 2,
- "errorCount": 1,
- "errorList": [
- {
- "code": "ERR01",
- "description": "Missing APPLICATION_ID and BAN for record: 2"
}
]
}
This API is used to fetch the transaction report details of the source or within two sources.
limit | integer <int32> Default: 100 Example: limit=100 Number of transactions per page |
page | integer <int32> Default: 1 Example: page=1 Page number |
Report request details
startDate required | string <date-time> Start date |
endDate required | string <date-time> End date |
sourceName required | string Source name configured in Optimus |
recordType required | string Record type configured in Optimus |
dateFieldName | string Date field name for which start date and end end filter needs to be applied |
Array of objects (OtherSource) Other source details | |
expectedFields | Array of strings Fields to be included in the response |
Request with mandatory fields
{- "startDate": "2022-01-19T18:30:00Z",
- "endDate": "2022-07-24T18:29:59Z",
- "sourceName": "Samson",
- "recordType": "Data"
}
Response based on mandatory fields in request
{- "result": [
- {
- "APPLICATION_ID": "ARPHPP",
- "RecordCount_CF": 10000,
- "PYM_SUB_METHOD": "MC",
- "Currency": "INR",
- "ACTV_DATE": "2022-07-21T00:00:00+05:30",
- "PYM_METHOD": "CK",
- "ACTV_CODE": "BCK",
- "SYS_CREATION_DATE": "2022-07-21T00:00:00+05:30",
- "ACTV_AMT": 2000,
- "ORIGINAL_BAN": "474346805",
- "DL_SERVICE_CODE": "AR003",
- "SOURCE_ID": "JPAY_RT",
- "BAN": "282886531",
- "DEPOSIT_DATE": "2022-07-21T00:00:00+05:30",
- "PRODUCT_TYPE": "G",
- "TodayDate_CF": "2022-07-22T16:11:19.453+05:30",
- "ACTV_REASON_CODE": "DCK",
- "RECEIPT_ID": "324532825",
- "ENT_SEQ_NO": "20000098",
- "INTERNAL_ACTV_AMT": 2000
}, - {
- "APPLICATION_ID": "ARPHPP",
- "RecordCount_CF": 12000,
- "PYM_SUB_METHOD": "MC",
- "Currency": "INR",
- "ACTV_DATE": "2022-07-21T00:00:00+05:30",
- "PYM_METHOD": "CK",
- "ACTV_CODE": "BCK",
- "SYS_CREATION_DATE": "2022-07-21T00:00:00+05:30",
- "ACTV_AMT": 2000,
- "ORIGINAL_BAN": "474346805",
- "DL_SERVICE_CODE": "AR003",
- "SOURCE_ID": "JPAY_RT",
- "BAN": "282886531",
- "DEPOSIT_DATE": "2022-07-21T00:00:00+05:30",
- "PRODUCT_TYPE": "G",
- "TodayDate_CF": "2022-07-22T16:11:19.453+05:30",
- "ACTV_REASON_CODE": "DCK",
- "RECEIPT_ID": "324532825",
- "ENT_SEQ_NO": "20000098",
- "INTERNAL_ACTV_AMT": 2000
}, - {
- "APPLICATION_ID": "ARPHPP",
- "RecordCount_CF": 13000,
- "PYM_SUB_METHOD": "VI",
- "Currency": "INR",
- "ACTV_DATE": "2022-07-21T00:00:00+05:30",
- "PYM_METHOD": "CK",
- "ACTV_CODE": "BCK",
- "SYS_CREATION_DATE": "2022-07-22T00:00:00+05:30",
- "ACTV_AMT": 1500,
- "ORIGINAL_BAN": "484346123",
- "DL_SERVICE_CODE": "AR003",
- "SOURCE_ID": "JPAY_RT",
- "BAN": "282886531",
- "DEPOSIT_DATE": "2022-07-21T00:00:00+05:30",
- "PRODUCT_TYPE": "G",
- "TodayDate_CF": "2022-07-22T16:11:19.453+05:30",
- "ACTV_REASON_CODE": "DCK",
- "RECEIPT_ID": "324532825",
- "ENT_SEQ_NO": "20000098",
- "INTERNAL_ACTV_AMT": 1500
}
], - "count": 3
}
This API is designed to get metadata for transaction reports.
includeTagValues | boolean Default: false Set to true if tag values are required for tag fields |
Transaction metadata request details
Array of objects (SourceWithRecordType) List of source name and record type. If present then, | |
sourceCategories | Array of strings Source categories, applicable when |
recordTypeCategories | Array of strings Record type categories, applicable when |
canvas | string Canvas name, applicable when |
sourceWithRecordType
is present
{- "sourceWithRecordType": [
- {
- "sourceName": "Samson",
- "recType": "Data"
}
]
}
[- {
- "name": "ACTV_CODE",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "AMT_DUE",
- "type": "AMOUNT",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "ACTV_SEQ_NO",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "SOURCE_ID",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "RECEIPT_ID",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "FEE_CURRENCY",
- "type": "STRING",
- "domainType": "feeCurrency",
- "tagField": false,
- "searchable": true,
- "includeInSummary": true
}, - {
- "name": "ENT_SEQ_NO",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "ORIGINAL_BAN",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "ORIGINAL_AMT",
- "type": "AMOUNT",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "AUTH_CHANNEL_ID",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "APPLICATION_ID",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "FEE_AMOUNT",
- "type": "AMOUNT",
- "domainType": "feeAmount",
- "tagField": false,
- "searchable": false,
- "includeInSummary": true
}, - {
- "name": "CardNetwork",
- "type": "STRING",
- "tagField": true
}, - {
- "name": "ACTV_REASON_CODE",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "PRODUCT_TYPE",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "ProductType",
- "type": "STRING",
- "tagField": true
}, - {
- "name": "ACTV_DATE",
- "type": "DATE",
- "domainType": "transactionDate",
- "tagField": false,
- "searchable": true,
- "includeInSummary": true
}, - {
- "name": "SETTLEMENT_AMOUNT",
- "type": "AMOUNT",
- "domainType": "settlementAmount",
- "tagField": false,
- "searchable": false,
- "includeInSummary": true
}, - {
- "name": "SOURCE_TYPE",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "INTERNAL_ACTV_AMT",
- "type": "AMOUNT",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "BAN",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "DESIGNATION",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "DEPOSIT_DATE",
- "type": "DATE",
- "tagField": false,
- "searchable": true,
- "includeInSummary": true
}, - {
- "name": "PYM_SUB_METHOD",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "DL_SERVICE_CODE",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "PYM_METHOD",
- "type": "STRING",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "SYS_CREATION_DATE",
- "type": "DATE",
- "tagField": false,
- "searchable": true,
- "includeInSummary": false
}, - {
- "name": "ACTV_AMT",
- "type": "AMOUNT",
- "domainType": "transactionAmount",
- "tagField": false,
- "searchable": true,
- "includeInSummary": true
}, - {
- "name": "SETTLEMENT_CURRENCY",
- "type": "STRING",
- "domainType": "settlementCurrency",
- "tagField": false,
- "searchable": true,
- "includeInSummary": true
}, - {
- "name": "Currency",
- "type": "STRING",
- "domainType": "transactionCurrency",
- "tagField": false,
- "searchable": true,
- "includeInSummary": true
}, - {
- "name": "CardType",
- "type": "STRING",
- "tagField": true
}
]
This API is used to fetch the summary report details of the source or within two sources.
limit | integer <int32> Default: 100 Example: limit=100 Number of records per page |
page | integer <int32> Default: 1 Example: page=1 Page number |
Report request details
startDate required | string <date-time> Start date |
endDate required | string <date-time> End date |
sourceName required | string Source name configured in Optimus |
recordType required | string Record type configured in Optimus |
dateFieldName | string Date field name for which start date and end end filter needs to be applied |
Array of objects (OtherSource) Other source details | |
expectedFields | Array of strings Fields to be included in the response |
Request with mandatory fields
{- "startDate": "2024-04-25T00:00:00Z",
- "endDate": "2024-05-01T23:59:59Z",
- "sourceName": "Samson",
- "recType": "Data"
}
Response based on mandatory fields in request
{- "result": [
- {
- "defaultDate": "2024-05-02T00:00:00Z",
- "transactionCurrency": "USD",
- "APPLICATION_ID": "ARPHPP",
- "SourceID": "JPAY_RT",
- "ProductType": "unknown",
- "DesignationTag": "unknown",
- "CardNetwordTag": "visa",
- "CardTypeTag": "unknown",
- "BAN": "0545332",
- "PYM_SUB_METHOD": "VS",
- "PYM_METHOD": "DC",
- "CurrencyType": "USD",
- "ToDoubleInternalAmt_CF": 0,
- "ProductCFDefect": 0,
- "feeAmount": "0.00",
- "totalAmount": 0,
- "interchangeFee": "0.00",
- "transactionAmount": "2000.00",
- "ENT_SEQ_NO": 29782,
- "CountCF": 2,
- "switchingFee": "0.00",
- "INTERNAL_ACTV_AMT": 2000,
- "assessmentsFee": "0.00"
}, - {
- "defaultDate": "2024-05-01T00:00:00Z",
- "transactionCurrency": "USD",
- "APPLICATION_ID": "ARPHPP",
- "SourceID": "JPAY_RT",
- "ProductType": "G",
- "DesignationTag": "unknown",
- "CardNetwordTag": "mastercard",
- "CardTypeTag": "unknown",
- "BAN": "0545331",
- "PYM_SUB_METHOD": "MC",
- "PYM_METHOD": "CC",
- "CurrencyType": "USD",
- "ToDoubleInternalAmt_CF": 0,
- "ProductCFDefect": 0,
- "feeAmount": "0.00",
- "totalAmount": 0,
- "interchangeFee": "0.00",
- "transactionAmount": "1000.00",
- "ENT_SEQ_NO": 29781,
- "CountCF": 1,
- "switchingFee": "0.00",
- "INTERNAL_ACTV_AMT": 1000,
- "assessmentsFee": "0.00"
}
], - "count": 2
}
This API is designed to get metadata for summary reports.
includeTagValues | boolean Default: false Set to true if tag values are required for tag fields |
Summary metadata request details
Array of objects (SourceWithRecordType) List of source name and record type. If present then, | |
sourceCategories | Array of strings Source categories, applicable when |
recordTypeCategories | Array of strings Record type categories, applicable when |
canvas | string Canvas name, applicable when |
sourceWithRecordType
is present
{- "sourceWithRecordType": [
- {
- "sourceName": "Samson",
- "recType": "Data"
}
]
}
[- {
- "name": "FEE_CURRENCY",
- "type": "STRING",
- "domainType": "feeCurrency",
- "tagField": false
}, - {
- "name": "Currency",
- "type": "STRING",
- "domainType": "transactionCurrency",
- "tagField": false
}, - {
- "name": "DEPOSIT_DATE",
- "type": "DATE",
- "tagField": false
}, - {
- "name": "CardNetwork",
- "type": "STRING",
- "tagField": true
}, - {
- "name": "ProductType",
- "type": "STRING",
- "tagField": true
}, - {
- "name": "ACTV_AMT",
- "type": "AMOUNT",
- "domainType": "transactionAmount",
- "tagField": false
}, - {
- "name": "CardType",
- "type": "STRING",
- "tagField": true
}, - {
- "name": "SETTLEMENT_CURRENCY",
- "type": "STRING",
- "domainType": "settlementCurrency",
- "tagField": false
}, - {
- "name": "FEE_AMOUNT",
- "type": "AMOUNT",
- "domainType": "feeAmount",
- "tagField": false
}, - {
- "name": "ACTV_DATE",
- "type": "DATE",
- "domainType": "transactionDate",
- "tagField": false
}, - {
- "name": "SETTLEMENT_AMOUNT",
- "type": "AMOUNT",
- "domainType": "settlementAmount",
- "tagField": false
}
]
This API is used to fetch the transaction report details of the source or within two sources with advanced request parameters.
limit | integer <int32> Default: 100 Example: limit=100 Number of transactions per page |
page | integer <int32> Default: 1 Example: page=1 Page number |
Advanced transaction request details
object (DataSource) Data source information | |
object (IFilter) Used to perform advance filtering | |
Array of objects (Sort) sorting information for results returned | |
reportName | string report name of the template already configured within Optimus |
Array of objects (TransactionField) list of all transaction fields expected in the response |
Transaction request for individual data ingestion
{- "dataSource": {
- "sourceWithRecordType": [
- {
- "sourceName": "Samson",
- "recType": "Data"
}
]
}, - "filters": {
- "type": "L",
- "op": "AND",
- "childs": [
- {
- "name": "tag.creationDate",
- "op": "range",
- "type": "C",
- "value": [
- "2024-04-30T18:30:00Z",
- "2024-05-30T18:29:59Z"
]
}
]
}, - "fields": [
- {
- "name": "BAN"
}, - {
- "name": "Total_Fee",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "SwitchingFee",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "AssessmentFee",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "CardtypeLookup_May_CF"
}, - {
- "name": "NConcatCF"
}, - {
- "name": "NewField_CF"
}, - {
- "name": "ENT_SEQ_NO"
}, - {
- "name": "DEPOSIT_DATE",
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}
}, - {
- "name": "ACTV_DATE",
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}
}, - {
- "name": "INTERNAL_ACTV_AMT",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "TxnCurrency"
}, - {
- "name": "MasknumberCF"
}, - {
- "name": "CountCF"
}, - {
- "name": "EqualCF"
}, - {
- "name": "SYS_CREATION_DATE",
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}
}, - {
- "name": "APPLICATION_ID"
}, - {
- "name": "AMT_DUE",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "ACTV_AMT",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "Total_FeeCurrency"
}, - {
- "name": "DL_SERVICE_CODE"
}, - {
- "name": "PYM_METHOD"
}, - {
- "name": "CardtypeLookupCF"
}, - {
- "name": "NewTableLookupCF"
}, - {
- "name": "PYM_SUB_METHOD"
}, - {
- "name": "RECEIPT_ID"
}, - {
- "name": "ACTV_CODE"
}, - {
- "name": "SOURCE_ID"
}, - {
- "name": "PRODUCT_TYPE"
}, - {
- "name": "ACTV_REASON_CODE"
}, - {
- "name": "ORIGINAL_BAN"
}, - {
- "name": "DateReport",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}
}, - {
- "name": "SwitchingFeeCurrency"
}, - {
- "name": "AssessmentFeeCurrency"
}, - {
- "name": "tag.creationDate",
- "output": false,
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}
}
]
}
Transaction response for individual data ingestion
{- "result": [
- {
- "BAN": "1121260",
- "Total_Fee": "50.00",
- "CardtypeLookup_May_CF": "PrepaidCard",
- "ENT_SEQ_NO": 29780,
- "DEPOSIT_DATE": "May 24th, 2024",
- "ACTV_DATE": "May 24th, 2024",
- "INTERNAL_ACTV_AMT": "1000.00",
- "TxnCurrency": "CAD",
- "CountCF": 11,
- "EqualCF": "CAD",
- "SYS_CREATION_DATE": "May 24th, 2024",
- "APPLICATION_ID": "ARPHPP",
- "AMT_DUE": "1000.00",
- "ACTV_AMT": "1000.00",
- "DL_SERVICE_CODE": "AR001",
- "PYM_METHOD": "PC",
- "PYM_SUB_METHOD": "VS",
- "RECEIPT_ID": "1925471",
- "ACTV_CODE": "PYM ",
- "SOURCE_ID": "JPAY_RT",
- "PRODUCT_TYPE": "U",
- "ACTV_REASON_CODE": "CCVS",
- "ORIGINAL_BAN": "24824571"
}, - {
- "BAN": "1121260",
- "Total_Fee": "50.00",
- "CardtypeLookup_May_CF": "PrepaidCard",
- "ENT_SEQ_NO": 29780,
- "DEPOSIT_DATE": "May 24th, 2024",
- "ACTV_DATE": "May 24th, 2024",
- "INTERNAL_ACTV_AMT": "1000.00",
- "TxnCurrency": "CAD",
- "CountCF": 10,
- "EqualCF": "CAD",
- "SYS_CREATION_DATE": "May 24th, 2024",
- "APPLICATION_ID": "ARPHPP",
- "AMT_DUE": "1000.00",
- "ACTV_AMT": "1000.00",
- "DL_SERVICE_CODE": "AR001",
- "PYM_METHOD": "PC",
- "PYM_SUB_METHOD": "MC",
- "RECEIPT_ID": "1925470",
- "ACTV_CODE": "PYM ",
- "SOURCE_ID": "JPAY_RT",
- "PRODUCT_TYPE": "U",
- "ACTV_REASON_CODE": "CCVS",
- "ORIGINAL_BAN": "24824571"
}
], - "count": 2
}
This API is used to fetch the summary report details of the source or within two sources with advanced request parameters.
limit | integer <int32> Default: 100 Example: limit=100 Number of transactions per page |
page | integer <int32> Default: 1 Example: page=1 Page number |
Advanced summary request details
object (DataSource) Data source information | |
object (IFilter) Used to perform advance filtering | |
Array of objects (Sort) sorting information for results returned | |
reportName | string report name of the template already configured within Optimus |
Array of objects (SummaryField) list of all summary fields expected in the response |
Summary request for individual data ingestion
{- "dataSource": {
- "sourceWithRecordType": [
- {
- "sourceName": "Samson",
- "recType": "Data"
}
]
}, - "filters": {
- "type": "L",
- "op": "AND",
- "childs": [
- {
- "name": "createdDate",
- "op": "range",
- "type": "C",
- "value": [
- "2024-04-30T18:30:00Z",
- "2024-05-30T18:29:59Z"
]
}, - {
- "name": "recType",
- "op": "eq",
- "type": "C",
- "value": "Data"
}
]
}, - "fields": [
- {
- "name": "BAN",
- "aggregatedBy": "NONE"
}, - {
- "name": "feeAmount",
- "alias": "Total_Fee",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM"
}, - {
- "name": "switchingFee",
- "alias": "SwitchingFee",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM"
}, - {
- "name": "assessmentsFee",
- "alias": "AssessmentFee",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM"
}, - {
- "name": "CardNetwordTag",
- "aggregatedBy": "NONE"
}, - {
- "name": "ENT_SEQ_NO",
- "aggregatedBy": "SUM"
}, - {
- "name": "DEPOSIT_DATE",
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}, - "aggregatedBy": "NONE"
}, - {
- "name": "ACTV_DATE",
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}, - "aggregatedBy": "NONE"
}, - {
- "name": "INTERNAL_ACTV_AMT",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM"
}, - {
- "name": "transactionCurrency",
- "alias": "TxnCurrency",
- "aggregatedBy": "NONE"
}, - {
- "name": "CountCF",
- "aggregatedBy": "SUM"
}, - {
- "name": "CardTypeTag",
- "aggregatedBy": "NONE"
}, - {
- "name": "transactionDate",
- "alias": "SYS_CREATION_DATE",
- "format": {
- "dateFormat": "MMM do, YYYY",
- "type": "DATE"
}, - "aggregatedBy": "NONE"
}, - {
- "name": "APPLICATION_ID",
- "aggregatedBy": "NONE"
}, - {
- "name": "transactionAmount",
- "alias": "ACTV_AMT",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM"
}, - {
- "name": "feeCurrency",
- "alias": "Total_FeeCurrency",
- "aggregatedBy": "NONE"
}, - {
- "name": "CurrencyType",
- "aggregatedBy": "NONE"
}, - {
- "name": "ProductType",
- "aggregatedBy": "NONE"
}, - {
- "name": "PYM_METHOD",
- "aggregatedBy": "NONE"
}, - {
- "name": "SourceID",
- "aggregatedBy": "NONE"
}, - {
- "name": "PYM_SUB_METHOD",
- "aggregatedBy": "NONE"
}, - {
- "name": "DesignationTag",
- "aggregatedBy": "NONE"
}, - {
- "name": "interchangeFee",
- "alias": "DateReport",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM"
}, - {
- "name": "switchingFeeCurrency",
- "alias": "SwitchingFeeCurrency",
- "aggregatedBy": "NONE"
}, - {
- "name": "assessmentsFeeCurrency",
- "alias": "AssessmentFeeCurrency",
- "aggregatedBy": "NONE"
}, - {
- "name": "interchangeFeeCurrency",
- "alias": "InterchangeFeeCurrency",
- "aggregatedBy": "NONE"
}, - {
- "name": "ToDoubleInternalAmt_CF",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM",
- "output": false
}, - {
- "name": "ProductCFDefect",
- "format": {
- "isCurrencyPrefixRequired": false,
- "isCommaPositionRequired": false,
- "type": "AMOUNT"
}, - "aggregatedBy": "SUM",
- "output": false
}
]
}
Summary response for individual data ingestion
{- "result": [
- {
- "BAN": "2245335",
- "Total_Fee": "0.00",
- "SwitchingFee": "0.00",
- "AssessmentFee": "0.00",
- "CardNetwordTag": "mastercard",
- "ENT_SEQ_NO": 29785,
- "DEPOSIT_DATE": "May 22nd, 2024",
- "ACTV_DATE": "May 22nd, 2024",
- "INTERNAL_ACTV_AMT": "5000.00",
- "TxnCurrency": "EUR",
- "CountCF": 5,
- "CardTypeTag": "unknown",
- "SYS_CREATION_DATE": "May 22nd, 2024",
- "APPLICATION_ID": "ARPHPP",
- "ACTV_AMT": "5000.00",
- "CurrencyType": "EUR",
- "ProductType": "G",
- "PYM_METHOD": "PC",
- "SourceID": "JPAY_RT",
- "PYM_SUB_METHOD": "MC",
- "DesignationTag": "unknown",
- "DateReport": "0.00"
}, - {
- "BAN": "2245334",
- "Total_Fee": "40.00",
- "SwitchingFee": "0.00",
- "AssessmentFee": "0.00",
- "CardNetwordTag": "visa",
- "ENT_SEQ_NO": 29784,
- "DEPOSIT_DATE": "May 22nd, 2024",
- "ACTV_DATE": "May 22nd, 2024",
- "INTERNAL_ACTV_AMT": "4000.00",
- "TxnCurrency": "GBP",
- "CountCF": 4,
- "CardTypeTag": "unknown",
- "SYS_CREATION_DATE": "May 22nd, 2024",
- "APPLICATION_ID": "ARPHPP",
- "ACTV_AMT": "4000.00",
- "CurrencyType": "GBP",
- "ProductType": "unknown",
- "PYM_METHOD": "DC",
- "SourceID": "JPAY_RT",
- "PYM_SUB_METHOD": "VS",
- "DesignationTag": "unknown",
- "DateReport": "0.00"
}
], - "count": 2
}