List transactions

GET/erp-transactions

Bearer token

Returns a paginated list of transactions for the company in the companyId header. Supports extensive filtering by transaction category, sync status, approval status, transaction status, card last four, employee, chart-of-account and tax-rate name/remote id, VAT and transaction amount ranges, billing and transaction currency, cardholder email, cleared and transaction time ranges, sync-exclusion flag, and Qashio id / parent Qashio id.

Query parameters

pagenumber: Example 1
limitnumber: Example 10
transactionCategorystring: Example card_loading
erpSyncStatusstring: Example pending
approvalStatusstring: Example pending
transactionStatusstring: Example draft
cardLastFourstring: Example 1234
employeeIdstring: Example emp-123
erpChartOfAccountNamestring: Example Expenses
erpChartOfAccountRemoteIdstring: Example abc
erpTaxRateNamestring: Example VAT 5%
erpTaxRateRemoteIdstring: Example tax_rate_1
vatAmountFromnumber: Example 5
vatAmountTonumber: Example 50
transactionAmountFromnumber: Example 100
transactionAmountTonumber: Example 1000
billingCurrencystring: Example USD
transactionCurrencystring: Example USD
cardHolderEmailstring: Example example@exmaple.com
clearedAtFromstring: Example 2024-01-01
clearedAtTostring: Example 2024-12-31
transactionTimeFromstring: Example 2024-01-01
transactionTimeTostring: Example 2024-12-31
excludeFromSyncboolean: Example false
parentQashioIdstring: Example CT123asd123
qashioIdstring: Example CT123asd123
idstring: Example c4943209-4462-455a-9bb9-f6781b3838bf

Header parameters

companyIdstringrequired: ID of the company to filter records
x-api-keystringrequired: Please provide a valid API Key

Response

Field	Type	Description
`page`	number
`totalPages`	number
`total`	number
`data`	object[]
`id`	string
`qashioId`	string
`companyId`	string
`cardExternalId`	string
`poolExternalId`	string
`amount`	number
`currency`	string
`transactionTime`	string
`transactionStatus`	string
`transactionMode`	string
`rrn`	string
`transactionDescription`	string
`transactionType`	string
`messageType`	string
`transmissionDateTime`	string
`vendorTrn`	string
`transactionAmount`	number
`transactionCurrency`	string
`purchaseOrderNumber`	string
`parentId`	string
`parentQashioId`	string
`memo`	string
`clearingStatus`	string
`vatAmount`	number
`transactionCategory`	string
`visible`	boolean
`clearedAt`	string
`excludeFromSync`	boolean
`status`	string
`syncErrors`	string[]
`erpSyncStatus`	string
`erpSyncType`	string
`merchantName`	string
`merchantCountry`	string
`erpSupplierName`	string
`erpSupplierRemoteId`	string
`poolAccountName`	string
`cardName`	string
`cardLastFour`	string
`cardHolderName`	string
`cardHolderEmail`	string
`employeeId`	string
`approvalStatus`	string
`approvedDateTime`	string
`approvedBy`	object
`chartOfAccountNumber`	string
`feeCharges`	number
`modifiedDate`	string
`receipts`	string[]
`segments`	any[]
`customSegments`	any[]
`createdAt`	string
`updatedAt`	string
`lineItems`	any[]

Errors

400Bad Request

Every error carries an errors[] array and a meta.request_id. See Errors for the full envelope.

GET/erp-transactions

curl -X GET 'https://erp.qashio.com/erp-transactions?page=1&limit=10' \
  -H 'Accept: application/json' \
  -H 'Authorization: Bearer <access_token>'

const accessToken = process.env.QASHIO_ACCESS_TOKEN;

const response = await fetch('https://erp.qashio.com/erp-transactions?page=1&limit=10', {
  method: 'GET',
  headers: {
    Accept: 'application/json',
    Authorization: `Bearer ${accessToken}`,
  },
});

if (!response.ok) {
  throw new Error(`Qashio API ${response.status}: ${await response.text()}`);
}

const { data, meta } = await response.json();
console.log(meta.request_id, data);

import https from 'node:https';

const url = new URL('https://erp.qashio.com/erp-transactions?page=1&limit=10');

const payload = await new Promise((resolve, reject) => {
  const req = https.request(
    url,
    {
      method: 'GET',
      headers: {
      Accept: 'application/json',
      Authorization: `Bearer ${process.env.QASHIO_ACCESS_TOKEN}`,
      },
    },
    (res) => {
      let raw = '';
      res.on('data', (chunk) => (raw += chunk));
      res.on('end', () => resolve(JSON.parse(raw)));
    },
  );
  req.on('error', reject);
  req.end();
});

console.log(payload.data);

import os
import requests

url = "https://erp.qashio.com/erp-transactions"
headers = {
    "Accept": "application/json",
    "Authorization": f"Bearer {os.environ['QASHIO_ACCESS_TOKEN']}",
}

params = {
    "page": 1,
    "limit": 10,
}

response = requests.get(url, headers=headers, params=params, timeout=30)
response.raise_for_status()

body = response.json()
print(body["meta"]["request_id"], body["data"])

<?php

$ch = curl_init('https://erp.qashio.com/erp-transactions?page=1&limit=10');

curl_setopt_array($ch, [
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_CUSTOMREQUEST  => 'GET',
  CURLOPT_HTTPHEADER     => [
      'Accept: application/json',
      'Authorization: Bearer ' . getenv('QASHIO_ACCESS_TOKEN'),
  ],
]);

$response = curl_exec($ch);
curl_close($ch);

$body = json_decode($response, true);
print_r($body['data']);

package main

import (
	"encoding/json"
	"fmt"
	"net/http"
	"os"
)

func main() {
	req, _ := http.NewRequest("GET", "https://erp.qashio.com/erp-transactions?page=1&limit=10", nil)
	req.Header.Set("Accept", "application/json")
	req.Header.Set("Authorization", "Bearer "+os.Getenv("QASHIO_ACCESS_TOKEN"))

	res, err := http.DefaultClient.Do(req)
	if err != nil {
		panic(err)
	}
	defer res.Body.Close()

	var out map[string]any
	json.NewDecoder(res.Body).Decode(&out)
	fmt.Println(out["data"])
}

require 'net/http'
require 'json'
require 'uri'

uri = URI('https://erp.qashio.com/erp-transactions?page=1&limit=10')
request = Net::HTTP::Get.new(uri)
request['Accept'] = 'application/json'
request['Authorization'] = "Bearer #{ENV.fetch('QASHIO_ACCESS_TOKEN')}"

response = Net::HTTP.start(uri.hostname, uri.port, use_ssl: uri.scheme == 'https') do |http|
  http.request(request)
end

body = JSON.parse(response.body)
puts body['data']

import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;

public class QashioExample {
  public static void main(String[] args) throws Exception {
    HttpRequest request = HttpRequest.newBuilder()
        .uri(URI.create("https://erp.qashio.com/erp-transactions?page=1&limit=10"))
        .header("Accept", "application/json")
        .header("Authorization", "Bearer " + System.getenv("QASHIO_ACCESS_TOKEN"))
        .method("GET", HttpRequest.BodyPublishers.noBody())
        .build();

    HttpResponse<String> response = HttpClient.newHttpClient()
        .send(request, HttpResponse.BodyHandlers.ofString());

    System.out.println(response.body());
  }
}

using System;
using System.Net.Http;
using System.Threading.Tasks;

var client = new HttpClient();

var request = new HttpRequestMessage(new HttpMethod("GET"), "https://erp.qashio.com/erp-transactions?page=1&limit=10");
request.Headers.Add("Accept", "application/json");
request.Headers.Add("Authorization", $"Bearer {Environment.GetEnvironmentVariable("QASHIO_ACCESS_TOKEN")}");

var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();

Console.WriteLine(await response.Content.ReadAsStringAsync());

import Foundation

var request = URLRequest(url: URL(string: "https://erp.qashio.com/erp-transactions?page=1&limit=10")!)
request.httpMethod = "GET"
request.setValue("application/json", forHTTPHeaderField: "Accept")
let token = ProcessInfo.processInfo.environment["QASHIO_ACCESS_TOKEN"]!
request.setValue("Bearer \(token)", forHTTPHeaderField: "Authorization")

let (data, _) = try await URLSession.shared.data(for: request)
print(String(data: data, encoding: .utf8)!)

Response

[
  {
    "page": 1,
    "totalPages": 1,
    "total": 1,
    "data": [
      {
        "id": "c4943209-4462-455a-9bb9-f6781b3838bf",
        "qashioId": "CT123asd123",
        "companyId": "COoyy0mfzqhxtbkm",
        "cardExternalId": "CA0zkna0yao4vpfq",
        "poolExternalId": "ACpool1234567890",
        "amount": 102,
        "currency": "USD",
        "transactionTime": "2025-02-18T11:44:39.204Z",
        "transactionStatus": "draft",
        "transactionMode": "Online",
        "rrn": "RRN-1739879079204-2",
        "transactionDescription": "Transaction for vendor 2",
        "transactionType": "Purchase",
        "messageType": "MTI123",
        "transmissionDateTime": "2025-02-18T11:44:39.204Z",
        "vendorTrn": "VendorTrn-2",
        "transactionAmount": 102.5,
        "transactionCurrency": "USD",
        "purchaseOrderNumber": "PO-2",
        "parentId": null,
        "parentQashioId": null,
        "memo": "Memo for transaction 2",
        "clearingStatus": "Processed",
        "vatAmount": 12,
        "transactionCategory": "Purchase",
        "visible": true,
        "clearedAt": "2025-02-18T11:44:39.204Z",
        "excludeFromSync": false,
        "status": "draft",
        "syncErrors": [],
        "erpSyncStatus": "Pending",
        "erpSyncType": "Full",
        "merchantName": "Amazon",
        "merchantCountry": "AE",
        "erpSupplierName": "Supplier 2",
        "erpSupplierRemoteId": "remote-id-2",
        "poolAccountName": "Account 2",
        "cardName": "Visa Platinum",
        "cardLastFour": "0002",
        "cardHolderName": "Card Holder 2",
        "cardHolderEmail": "holder2@example.com",
        "employeeId": "emp-123",
        "approvalStatus": "Pending",
        "approvedDateTime": "2026-03-15T16:45:22.000Z",
        "approvedBy": {
          "userExternalId": "UP95egoevjjmct7u",
          "name": "Zahid Automation"
        },
        "chartOfAccountNumber": "COA-6100",
        "feeCharges": 2.75,
        "modifiedDate": "2026-03-16T09:12:05.000Z",
        "receipts": [
          "https://example.com/receipt1.jpg",
          "https://example.com/receipt2.jpg"
        ],
        "segments": [
          {
            "name": "Main Office",
            "label": "Location",
            "erp_internal_id": "LOC-001",
            "code": "MO"
          },
          {
            "name": "Project Alpha",
            "label": "Project",
            "erp_internal_id": "PROJ-001",
            "code": "PA"
          },
          {
            "name": "Engineering",
            "label": "Division",
            "erp_internal_id": "DIV-001",
            "code": "ENG"
          },
          {
            "name": "IT Department",
            "label": "Department",
            "erp_internal_id": "DEPT-001"
          },
          {
            "name": "Vendor Name",
            "label": "CustomSegment-Vender",
            "code": "VENDOR-001"
          },
          {
            "name": "Customer Name",
            "label": "CustomSegment-Customer",
            "code": "CUSTOMER-001"
          }
        ],
        "customSegments": [
          {
            "label": "CustomSegment-Vender",
            "name": "Vendor Name",
            "erp_internal_id": null,
            "code": "VENDOR-001"
          }
        ],
        "createdAt": "2025-02-18T11:44:39.211Z",
        "updatedAt": "2025-02-18T11:44:39.211Z",
        "lineItems": [
          {
            "id": "7d31f208-e6d7-42c8-adad-a66a19206ffa",
            "amount": 120,
            "vatAmount": 14,
            "description": "Line Item for Transaction 2",
            "expenseCategory": "Office Supplies",
            "erpTaxRateName": "Tax Rate 2",
            "erpTaxRateRemoteId": "tax-rate-remote-id-2",
            "erpChartOfAccountName": "Account 2",
            "erpChartOfAccountRemoteId": "chart-account-remote-id-2",
            "segments": [
              {
                "name": "Main Office",
                "label": "Location",
                "erp_internal_id": "LOC-001",
                "code": "MO"
              },
              {
                "name": "Project Alpha",
                "label": "Project",
                "erp_internal_id": "PROJ-001",
                "code": "PA"
              },
              {
                "name": "Engineering",
                "label": "Division",
                "erp_internal_id": "DIV-001",
                "code": "ENG"
              },
              {
                "name": "IT Department",
                "label": "Department",
                "erp_internal_id": "DEPT-001"
              },
              {
                "name": "Vendor Name",
                "label": "CustomSegment-Vender",
                "code": "VENDOR-001"
              },
              {
                "name": "Customer Name",
                "label": "CustomSegment-Customer",
                "code": "CUSTOMER-001"
              }
            ],
            "createdAt": "2025-02-18T12:59:22.393Z",
            "updatedAt": "2025-02-18T12:59:22.393Z"
          },
          {
            "id": "a2f5bcf2-3743-4573-a88f-477cfd6f3e52",
            "amount": 120,
            "vatAmount": 14,
            "description": "Line Item for Transaction 2",
            "erpTaxRateName": "Tax Rate 2",
            "erpTaxRateRemoteId": "tax-rate-remote-id-2",
            "erpChartOfAccountName": "Account 2",
            "erpChartOfAccountRemoteId": "chart-account-remote-id-2",
            "segments": [
              {
                "name": "Main Office",
                "label": "Location",
                "erp_internal_id": "LOC-001",
                "code": "MO"
              },
              {
                "name": "Project Alpha",
                "label": "Project",
                "erp_internal_id": "PROJ-001",
                "code": "PA"
              },
              {
                "name": "Engineering",
                "label": "Division",
                "erp_internal_id": "DIV-001",
                "code": "ENG"
              },
              {
                "name": "IT Department",
                "label": "Department",
                "erp_internal_id": "DEPT-001"
              },
              {
                "name": "Vendor Name",
                "label": "CustomSegment-Vender",
                "code": "VENDOR-001"
              },
              {
                "name": "Customer Name",
                "label": "CustomSegment-Customer",
                "code": "CUSTOMER-001"
              }
            ],
            "createdAt": "2025-02-18T12:59:46.648Z",
            "updatedAt": "2025-02-18T12:59:46.648Z"
          }
        ]
      }
    ]
  }
]

{
  "message": [
    "id must be a UUID"
  ],
  "error": "Bad Request",
  "statusCode": 400
}