--- updatedAt: 2026-09-11T15:18:42.000Z agentTools: projectIndex: https://docs.us.zip.co/llms.txt --- # /transactions/{merchantId}/v3/csv Sandbox (Testing): https://gateway.sand.us.zip.co/transactions/{merchantId}/v3/csv An abbreviated list of transactions in CSV format. [block:api-header] { "title": "Important Notes" } [/block] 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** [block:code] { "codes": [ { "code": "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\n788452a3-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\"\"}\"\n788452a3-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\"\"}\"\n788452a3-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\"\"}\"\n", "language": "text" } ] } [/block] # OpenAPI definition ```json { "openapi": "3.1.0", "info": { "title": "gateway-api-1", "version": "1.0" }, "servers": [ { "url": "https://gateway.us.zip.co" } ], "components": { "securitySchemes": { "sec0": { "type": "oauth2", "flows": { "clientCredentials": { "tokenUrl": "https://example.com/oauth2/token", "scopes": {} } } } } }, "security": [ { "sec0": [] } ], "paths": { "/transactions/{merchantId}/v3/csv": { "get": { "summary": "/transactions/{merchantId}/v3/csv", "description": "Sandbox (Testing): https://gateway.sand.us.zip.co/transactions/{merchantId}/v3/csv An abbreviated list of transactions in CSV format.", "operationId": "transactionsmerchantidv3csv", "parameters": [ { "name": "merchantId", "in": "path", "description": "The unique Zip Merchant ID", "schema": { "type": "string" }, "required": true }, { "name": "TransferId", "in": "query", "description": "The Transfer Id of the payment to filter transactions by", "schema": { "type": "string" } }, { "name": "MinimumCreateDateTime", "in": "query", "description": "The begin created date of the query search", "required": true, "schema": { "type": "string", "format": "date" } }, { "name": "MaximumCreateDateTime", "in": "query", "description": "The end created date of the query search", "required": true, "schema": { "type": "string", "format": "date" } }, { "name": "OrderBy", "in": "query", "description": "The order sort of the result set", "schema": { "type": "string" } }, { "name": "X-QP-Signature", "in": "query", "description": "The signature for merchant validation", "required": true, "schema": { "type": "string" } }, { "name": "MerchantId", "in": "query", "description": "The unique Zip Merchant ID", "required": true, "schema": { "type": "string" } }, { "name": "QP-Territory", "in": "header", "description": "Territory of the request (US)", "required": true, "schema": { "type": "string" } }, { "name": "X-QP-Signature", "in": "header", "description": "The signature for merchant validation", "required": true, "schema": { "type": "string" } }, { "name": "page", "in": "query", "description": "The page subset of the total results. Default is 1.", "required": true, "schema": { "type": "integer", "format": "int32" } }, { "name": "pageSize", "in": "query", "description": "The number of records to include in the result set. Default/maximum is 100,000.", "required": true, "schema": { "type": "integer", "format": "int32" } } ], "responses": { "200": { "description": "200", "content": { "text/plain": { "examples": { "Result": { "value": "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\n788452a3-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\"\"}\"\n788452a3-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\"\"}\"\n788452a3-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\"\"}\"\n" } } } } } }, "security": [] } } }, "x-readme": { "headers": [], "explorer-enabled": false, "proxy-enabled": false }, "x-readme-fauxas": true } ```