Fetch Transaction Information

A guide to using the Transaction Status API.

The PayConex Transaction Status API provides an interface to request previous transaction details or a transaction_id value prior to processing a payment.

By fetching a transaction_id value beforehand a developer can send a transaction_id within a PayConex payment request. In this scenario if a communication error, packet loss, or similar issue occurs a developer could use the Transaction Status API to request transaction details in order to determine if the transaction was successful or not.

API URLs

For the certification test environment:

https://cert.payconex.net/api/tsapi/3.8

For the production environment:

https://secure.payconex.net/api/tsapi/3.8

Transaction Status API Functions

There are two main actions that can be completed using the Transaction Status API:

  1. GET_TRANSACTION_ID: Returns a transaction_id for use in a PayConex payment request. This value is passed through the transaction_id parameter.
  2. GET_TRANSACTION_STATUS: Returns the status of a transaction.

Fetching a Transaction ID

This is an example of a request to fetch a transaction_id value:

curl --request POST \
  --url https://cert.payconex.net/api/tsapi/3.8 \
  --header 'Content-Type: application/x-www-form-urlencoded' \
  --data account_id=220614966801 \
  --data api_accesskey=32d42f0f0b6c89616d42aed8c96801e6 \
  --data action=GET_TRANSACTION_ID

This is an example of a PayConex API request using a pre-fetched transaction_id. For more PayConex API examples and information please see our Processing Transactions guide.

curl --request POST \
  --url https://cert.payconex.net/api/qsapi/3.8 \
  --header 'Content-Type: application/x-www-form-urlencoded' \
  --data account_id=220614966801 \
  --data api_accesskey=32d42f0f0b6c89616d42aed8c96801e6 \
  --data tender_type=CARD \
  --data transaction_type=SALE \
  --data transaction_amount=1.00 \
  --data card_number=4124939999999990 \
  --data card_expiration=1230 \
  --data card_verification=456 \
  --data transaction_id=000000101281

Fetching Transaction Details

This is an example of a request to fetch the details of a previous transaction:

curl --request POST \
  --url https://cert.payconex.net/api/tsapi/3.8 \
  --header 'Content-Type: application/x-www-form-urlencoded' \
  --data account_id=220614966801 \
  --data api_accesskey=32d42f0f0b6c89616d42aed8c96801e6 \
  --data action=GET_TRANSACTION_STATUS \
  --data transaction_id=000000101161

Handling Transaction Status API Responses

The Transaction Status API provides the response_format parameter to allow developers a method to specify a desired data format.

There are three supported data formats at this time:

  • FORM: A URL-encoded HTTP form query string.
  • JSON: A string in JavaScript Object Notation format.
  • DEBUG: A simple, human readable array output. Intended only for use by a developer for testing.

This is an example response where the action is GET_TRANSACTION_ID with the response_format value as JSON.

{
  "transaction_id": "000000101261",
  "error": false,
  "error_code": 0,
  "error_message": null,
  "error_msg": null
}

This is an example response where the action is GET_TRANSACTION_STATUS with the response_format value as JSON.

{
  "transaction_id": "000000101161",
  "transaction_timestamp": "2021-08-12 21:53:13",
  "authorization_message": "APPROVED",
  "transaction_amount": 1,
  "cashier": "QSAPI 3.8",
  "transaction_approved": true,
  "found": true,
  "error": false,
  "error_code": 0,
  "error_message": null,
  "error_msg": null
}

TSAPI Request Format

Indexed in the table below are all the variables that can be posted to TSAPI along with a brief description of each.

Variable Name Max Type Req'd Description
account_id 12 Numeric Yes This is the Payconex account identification number that you are issued after your account has been setup.
action n/a Enumerated Yes GET_TRANSACTION_ID: Returns a transaction_id for use with a new SALE, AUTHORIZATION, CREDIT transaction to be passed through the transaction_id variable. GET_TRANSACTION_STATUS: Returns the status of a transaction.
api_accesskey 32 Alphanumeric Yes This is a secret key that you will be provided when your Payconex account is set up and when you have requested access to QSAPI.
response_format 5 Enumerated No Desired response format. FORM: www-form-urlencoded string (default format) JSON: JavaScript Object Notation JSONP: JSON w/ Padding DEBUG: human readable array output
transaction_id 12 Numeric Yes/No Required for GET_TRANSACTION_STATUS action.

TSAPI Response Format

Indexed in the table below are all the variables that can be returned via TSAPI along with a brief description of each.

👍

Note

For your security, transactions older than 18 months may be purged from our system.

Variable Name Max Type Description
authorization_message 50 Alphanumeric Only returned from GET_TRANSACTION_STATUS if transaction is found. Same as the response from a QSAPI SALE transaction_type.
cashier 100 Alphanumeric Only returned from GET_TRANSACTION_STATUS if transaction is found. Same as the response from a QSAPI SALE transaction_type.
found 1 Boolean Returned from GET_TRANSACTION_STATUS action as True if transaction is found.
transaction_amount 9 Numeric with decimal Only returned from GET_TRANSACTION_STATUS if transaction is found. Same as the response from a QSAPI SALE transaction_type.
transaction_approved 1 Boolean Only returned from GET_TRANSACTION_STATUS if transaction is found. Same as the response from a QSAPI SALE transaction_type.
transaction_id 12 Numeric The only variable returned from the GET_TRANSACTION_ID action.
transaction_id 12 Numeric Only returned from GET_TRANSACTION_STATUS if transaction is found. Same as the response from a QSAPI SALE transaction_type.
transaction_timestamp 19 YYYY-MM-DD HH:MM:SS Only returned from GET_TRANSACTION_STATUS if transaction is found. Same as the response from a QSAPI SALE transaction_type.