> ## Documentation Index
> Fetch the complete documentation index at: https://learn.nexudus.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Search ProposalProducts

> Search and list ProposalProduct records with filtering, sorting, and pagination.

## Authentication

<Note>
  This endpoint requires OAuth2 authentication. Include a valid bearer token in the `Authorization` header.
  The authenticated user must be a full unrestricted administrator or have the **`ProposalProduct-List`** role.
</Note>

## Query Parameters

### Pagination & Sorting

<ParamField query="page" type="integer" default="1">
  The page number to retrieve.
</ParamField>

<ParamField query="size" type="integer" default="25">
  The number of records per page.
</ParamField>

<ParamField query="orderBy" type="string">
  The property name to sort results by (e.g. `Name`, `CreatedOn`).
</ParamField>

<ParamField query="dir" type="integer">
  Sort direction. `0` for ascending, `1` for descending.
</ParamField>

### Filters

<ParamField query="ProposalProduct_Proposal" type="integer">
  Filter by Proposal Id.
</ParamField>

<ParamField query="ProposalProduct_Proposal_Coworker_Id" type="string">
  Filter by proposal coworker ID.
</ParamField>

<ParamField query="ProposalProduct_Proposal_Coworker_Email" type="string">
  Filter by proposal coworker email.
</ParamField>

<ParamField query="ProposalProduct_Proposal_Coworker_FullName" type="string">
  Filter by proposal coworker full name.
</ParamField>

<ParamField query="ProposalProduct_Product" type="integer">
  Filter by Product Id.
</ParamField>

<ParamField query="ProposalProduct_Product_Name" type="string">
  Filter by product name.
</ParamField>

<ParamField query="ProposalProduct_Product_Price" type="number">
  Filter by product price.
</ParamField>

<ParamField query="ProposalProduct_Product_ApplyProRating" type="string">
  Filter by whether product applies pro-rating.
</ParamField>

<ParamField query="ProposalProduct_Product_Business_Currency_Code" type="string">
  Filter by product business currency code.
</ParamField>

<ParamField query="ProposalProduct_Quantity" type="integer">
  Filter by quantity.
</ParamField>

<ParamField query="ProposalProduct_Price" type="number">
  Filter by price override.
</ParamField>

<ParamField query="ProposalProduct_IsDeposit" type="boolean">
  Filter by whether this is a deposit.
</ParamField>

<ParamField query="ProposalProduct_IsContractProduct" type="boolean">
  Filter by whether this is a contract product.
</ParamField>

<ParamField query="ProposalProduct_RegularCharge" type="boolean">
  Filter by whether this is a regular charge.
</ParamField>

<ParamField query="ProposalProduct_RepeatCycle" type="integer">
  Filter by repeat cycle pattern.
</ParamField>

<ParamField query="ProposalProduct_InvoiceOn" type="string">
  Filter by invoice on date.
</ParamField>

<ParamField query="ProposalProduct_RepeatFrom" type="string">
  Filter by repeat from date.
</ParamField>

<ParamField query="ProposalProduct_RepeatUntil" type="string">
  Filter by repeat until date.
</ParamField>

<ParamField query="ProposalProduct_RepeatUnit" type="integer">
  Filter by number of repeat units.
</ParamField>

<ParamField query="ProposalProduct_ApplyProRating" type="boolean">
  Filter by apply pro-rating.
</ParamField>

<ParamField query="ProposalProduct_Notes" type="string">
  Filter by notes.
</ParamField>

### Range Filters

<ParamField query="from_ProposalProduct_ProductPrice" type="number">
  Filter by product price greater than or equal to this value.
</ParamField>

<ParamField query="to_ProposalProduct_ProductPrice" type="number">
  Filter by product price less than or equal to this value.
</ParamField>

<ParamField query="from_ProposalProduct_Quantity" type="integer">
  Filter by quantity greater than or equal to this value.
</ParamField>

<ParamField query="to_ProposalProduct_Quantity" type="integer">
  Filter by quantity less than or equal to this value.
</ParamField>

<ParamField query="from_ProposalProduct_Price" type="number">
  Filter by price override greater than or equal to this value.
</ParamField>

<ParamField query="to_ProposalProduct_Price" type="number">
  Filter by price override less than or equal to this value.
</ParamField>

<ParamField query="from_ProposalProduct_InvoiceOn" type="string">
  Filter by invoice on date greater than or equal to this value. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="to_ProposalProduct_InvoiceOn" type="string">
  Filter by invoice on date less than or equal to this value. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="from_ProposalProduct_RepeatFrom" type="string">
  Filter by repeat from date greater than or equal to this value. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="to_ProposalProduct_RepeatFrom" type="string">
  Filter by repeat from date less than or equal to this value. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="from_ProposalProduct_RepeatUntil" type="string">
  Filter by repeat until date greater than or equal to this value. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="to_ProposalProduct_RepeatUntil" type="string">
  Filter by repeat until date less than or equal to this value. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="from_ProposalProduct_RepeatUnit" type="integer">
  Filter by number of repeat units greater than or equal to this value.
</ParamField>

<ParamField query="to_ProposalProduct_RepeatUnit" type="integer">
  Filter by number of repeat units less than or equal to this value.
</ParamField>

<ParamField query="from_ProposalProduct_CreatedOn" type="string">
  Filter records created on or after this date. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="to_ProposalProduct_CreatedOn" type="string">
  Filter records created on or before this date. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="from_ProposalProduct_UpdatedOn" type="string">
  Filter records updated on or after this date. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

<ParamField query="to_ProposalProduct_UpdatedOn" type="string">
  Filter records updated on or before this date. Format: `YYYY-MM-DDTHH:mm`.
</ParamField>

## Code Examples

### Simple listing

<CodeGroup>
  ```bash cURL theme={null}
  curl -X GET \
    "https://spaces.nexudus.com/api/billing/proposalproducts?page=1&size=15&orderBy=CreatedOn&dir=0" \
    -H "Authorization: Bearer YOUR_TOKEN"
  ```

  ```javascript JavaScript theme={null}
  const response = await fetch(
    'https://spaces.nexudus.com/api/billing/proposalproducts?' + new URLSearchParams({
      page: 1,
      size: 15,
      orderBy: 'CreatedOn',
      dir: 1 // Ascending
    }),
    {
      headers: {
        'Authorization': 'Bearer YOUR_TOKEN'
      }
    }
  );

  const data = await response.json();
  ```

  ```python Python theme={null}
  import requests

  response = requests.get(
      'https://spaces.nexudus.com/api/billing/proposalproducts',
      params={
          'page': 1,
          'size': 15,
          'orderBy': 'CreatedOn',
          'dir': 0 // Ascending
      },
      headers={
          'Authorization': 'Bearer YOUR_TOKEN'
      }
  )

  data = response.json()
  ```
</CodeGroup>

### Filtering by CreatedOn

<CodeGroup>
  ```bash cURL theme={null}
  curl -X GET \
    "https://spaces.nexudus.com/api/billing/proposalproducts?ProposalProduct_CreatedOn=example-value&orderBy=CreatedOn&dir=0" \
    -H "Authorization: Bearer YOUR_TOKEN"
  ```

  ```javascript JavaScript theme={null}
  const response = await fetch(
    'https://spaces.nexudus.com/api/billing/proposalproducts?' + new URLSearchParams({
      ProposalProduct_CreatedOn: 'example-value',
      orderBy: 'CreatedOn',
      dir: 1
    }),
    {
      headers: {
        'Authorization': 'Bearer YOUR_TOKEN'
      }
    }
  );

  const data = await response.json();
  ```

  ```python Python theme={null}
  import requests

  response = requests.get(
      'https://spaces.nexudus.com/api/billing/proposalproducts',
      params={
          'ProposalProduct_CreatedOn': 'example-value',
          'orderBy': 'CreatedOn',
          'dir': 0 // Ascending
      },
      headers={
          'Authorization': 'Bearer YOUR_TOKEN'
      }
  )

  data = response.json()
  ```
</CodeGroup>

### Range filters

<CodeGroup>
  ```bash cURL theme={null}
  curl -X GET \
    "https://spaces.nexudus.com/api/billing/proposalproducts?from_ProposalProduct_UpdatedOn=2025-01-01T00:00&to_ProposalProduct_UpdatedOn=2025-12-31T23:59&orderBy=UpdatedOn&dir=0" \
    -H "Authorization: Bearer YOUR_TOKEN"
  ```

  ```javascript JavaScript theme={null}
  const response = await fetch(
    'https://spaces.nexudus.com/api/billing/proposalproducts?' + new URLSearchParams({
      from_ProposalProduct_UpdatedOn: '2025-01-01T00:00',
      to_ProposalProduct_UpdatedOn: '2025-12-31T23:59',
      orderBy: 'UpdatedOn',
      dir: 1 // Descending
     }),
    {
      headers: {
        'Authorization': 'Bearer YOUR_TOKEN'
      }
    }
  );

  const data = await response.json();
  ```

  ```python Python theme={null}
  import requests

  response = requests.get(
      'https://spaces.nexudus.com/api/billing/proposalproducts',
      params={
          'from_ProposalProduct_UpdatedOn': '2025-01-01T00:00',
          'to_ProposalProduct_UpdatedOn': '2025-12-31T23:59',
          'orderBy': 'UpdatedOn',
          'dir': 1 // Descending
      },
      headers={
          'Authorization': 'Bearer YOUR_TOKEN'
      }
  )

  data = response.json()
  ```
</CodeGroup>

## Response

### 200

<ResponseField name="Records" type="ProposalProduct[]">
  The list of ProposalProduct records matching the query. See the [Get one ProposalProduct](/rest-api/billing/get-proposalproducts-by-id) endpoint for the full list of properties returned for each record.
</ResponseField>

<Warning>
  **Partial records** — The listing endpoint returns a summary representation of each ProposalProduct. The following fields are **not populated** in the `Records[]` response: `RepeatCycle`, `Notes`.

  To get all fields, fetch the full record using the [Get one ProposalProduct](/rest-api/billing/get-proposalproducts-by-id) endpoint.

  **Important for updates:** When updating a record via `PUT`, always retrieve the full record with a `GET` request first, apply your changes to that complete data, and then send the updated record. Do not use data from a listing response as the base for a `PUT` request, as missing fields may be unintentionally cleared.
</Warning>

<ResponseField name="CurrentPage" type="integer">
  Current page number.
</ResponseField>

<ResponseField name="CurrentPageSize" type="integer">
  Number of records per page.
</ResponseField>

<ResponseField name="CurrentOrderField" type="string">
  The field used for sorting.
</ResponseField>

<ResponseField name="CurrentSortDirection" type="integer">
  The sort direction (`0` = ascending, `1` = descending).
</ResponseField>

<ResponseField name="FirstItem" type="integer">
  Index of the first item on the current page.
</ResponseField>

<ResponseField name="LastItem" type="integer">
  Index of the last item on the current page.
</ResponseField>

<ResponseField name="TotalItems" type="integer">
  Total number of matching records across all pages.
</ResponseField>

<ResponseField name="TotalPages" type="integer">
  Total number of pages.
</ResponseField>

<ResponseField name="HasNextPage" type="boolean">
  Whether there is a next page of results.
</ResponseField>

<ResponseField name="HasPreviousPage" type="boolean">
  Whether there is a previous page of results.
</ResponseField>

```json Example Response theme={null}
{
  "Records": [
    {
      "ProposalId": 0,
      "ProposalCoworkerId": null,
      "ProposalCoworkerEmail": null,
      "ProposalCoworkerFullName": null,
      "ProductId": 0,
      "ProductName": null,
      "ProductPrice": 0,
      "ProductApplyProRating": null,
      "ProductBusinessCurrencyCode": null,
      "Quantity": 0,
      "Price": null,
      "IsDeposit": false,
      "IsContractProduct": false,
      "RegularCharge": false,
      "InvoiceOn": null,
      "RepeatFrom": null,
      "RepeatUntil": null,
      "RepeatUnit": null,
      "ApplyProRating": false,
      "Id": 87654321,
      "UpdatedOn": "2025-01-15T10:30:00Z",
      "CreatedOn": "2025-01-10T08:00:00Z",
      "UniqueId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
      "UpdatedBy": "admin@example.com",
      "IsNew": false,
      "SystemId": null,
      "ToStringText": "ProposalProduct Example",
      "LocalizationDetails": null,
      "CustomFields": null
    }
  ],
  "CurrentPageSize": 15,
  "CurrentPage": 1,
  "CurrentOrderField": "CreatedOn",
  "CurrentSortDirection": 1,
  "FirstItem": 1,
  "HasNextPage": false,
  "HasPreviousPage": false,
  "LastItem": 1,
  "PageNumber": 1,
  "PageSize": 15,
  "TotalItems": 1,
  "TotalPages": 1
}
```