Skip to main content
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

FieldsDescription
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
    }
]

Related topics

ACH OriginationACH PendingACH VerificationACH GatewayACH Receiving