GuidesAPI Reference
API Reference

/transactions/{merchantId}/v3/csv

get https://gateway.us.zip.co/transactions//v3/csv

Sandbox (Testing): https://gateway.sand.us.zip.co/transactions/{merchantId}/v3/csv

An abbreviated list of payments 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""}"
Language