get https://gateway.us.zip.co/transactions//v3/csv
An abbreviated list of statement transactions in CSV format.
Important Notes
If the "productType" is set to "Virtual", and the "transactionType" is set to "Capture", the following "metadata" will be returned in your response with these parameters:
- authorizationCodes: An authorization code for the authorizations made on the virtual card. It can be one or many, depending on the number of authorizations done on the card.
- networkTransactionId: A unique transaction id from the payment gateway.
- issuingCardType: Can be "Virtual" or "InStore", depending on where the card was processed.
Note: The metadata will be blank for "transactionType": "Refund."
Example Response
MerchantId,TransactionId,TransactionDateTime,StatementId,StatementNumber,OrderCreatedDateTime,OrderNumber,OrderId,MerchantName,MerchantReference,MerchantPlatformId,TransactionType,DebitOrCredit,Currency,Amount,AmountSigned ,ProductType,CaptureAmount,RefundAmount,TransactionFeeAmount,TransactionFeeReversalAmount,MerchantFeeAmount,MerchantFeeReversalAmount,MerchantFeeForPaymentPlanAmount,MerchantFeeForPaymentPlanReversalAmount,PaymentDate,TransferId,Metadata
788452a3-7339-409f-89bc-f1436006821e,d53dd2ed-5563-4c4a-b3e4-320298c22d31,2022-08-17 23:59:28 +00:00,77df71d9-3845-42b3-b78a-ade8833db2a0,77df71d9384542b3b78aade8833db2a0,08/17/2022 23:59:25 +00:00,110817-282404,ab3eadeb-d6b4-41b4-8bf3-05d746192662,TEST,6fgd835-ee5x7gzz-N,,Capture,Credit,USD,396.09,396.09,Virtual,396.09,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,,"{""AuthorizationCodes"":[""S00000""],""NetworkTransactionId"":""1234567890123456"",""IssuingCardType"":""Virtual""}"
788452a3-7339-409f-89bc-f1436006821e,c2c1c0fd-79db-435d-88cc-8a079ae6e31d,2022-08-17 23:59:26 +00:00,77df71d9-3845-42b3-b78a-ade8833db2a0,77df71d9384542b3b78aade8833db2a0,08/17/2022 23:59:25 +00:00,110817-282434,8098010a-c55a-4894-94f7-49d199c5db36,TEST,6fgd835-ee5x73hz-N,,MerchantFeeForPaymentPlan,Debit,USD,2.00,-2.00,Virtual,0.00,0.00,0.00,0.00,0.00,0.00,2.00,0.00,,,"{""AuthorizationCodes"":[""S00000""],""NetworkTransactionId"":""1234567890123456"",""IssuingCardType"":""Virtual""}"
788452a3-7339-409f-89bc-f1436006821e,a77abbae-802f-4448-908a-77e27b6fd687,2022-08-17 23:58:59 +00:00,77df71d9-3845-42b3-b78a-ade8833db2a0,77df71d9384542b3b78aade8833db2a0,08/17/2022 23:58:57 +00:00,110817-282499,0a2cc8d9-3bfc-4cac-b863-138f745b132f,TEST,6fgd839-ertx7gzz-N,,Capture,Credit,USD,25.03,25.03,Virtual,25.03,0.00,0.00,0.00,0.00,0.00,0.00,0.00,,,"{""AuthorizationCodes"":[""S00000""],""NetworkTransactionId"":""1234567890123456"",""IssuingCardType"":""Virtual""}"