> This page is for Developers. > For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://zuora.ferndocs.com/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server. # List payment schedules GET https://rest.test.zuora.com/object-query/payment-schedules Lists payment schedules. You can use the query parameters to filter, expand, and sort the returned results. Reference: https://zuora.ferndocs.com/developers/api-reference/zuora-api/object-query/object-queries/query-payment-schedules ## Authentication - `Authorization` header (bearer token, required) — Use `Bearer {{token}}` in the `Authorization` header for authentication. ## Servers - `https://rest.test.zuora.com` (US Developer & Central Sandbox (incl. Test Drive), default) - `https://rest.sandbox.na.zuora.com` (US API Sandbox Cloud 1) - `https://rest.apisandbox.zuora.com` (US API Sandbox Cloud 2) - `https://rest.na.zuora.com` (US Production Cloud 1) - `https://rest.zuora.com` (US Production Cloud 2) - `https://rest.test.eu.zuora.com` (EU Developer & Central Sandbox) - `https://rest.sandbox.eu.zuora.com` (EU API Sandbox) - `https://rest.eu.zuora.com` (EU Production) - `https://rest.test.ap.zuora.com` (APAC Developer & Central Sandbox) - `https://rest.ap.zuora.com` (APAC Production) ## Request ### Query parameters - `pageSize` (integer, optional, default: 10) — The maximum number of results to return in a single page. If the specified `pageSize` is less than 1 or greater than 99, Zuora will return a 400 error. - `cursor` (string, optional) — A cursor for use in pagination. A cursor defines the starting place in a list. For instance, if you make a list request and receive 100 objects, ending with `next_page=W3sib3JkZXJ=`, your subsequent call can include `cursor=W3sib3JkZXJ=` in order to fetch the next page of the list. - `sort[]` (list of string, optional) — A case-insensitive query parameter that specifies the sort order of the list, which can be either ascending (e.g. `accountnumber.ASC`) or descending (e.g. `accountnumber.DESC`). You cannot sort on properties in arrays. If the array-type properties are specified for the `sort[]` parameter, they are ignored. Supported sortable fields: - id - updateddate - number - accountid - invoiceid - debitmemoid - occurrences - status - `expand[]` (list of string, optional) — Allows you to expand responses by including related object information in a single call. The Payment Schedule object does not support expanding any related objects. - `filter[]` (list of string, optional) — A case-insensitive filter on the list. Supported filterable fields: * id * updateddate * number * accountid * invoiceid * debitmemoid * occurrences * status * \{indexedcustomfield}: Use the format like `customField__c` to filter on custom fields. - `fields[]` (list of string, optional) — A case-insensitive query parameter that allows you to specify which fields are returned in the response. - `includeNullFields` (boolean, optional, default: false) — Specifies whether to include fields with the `null` value in the response. - If set to `true`, all fields will be returned in the response, including those with the `null` value. - If set to `false`, only fields with non-null values will be returned. ### Headers - `Idempotency-Key` (string, optional) — Specify a unique idempotency key if you want to perform an idempotent POST or PATCH request. Do not use this header in other request types. With this header specified, the Zuora server can identify subsequent retries of the same request using this value, which prevents the same operation from being performed multiple times by accident. - `Accept-Encoding` (string, optional) — Include the `Accept-Encoding: gzip` header to compress responses as a gzipped file. It can significantly reduce the bandwidth required for a response. If specified, Zuora automatically compresses responses that contain over 1000 bytes of data, and the response contains a `Content-Encoding` header with the compression algorithm so that your client can decompress it. - `Content-Encoding` (string, optional) — Include the `Content-Encoding: gzip` header to compress a request. With this header specified, you should upload a gzipped file for the request payload instead of sending the JSON payload. - `Zuora-Track-Id` (string, optional) — A custom identifier for tracing the API call. If you set a value for this header, Zuora returns the same value in the response headers. This header enables you to associate your system process identifiers with Zuora API calls, to assist with troubleshooting in the event of an issue. The value of this field must use the US-ASCII character set and must not include any of the following characters: colon (`:`), semicolon (`;`), double quote (`"`), and quote (`'`). - `Zuora-Entity-Ids` (string, optional) — An entity ID. If you have [Zuora Multi-entity](https://knowledgecenter.zuora.com/BB_Introducing_Z_Business/Multi-entity) enabled and the OAuth token is valid for more than one entity, you must use this header to specify which entity to perform the operation in. If the OAuth token is only valid for a single entity, or you do not have Zuora Multi-entity enabled, you should not set this header. - `Zuora-Org-Ids` (string, optional) — Comma separated IDs. If you have Zuora Multi-Org enabled, you can use this header to specify which orgs to perform the operation in. If you do not have Zuora Multi-Org enabled, you should not set this header. The IDs must be a sub-set of the user's accessible orgs. If you specify an org that the user does not have access to, the operation fails. This header is important in Multi-Org (MO) setups because it defines the organization context under which the API should operate—mainly used for read access or data visibility filtering. If the header is not set, the operation is performed in scope of the user's accessible orgs. - `Zuora-Version` (string, optional) — The minor API version. For a list of available minor versions, see [API upgrades](https://developer.zuora.com/v1-api-reference/api-upgrades/). ## Response ### 200 OK - `nextPage` (string, optional, nullable) — A string that can be used as the `cursor` value to retrieve the next page of the response if it exists; otherwise absent. - `data` (list of ExpandedPaymentSchedule, optional) ## Errors ### 500 Internal Server Error Internal server error - `reasons` (list of CommonOqErrorResponseReasonsItems, optional) — The container of the error code and message. This field is available only if the `success` field is `false`. - `requestId` (any, optional) — The unique identifier of the request. ### 400 Client Request Error Invalid input - `reasons` (list of CommonOqErrorResponseReasonsItems, optional) — The container of the error code and message. This field is available only if the `success` field is `false`. - `requestId` (any, optional) — The unique identifier of the request. ## Types ### ExpandedPaymentSchedule - `id` (string, optional) — The unique identifier of the payment schedule. - `createdById` (string, optional) — The unique identifier of the user who created the payment schedule. - `createdDate` (datetime, optional) — The time that the payment schedule gets created in the system, in the `YYYY-MM-DD HH:MM:SS` format. - `updatedById` (string, optional) — The unique identifier of the user who last updated the payment schedule. - `updatedDate` (datetime, optional) — The time that the payment schedule gets updated in the system, in the `YYYY-MM-DD HH:MM:SS` format. - `number` (string, optional) — Number of the payment schedule. - `accountId` (string, optional) — ID of the account that owns the payment schedule. - `invoiceId` (string, optional) — The unique identifier of the invoice to which the payment is applied. - `debitmemoId` (string, optional) — The unique identifier of the debit memo to which the payment is applied. - `paymentOptionId` (string, optional) — The unique identifier of the payment option that is used to process the payment schedule. - `startDate` (date, optional) — The date when the first payment of this payment schedule is proccessed. - `runHour` (integer, optional) — At which hour in the day in the tenant’s timezone the recurring payment schedule items will be collected. Return `0` for custom payment schedules. - `period` (enum, optional, nullable) — For recurring payment schedule only. The period of payment generation. Returns `null` for custom payment schedules. - Allowed values: `Monthly`, `Weekly`, `BiWeekly` - `prepayment` (boolean, optional) — Indicates whether the payments created by the payment schedule are used as a reserved payment. This field is available only if the prepaid cash drawdown permission is enabled. See [Prepaid Cash with Drawdown](https://knowledgecenter.zuora.com/Zuora_Billing/Billing_and_Invoicing/JA_Advanced_Consumption_Billing/Prepaid_Cash_with_Drawdown) for more information. - `occurrences` (integer, optional) — The number of payment schedule items that are created by this payment schedule. - `status` (enum, optional) — The status of the payment schedule. - Active: There is still payment schedule item to process. - Canceled: After a payment schedule is canceled by the user, the schedule is marked as `canceled`. - Completed: After all payment schedule items are processed, the schedule is marked as `Completed`. - Allowed values: `Active`, `Canceled`, `Completed` - `description` (string, optional) — The description of the payment schedule. - `nextPaymentDate` (date, optional) — The date the next payment will be processed. - `recentPaymentDate` (date, optional) — The date the last payment was processed. - `totalPaymentsProcessed` (integer, optional) — The number of processed payments. - `totalPaymentsErrored` (integer, optional) — The number of errored payments. - `totalAmount` (double, optional) — The total amount that will be collected by the payment schedule. ### CommonOqErrorResponseReasonsItems - `code` (integer, optional) — The error code of response. - `message` (string, optional) — The detail information of the error response ## Examples **Response** ```json { "nextPage": "W3sidmFsdWUiOiIyMDIzLTAyLTA3VDIwOjUwOjQyLTA4OjAwIiwib3JkZXJCeSI6eyJmaWVsZCI6IlVwZGF0ZWREYXRlIiwib3JkZXIiOiJERVNDIn19LHsidmFsdWUiOiI4YWQwOGUxYTg2MjU1MTc2MDE4NjJmNWM1MGRjMjFhNyIsIm9yZGVyQnkiOnsiZmllbGQiOiJJZCIsIm9yZGVyIjoiREVTQyJ9fV0=", "data": [ { "id": "8ad08e1a8625517601862f5c50dc21a7", "createdById": "2c92c09467cada0a0167cc79e59c0884", "createdDate": "2023-02-07T20:50:24-08:00", "updatedById": "2c92c09467cada0a0167cc79e59c0884", "updatedDate": "2023-02-07T20:50:42-08:00", "number": "PS-00000002", "accountId": "2c92c0f86ac39714016ad3e985c270c8", "invoiceId": "8ad098887fd49533017fde9722806ac9", "startDate": "2025-02-09", "runHour": 2, "period": "Weekly", "prepayment": false, "occurrences": 3, "status": "Active", "description": "Payment Schedule 1", "totalPaymentsProcessed": 0, "totalPaymentsErrored": 0, "totalAmount": 0 } ] } ``` **SDK Code** ```python Object Queries_queryPaymentSchedules_example import requests url = "https://rest.test.zuora.com/object-query/payment-schedules" querystring = {"fields[]":"[\"id,createddate\"]"} headers = {"Authorization": "Bearer "} response = requests.get(url, headers=headers, params=querystring) print(response.json()) ``` ```javascript Object Queries_queryPaymentSchedules_example const url = 'https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D'; const options = {method: 'GET', headers: {Authorization: 'Bearer '}}; try { const response = await fetch(url, options); const data = await response.json(); console.log(data); } catch (error) { console.error(error); } ``` ```go Object Queries_queryPaymentSchedules_example package main import ( "fmt" "net/http" "io" ) func main() { url := "https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D" req, _ := http.NewRequest("GET", url, nil) req.Header.Add("Authorization", "Bearer ") res, _ := http.DefaultClient.Do(req) defer res.Body.Close() body, _ := io.ReadAll(res.Body) fmt.Println(res) fmt.Println(string(body)) } ``` ```ruby Object Queries_queryPaymentSchedules_example require 'uri' require 'net/http' url = URI("https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D") http = Net::HTTP.new(url.host, url.port) http.use_ssl = true request = Net::HTTP::Get.new(url) request["Authorization"] = 'Bearer ' response = http.request(request) puts response.read_body ``` ```java Object Queries_queryPaymentSchedules_example import com.mashape.unirest.http.HttpResponse; import com.mashape.unirest.http.Unirest; HttpResponse response = Unirest.get("https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D") .header("Authorization", "Bearer ") .asString(); ``` ```php Object Queries_queryPaymentSchedules_example request('GET', 'https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D', [ 'headers' => [ 'Authorization' => 'Bearer ', ], ]); echo $response->getBody(); ``` ```csharp Object Queries_queryPaymentSchedules_example using RestSharp; var client = new RestClient("https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D"); var request = new RestRequest(Method.GET); request.AddHeader("Authorization", "Bearer "); IRestResponse response = client.Execute(request); ``` ```swift Object Queries_queryPaymentSchedules_example import Foundation let headers = ["Authorization": "Bearer "] let request = NSMutableURLRequest(url: NSURL(string: "https://rest.test.zuora.com/object-query/payment-schedules?fields%5B%5D=%5B%22id%2Ccreateddate%22%5D")! as URL, cachePolicy: .useProtocolCachePolicy, timeoutInterval: 10.0) request.httpMethod = "GET" request.allHTTPHeaderFields = headers let session = URLSession.shared let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in if (error != nil) { print(error as Any) } else { let httpResponse = response as? HTTPURLResponse print(httpResponse) } }) dataTask.resume() ```