OrderItems
Returns the items in an order.
View-Specific Information
SELECT
Note: The PayPal REST API does not provide a way to list all OrderIds, so you must specify one. For scenarios that require listing transactions, use the Transactions and TransactionItems views in the SOAP schema. The only filter supported by the PayPal API is OrderId, which is required. The provider processes all other filters client-side.
For example, the provider processes the following queries server-side to retrieve details for a specific order.
SELECT * FROM OrderItems WHERE OrderId = 'O-1HE90236LH9332431'
SELECT * FROM OrderItems WHERE OrderId IN ('O-1HE90236LH9332431', 'O-7D635956955612146')
Columns
| Name | Type | References | Description |
| OrderId | String | The ID of the Order this Item belongs to. | |
| Id | String | The PayPal-generated ID for the purchase unit. This ID appears in both the payer's transaction history and the emails that the payer receives. | |
| ReferenceId | String | The API caller-provided external ID for the purchase unit. Required for multiple purchase units when you must update the order through PATCH. | |
| Amount | String | The total order amount with an optional breakdown that provides details, such as the total item amount, total tax amount, shipping, handling, insurance, and discounts, if any. | |
| Description | String | The purchase description. | |
| CustomId | String | The API caller-provided external ID. Used to reconcile API caller-initiated transactions with PayPal transactions. Appears in transaction and settlement reports. | |
| InvoiceId | String | The API caller-provided external invoice ID for this order. | |
| SoftDescriptor | String | The payment descriptor on account transactions on the customer's credit card statement. | |
| ShipperFullName | String | When the party is a person, the party's full name. | |
| ShippingAddressLine1 | String | The first line of the address. For example, number or street. | |
| ShippingAddressLine2 | String | The second line of the address. For example, suite or apartment number. | |
| ShippingAddressPostalCode | String | The postal code, which is the zip code or equivalent. Typically required for countries with a postal code or an equivalent. | |
| ShippingAddressCountryCode | String | The two-character ISO 3166-1 code that identifies the country or region. | |
| PayeeEmail | String | The email address of the merchant. | |
| PayeeMerchantId | String | The encrypted PayPal account ID of the merchant. | |
| DisbursementMode | String | The funds that are held on behalf of the merchant. | |
| Items | String | An array of items that the customer purchases from the merchant. | |
| MostRecentErrors | String | The error reason code and description that are the reason for the most recent order decline. | |
| PaymentInstruction | String | Any additional payment instructions to be considered during payment processing. | |
| SupplementaryData | String | Supplementary data about this payment. | |
| Payments | String | The comprehensive history of payments for the purchase unit. |