Simplified Format Transaction Export Data

Returns daily transaction and batch data for all merchants in a consolidated XML format, optimized for multi-merchant parsing with Merchant > Batches > Transactions hierarchy under a single root element.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

Simplified Format Transaction Export Data

The SimplifiedFormat export provides the same batch and transaction data as the standard Transactions export, but delivered in a consolidated XML structure that wraps all merchants under a single <Transactions> root element. It is designed for institutions that need core transaction and batch reconciliation data across their full merchant portfolio in a single file, without the full field depth of the standard Transactions export.

Endpoint

GET /download/YYYYMMDD/SimplifiedFormat

Authentication

Basic HTTP Authentication required.
Encode username:password in Base64 and pass in the Authorization header:

Authorization: Basic {base64(username:password)}

When to use

Use this file when building a portfolio-level transaction reconciliation process where all merchants need to be processed together in a single pass. It is particularly useful for institutions with simpler integration requirements that do not need the full field set of the standard Transactions file. All amounts are in cents — divide by 100 to get dollar values.

Query Parameters

None. The file is identified by the date path segment (YYYYMMDD) and delivered via SFTP.

Response

200 OK — Returns XML content with the following structure:

XML Hierarchy: Transactions > Merchants > Merchant > Batches > Batch > Transactions > Transaction

<Merchant> fields:

FieldTypeDescription
MIDstringMerchant identifier (unique account number)

<Batch> fields:

FieldTypeDescription
InternalIdintegerInternal system identifier for the batch
BatchIdstringExternal batch identifier
PointOfSaleOrInteractionTerminalIdentifierstringV-number: terminal ID where the batch originated
BatchDatedatetimeDate the batch was closed
MerchantDepositDatedatetimeDate funds are scheduled to be deposited to the merchant
BatchNumberstringSequential batch number for the processing period
NetDepositAmountintegerNet deposit amount for the batch in cents
TransactionsCountintegerTotal number of transactions in the batch
SalesAmountintegerTotal sales volume in the batch in cents
SalesCountintegerNumber of sale transactions
RefundAmountintegerTotal refund amount in the batch in cents
RefundCountintegerNumber of refund transactions

<Transaction> fields:

FieldTypeDescription
CardTypestringCard network: V = Visa, M = Mastercard, S = Amex, D = Discover, R = Discover (proprietary BIN)
CardholderAccountNumberstringMasked card PAN (e.g. 414776******0555)
TransactionDatedatetimeDate and time the transaction occurred
TransactionAmountintegerTransaction amount in cents
TerminalEntryModestringCapture method: 01 = manual, 02 = magnetic stripe, 05 = chip/EMV, 07 = contactless
AuthorizationCodestringApproval code from the card issuer
AuthorizationSourceCodestringSource of authorization response (empty for Mastercard)
CardholderIdentificationMethodstringCardholder ID method: space = not specified, 1 = signature, 2 = PIN, 3 = unattended, 4 = MOTO
AuthorizationCharacteristicsIndicatorstringInterchange qualification indicator (E, A, N, etc.)
PS2000TransactionIdentifierstringUnique network-level transaction reference identifier
ValidationCodestringInterchange validation code (empty for Mastercard)
TransactionCodestringInternal code classifying the transaction type
AuthorizationResponseCodestringIssuer response code (00 = approved; empty for some card types)
TransactionFeeintegerFee applied to the transaction in cents; xsi:nil="true" if not applicable
TransactionFeeIndicatorstringFee type indicator (empty if none)
<?xml version="1.0" encoding="utf-8"?>
<Transactions xmlns:xsd="http://www.w3.org/2001/XMLSchema"
              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Merchants>
    <Merchant>
      <MID>9180000000001234</MID>
      <Batches>
        <Batch>
          <InternalId>33797488</InternalId>
          <BatchId>00001247970</BatchId>
          <PointOfSaleOrInteractionTerminalIdentifier>79416045</PointOfSaleOrInteractionTerminalIdentifier>
          <BatchDate>2026-05-27T00:00:00</BatchDate>
          <MerchantDepositDate>2026-05-28T00:00:00</MerchantDepositDate>
          <BatchNumber>8436</BatchNumber>
          <NetDepositAmount>42657</NetDepositAmount>
          <TransactionsCount>3</TransactionsCount>
          <SalesAmount>42657</SalesAmount>
          <SalesCount>3</SalesCount>
          <RefundAmount>0</RefundAmount>
          <RefundCount>0</RefundCount>
          <Transactions>
            <Transaction>
              <CardType>V</CardType>
              <CardholderAccountNumber>414776******0555</CardholderAccountNumber>
              <TransactionDate>2026-05-27T14:22:00</TransactionDate>
              <TransactionAmount>14200</TransactionAmount>
              <TerminalEntryMode>07</TerminalEntryMode>
              <AuthorizationCode>014122</AuthorizationCode>
              <AuthorizationSourceCode>V</AuthorizationSourceCode>
              <CardholderIdentificationMethod>1</CardholderIdentificationMethod>
              <AuthorizationCharacteristicsIndicator>E</AuthorizationCharacteristicsIndicator>
              <PS2000TransactionIdentifier>346134553487245</PS2000TransactionIdentifier>
              <ValidationCode>ML6X</ValidationCode>
              <TransactionCode>0101</TransactionCode>
              <AuthorizationResponseCode>00</AuthorizationResponseCode>
              <TransactionFee>0</TransactionFee>
              <TransactionFeeIndicator />
            </Transaction>
            <Transaction>
              <CardType>M</CardType>
              <CardholderAccountNumber>536759******6473</CardholderAccountNumber>
              <TransactionDate>2026-05-27T15:10:00</TransactionDate>
              <TransactionAmount>18700</TransactionAmount>
              <TerminalEntryMode>05</TerminalEntryMode>
              <AuthorizationCode>072795</AuthorizationCode>
              <AuthorizationSourceCode />
              <CardholderIdentificationMethod>1</CardholderIdentificationMethod>
              <AuthorizationCharacteristicsIndicator>A</AuthorizationCharacteristicsIndicator>
              <PS2000TransactionIdentifier>MDJN4MFFJ</PS2000TransactionIdentifier>
              <ValidationCode />
              <TransactionCode>0101</TransactionCode>
              <AuthorizationResponseCode />
              <TransactionFee>0</TransactionFee>
              <TransactionFeeIndicator />
            </Transaction>
          </Transactions>
        </Batch>
      </Batches>
    </Merchant>
  </Merchants>
</Transactions>

Error Codes

CodeWhen it happens
400Malformed date format in URL path
401Invalid or missing Basic Auth credentials
403User does not have permission for this operation
404No SimplifiedFormat file found for the specified date
500Internal server error

Common Mistakes

  • Expecting the same root element structure as the standard Transactions file — SimplifiedFormat wraps all merchants in <Transactions><Merchants>, not a per-merchant root.
  • Not dividing amounts by 100 — all amount fields (TransactionAmount, NetDepositAmount, SalesAmount, RefundAmount) are in cents.
  • Treating empty ValidationCode or AuthorizationResponseCode for Mastercard as errors — these fields are intentionally blank for Mastercard transactions.
  • Treating TransactionFee: xsi:nil="true" as zero — nil means no fee information is available, which is different from a zero-value fee.
  • Using CardType: S without knowing it represents Amex OptBlue (non-direct) and CardType: R as Discover proprietary BIN range (including Diner's Club).

Related Endpoints

  • GET /download/YYYYMMDD/Transactions — standard per-merchant transaction XML with more fields
  • GET /download/YYYYMMDD/TransactionsExtendedData — extended card type and network identifier data
  • GET /download/YYYYMMDD/TransAuth — authorization records for each transaction attempt

Example

curl -X GET "https://hq.staging.netevia.dev/download/20260528/SimplifiedFormat" \
  -H "Authorization: Basic $(echo -n 'username:password' | base64)"
Headers
string
enum
Defaults to application/json

Generated from available response content types

Allowed:
Response

Language
Credentials
Basic
base64
:
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json
text/json
merchants