Insightly

Links

    Insightly API

    Getting access, Developing, Testing

    Back to Insightly

    Gets 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