Back to InsightlyGets A Filtered List Of Opportunity Products
To filter with a field name and value, both field_name and field_value parameters must be provided.
Simple object graphs (excluding TAGS, CUSTOMFIELDS, etc.) are returned if "brief=true" is used in the query string.
Input
type: object
properties:
parameters:
type: object
properties:
field_name:
type: string
description: Optional, field name for object
field_value:
type: string
description: Optional, field value of the record
updated_after_utc:
type: string
description: Optional, earliest date when a record was last updated.
brief:
type: string
description: >-
Optional, true if response should only contain top level properties of
the record.
skip:
type: string
description: Optional, number of records to skip.
top:
type: string
description: Optional, maximum number of records to return in the response.
count_total:
type: string
description: >-
Optional, true if total number of records should be returned in the
response headers.
title: Parameters
Output
type: array
items:
type: object
title: OpportunityLineItem
properties:
OPPORTUNITY_ITEM_ID:
format: int64
maxLength: 0
type: integer
readOnly: true
OPPORTUNITY_ID:
format: int64
maxLength: 0
type: integer
readOnly: true
PRICEBOOK_ENTRY_ID:
format: int64
maxLength: 0
type: integer
readOnly: true
CURRENCY_CODE:
format: string
maxLength: 3
type: string
readOnly: false
UNIT_PRICE:
format: string
maxLength: 19
type: number
readOnly: false
DESCRIPTION:
format: string
maxLength: 255
type: string
readOnly: false
QUANTITY:
format: string
maxLength: 0
type: number
readOnly: false
SERVICE_DATE:
format: date-time
maxLength: 0
type: string
readOnly: false
TOTAL_PRICE:
format: string
maxLength: 19
type: number
readOnly: true
DATE_CREATED_UTC:
format: date-time
maxLength: 0
type: string
readOnly: true
DATE_UPDATED_UTC:
format: date-time
maxLength: 0
type: string
readOnly: true
LIST_PRICE:
format: string
maxLength: 19
type: number
readOnly: false
SUBTOTAL:
format: string
maxLength: 19
type: number
readOnly: true
DISCOUNT:
format: string
maxLength: 0
type: number
readOnly: false
CUSTOMFIELDS:
type: array
items:
type: object
title: CustomField
properties:
FIELD_NAME:
type: string
FIELD_VALUE:
type: object