Class TransactionAdminService

Read-only query services to fetch normalised transactions across all products

If you need more info about a transaction, fetch it using its specific service. Transaction Service will remain generic and high-level.

Index

Constructors

constructor

Methods

countByMethod getBaseQuery search searchCustomerIds searchEntities searchPaymentInstrumentIds searchWalletAddresses

Constructors

constructor

new TransactionAdminService(
    args: {
        db: B2bDatabase;
        solanaTokenMintAddressService: SolanaTokenMintAddressService;
    },
): TransactionAdminService
Parameters
- args: {
  db: B2bDatabase;
  solanaTokenMintAddressService: SolanaTokenMintAddressService;
  }
Returns TransactionAdminService
- Defined in transaction-services/src/TransactionAdminService.ts:47

Methods

countByMethod

countByMethod(
    __namedParameters: {
        statuses: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[];
        token?: Token;
    },
): Promise<
    {
        ok: true;
        value: {
            counts: {
                count: number;
                method: | "REDEMPTION"
                | "SWAP"
                | "VIRTUAL_CARD"
                | "PHYSICAL_CARD"
                | "DEPOSIT_US_CASH"
                | "DEPOSIT_US_BANK_ACH"
                | "DEPOSIT_ACH_CREDIT"
                | "DEPOSIT_RTP"
                | "DEPOSIT_US_WIRE"
                | "DEPOSIT_SWIFT_WIRE"
                | "TRANSFER_NETWORK"
                | "TRANSFER"
                | "WITHDRAW_AF_BANK"
                | "WITHDRAW_AF_MOMO"
                | "WITHDRAW_MX_SPEI"
                | "WITHDRAW_SWIFT_WIRE"
                | "WITHDRAW_BLOCKCHAIN"
                | "WITHDRAW_US_BANK_ACH"
                | "WITHDRAW_US_INSTANT"
                | "WITHDRAW_ACH_PULL"
                | "WITHDRAW_US_WIRE_DRAWDOWN"
                | "WITHDRAW_US_WIRE"
                | "DEPOSIT_BLOCKCHAIN"
                | "DEPOSIT_DIRECT"
                | "FEE_TRANSFER";
            }[];
        };
    },
>
Count transactions grouped by method, scoped to the given statuses (e.g. ["PROCESSING"] for in-flight / stuck transactions). Returns one entry per method that has at least one matching row; methods with zero matches are omitted. Order is unspecified — callers sort.
Parameters
- __namedParameters: {
  statuses: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[];
  token?: Token;
  }
Returns Promise<
    {
        ok: true;
        value: {
            counts: {
                count: number;
                method: | "REDEMPTION"
                | "SWAP"
                | "VIRTUAL_CARD"
                | "PHYSICAL_CARD"
                | "DEPOSIT_US_CASH"
                | "DEPOSIT_US_BANK_ACH"
                | "DEPOSIT_ACH_CREDIT"
                | "DEPOSIT_RTP"
                | "DEPOSIT_US_WIRE"
                | "DEPOSIT_SWIFT_WIRE"
                | "TRANSFER_NETWORK"
                | "TRANSFER"
                | "WITHDRAW_AF_BANK"
                | "WITHDRAW_AF_MOMO"
                | "WITHDRAW_MX_SPEI"
                | "WITHDRAW_SWIFT_WIRE"
                | "WITHDRAW_BLOCKCHAIN"
                | "WITHDRAW_US_BANK_ACH"
                | "WITHDRAW_US_INSTANT"
                | "WITHDRAW_ACH_PULL"
                | "WITHDRAW_US_WIRE_DRAWDOWN"
                | "WITHDRAW_US_WIRE"
                | "DEPOSIT_BLOCKCHAIN"
                | "DEPOSIT_DIRECT"
                | "FEE_TRANSFER";
            }[];
        };
    },
>
- Defined in transaction-services/src/TransactionAdminService.ts:336

getBaseQuery

getBaseQuery(token?: Token): { params: unknown[]; sql: string }
Returns the base UNION query (all selects enabled) as a SQL string with params.
Parameters
- token: Token = "MOVEUSD"
Returns { params: unknown[]; sql: string }
- Defined in transaction-services/src/TransactionAdminService.ts:56

search

search(
    __namedParameters: {
        amount?: { operator: "EQ" | "LTE" | "GTE"; value: BigNumber };
        bankIds?: Required<
            "greendot"
            | "dart"
            | "burling"
            | "jiko"
            | "fib"
            | undefined,
        >[];
        bankTransactionIds?: (string | undefined)[];
        cardIds?: string[];
        createdAt?: DbTimestampCriteria;
        customerIds?: string[];
        entityIds?: string[];
        entityTypes?: NonNullable<"IDENTITY" | "ORGANIZATION" | null>[];
        ids?: string[];
        methods?: (
            | "REDEMPTION"
            | "SWAP"
            | "VIRTUAL_CARD"
            | "PHYSICAL_CARD"
            | "DEPOSIT_US_CASH"
            | "DEPOSIT_US_BANK_ACH"
            | "DEPOSIT_ACH_CREDIT"
            | "DEPOSIT_RTP"
            | "DEPOSIT_US_WIRE"
            | "DEPOSIT_SWIFT_WIRE"
            | "TRANSFER_NETWORK"
            | "TRANSFER"
            | "WITHDRAW_AF_BANK"
            | "WITHDRAW_AF_MOMO"
            | "WITHDRAW_MX_SPEI"
            | "WITHDRAW_SWIFT_WIRE"
            | "WITHDRAW_BLOCKCHAIN"
            | "WITHDRAW_US_BANK_ACH"
            | "WITHDRAW_US_INSTANT"
            | "WITHDRAW_ACH_PULL"
            | "WITHDRAW_US_WIRE_DRAWDOWN"
            | "WITHDRAW_US_WIRE"
            | "DEPOSIT_BLOCKCHAIN"
            | "DEPOSIT_DIRECT"
            | "FEE_TRANSFER"
        )[];
        orderBy?: { direction: "ASC"
        | "DESC"; field: "createdAt" | "updatedAt" }[];
        page?: number;
        pageSize?: number;
        paymentInstrumentIds?: (string | undefined)[];
        signatures?: string[];
        statuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[];
        subtypes?: ("FEE" | "RETURN" | undefined)[] | null;
        token?: Token;
        types?: ("CREDIT" | "DEBIT")[];
        updatedAt?: DbTimestampCriteria;
        walletAddresses?: Address[];
    },
): Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (Transaction & { customerId: string })[];
        };
    },
>
Parameters
- __namedParameters: {
      amount?: { operator: "EQ" | "LTE" | "GTE"; value: BigNumber };
      bankIds?: Required<
          "greendot"
          | "dart"
          | "burling"
          | "jiko"
          | "fib"
          | undefined,
      >[];
      bankTransactionIds?: (string | undefined)[];
      cardIds?: string[];
      createdAt?: DbTimestampCriteria;
      customerIds?: string[];
      entityIds?: string[];
      entityTypes?: NonNullable<"IDENTITY" | "ORGANIZATION" | null>[];
      ids?: string[];
      methods?: (
          | "REDEMPTION"
          | "SWAP"
          | "VIRTUAL_CARD"
          | "PHYSICAL_CARD"
          | "DEPOSIT_US_CASH"
          | "DEPOSIT_US_BANK_ACH"
          | "DEPOSIT_ACH_CREDIT"
          | "DEPOSIT_RTP"
          | "DEPOSIT_US_WIRE"
          | "DEPOSIT_SWIFT_WIRE"
          | "TRANSFER_NETWORK"
          | "TRANSFER"
          | "WITHDRAW_AF_BANK"
          | "WITHDRAW_AF_MOMO"
          | "WITHDRAW_MX_SPEI"
          | "WITHDRAW_SWIFT_WIRE"
          | "WITHDRAW_BLOCKCHAIN"
          | "WITHDRAW_US_BANK_ACH"
          | "WITHDRAW_US_INSTANT"
          | "WITHDRAW_ACH_PULL"
          | "WITHDRAW_US_WIRE_DRAWDOWN"
          | "WITHDRAW_US_WIRE"
          | "DEPOSIT_BLOCKCHAIN"
          | "DEPOSIT_DIRECT"
          | "FEE_TRANSFER"
      )[];
      orderBy?: { direction: "ASC"
      | "DESC"; field: "createdAt" | "updatedAt" }[];
      page?: number;
      pageSize?: number;
      paymentInstrumentIds?: (string | undefined)[];
      signatures?: string[];
      statuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[];
      subtypes?: ("FEE" | "RETURN" | undefined)[] | null;
      token?: Token;
      types?: ("CREDIT" | "DEBIT")[];
      updatedAt?: DbTimestampCriteria;
      walletAddresses?: Address[];
  }
  - Optionalamount?: { operator: "EQ" | "LTE" | "GTE"; value: BigNumber }
  - OptionalbankIds?: Required<"greendot" | "dart" | "burling" | "jiko" | "fib" | undefined>[]
  - OptionalbankTransactionIds?: (string | undefined)[]
  - OptionalcardIds?: string[]
  - OptionalcreatedAt?: DbTimestampCriteria
  - OptionalcustomerIds?: string[]
  - OptionalentityIds?: string[]
  - OptionalentityTypes?: NonNullable<"IDENTITY" | "ORGANIZATION" | null>[]
  - Optionalids?: string[]
  - Optionalmethods?: (
        | "REDEMPTION"
        | "SWAP"
        | "VIRTUAL_CARD"
        | "PHYSICAL_CARD"
        | "DEPOSIT_US_CASH"
        | "DEPOSIT_US_BANK_ACH"
        | "DEPOSIT_ACH_CREDIT"
        | "DEPOSIT_RTP"
        | "DEPOSIT_US_WIRE"
        | "DEPOSIT_SWIFT_WIRE"
        | "TRANSFER_NETWORK"
        | "TRANSFER"
        | "WITHDRAW_AF_BANK"
        | "WITHDRAW_AF_MOMO"
        | "WITHDRAW_MX_SPEI"
        | "WITHDRAW_SWIFT_WIRE"
        | "WITHDRAW_BLOCKCHAIN"
        | "WITHDRAW_US_BANK_ACH"
        | "WITHDRAW_US_INSTANT"
        | "WITHDRAW_ACH_PULL"
        | "WITHDRAW_US_WIRE_DRAWDOWN"
        | "WITHDRAW_US_WIRE"
        | "DEPOSIT_BLOCKCHAIN"
        | "DEPOSIT_DIRECT"
        | "FEE_TRANSFER"
    )[]
  - OptionalorderBy?: { direction: "ASC" | "DESC"; field: "createdAt" | "updatedAt" }[]
    Defaults to createdAt DESC
  - Optionalpage?: number
    Defaults to 1
  - OptionalpageSize?: number
    Defaults to 10
  - OptionalpaymentInstrumentIds?: (string | undefined)[]
  - Optionalsignatures?: string[]
  - Optionalstatuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[]
  - Optionalsubtypes?: ("FEE" | "RETURN" | undefined)[] | null
    Pass values to include only those subtypes; pass null to exclude transactions with a subtype
  - Optionaltoken?: Token
    Token name to resolve to a mint address. Defaults to MOVEUSD
  - Optionaltypes?: ("CREDIT" | "DEBIT")[]
  - OptionalupdatedAt?: DbTimestampCriteria
  - OptionalwalletAddresses?: Address[]
Returns Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (Transaction & { customerId: string })[];
        };
    },
>
- Defined in transaction-services/src/TransactionAdminService.ts:88

searchCustomerIds

searchCustomerIds(
    __namedParameters: {
        bankIds: NonNullable<
            "greendot"
            | "dart"
            | "burling"
            | "jiko"
            | "fib"
            | undefined,
        >[];
        token?: Token;
    },
): Promise<{ ok: true; value: { customerIds: string[] } }>
Parameters
- __namedParameters: {
      bankIds: NonNullable<
          "greendot"
          | "dart"
          | "burling"
          | "jiko"
          | "fib"
          | undefined,
      >[];
      token?: Token;
  }
Returns Promise<{ ok: true; value: { customerIds: string[] } }>
- Defined in transaction-services/src/TransactionAdminService.ts:425

searchEntities

searchEntities(
    __namedParameters: {
        bankIds: NonNullable<
            "greendot"
            | "dart"
            | "burling"
            | "jiko"
            | "fib"
            | undefined,
        >[];
        token?: Token;
    },
): Promise<{ ok: true; value: { entityIds: string[] } }>
Parameters
- __namedParameters: {
      bankIds: NonNullable<
          "greendot"
          | "dart"
          | "burling"
          | "jiko"
          | "fib"
          | undefined,
      >[];
      token?: Token;
  }
Returns Promise<{ ok: true; value: { entityIds: string[] } }>
- Defined in transaction-services/src/TransactionAdminService.ts:379

searchPaymentInstrumentIds

searchPaymentInstrumentIds(
    __namedParameters: {
        bankIds: NonNullable<
            "greendot"
            | "dart"
            | "burling"
            | "jiko"
            | "fib"
            | undefined,
        >[];
        token?: Token;
    },
): Promise<{ ok: true; value: { paymentInstrumentIds: string[] } }>
Parameters
- __namedParameters: {
      bankIds: NonNullable<
          "greendot"
          | "dart"
          | "burling"
          | "jiko"
          | "fib"
          | undefined,
      >[];
      token?: Token;
  }
Returns Promise<{ ok: true; value: { paymentInstrumentIds: string[] } }>
- Defined in transaction-services/src/TransactionAdminService.ts:463

searchWalletAddresses

searchWalletAddresses(
    __namedParameters: {
        bankIds: NonNullable<
            "greendot"
            | "dart"
            | "burling"
            | "jiko"
            | "fib"
            | undefined,
        >[];
        token?: Token;
    },
): Promise<{ ok: true; value: { walletAddresses: string[] } }>
Parameters
- __namedParameters: {
      bankIds: NonNullable<
          "greendot"
          | "dart"
          | "burling"
          | "jiko"
          | "fib"
          | undefined,
      >[];
      token?: Token;
  }
Returns Promise<{ ok: true; value: { walletAddresses: string[] } }>
- Defined in transaction-services/src/TransactionAdminService.ts:505

Class TransactionAdminService

Index

Constructors

Methods

Constructors

constructor

Parameters

Returns TransactionAdminService

Methods

countByMethod

Parameters

getBaseQuery

Parameters

Returns { params: unknown[]; sql: string }

search

Parameters

Optionalamount?: { operator: "EQ" | "LTE" | "GTE"; value: BigNumber }

OptionalbankIds?: Required<"greendot" | "dart" | "burling" | "jiko" | "fib" | undefined>[]

OptionalbankTransactionIds?: (string | undefined)[]

OptionalcardIds?: string[]

OptionalcreatedAt?: DbTimestampCriteria

OptionalcustomerIds?: string[]

OptionalentityIds?: string[]

OptionalentityTypes?: NonNullable<"IDENTITY" | "ORGANIZATION" | null>[]

Optionalids?: string[]

OptionalorderBy?: { direction: "ASC" | "DESC"; field: "createdAt" | "updatedAt" }[]

Optionalpage?: number

OptionalpageSize?: number

OptionalpaymentInstrumentIds?: (string | undefined)[]

Optionalsignatures?: string[]

Optionalstatuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[]

Optionalsubtypes?: ("FEE" | "RETURN" | undefined)[] | null

Optionaltoken?: Token

Optionaltypes?: ("CREDIT" | "DEBIT")[]

OptionalupdatedAt?: DbTimestampCriteria

OptionalwalletAddresses?: Address[]

Returns Promise< { ok: true; value: { hasNext: boolean; items: (Transaction & { customerId: string })[]; }; },>

searchCustomerIds

Parameters

Returns Promise<{ ok: true; value: { customerIds: string[] } }>

searchEntities

Parameters

Returns Promise<{ ok: true; value: { entityIds: string[] } }>

searchPaymentInstrumentIds

Parameters

Returns Promise<{ ok: true; value: { paymentInstrumentIds: string[] } }>

searchWalletAddresses

Parameters

Returns Promise<{ ok: true; value: { walletAddresses: string[] } }>

Settings

On This Page

`Optional`amount?: { operator: "EQ" | "LTE" | "GTE"; value: BigNumber }

`Optional`bankIds?: Required<"greendot" | "dart" | "burling" | "jiko" | "fib" | undefined>[]

`Optional`bankTransactionIds?: (string | undefined)[]

`Optional`cardIds?: string[]

`Optional`createdAt?: DbTimestampCriteria

`Optional`customerIds?: string[]

`Optional`entityIds?: string[]

`Optional`entityTypes?: NonNullable<"IDENTITY" | "ORGANIZATION" | null>[]

`Optional`ids?: string[]

`Optional`orderBy?: { direction: "ASC" | "DESC"; field: "createdAt" | "updatedAt" }[]

`Optional`page?: number

`Optional`pageSize?: number

`Optional`paymentInstrumentIds?: (string | undefined)[]

`Optional`signatures?: string[]

`Optional`statuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[]

`Optional`subtypes?: ("FEE" | "RETURN" | undefined)[] | null

`Optional`token?: Token

`Optional`types?: ("CREDIT" | "DEBIT")[]

`Optional`updatedAt?: DbTimestampCriteria

`Optional`walletAddresses?: Address[]

Returns Promise<
{
ok: true;
value: {
hasNext: boolean;
items: (Transaction & { customerId: string })[];
};
},
>