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

getBaseQuery search searchCustomerIds searchEntities searchPaymentInstrumentIds searchWalletAddresses

Constructors

constructor

new TransactionAdminService(
args: { sqlClient: Sql; tokens: Record<"MOVEUSD", { mint: PublicKey }> },
): TransactionAdminService
Parameters
- args: { sqlClient: Sql; tokens: Record<"MOVEUSD", { mint: PublicKey }> }
Returns TransactionAdminService
- Defined in transaction-services/src/TransactionAdminService.ts:34

Methods

getBaseQuery

getBaseQuery(): { params: unknown[]; sql: string }
Returns the base UNION query (all selects enabled) as a SQL string with params.

Returns { params: unknown[]; sql: string }
- Defined in transaction-services/src/TransactionAdminService.ts:43

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[];
        ids?: string[];
        methods?: (
            | "REDEMPTION"
            | "DEPOSIT_BLOCKCHAIN"
            | "DEPOSIT_DIRECT"
            | "DEPOSIT_US_BANK_ACH"
            | "DEPOSIT_ACH_CREDIT"
            | "DEPOSIT_RTP"
            | "DEPOSIT_US_CASH"
            | "DEPOSIT_US_WIRE"
            | "DEPOSIT_SWIFT_WIRE"
            | "SWAP"
            | "FEE_TRANSFER"
            | "TRANSFER"
            | "TRANSFER_NETWORK"
            | "WITHDRAW_AF_BANK"
            | "WITHDRAW_AF_MOMO"
            | "WITHDRAW_MX_SPEI"
            | "WITHDRAW_SWIFT_WIRE"
            | "WITHDRAW_US_BANK_ACH"
            | "WITHDRAW_US_INSTANT"
            | "WITHDRAW_ACH_PULL"
            | "WITHDRAW_US_WIRE_DRAWDOWN"
            | "WITHDRAW_US_WIRE"
            | "WITHDRAW_BLOCKCHAIN"
            | "VIRTUAL_CARD"
            | "PHYSICAL_CARD"
        )[];
        orderBy?: { direction: "ASC"
        | "DESC"; field: "createdAt" | "updatedAt" }[];
        page?: number;
        pageSize?: number;
        paymentInstrumentIds?: (string | undefined)[];
        signatures?: string[];
        statuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[];
        types?: ("CREDIT" | "DEBIT")[];
        updatedAt?: DbTimestampCriteria;
        walletAddresses?: PublicKey[];
    },
): 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[];
      ids?: string[];
      methods?: (
          | "REDEMPTION"
          | "DEPOSIT_BLOCKCHAIN"
          | "DEPOSIT_DIRECT"
          | "DEPOSIT_US_BANK_ACH"
          | "DEPOSIT_ACH_CREDIT"
          | "DEPOSIT_RTP"
          | "DEPOSIT_US_CASH"
          | "DEPOSIT_US_WIRE"
          | "DEPOSIT_SWIFT_WIRE"
          | "SWAP"
          | "FEE_TRANSFER"
          | "TRANSFER"
          | "TRANSFER_NETWORK"
          | "WITHDRAW_AF_BANK"
          | "WITHDRAW_AF_MOMO"
          | "WITHDRAW_MX_SPEI"
          | "WITHDRAW_SWIFT_WIRE"
          | "WITHDRAW_US_BANK_ACH"
          | "WITHDRAW_US_INSTANT"
          | "WITHDRAW_ACH_PULL"
          | "WITHDRAW_US_WIRE_DRAWDOWN"
          | "WITHDRAW_US_WIRE"
          | "WITHDRAW_BLOCKCHAIN"
          | "VIRTUAL_CARD"
          | "PHYSICAL_CARD"
      )[];
      orderBy?: { direction: "ASC"
      | "DESC"; field: "createdAt" | "updatedAt" }[];
      page?: number;
      pageSize?: number;
      paymentInstrumentIds?: (string | undefined)[];
      signatures?: string[];
      statuses?: ("PROCESSING" | "COMPLETED" | "FAILED" | "RETURNED")[];
      types?: ("CREDIT" | "DEBIT")[];
      updatedAt?: DbTimestampCriteria;
      walletAddresses?: PublicKey[];
  }
  - 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[]
  - Optionalids?: string[]
  - Optionalmethods?: (
        | "REDEMPTION"
        | "DEPOSIT_BLOCKCHAIN"
        | "DEPOSIT_DIRECT"
        | "DEPOSIT_US_BANK_ACH"
        | "DEPOSIT_ACH_CREDIT"
        | "DEPOSIT_RTP"
        | "DEPOSIT_US_CASH"
        | "DEPOSIT_US_WIRE"
        | "DEPOSIT_SWIFT_WIRE"
        | "SWAP"
        | "FEE_TRANSFER"
        | "TRANSFER"
        | "TRANSFER_NETWORK"
        | "WITHDRAW_AF_BANK"
        | "WITHDRAW_AF_MOMO"
        | "WITHDRAW_MX_SPEI"
        | "WITHDRAW_SWIFT_WIRE"
        | "WITHDRAW_US_BANK_ACH"
        | "WITHDRAW_US_INSTANT"
        | "WITHDRAW_ACH_PULL"
        | "WITHDRAW_US_WIRE_DRAWDOWN"
        | "WITHDRAW_US_WIRE"
        | "WITHDRAW_BLOCKCHAIN"
        | "VIRTUAL_CARD"
        | "PHYSICAL_CARD"
    )[]
  - 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")[]
  - Optionaltypes?: ("CREDIT" | "DEBIT")[]
  - OptionalupdatedAt?: DbTimestampCriteria
  - OptionalwalletAddresses?: PublicKey[]
Returns Promise<
    {
        ok: true;
        value: {
            hasNext: boolean;
            items: (Transaction & { customerId: string })[];
        };
    },
>
- Defined in transaction-services/src/TransactionAdminService.ts:74

searchCustomerIds

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

searchEntities

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

searchPaymentInstrumentIds

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

searchWalletAddresses

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

Class TransactionAdminService

Index

Constructors

Methods

Constructors

constructor

Parameters

Returns TransactionAdminService

Methods

getBaseQuery

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[]

Optionalids?: string[]

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

Optionalpage?: number

OptionalpageSize?: number

OptionalpaymentInstrumentIds?: (string | undefined)[]

Optionalsignatures?: string[]

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

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

OptionalupdatedAt?: DbTimestampCriteria

OptionalwalletAddresses?: PublicKey[]

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`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`types?: ("CREDIT" | "DEBIT")[]

`Optional`updatedAt?: DbTimestampCriteria

`Optional`walletAddresses?: PublicKey[]

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