documentation
  • LATAM Payment Methods
  • Integration guide
    • Getting started
      • Payment Methods
      • Payment Types
      • Supported Brands
      • Overview (Authentication and Endpoint)
    • COPYandPAY
      • Customization
      • Advanced Options
      • COPYandPAY API
      • Tokenization
      • Mobile Optimization
    • Server-to-Server
      • Tokenization
  • Manage Payments
    • Backoffice Operations
    • Recurring Payments
    • Installments
    • ZeroAuth
    • Transactions status
  • Instant Payment Notification (IPN) / Webhooks
    • General Information
    • Integration Guide
  • Queries
    • XML Integrator (Queries)
  • Reporting
    • Overview
    • Processed Report
    • Payout Report
    • Report Availability
    • Glossary of Fields
  • Compliance
    • Mandatory parameters by country
    • Test cards by country
    • Customer Identification Number by country (Customer ID)
    • Supported Countries and States
    • Requirements Before Going-Live
  • Reference
    • API Reference
    • Result Codes
  • FAQ
    • COPYandPAY FAQ
    • PCI DSS
    • TLS 1.2
Powered by GitBook
On this page
  • Transaction Reports
  • Transaction Search Using paymentId
  • Transaction Search Using merchantTransactionId
  1. Manage Payments

Transactions status

PreviousZeroAuthNextGeneral Information

Last updated 4 years ago

Transaction Reports

There are currently 2 ways to get a report with the details of an existing payment:

Transaction Search Using paymentId

curl -G https://test.oppwa.com/v1/query/{id} \
 -d "entityId=8a8294174e918ca6014e9c6f5ae12a9c" \
 -H "Authorization: Bearer OGE4Mjk0MTcyODFiOGVlMzAxMjgyOTkwNjZmNTBjZGJ8ZGVtbw=="

{
  "id":"8ac7a4a277bb37680177ca9e266d3192",
  "paymentType":"DB",
  "paymentBrand":"MASTER",
  "amount":"5670.30",
  "currency":"BRL",
  "descriptor":"12345 Usage",
  "merchantTransactionId":"ABCDEF12345",
  "recurringType":"INITIAL",
  "result":{
    "code":"000.100.112",
    "description":"Request successfully processed in 'Merchant in Connector Test Mode'"
  },
  "resultDetails":{
    "ConnectorTxID1":"8ac7a4a277bb37680177ca9e266d3192",
    "connectorInstanceId":"10.2.4.54",
    "acquirerReturnCode":"6",
    "ExtendedDescription":"Transaction succeeded",
    "acquirerTxId3":"8ac7a4a277bb37680177ca9e266d3192",
    "merchantAccount":"Cielo_ACON3_STAGING",
    "acquirerResponse1":"0222014139193",
    "acquirerResponse2":"641213",
    "connectorVersion":"3.2.35",
    "AcquirerResponse":"000.000.000",
    "connectorName":"Cielo",
    "acquirerReturnMessage":"Operation Successful",
    "acquirerInitialTxId":"4404e7cc-0321-42c2-a60b-4c603faeb44c",
    "acquirerTxId1":"4404e7cc-0321-42c2-a60b-4c603faeb44c",
    "acquirerTxId2":"0222014139193#APG@979914"
  },
  "card":{
    "bin":"522864",
    "binCountry":"UA",
    "last4Digits":"0691",
    "holder":"John Doe",
    "expiryMonth":"05",
    "expiryYear":"2022"
  },
  "customer":{
    "givenName":"John",
    "surname":"Doe",
    "merchantCustomerId":"11438374798",
    "email":"info10@provider.com",
    "ip":"127.0.0.116"
  },
  "billing":{
    "street1":"Rua Itapeva 547",
    "city":"Sao Paulo",
    "state":"SP",
    "postcode":"02702500",
    "country":"BR"
  },
  "customParameters":{
    "product":"1 month membership",
    "CTPE_DESCRIPTOR_TEMPLATE":"${USAGE}",
    "merchant_website":"www.store.com"
  },
  "risk":{
    "score":"0"
  },
  "buildNumber":"2be345f923663201482518934a5fae086ead4483@2021-02-22 14:09:46 +0000",
  "timestamp":"2021-02-22 16:41:39+0000",
  "ndc":"8a8294174e918ca6014e9c6f5ae12a9c_438a0a920f1841a4958fcc081a98dede"
}

Transaction Search Using merchantTransactionId

curl -G https://test.oppwa.com/v1/query \
 -d "entityId=8a8294174e918ca6014e9c6f5ae12a9c" \
 -d "merchantTransactionId=ABCDEF12345" \
 -H "Authorization: Bearer OGE4Mjk0MTcyODFiOGVlMzAxMjgyOTkwNjZmNTBjZGJ8ZGVtbw=="

{
  "result":{
    "code":"000.000.100",
    "description":"successful request"
  },
  "buildNumber":"2be345f923663201482518934a5fae086ead4483@2021-02-22 14:09:46 +0000",
  "timestamp":"2021-02-22 16:41:59+0000",
  "ndc":"8a8294174e918ca6014e9c6f5ae12a9c_f50552ba366a4cd2b79ac72098b05b35",
  "payments":[
    {
      "id":"8ac7a4a277bb37680177ca9e266d3192",
      "paymentType":"DB",
      "paymentBrand":"MASTER",
      "amount":"5670.30",
      "currency":"BRL",
      "descriptor":"12345 Usage",
      "merchantTransactionId":"ABCDEF12345",
      "recurringType":"INITIAL",
      "result":{
        "code":"000.100.112",
        "description":"Request successfully processed in 'Merchant in Connector Test Mode'"
      },
      "resultDetails":{
        "ConnectorTxID1":"8ac7a4a277bb37680177ca9e266d3192",
        "connectorInstanceId":"10.2.4.54",
        "acquirerReturnCode":"6",
        "ExtendedDescription":"Transaction succeeded",
        "acquirerTxId3":"8ac7a4a277bb37680177ca9e266d3192",
        "merchantAccount":"Cielo_ACON3_STAGING",
        "acquirerResponse1":"0222014139193",
        "acquirerResponse2":"641213",
        "connectorVersion":"3.2.35",
        "AcquirerResponse":"000.000.000",
        "connectorName":"Cielo",
        "acquirerReturnMessage":"Operation Successful",
        "acquirerInitialTxId":"4404e7cc-0321-42c2-a60b-4c603faeb44c",
        "acquirerTxId1":"4404e7cc-0321-42c2-a60b-4c603faeb44c",
        "acquirerTxId2":"0222014139193#APG@979914"
      },
      "card":{
        "bin":"522864",
        "binCountry":"UA",
        "last4Digits":"0691",
        "holder":"John Doe",
        "expiryMonth":"05",
        "expiryYear":"2022"
      },
      "customer":{
        "givenName":"John",
        "surname":"Doe",
        "merchantCustomerId":"11438374798",
        "email":"info10@provider.com",
        "ip":"127.0.0.116"
      },
      "billing":{
        "street1":"Rua Itapeva 547",
        "city":"Sao Paulo",
        "state":"SP",
        "postcode":"02702500",
        "country":"BR"
      },
      "customParameters":{
        "product":"1 month membership",
        "CTPE_DESCRIPTOR_TEMPLATE":"${USAGE}",
        "merchant_website":"www.store.com"
      },
      "risk":{
        "score":"0"
      },
      "timestamp":"2021-02-22 16:41:39+0000"
    }
  ]
}
Transaction Search Using paymentId
Transaction Search Using merchantTransactionId