Skip to main content
Use this view endpoint to retrieve credit account adjustments data for a program in either a detailed or monthly view. The data is derived from the balance-related activity on the Marqeta platform. 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 account adjustments detail (JSON)

Action: GET
Endpoint: /views/credit/accountadjustments/detail Retrieve account adjustments detail information for a program. 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/credit/accountadjustments/detail?program=my_program&fields=amount,description,created_time endpoint.
JSON
{
  "total": 76,
  "is_more": false,
  "count": 76,
  "info": {},
  "start_date": "2021-04-01T00:00:00+0000",
  "end_date": "2021-04-01T00:00:00+0000",
  "last_run_time": "2021-04-01T00:00:00+0000",
  "schema": [
    {
      "field": "amount",
      "type": "NUMBER",
      "scale": 2.0,
      "character_maximum_length": null,
      "description": "#N/A",
      "display": "Amount",
      "units": null,
      "has_total": true,
      "is_filter_only": false
    },
    {
      "field": "description",
      "type": "TEXT",
      "scale": null,
      "character_maximum_length": 16777216.0,
      "description": null,
      "display": "Description",
      "units": null,
      "has_total": false,
      "is_filter_only": false
    },
    {
      "field": "created_time",
      "type": "TIMESTAMP_NTZ",
      "scale": null,
      "character_maximum_length": null,
      "description": "The time the ACH verification was created.",
      "display": "Created Time",
      "units": null,
      "has_total": false,
      "date_format": "YYYY-MM-DD HH:mm:ss",
      "is_filter_only": false
    }
  ],
  "records": [
    {
      "amount": 3099.4,
      "description": "Minimum Interest Fee Adjustment",
      "created_time": "2021-04-23T00:00:00.000Z"
    },
    {
      "amount": 6108.1,
      "description": "Minimum Interest Fee Adjustment",
      "created_time": "2021-05-01T08:29:12.000Z"
    },

    ...

    {
      "amount": 2705.85,
      "description": "Minimum Interest Fee Adjustment",
      "created_time": "2021-04-02T08:29:42.859Z"
    }
  ]
}

​
Retrieve account adjustments by month (file export)

Action: GET
Endpoint: /views/credit/accountadjustments/detail/{export_type} Retrieve account adjustments detail information and export to 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.

​
URL path parameters

FieldsDescription
export_type

string
Required		File format in which to export the data.

Allowable Values:

csv

​
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 schema for account adjustments detail

Action: GET
Endpoint: /views/credit/accountadjustments/detail/schema Retrieve a JSON representation of the account adjustments detail 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/credit/accountadjustments/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": "token",
        "type": "character varying(36)",
        "display": "Token",
        "description": "#N/A",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "account_token",
        "type": "character varying(36)",
        "display": "Account Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "original_ledger_entry_token",
        "type": "character varying(36)",
        "display": "Original Ledger Entry Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "external_adjustment_id",
        "type": "character varying(36)",
        "display": "External Adjustment Id",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "adjustment_detail_token",
        "type": "character varying(36)",
        "display": "Adjustment Detail Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "related_detail_token",
        "type": "character varying(36)",
        "display": "Related Detail Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "amount",
        "type": "numeric(14,2)",
        "display": "Amount",
        "description": "#N/A",
        "units": "USD",
        "has_total": true,
        "is_filter_only": false
    },
    {
        "field": "currency_code",
        "type": "character varying(3)",
        "display": "Currency Code",
        "description": "The three-number code of the currency.",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "description",
        "type": "character varying(16777216)",
        "display": "Description",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "note",
        "type": "character varying(16777216)",
        "display": "Note",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "reason",
        "type": "character varying(16777216)",
        "display": "Reason",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "created_time",
        "type": "timestamp without time zone",
        "display": "Created Time",
        "description": "The time the ACH verification was created.",
        "date_format": "YYYY-MM-DD HH:mm:ss",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "report_load_timestamp",
        "type": "timestamp without time zone",
        "display": "Report Load Timestamp",
        "description": "UTC time when the record was loaded into Marqeta's reporting system",
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    }
]

​
Retrieve account adjustments by month (JSON)

Action: GET
Endpoint: /views/credit/accountadjustments/month Retrieve a sum of all credit account adjustments for a given month grouped by account. 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/credit/accountadjustments/month?program=my_program&fields=amount,description,created_time endpoint.
JSON
{
  "total": 109,
  "is_more": false,
  "count": 109,
  "info": {},
  "start_date": "2021-04-01T00:00:00+0000",
  "end_date": "2021-04-01T00:00:00+0000",
  "last_run_time": "2021-04-01T00:00:00+0000",
  "schema": [
    {
      "field": "account_token",
      "type": "TEXT",
      "scale": null,
      "character_maximum_length": 36.0,
      "description": null,
      "display": "Account Token",
      "units": null,
      "has_total": false,
      "is_filter_only": false
    },
    {
      "field": "total_amount",
      "type": "NUMBER",
      "scale": 2.0,
      "character_maximum_length": null,
      "description": null,
      "display": "Total Amount",
      "units": null,
      "has_total": false,
      "is_filter_only": false
    },
    {
      "field": "month_key",
      "type": "DATE",
      "scale": null,
      "character_maximum_length": null,
      "description": null,
      "display": "Month Key",
      "units": null,
      "has_total": false,
      "date_format": "YYYY-MM",
      "is_filter_only": false
    }
  ],
  "records": [
    {
      "account_token": "<account_token>",
      "total_amount": 0.99,
      "month_key": "2022-08-23T00:00:00.000Z"
    },
    {
      "account_token": "<account_token>",
      "total_amount": 1.01,
      "month_key": "2022-08-01T08:29:12.000Z"
    },

    ...

    {
      "account_token": "<account_token>",
      "total_amount": 2.07,
      "month_key": "2022-08-02T08:29:42.859Z"
    }
  ]
}

​
Retrieve account adjustments by month (file export)

Action: GET
Endpoint: /views/credit/accountadjustments/month/{export_type} Retrieve account adjustments by month and export to 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.

​
URL path parameters

FieldsDescription
export_type

string
Required		File format in which to export the data.

Allowable Values:

csv

​
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 schema for account adjustments by month

Action: GET
Endpoint: /views/credit/accountadjustments/month/schema Retrieve a JSON representation of the account adjustments by month 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/credit/accountadjustments/month/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": "account_token",
        "type": "character varying(36)",
        "display": "Account Token",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "total_amount",
        "type": "numeric(14,2)",
        "display": "Total Amount",
        "description": null,
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "month_key",
        "type": "date",
        "display": "Month Key",
        "description": null,
        "date_format": "YYYY-MM",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    },
    {
        "field": "report_load_timestamp",
        "type": "timestamp without time zone",
        "display": "Report Load Timestamp",
        "description": "UTC time when the record was loaded into Marqeta's reporting system",
        "date_format": "YYYY-MM-DD",
        "units": null,
        "has_total": false,
        "is_filter_only": false
    }
]

Related topics

AdjustmentsAbout Credit Account Ledger EntriesAbout Credit Account Journal EntriesAbout Credit Account StatementsAbout Credit Accounts