ACH Origination

Use this view endpoint to retrieve transaction-level detail for ACH Origination transfers for both Program Funding and User Funding use cases. The data is derived from ACH origination transactions on the Marqeta platform. For in-depth information on this endpoint, see ACH Origination in Reports In-depth. This endpoint supports multiple response formats, query filtering, field filtering, sorting, pagination, and currency conversion. For more information about response options, see Response Customization.

Retrieve ACH Origination detail data (JSON)

Action: GET
Endpoint: /views/achorigination/detail Retrieve ACH origination detail data. This endpoint returns a JSON object that contains an array of records matching your filter query.

Sample response body

The following sample shows a representative response for a GET request to the /views/achorigination/detail?program=my_program&fields=transfer_amount,currency endpoint.

JSON

{
"total": 72,
    "is_more": false,
    "count": 72,
    "info": {},
    "start_date": "2022-02-01T00:00:00+0000",
    "end_date": "2022-02-01T00:00:00+0000",
    "last_run_time": "2022-02-01T00:00:00+0000",
    "schema": [
        {
            "field": "transfer_amount",
            "type": "numeric(14,2)",
            "display": "Transfer Amount",
            "description": null,
            "units": null,
            "has_total": false,
            "is_filter_only": false
        },
        {
            "field": "currency",
            "type": "character varying(12)",
            "display": "Currency",
            "description": "The abbreviated currency code.",
            "units": null,
            "has_total": false,
            "is_filter_only": false
        }
    ],
    "records": [
        {
            "transfer_amount": 129.75,
            "currency": "USD"
        },
        {
            "transfer_amount": 1539.69,
            "currency": "USD"
        },
        ...
        {
            "transfer_amount": 100.00,
            "currency": "USD"
        }
    ]
}

Retrieve ACH origination detail data (file export)

Action: GET
Endpoint: /views/achorigination/detail/{export_type} Retrieve ACH origination detail data in a file. This endpoint asynchronously generates a file in the specified format and returns a job token for retrieving the file when it is completed. The file contains a list of records matching your filter query.

Query parameters

Fields	Description
compress string optional	Type of file compression for the exported file. Allowable Values: gz, zip Default value: gz

Sample response body

JSON

{
    "token": "111122226c444d8888888a9999ae11111db63da4.csv.gz"
}

Retrieve ACH origination detail schema

Action: GET
Endpoint: /views/achorigination/detail/schema Retrieve a JSON representation of the ACH Origination view schema. The schema object contains an array of objects that describe the available columns and the data type of each column.

Sample response body

The following sample shows a representative response for a GET request to the /views/achorigination/detail/schema?program=my_program endpoint. The schema can vary based on the data you are authorized to access (based on the credentials you provide in your request).

JSON

[
    {
        "field": "program",
        "type": "character varying(256)",
        "display": "Program",
        "description": "The name of the card program.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "bank",
        "type": "character varying(256)",
        "display": "Bank",
        "description": "The bank under which the program operates.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "bank_transfer_id",
        "type": "integer",
        "display": "Bank Transfer ID",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "ach_transfer_token",
        "type": "character varying(256)",
        "display": "ACH Transfer Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "funding_source_token",
        "type": "character varying(256)",
        "display": "Funding Source Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "payment_order_token",
        "type": "character varying(256)",
        "display": "Payment Order Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "account_holder_token",
        "type": "character varying(256)",
        "display": "Account Holder Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "account_holder_token_type",
        "type": "character varying(1080)",
        "display": "Account Holder Token Type",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "ach_origination_use_case",
        "type": "character varying(256)",
        "display": "ACH Origination Use Case",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transfer_status",
        "type": "character varying(256)",
        "display": "Transfer Status",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transfer_type",
        "type": "character varying(256)",
        "display": "Transfer Type",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "debit_or_credit",
        "type": "character varying(256)",
        "display": "Debit or Credit Indicator",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transfer_amount",
        "type": "numeric(14,2)",
        "display": "Transfer Amount",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "currency",
        "type": "character varying(12)",
        "display": "Currency",
        "description": "The abbreviated currency code.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "memo",
        "type": "character varying(1020)",
        "display": "Memo",
        "description": "Memo associated.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "statement_descriptor",
        "type": "character varying(256)",
        "display": "Statement Descriptor",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transfer_speed",
        "type": "character varying(32)",
        "display": "The speed of the ACH transfer. Possible values: Standard, Same Day",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "standard_entry_class_code",
        "type": "character varying(12)",
        "display": "Standard Entry Class (SEC) Code",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transfer_created_time",
        "type": "timestamp without time zone",
        "display": "Transfer Created Time",
        "description": null,
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "last_modified_time",
        "type": "timestamp without time zone",
        "display": "Last Modified Date",
        "description": "The date when the record was most recently updated.",
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "effective_date",
        "type": "timestamp without time zone",
        "display": "Effective Date",
        "description": null,
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "return_date",
        "type": "timestamp without time zone",
        "display": "Return Date",
        "description": null,
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "return_code",
        "type": "character varying(500)",
        "display": "Return Code",
        "description": "A code relating to ach reversals and the reason for a reversal. Reasons vary from insufficient funds to invalid account numbers.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "return_reason",
        "type": "character varying(1080)",
        "display": "Return Reason",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "transaction_token",
        "type": "integer",
        "display": "Transaction Token",
        "description": "The token of the transaction; unique within a program.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    }
]

​Retrieve ACH Origination detail data (JSON)

​Sample response body

​Retrieve ACH origination detail data (file export)

​Query parameters

​Sample response body

​Retrieve ACH origination detail schema

​Sample response body

Retrieve ACH Origination detail data (JSON)

Sample response body

Retrieve ACH origination detail data (file export)

Query parameters

Sample response body

Retrieve ACH origination detail schema

Sample response body