Transaction history

Use this API to query the transaction history (credit and debit) of a Merchant or shop. You can filter by virtual account (VA) number, bank code or a specific time range for reconciliation.

POST

URLhttps://open-api.tingee.vn/v1/transaction/get-paging

Query the detailed transaction history. The result includes the amount, transaction type, time and transfer description.

Header Request

Header	Required	Description
`Content-Type`	✓	`application/json`
`x-client-id`	✓	Partner identifier issued by TINGEE.
`x-signature`	✓	HMAC SHA512 authentication signature. See How to generate the signature.
`x-request-timestamp`	✓	Time the request is sent (format: `yyyyMMddHHmmssSSS`, UTC+7)

Body Parameter

Field	Type	Required	Description
`skipCount`	number	✕	Number of records to skip (pagination).
`maxResultCount`	number	✕	Maximum number of records per page (up to `200`).
`merchantId`	number	✕	Merchant ID (required if you connect with a Master Merchant account).
`shopIds`	array	✕	List of shop IDs to filter by.
`vaAccountNumbers`	array	✕	List of virtual account numbers to filter by.
`bankBin`	string	✕	Bank BIN. See Supported banks.
`billId`	string	✕	Filter payment transactions for a dynamic QR code (the `billId` returned by the create dynamic QR API).
`startTime`	string	✓	Start time (format: `yyyyMMddHHmmss`, UTC+7).
`endTime`	string	✓	End time (format: `yyyyMMddHHmmss`, UTC+7).

Query time range limit

Each request can query a range of up to 10 days. The gap between startTime and endTime must not exceed 10 days. To get data for a longer period, split it into several smaller requests.

Code samples

cURL
NestJS
C#
Java
PHP

curl --location --request POST 'https://open-api.tingee.vn/v1/transaction/get-paging' \
--header 'accept: application/json' \
--header 'x-client-id: YOUR_CLIENT_ID' \
--header 'x-request-timestamp: 20240509154004003' \
--header 'x-signature: YOUR_SIGNATURE' \
--header 'Content-Type: application/json' \
--data '{
  "skipCount": 0,
  "maxResultCount": 50,
  "vaAccountNumbers": [
    "88880935926988"
  ],
  "bankBin": "970418",
  "startTime": "20251001000000",
  "endTime": "20251010235959"
}'

import axios from "axios";
import { createHmac } from "crypto";

const CLIENT_ID = "YOUR_CLIENT_ID";
const SECRET_KEY = "YOUR_SECRET_KEY";

// Timestamp in UTC+7, format yyyyMMddHHmmssSSS
function getTimestamp() {
    return new Date(Date.now() + 7 * 60 * 60 * 1000)
        .toISOString()
        .replace(/[-:TZ.]/g, "")
        .slice(0, 17);
}

async function transactionGetPaging() {
    const body = {
        skipCount: 0,
        maxResultCount: 50,
        vaAccountNumbers: [
            "88880935926988",
        ],
        bankBin: "970418",
        startTime: "20251001000000",
        endTime: "20251010235959",
    };

    const bodyJson = JSON.stringify(body);
    const timestamp = getTimestamp();
    const signature = createHmac("sha512", SECRET_KEY)
        .update(`${timestamp}:${bodyJson}`)
        .digest("hex");

    const res = await axios.request({
        method: "POST",
        url: "https://open-api.tingee.vn/v1/transaction/get-paging",
        data: bodyJson,
        headers: {
            accept: "application/json",
            "Content-Type": "application/json",
            "x-client-id": CLIENT_ID,
            "x-request-timestamp": timestamp,
            "x-signature": signature,
        },
    });

    console.log(res.data);
}

transactionGetPaging();

using System;
using System.Net.Http;
using System.Security.Cryptography;
using System.Text;
using System.Text.Encodings.Web;
using System.Text.Json;
using System.Threading.Tasks;

public class Program
{
    private const string ClientId = "YOUR_CLIENT_ID";
    private const string SecretKey = "YOUR_SECRET_KEY";
    private static readonly HttpClient Client = new HttpClient();

    public static async Task Main()
    {
        var body = new
        {
            skipCount = 0,
            maxResultCount = 50,
            vaAccountNumbers = new object[]
            {
                "88880935926988"
            },
            bankBin = "970418",
            startTime = "20251001000000",
            endTime = "20251010235959"
        };

        // Do not escape non-ASCII / special characters so the JSON matches TINGEE's JSON.stringify
        var jsonOptions = new JsonSerializerOptions { Encoder = JavaScriptEncoder.UnsafeRelaxedJsonEscaping };
        var bodyJson = JsonSerializer.Serialize(body, jsonOptions);

        // Timestamp in UTC+7, format yyyyMMddHHmmssSSS
        var timestamp = DateTime.UtcNow.AddHours(7).ToString("yyyyMMddHHmmssfff");
        var signature = HmacSha512(SecretKey, $"{timestamp}:{bodyJson}");

        var request = new HttpRequestMessage(HttpMethod.Post, "https://open-api.tingee.vn/v1/transaction/get-paging");
        request.Headers.Add("accept", "application/json");
        request.Headers.Add("x-client-id", ClientId);
        request.Headers.Add("x-request-timestamp", timestamp);
        request.Headers.Add("x-signature", signature);
        request.Content = new StringContent(bodyJson, Encoding.UTF8, "application/json");

        var response = await Client.SendAsync(request);
        Console.WriteLine(await response.Content.ReadAsStringAsync());
    }

    private static string HmacSha512(string key, string message)
    {
        using var hmac = new HMACSHA512(Encoding.UTF8.GetBytes(key));
        var hash = hmac.ComputeHash(Encoding.UTF8.GetBytes(message));
        return Convert.ToHexString(hash).ToLower();
    }
}

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.nio.charset.StandardCharsets;
import java.time.ZoneId;
import java.time.ZonedDateTime;
import java.time.format.DateTimeFormatter;
import javax.crypto.Mac;
import javax.crypto.spec.SecretKeySpec;

public class Main {
    private static final String CLIENT_ID = "YOUR_CLIENT_ID";
    private static final String SECRET_KEY = "YOUR_SECRET_KEY";

    public static void main(String[] args) throws Exception {
        // Minified JSON, same as JSON.stringify()
        String bodyJson = "{\"skipCount\":0,\"maxResultCount\":50,\"vaAccountNumbers\":[\"88880935926988\"],\"bankBin\":\"970418\",\"startTime\":\"20251001000000\",\"endTime\":\"20251010235959\"}";

        // Timestamp in UTC+7, format yyyyMMddHHmmssSSS
        String timestamp = ZonedDateTime.now(ZoneId.of("Asia/Ho_Chi_Minh"))
                .format(DateTimeFormatter.ofPattern("yyyyMMddHHmmssSSS"));
        String signature = hmacSha512(SECRET_KEY, timestamp + ":" + bodyJson);

        HttpRequest request = HttpRequest.newBuilder()
                .uri(URI.create("https://open-api.tingee.vn/v1/transaction/get-paging"))
                .header("accept", "application/json")
                .header("Content-Type", "application/json")
                .header("x-client-id", CLIENT_ID)
                .header("x-request-timestamp", timestamp)
                .header("x-signature", signature)
                .method("POST", HttpRequest.BodyPublishers.ofString(bodyJson, StandardCharsets.UTF_8))
                .build();

        HttpResponse<String> response = HttpClient.newHttpClient()
                .send(request, HttpResponse.BodyHandlers.ofString());
        System.out.println(response.body());
    }

    private static String hmacSha512(String key, String data) throws Exception {
        Mac mac = Mac.getInstance("HmacSHA512");
        mac.init(new SecretKeySpec(key.getBytes(StandardCharsets.UTF_8), "HmacSHA512"));
        byte[] hash = mac.doFinal(data.getBytes(StandardCharsets.UTF_8));
        StringBuilder hex = new StringBuilder();
        for (byte b : hash) hex.append(String.format("%02x", b));
        return hex.toString();
    }
}

<?php
$clientId = "YOUR_CLIENT_ID";
$secretKey = "YOUR_SECRET_KEY";

$body = [
    "skipCount" => 0,
    "maxResultCount" => 50,
    "vaAccountNumbers" => [
        "88880935926988",
    ],
    "bankBin" => "970418",
    "startTime" => "20251001000000",
    "endTime" => "20251010235959",
];

// Do not escape "/" or non-ASCII characters so the JSON matches TINGEE's JSON.stringify
$bodyJson = json_encode($body, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);

// Timestamp in UTC+7, format yyyyMMddHHmmssSSS
$now = new DateTime("now", new DateTimeZone("Asia/Ho_Chi_Minh"));
$timestamp = $now->format("YmdHisv");
$signature = hash_hmac("sha512", $timestamp . ":" . $bodyJson, $secretKey);

$ch = curl_init();
curl_setopt_array($ch, [
    CURLOPT_URL => "https://open-api.tingee.vn/v1/transaction/get-paging",
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_CUSTOMREQUEST => "POST",
    CURLOPT_POSTFIELDS => $bodyJson,
    CURLOPT_HTTPHEADER => [
        "Accept: application/json",
        "Content-Type: application/json",
        "x-client-id: " . $clientId,
        "x-request-timestamp: " . $timestamp,
        "x-signature: " . $signature,
    ],
]);

$response = curl_exec($ch);
if ($response === false) {
    echo "cURL Error: " . curl_error($ch);
} else {
    echo $response;
}
curl_close($ch);

Sample Response

{
  "code": "00",
  "message": "Success",
  "data": {
    "totalCount": 1,
    "items": [
      {
        "transactionId": "3f1c2a9e-8b4d-4e57-9a61-2c7d5b0e8f14",
        "merchantId": 1001,
        "shopId": 1024,
        "bankBin": "970418",
        "cashFlowSource": "bank-transfer",
        "code": "FT25283123456",
        "amount": 100000,
        "type": "credit",
        "content": "Thanh toan don hang 123",
        "currency": "VND",
        "accountNumber": "0935926988",
        "vaAccountNumber": "88880935926988",
        "transactionDate": "20251010103000",
        "billId": null
      }
    ]
  }
}

Field	Type	Description
`code`	string	Result code (`00` = success).
`message`	string	Response message.
`data.totalCount`	number	Total number of transactions found.
`data.items[].transactionId`	string	Transaction ID on the TINGEE system (UUID).
`data.items[].merchantId`	number	Merchant ID.
`data.items[].shopId`	number	Shop ID.
`data.items[].bankBin`	string	Bank BIN.
`data.items[].cashFlowSource`	string	Source of funds: `bank-transfer` (bank transfer) or `card` (card).
`data.items[].code`	string	Bank-side transaction code.
`data.items[].amount`	number	Transaction amount.
`data.items[].type`	string	Transaction type: `credit` or `debit`.
`data.items[].content`	string	Transfer description.
`data.items[].currency`	string	Currency.
`data.items[].accountNumber`	string	Original account number.
`data.items[].vaAccountNumber`	string	Virtual account number that received the money.
`data.items[].transactionDate`	string	Transaction time (format: `yyyyMMddHHmmss`, UTC+7).
`data.items[].billId`	string	Related dynamic QR ID (if the transaction is a payment for a dynamic QR code).

Common error codes

Code	Description	How to handle
`1107`	Time range exceeds the limit	`endTime` must not be more than 10 days after `startTime`. Split into several smaller requests.
`1108`	Page size too large	`maxResultCount` is at most 200.
`90`, `91`, `92`, `97`	Request authentication error (timestamp, client-id, signature)	See System error codes.
`Others`	Other errors	See Error codes.

Header Request​

Body Parameter​

Code samples​

Sample Response​

Common error codes​

Header Request

Body Parameter

Code samples

Sample Response

Common error codes