Get PIF Transactions
Get all transactions from a PIF
With this endpoint, you can get PIF transaction information such as status and amount.
https://sandbox-api.cpxenterprise.com/payment/v1/payment?fileId={fileId}
{
"aggregations": {
"totalAmount": {
"value": 0.05
},
"settledCount": {
"doc_count": 0
},
"settledAmount": {
"value": 0
}
},
"totalRecords": 3,
"recordCount": 3,
"records": [
{
"accountType": "ACH",
"achDebitId": "09222bb-227-22d-9685-72124248a3310",
"achTransactionType": "credit",
"acl": [
"network:2cc59b04-ddd6-ddae-baa3-435e32323232d6",
"institution:6ff3ec4-3333-ddd58-dd0e-6bejeje33kef",
"buyer:df3f3x85-ce3c-ffff-aas6-a79333cc297",
"pps:cpx-acquiring",
"pif:{fileId}",
"supplier:f17eee2-2fb-53e-934d-f46c3d42f2332"
],
"amount": 0.02,
"buyerBillingProduct": "ACH",
"created": "2021-04-14T18:36:23.598Z",
"creator": {
"id": "f74wede39-3ca-508d-379-34wef9c23e328",
"username": "username+sandbox"
},
"fileDate": "2010-01-20T00:00:00.000Z",
"fileId": "{fileId}",
"filePath": "file.pif.WEB_20210414143623.csv",
"hasInvoices": false,
"hasPendingDebit": false,
"id": "86q3dq1e-fqwwa6-qbc7-q586-9eec3112d212d",
"importDate": "2021-04-14T18:36:23.421Z",
"invoiceCount": 0,
"isProxyPay": false,
"merchantId": "4189617528",
"modified": "2021-04-14T18:36:57.818Z",
"modifier": {
"id": "11223356-3300-45cc-31c-3f20f69b2",
"username": "system"
},
"network": {
"externalStatus": "Active",
"id": "22823b04-d3f6-5eae-bbbd-435ea323c28d6",
"name": "name",
"nid": "nid",
"status": "Approved"
},
"originalAmount": 0.02,
"paymentAccountNumber": "1230",
"paymentAuthMessage": "",
"paymentMethod": "ACH",
"paymentProcessDate": "2021-04-14T18:36:29.197Z",
"paymentReference": "1324580454856",
"paymentStatus": "Sent",
"pending": "2021-04-14T18:36:23.425Z",
"ready": "2021-04-14T18:36:29.710Z",
"replayId": "439132678613110785",
"sent": "2021-04-14T18:36:57.735Z",
"statusDate": "2021-04-14T18:36:57.735Z",
"tags": [
"Standard ACH"
],
"totalDebitAmount": 0.02,
"transactionDate": "2021-04-14T18:36:57.735Z",
"transactionId": "testpaymen23246",
"bankAccountNumber": {
"hash": "JPHotseq53b1SDLcXtwNuHZtb6S0sFMmrZfKhjt8CyY=",
"mask": "7890"
},
"bankRoutingNumber": {
"hash": "zRfToVYOtK8WNIPQSzxFFDbwCHVMrdUZITqyOUoeZBE=",
"mask": "0052"
},
"supplier": {
"address": {
"city": "Washington",
"country": "USA",
"postalCode": "20024",
"state": "DC",
"street1": "800 Maine Avenue SW",
"street2": "Suite 650"
},
"contacts": [
{
"email": "[email protected]",
"id": "28344390-14337-5733-ad33e4-234444579",
"name": "apihelp",
"phone": "9999999999",
"primary": true,
"title": "Default Contact"
}
],
"expirePreAuths": false,
"externalStatus": "Active",
"id": "f4ewuerb92-bgdfab-fff-934d-fg4514c45e2",
"mcc": {
"code": "",
"description": ""
},
"name": "Supplier",
"payeeType": "Supplier",
"sid": "sid",
"status": "Approved",
"paymentTypes": [
{
"emails": "apitest.com",
"enabled": true,
"id": "V Card",
"proxyPayment": false,
"requirePin": false,
"type": "V Card"
},
{
"enabled": false,
"id": "Prepaid Debit",
"prepaidDebitBalance": 0,
"prepaidDebitId": "",
"type": "Prepaid Debit"
},
{
"enabled": false,
"id": "Virtual Wallet",
"type": "Virtual Wallet",
"virtualWalletBalance": 0,
"virtualWalletId": ""
},
{
"enabled": false,
"id": "Check Issuing",
"payableTo": "",
"type": "Check Issuing"
},
{
"enabled": false,
"id": "Direct",
"type": "Direct"
},
{
"accountType": "Checking",
"enabled": true,
"id": "ACH",
"type": "ACH"
},
{
"accountType": "",
"discountRate": "0",
"enabled": false,
"feeType": "",
"flatFee": 0,
"id": "ACH+",
"netFees": false,
"type": "ACH+"
},
{
"accountType": "",
"discountRate": "0",
"enabled": false,
"highTermDays": 0,
"id": "Dynamic Discounting",
"lowTermDays": 0,
"netFees": false,
"type": "Dynamic Discounting"
},
{
"enabled": false,
"id": "Dollar Splits",
"type": "Dollar Splits"
},
{
"enabled": false,
"id": "Payment Thresholds",
"type": "Payment Thresholds"
}
]
},
"institution": {
"achDelayDays": 0,
"associatedNetworkId": "rtgtg-d3f6-5ea4e-bbdbd-435e55a27c28d6",
"externalStatus": "Active",
"fees": {
"bankAccountId": ""
},
"fid": "fid",
"id": "60we3ec4-35b3-5wee-9we0e-6b8e8wewe2df",
"includeVcnInDisposition": true,
"name": "name",
"paymentFileType": "e2wr1aad2-1er7a-5b29-a718-19rebdfd1198",
"pifConfirmationEmail": "[email protected]",
"revenue": {
"bankAccountId": ""
},
"status": "Approved",
"suppressSIPEmail": false,
"vcnHost": "falcons",
"vcnHostConfig": {
"falcons": {
"products": [
{
"default": true,
"id": "71ae443dc-1fdd-517a-975e-b475434301",
"name": "PPS Virtual Lodged - 6047",
"type": "LDG",
"value": "6047"
},
{
"default": true,
"id": "9d455545-4023-5a1f-945c-11321ef64",
"name": "PPS Multi Use - 6035",
"type": "VCN",
"value": "6035"
},
{
"default": true,
"id": "5384-ebb0-503e-82f1-1172w342159",
"name": "PPS Commercial Prepaid Blue - 6321",
"type": "PPD",
"value": "6321"
},
{
"default": true,
"id": "dcf43453433-2a60-5a29-d345rf-7dgt3339",
"name": "PPS Consumer Prepaid Gray - 6339",
"type": "VWA",
"value": "6339"
}
],
"vendor": "galileo"
}
},
"goodFunds": {
"bankAccountId": "",
"bankAccountNumber": {
"hash": "EWFKDSzFNticoer4XcZQb6EZ3jfo4gZB2xMYzH0z13c=",
"mask": "0009"
},
"bankRoutingNumber": {
"hash": "EWFKDSzFNticoer4XcZQb6EZ3jfo4gZB2xMYzH0z13c=",
"mask": "0009"
}
}
},
"buyer": {
"ach": {
"bankAccountId": "3a8b63b0f32f4ab86fa3db8858f0f51c1a2323b7ec835990fb929b1871d4036d",
"billing": "GOOD_FUNDS"
},
"achEnabled": true,
"achMerchantId": "",
"achRequested": true,
"address": {
"city": "test",
"country": "USA",
"postalCode": "12345",
"state": "TX",
"street1": "1234 tester street"
},
"associatedInstitutionId": "60ea3325b3-5358-9f430e-6b82312fe2df",
"bid": "d028885-24bc-5dw3f-aca6-a4a1a5297",
"checkIssuingEnabled": false,
"creditLimit": 0,
"dualPifApproval": {
"enabled": false
},
"externalStatus": "Active",
"failOverPayment": {
"enabled": false
},
"id": "d016r5-5345-5d3f-aca6-a7932353421297",
"instVcnHost": "falcons",
"lodgePaymentEnabled": true,
"name": "name",
"status": "Approved",
"virtualCard": {
"bankAccountId": "3a8b63b0f32f4ab86fa3db8858f0f51c1a2323b7ec835990fb929b1871d4036d",
"billing": "DAILY_BILL_DAILY_PAY",
"debitMethod": "Manual"
},
"virtualCardEnabled": true,
"virtualCardRequested": true,
"vcnHostConfig": {
"falcons": {
"paymentReferenceNumber": "9039075324548674",
"products": {
"LDG": {
"id": "71ae43dc-1fdd-514975e-b475b6224301",
"name": "PPS Virtual Lodged - 6047",
"value": "6047"
},
"PPD": {
"id": "538f55-ebb0-501e-444-117fre32159",
"name": "PPS Commercial Prepaid Blue - 6321",
"value": "6321"
},
"VCN": {
"id": "9dd445-404d-5a1f-44c-1149dc1ef64",
"name": "PPS Multi Use - 6035",
"value": "6035"
},
"VWA": {
"id": "dcf18a43-dff-5a29-a4cc-70ff339",
"name": "PPS Consumer Prepaid Gray - 6339",
"value": "6339"
}
}
}
}
}
},
{
"accountType": "CHK",
"acl": [
"network:2285tre-d3f6-5eae-bfbd-435ea27c28d6",
"institution:60fg4-35b3-534-9e4f0e-6bfg812fe2df",
"buyer:de68885-24bce44f-aca6-a79e1297",
"pps:cpx-acquiring",
"pif:5cfdabf8-e-5523-9087-5d3bda8fd"
],
"amount": 0.01,
"checkNumber": 22,
"created": "2021-04-14T18:36:23.597Z",
"creator": {
"id": "f7402cc9-48ca-508d-8e79-3477e9c9ea28",
"username": "johnson.nguyen+sandbox"
},
"failed": "2021-04-14T18:36:35.668Z",
"failedPaymentNotificationSent": "2021-04-14T18:40:35.196Z",
"fileDate": "2010-01-20T00:00:00.000Z",
"fileId": "{fileId}",
"filePath": "file.pif.WEB_20210414143623.csv",
"hasInvoices": false,
"id": "f6efrt9-b0c7-5dd7-b00f-affr6f5",
"importDate": "2021-04-14T18:36:23.421Z",
"invoiceCount": 0,
"isProxyPay": false,
"modified": "2021-04-14T18:40:35.196Z",
"modifier": {
"id": "50335456-0300-45cc-b01c-37c5f20f69b2",
"username": "system"
},
"network": {
"externalStatus": "Active",
"id": "22859b04-d3f6-5eae-bbbd-435ea27c28d6",
"name": "name",
"nid": "nid",
"status": "Approved"
},
"originalAmount": 0.01,
"paymentAccountNumber": "22",
"paymentAuthMessage": "Buyer 6543-2fgc-5ff-acad-gfrdertyu6597 is not Enabled for Check Issuing",
"paymentMethod": "Check",
"paymentProcessDate": "2021-04-14T18:36:29.196Z",
"paymentStatus": "Failed",
"paymentStatusHistory": [
"20210414183635 Failed Buyer d0tytr885-24bc-5fr-aca6-a7e4561a52125 is not Enabled for Check Issuing"
],
"pending": "2021-04-14T18:36:23.425Z",
"ready": "2021-04-14T18:36:29.711Z",
"statusDate": "2021-04-14T18:36:35.668Z",
"transactionDate": "2021-04-14T18:36:23.421Z",
"transactionId": "testpayment456e",
"supplier": {
"acl": [
"pps:cpx-acquiring",
"supplier:954342-dfg-5f9-8241-htre45d8a72",
"buyer:ftg4885-2de4-f45f-adfgt56-fgtr497",
"institution:6dfgy54-35343-53df8-9f0e-6dfgt56e2df",
"network:dfrt4-d3f6-5eae-bswer5d-dfgt527c28d6"
],
"address": {
"city": "Altta",
"country": "USA",
"postalCode": "30085",
"state": "GA",
"street1": "1112 Main Street",
"street2": "Unit Z"
},
"contacts": [
{
"email": "[email protected]",
"id": "a8d45e77a63-5345c02-5365-ae1f-13465",
"name": "name",
"primary": true,
"title": "title"
}
],
"deleted": false,
"email": "[email protected]",
"externalStatus": "Active",
"id": "9gf542-d4458-5f59-8f51-fr5d8a72",
"name": "SupTester",
"payeeType": "Supplier",
"sid": "Teeeem",
"status": "Approved",
"paymentTypes": [
{
"address": {
"city": "Altta",
"country": "USA",
"postalCode": "30085",
"state": "GA",
"street1": "1112 Main Street",
"street2": "Unit Z"
},
"enabled": true,
"id": "0b9eb5c0-ce6e-54a6-ba4b-598d46ec4e03",
"payableTo": "SupTester",
"type": "Check Issuing"
}
]
},
"institution": {
"achDelayDays": 0,
"associatedNetworkId": "228ff04-d3f6-5eae-bbbd-435ea27c28d6",
"externalStatus": "Active",
"fees": {
"bankAccountId": ""
},
"fid": "fid",
"id": "60ef55c4-35b3-535558gref0e-6b8e812fe2df",
"includeVcnInDisposition": true,
"name": "name",
"paymentFileType": "e34432-117a-5b29-343418-1971bdfd1198",
"pifConfirmationEmail": "[email protected]",
"revenue": {
"bankAccountId": ""
},
"status": "Approved",
"suppressSIPEmail": false,
"vcnHost": "falcons",
"vcnHostConfig": {
"falcons": {
"products": [
{
"default": true,
"id": "71ae45dc-1fdd-517a-975e-b475b6224301",
"name": "PPS Virtual Lodged - 6047",
"type": "LDG",
"value": "6047"
},
{
"default": true,
"id": "9ddbc6a5-404d-5a1f-945c-11495271ef64",
"name": "PPS Multi Use - 6035",
"type": "VCN",
"value": "6035"
},
{
"default": true,
"id": "538a5a9b-ebb0-501e-87f1-1172ecf32159",
"name": "PPS Commercial Prepaid Blue - 6321",
"type": "PPD",
"value": "6321"
},
{
"default": true,
"id": "dcfd-2a60-5a29-a4cc-70fe08419339",
"name": "PPS Consumer Prepaid Gray - 6339",
"type": "VWA",
"value": "6339"
}
],
"vendor": "galileo"
}
},
"goodFunds": {
"bankAccountId": "",
"bankAccountNumber": {
"hash": "EWFKDSzFNticoer4XcZQb6EZ3jfo4gZB2xMYzH0z13c=",
"mask": "0009"
},
"bankRoutingNumber": {
"hash": "EWFKDSzFNticoer4XcZQb6EZ3jfo4gZB2xMYzH0z13c=",
"mask": "0009"
}
}
},
"buyer": {
"ach": {
"bankAccountId": "ddd3tefr33f0dff1871d4036d",
"billing": "GOOD_FUNDS"
},
"achEnabled": true,
"achMerchantId": "",
"achRequested": true,
"address": {
"city": "test",
"country": "USA",
"postalCode": "12345",
"state": "TX",
"street1": "1234 tester street"
},
"associatedInstitutionId": "60ea3ec4-35b3-5358-9f0e-6b8e812fe2df",
"bid": "d0168885-24bc-5d3f-aca6-a79a1a521297",
"checkIssuingEnabled": false,
"creditLimit": 0,
"dualPifApproval": {
"enabled": false
},
"externalStatus": "Active",
"failOverPayment": {
"enabled": false
},
"id": "d0168885-24bc-5d3f-aca6-a79a1a521297",
"instVcnHost": "falcons",
"lodgePaymentEnabled": true,
"name": "JNTester",
"status": "Approved",
"virtualCard": {
"bankAccountId": "3a8b63b0f32f4ab86fa3db8858f0f51c1a2323b7ec835990fb929b1871d4036d",
"billing": "DAILY_BILL_DAILY_PAY",
"debitMethod": "Manual"
},
"virtualCardEnabled": true,
"virtualCardRequested": true,
"vcnHostConfig": {
"falcons": {
"paymentReferenceNumber": "906103448674",
"products": {
"LDG": {
"id": "71ae45dc-1fdd-517a-975e-b475b6224301",
"name": "PPS Virtual Lodged - 6047",
"value": "6047"
},
"PPD": {
"id": "538a5a9b-ebb0-501e-87f1-1172ecf32159",
"name": "PPS Commercial Prepaid Blue - 6321",
"value": "6321"
},
"VCN": {
"id": "9ddbc6a5-404d-5a1f-945c-11495271ef64",
"name": "PPS Multi Use - 6035",
"value": "6035"
},
"VWA": {
"id": "dcf18a43-2a60-5a29-a4cc-70fe08419339",
"name": "PPS Consumer Prepaid Gray - 6339",
"value": "6339"
}
}
}
}
}
},
{
"accountType": "ACH",
"achTransactionType": "debit",
"acl": [
"network:fg59b04-d3f6dsfe-bbbd-43fa27c28d6",
"institution:dde45-ggg0e-6b8e812fe2df",
"buyer:d0168885-24bc-5d3f-dfa79a1a521297",
"pps:cpx-acquiring",
"pif:5cfdabf8-66a6-5523df5612b3fg-8fd",
"piftransaction:09ffabb-2aa7-dfdd-9685-721ffd8af810"
],
"amount": 0.02,
"associatedSupplierCreditIds": [
"dsgf8071e-fca6-5df7-a586-91d60e44cbf5"
],
"buyerBillingProduct": "ACH",
"created": "2021-04-14T18:36:29.709Z",
"createdFrom": "PIF Plan",
"creator": {
"id": "50ft6-0300-45cc-bdfc-3dff0f69b2",
"username": "system"
},
"fileDate": "2010-01-20T00:00:00.000Z",
"fileId": "{fileId}",
"filePath": "fil.pif.WEB_20210414143623.csv",
"hasInvoices": false,
"id": "09d81abb-2aa7-58ad-9685-72118d8af810",
"importDate": "2021-04-14T18:36:23.421Z",
"invoiceCount": 0,
"isGoodFundsBuyerDebit": true,
"isNewTransaction": true,
"isProxyPay": false,
"merchantId": "418277678",
"modified": "2021-04-14T18:36:35.361Z",
"modifier": {
"id": "50ghjjj6-03hhhc-b01c-37c5hh9b2",
"username": "system"
},
"network": {
"externalStatus": "Active",
"id": "2j9b04-d3f6-5eae-bbbd-435rr7c28d6",
"name": "name"
"nid": "nid",
"status": "Approved"
},
"originalAmount": 0.02,
"paymentAccountNumber": "7890",
"paymentAuthMessage": "",
"paymentMethod": "ACH",
"paymentProcessDate": "2021-04-14T18:36:29.198Z",
"paymentReference": "110418004851",
"paymentStatus": "Sent",
"ready": "2021-04-14T18:36:29.709Z",
"replayId": "439132678613110784",
"sent": "2021-04-14T18:36:35.129Z",
"statusDate": "2021-04-14T18:36:35.129Z",
"tags": [
"Standard ACH"
],
"transactionDate": "2021-04-14T18:36:35.129Z",
"transactionId": "09d81adff-rerre-58ad-9685-7211-8af810",
"debitBankAccountNumber": {
"hash": "JPHotseq53b1SDLcXtwNuHZtb6S0sFMmrZfKhjt8CyY=",
"mask": "7890"
},
"debitBankRoutingNumber": {
"hash": "zRfToVYOtK8WNIPQSzxFFDbwCHVMrdUZITqyOUoeZBE=",
"mask": "0052"
},
"institution": {
"achDelayDays": 0,
"associatedNetworkId": "228bvhh--d3f6-5eae-bbbd-435ea27c28d6",
"externalStatus": "Active",
"fees": {
"bankAccountId": ""
},
"fid": "fid",
"id": "60eh-35b3-5358-9f0e-6he2df",
"includeVcnInDisposition": true,
"name": "KUNAL SANDBOX",
"paymentFileType": "e2d1aad2-11ha-u-hhhhu18-1hdfd1h198",
"pifConfirmationEmail": "[email protected]",
"revenue": {
"bankAccountId": ""
},
"status": "Approved",
"suppressSIPEmail": false,
"vcnHost": "falcons",
"vcnHostConfig": {
"falcons": {
"products": [
{
"default": true,
"id": "71ae45dc-1fdd-517a-975e-b475b6224301",
"name": "PPS Virtual Lodged - 6047",
"type": "LDG",
"value": "6047"
},
{
"default": true,
"id": "9ddbc6a5-404d-5a1f-945c-11495271ef64",
"name": "PPS Multi Use - 6035",
"type": "VCN",
"value": "6035"
},
{
"default": true,
"id": "538a5a9b-ebb0-501e-87f1-1172ecf32159",
"name": "PPS Commercial Prepaid Blue - 6321",
"type": "PPD",
"value": "6321"
},
{
"default": true,
"id": "dcf18a43-2a60-5a29-a4cc-70fe08419339",
"name": "PPS Consumer Prepaid Gray - 6339",
"type": "VWA",
"value": "6339"
}
],
"vendor": "galileo"
}
},
"bankAccountNumber": null,
"bankRoutingNumber": null,
"goodFunds": {
"bankAccountId": "",
"bankAccountNumber": {
"hash": "EWFKDSzFNticoer4XcZQb6EZ3jfo4gZB2xMYzH0z13c=",
"mask": "0009"
},
"bankRoutingNumber": {
"hash": "EWFKDSzFNticoer4XcZQb6EZ3jfo4gZB2xMYzH0z13c=",
"mask": "0009"
}
}
},
"buyer": {
"ach": {
"bankAccountId": "3a8j4ab86fa3db8858f0f51c1i7ec835990fb929b1871d4036d",
"billing": "GOOD_FUNDS"
},
"achEnabled": true,
"achMerchantId": "",
"achRequested": true,
"address": {
"city": "test",
"country": "USA",
"postalCode": "12345",
"state": "TX",
"street1": "1234 tester street"
},
"associatedInstitutionId": "60eau35b3-535u9f0e-u8e81udf",
"bid": "d0168885-2ui77c-5du3f-aiuca6-a7ui521297",
"checkIssuingEnabled": false,
"creditLimit": 0,
"dualPifApproval": {
"enabled": false
},
"externalStatus": "Active",
"failOverPayment": {
"enabled": false
},
"id": "d0168i24bc-5d3f-acu79a1aui-21297",
"lodgePaymentEnabled": true,
"name": "JNTester",
"status": "Approved",
"virtualCard": {
"bankAccountId": "3a8b63b0iuf4ab86fa3db881c1a232392ui4036d",
"billing": "DAILY_BILL_DAILY_PAY",
"debitMethod": "Manual"
},
"virtualCardEnabled": true,
"virtualCardRequested": true,
"vcnHostConfig": {
"falcons": {
"paymentReferenceNumber": "iu3448674",
"products": {
"LDG": {
"id": "71aeiuc-1fdd-517a-975e-b475b6224301",
"name": "PPS Virtual Lodged - 6047",
"value": "6047"
},
"PPD": {
"id": "538a5aiu501e-87f1-1172ecf32159",
"name": "PPS Commercial Prepaid Blue - 6321",
"value": "6321"
},
"VCN": {
"id": "9ddbc6a5-4iu-5a1f-945c-1iu95271ef64",
"name": "PPS Multi Use - 6035",
"value": "6035"
},
"VWA": {
"id": "dcf18a43-2a60-ui9-a4cc-uiuuuu",
"name": "PPS Consumer Prepaid Gray - 6339",
"value": "6339"
}
}
}
}
}
}
]
}
Updated over 3 years ago