> This is Payabli documentation. For a complete page index, fetch https://docs.payabli.com/llms.txt — append .md to any page URL for lightweight markdown. For section-level indexes, query parameters, and other AI-optimized access methods, see https://docs.payabli.com/ai-agents.md

# List vcard transactions by paypoint

GET https://api-sandbox.payabli.com/api/Query/vcardsTransactions/{entry}

Retrieve a list of virtual card transactions for an entrypoint. Use filters to limit results.

Reference: https://docs.payabli.com/developers/api-reference/query/get-list-of-virtual-card-transactions-for-entrypoint

## OpenAPI Specification

```yaml
openapi: 3.1.0
info:
  title: payabliApi-oas
  version: 1.0.0
paths:
  /Query/vcardsTransactions/{entry}:
    get:
      operationId: ListVcardsTransactions
      summary: Get list of virtual card transactions for entrypoint
      description: >-
        Retrieve a list of virtual card transactions for an entrypoint. Use
        filters to limit results.
      tags:
        - Query
      parameters:
        - name: entry
          in: path
          description: >-
            The entity's entrypoint identifier. [Learn
            more](/developers/api-reference/api-overview#entrypoint-vs-entry)
          required: true
          schema:
            $ref: '#/components/schemas/Entry'
        - name: fromRecord
          in: query
          description: >-
            The number of records to skip before starting to collect the result
            set.
          required: false
          schema:
            type: integer
            default: 0
        - name: limitRecord
          in: query
          description: >-
            Max number of records to return for the query. Use `0` or negative
            value to return all records.
          required: false
          schema:
            type: integer
            default: 20
        - name: parameters
          in: query
          description: >-
            Collection of field names, conditions, and values used to filter the
            query.


            <Info>
              **You must remove `parameters=` from the request before you send it, otherwise Payabli will ignore the filters.**

              Because of a technical limitation, you can't make a request that includes filters from the API console on this page. The response won't be filtered. Instead, copy the request, remove `parameters=` and run the request in a different client.

              For example:

              --url https://api-sandbox.payabli.com/api/Query/vcardsTransactions/8cfec329267?parameters=transactionAmount(gt)=100&limitRecord=20

              should become:

              --url https://api-sandbox.payabli.com/api/Query/vcardsTransactions/8cfec329267?transactionAmount(gt)=100&limitRecord=20
            </Info>


            List of field names accepted:

              - `identifier` (eq, ne, ct, nct)
              - `transactionType` (eq, ne, ct, nct)
              - `transactionStatus` (eq, ne, ct, nct, in, nin)
              - `transactionAmount` (eq, ne, gt, ge, lt, le, ct, nct)
              - `transactionCreatedOn` (eq, ne, gt, ge, lt, le)
              - `cardToken` (ct, nct, eq, ne)
              - `lastFour` (ct, nct, eq, ne)
              - `expirationDate` (ct, nct, eq, ne)
              - `mcc` (ct, nct, eq, ne)
              - `payoutId` (gt, lt, eq, ne)
              - `customerId` (gt, lt, eq, ne)
              - `vendorId` (gt, lt, eq, ne)
              - `miscData1` (ct, nct, eq, ne)
              - `miscData2` (ct, nct, eq, ne)
              - `currentUses` (gt, ge, lt, le, eq, ne)
              - `amount` (gt, ge, lt, le, eq, ne)
              - `balance` (gt, ge, lt, le, eq, ne)
              - `paypointLegal` (ne, eq, ct, nct)
              - `paypointDba` (ne, eq, ct, nct)
              - `orgName` (ne, eq, ct, nct, in, nin)
              - `externalPaypointID` (ct, nct, eq, ne)
              - `paypointId` (gt, lt, eq, ne)

            List of comparison accepted - enclosed between parentheses:

              - eq or empty => equal
              - gt => greater than
              - ge => greater or equal
              - lt => less than
              - le => less or equal
              - ne => not equal
              - ct => contains
              - nct => not contains
              - in => inside array separated by "|"
              - nin => not inside array separated by "|"
          required: false
          schema:
            type: object
            additionalProperties:
              type:
                - string
                - 'null'
        - name: sortBy
          in: query
          description: >-
            The field name to use for sorting results. Use `desc(field_name)` to
            sort descending by `field_name`, and use `asc(field_name)` to sort
            ascending by `field_name`.
          required: false
          schema:
            type: string
        - name: requestToken
          in: header
          description: >
            Long-lived API token sent in the `requestToken` header. See [API
            token authentication](/developers/api-tokens).
          required: true
          schema:
            type: string
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/VCardTransactionQueryResponse'
        '400':
          description: Bad request / invalid data.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PayabliErrorBody'
        '401':
          description: Unauthorized request.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PayabliErrorBody'
        '500':
          description: Internal server error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PayabliErrorBody'
        '503':
          description: Database connection error.
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/PayabliErrorBody'
servers:
  - url: https://api-sandbox.payabli.com/api
    description: Sandbox
  - url: https://api.payabli.com/api
    description: Production
components:
  schemas:
    Entry:
      type: string
      description: >
        The entity's entrypoint identifier.

        [Learn
        more](/developers/api-reference/api-overview#entrypoint-vs-entry).
      title: Entry
    Totalpages:
      type: integer
      description: Total number of pages in response.
      title: Totalpages
    Totalrecords:
      type: integer
      description: Total number of records in response.
      title: Totalrecords
    PageIdentifier:
      type: string
      description: Auxiliary validation used internally by payment pages and components.
      title: PageIdentifier
    Pagesize:
      type: integer
      description: Number of records on each response page.
      title: Pagesize
    VCardSummary:
      type: object
      properties:
        totalPages:
          $ref: '#/components/schemas/Totalpages'
        totalRecords:
          $ref: '#/components/schemas/Totalrecords'
        totalAmount:
          type: number
          format: double
          description: Total amount for the records.
        totalNetAmount:
          type: number
          format: double
          description: Total net amount for the records.
        totalactive:
          type: integer
          description: Total number of active vCards.
        totalamountactive:
          type: number
          format: double
          description: Total amount of active vCards.
        totalbalanceactive:
          type: number
          format: double
          description: Total balance of active vCards.
        pageidentifier:
          $ref: '#/components/schemas/PageIdentifier'
        pageSize:
          $ref: '#/components/schemas/Pagesize'
      required:
        - totalPages
        - totalRecords
        - totalAmount
        - totalactive
        - totalamountactive
        - totalbalanceactive
      title: VCardSummary
    Mcc:
      type: string
      description: >
        Business Merchant Category Code (MCC).

        [This
        resource](https://github.com/greggles/mcc-codes/blob/main/mcc_codes.csv)

        lists MCC codes.
      title: Mcc
    Legalname:
      type: string
      description: Business legal name.
      title: Legalname
    Dbaname:
      type: string
      description: |
        The alternate or common name that this business is doing business under,
        usually referred to as a DBA name.
      title: Dbaname
    ExternalPaypointId:
      type: string
      description: |
        A custom identifier for the paypoint, if applicable.
      title: ExternalPaypointId
    OrgParentName:
      type: string
      description: The name of the parent organization.
      title: OrgParentName
    VCardTransactionRecord:
      type: object
      properties:
        Identifier:
          type:
            - string
            - 'null'
          description: Unique identifier for the transaction.
        CardToken:
          type:
            - string
            - 'null'
          description: Token of the virtual card associated with the transaction.
        LastFour:
          type:
            - string
            - 'null'
          description: Last four digits of the masked virtual card number.
        ExpirationDate:
          type:
            - string
            - 'null'
          description: Expiration date of the virtual card used for the transaction.
        Mcc:
          oneOf:
            - $ref: '#/components/schemas/Mcc'
            - type: 'null'
        PayoutId:
          type:
            - integer
            - 'null'
          format: int64
          description: Identifier of the payout linked to this transaction.
        CustomerId:
          type:
            - integer
            - 'null'
          format: int64
          description: Identifier of the customer linked to this transaction.
        VendorId:
          type:
            - integer
            - 'null'
          format: int64
          description: Identifier of the vendor linked to this transaction.
        MiscData1:
          type:
            - string
            - 'null'
          description: Custom field 1 from the virtual card.
        MiscData2:
          type:
            - string
            - 'null'
          description: Custom field 2 from the virtual card.
        CurrentUses:
          type:
            - integer
            - 'null'
          description: Number of times the virtual card has been used.
        Amount:
          type:
            - number
            - 'null'
          format: double
          description: Authorized amount on the virtual card.
        Balance:
          type:
            - number
            - 'null'
          format: double
          description: Current balance remaining on the virtual card.
        PaypointId:
          type:
            - integer
            - 'null'
          format: int64
          description: Numeric identifier of the paypoint that issued the virtual card.
        PaypointLegal:
          oneOf:
            - $ref: '#/components/schemas/Legalname'
            - type: 'null'
        PaypointDba:
          oneOf:
            - $ref: '#/components/schemas/Dbaname'
            - type: 'null'
        ExternalPaypointID:
          oneOf:
            - $ref: '#/components/schemas/ExternalPaypointId'
            - type: 'null'
        OrgName:
          oneOf:
            - $ref: '#/components/schemas/OrgParentName'
            - type: 'null'
        Type:
          type:
            - string
            - 'null'
          description: Transaction type, such as `AUTHORIZATION`.
        Status:
          type:
            - string
            - 'null'
          description: Transaction status, such as `AUTHORIZATION`.
        CreatedOn:
          type:
            - string
            - 'null'
          description: >-
            Date and time the transaction was created. Format: `YYYY-MM-DD
            HH:MM:SS.ffffff`.
        TransactionAmount:
          type:
            - string
            - 'null'
          description: Amount of the transaction, as a string value.
        PostedAmount:
          type:
            - string
            - 'null'
          description: Posted amount of the transaction, as a string value.
        PostedOn:
          type:
            - string
            - 'null'
          description: >-
            Date and time the transaction was posted, in format `YYYY-MM-DD
            HH:MM:SS.ffffff`. Null when the transaction hasn't posted yet.
        MerchantName:
          type:
            - string
            - 'null'
          description: Name of the merchant where the virtual card was used.
        AuthorizationStatus:
          type:
            - string
            - 'null'
          description: Authorization status of the transaction.
        ReasonToDecline:
          type:
            - string
            - 'null'
          description: Reason the transaction was declined, when applicable.
      required:
        - Identifier
        - CardToken
        - LastFour
        - ExpirationDate
        - Mcc
        - PayoutId
        - CustomerId
        - VendorId
        - MiscData1
        - MiscData2
        - CurrentUses
        - Amount
        - Balance
        - PaypointId
        - PaypointLegal
        - PaypointDba
        - ExternalPaypointID
        - OrgName
        - Type
        - Status
        - CreatedOn
        - TransactionAmount
        - PostedAmount
        - PostedOn
        - MerchantName
        - AuthorizationStatus
        - ReasonToDecline
      description: A virtual card transaction record returned by the query.
      title: VCardTransactionRecord
    VCardTransactionQueryResponse:
      type: object
      properties:
        Summary:
          $ref: '#/components/schemas/VCardSummary'
        Records:
          type: array
          items:
            $ref: '#/components/schemas/VCardTransactionRecord'
      required:
        - Summary
        - Records
      description: Response body for queries about virtual card transactions.
      title: VCardTransactionQueryResponse
    PayabliErrorBodyResponseData:
      type: object
      properties:
        explanation:
          type: string
          description: Human-readable explanation of what happened.
        todoAction:
          type: string
          description: Suggested resolution.
      description: Object with detailed error context.
      title: PayabliErrorBodyResponseData
    PayabliErrorBody:
      type: object
      properties:
        isSuccess:
          type: boolean
          description: Always `false` for error responses.
        responseCode:
          type: integer
          description: |
            Code for the response. Learn more in
            [API Response Codes](/developers/api-reference/api-responses).
        responseText:
          type: string
          description: Error text describing what went wrong.
        responseData:
          $ref: '#/components/schemas/PayabliErrorBodyResponseData'
          description: Object with detailed error context.
      required:
        - isSuccess
        - responseText
      description: |
        Shape returned by every Payabli API error response. The `responseData`
        object carries human-readable error context.
      title: PayabliErrorBody
  securitySchemes:
    APIKeyAuth:
      type: apiKey
      in: header
      name: requestToken
      description: >
        Long-lived API token sent in the `requestToken` header. See [API token
        authentication](/developers/api-tokens).
    BearerAuth:
      type: http
      scheme: bearer
      description: >
        OAuth2 Bearer access token from the client-credentials flow. See [OAuth
        authentication](/developers/oauth-authentication).

```

## Examples



**Response**

```json
{
  "Summary": {
    "totalPages": 20,
    "totalRecords": 393,
    "totalAmount": 231.58,
    "totalactive": 388,
    "totalamountactive": 219.58,
    "totalbalanceactive": -213.83
  },
  "Records": [
    {
      "Identifier": "7HQ2P9B4XD",
      "CardToken": "5RJ8MN2KC4",
      "LastFour": "1234",
      "ExpirationDate": "06-30-2029",
      "Mcc": "5943",
      "PayoutId": 84210,
      "CustomerId": 4440,
      "VendorId": 456,
      "MiscData1": "Invoice #12345",
      "MiscData2": "Project: Office Supplies",
      "CurrentUses": 1,
      "Amount": 500,
      "Balance": 425.5,
      "PaypointId": 3040,
      "PaypointLegal": "Global Factory LLC",
      "PaypointDba": "Global Factory",
      "ExternalPaypointID": "pay-10",
      "OrgName": "SupplyPro",
      "Type": "AUTHORIZATION",
      "Status": "AUTHORIZATION",
      "CreatedOn": "2026-05-05 03:28:53.082830",
      "TransactionAmount": "74.500",
      "PostedAmount": "0.000",
      "PostedOn": null,
      "MerchantName": "Office Supply Co.",
      "AuthorizationStatus": "AUTHORIZATION",
      "ReasonToDecline": null
    }
  ]
}
```

**SDK Code**

```typescript
import { PayabliClient } from "@payabli/sdk-node";

async function main() {
    const client = new PayabliClient({
        apiKey: "YOUR_API_KEY_HERE",
    });
    await client.query.listVcardsTransactions("8cfec329267", {
        fromRecord: 0,
        limitRecord: 20,
        sortBy: "desc(CreatedOn)",
    });
}
main();

```

```python
from payabli import payabli

client = payabli(
    api_key="YOUR_API_KEY_HERE",
)

client.query.list_vcards_transactions(
    entry="8cfec329267",
    from_record=0,
    limit_record=20,
    sort_by="desc(CreatedOn)",
)

```

```java
package com.example.usage;

import io.github.payabli.api.PayabliPayabliApiOasClient;
import io.github.payabli.api.resources.query.requests.ListVcardsTransactionsRequest;

public class Example {
    public static void main(String[] args) {
        PayabliPayabliApiOasClient client = PayabliPayabliApiOasClient
            .builder()
            .apiKey("YOUR_API_KEY_HERE")
            .build();

        client.query().listVcardsTransactions(
            "8cfec329267",
            ListVcardsTransactionsRequest
                .builder()
                .fromRecord(0)
                .limitRecord(20)
                .sortBy("desc(CreatedOn)")
                .build()
        );
    }
}
```

```csharp
using PayabliPayabliApiOas;
using System.Threading.Tasks;

namespace Usage;

public class Example
{
    public async Task Do() {
        var client = new PayabliPayabliApiOasClient(
            apiKey: "YOUR_API_KEY_HERE"
        );

        await client.Query.ListVcardsTransactionsAsync(
            "8cfec329267",
            new ListVcardsTransactionsRequest {
                FromRecord = 0,
                LimitRecord = 20,
                SortBy = "desc(CreatedOn)"
            }
        );
    }

}

```

```go
package example

import (
    context "context"

    payabli "github.com/payabli/sdk-go"
    client "github.com/payabli/sdk-go/client"
    option "github.com/payabli/sdk-go/option"
)

func do() {
    client := client.NewClient(
        option.WithApiKey(
            "YOUR_API_KEY_HERE",
        ),
    )
    request := &payabli.ListVcardsTransactionsRequest{
        FromRecord: payabli.Int(
            0,
        ),
        LimitRecord: payabli.Int(
            20,
        ),
        SortBy: payabli.String(
            "desc(CreatedOn)",
        ),
    }
    client.Query.ListVcardsTransactions(
        context.TODO(),
        "8cfec329267",
        request,
    )
}

```

```php
<?php

namespace Example;

use Payabli\PayabliClient;
use Payabli\Query\Requests\ListVcardsTransactionsRequest;

$client = new PayabliClient(
    apiKey: 'YOUR_API_KEY_HERE',
);
$client->query->listVcardsTransactions(
    '8cfec329267',
    new ListVcardsTransactionsRequest([
        'fromRecord' => 0,
        'limitRecord' => 20,
        'sortBy' => 'desc(CreatedOn)',
    ]),
);

```

```ruby
require 'uri'
require 'net/http'

url = URI("https://api-sandbox.payabli.com/api/Query/vcardsTransactions/8cfec329267?fromRecord=0&limitRecord=20&sortBy=desc%28CreatedOn%29")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["requestToken"] = '<apiKey>'

response = http.request(request)
puts response.read_body
```

```swift
import Foundation

let headers = ["requestToken": "<apiKey>"]

let request = NSMutableURLRequest(url: NSURL(string: "https://api-sandbox.payabli.com/api/Query/vcardsTransactions/8cfec329267?fromRecord=0&limitRecord=20&sortBy=desc%28CreatedOn%29")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "GET"
request.allHTTPHeaderFields = headers

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```