invantive documentation
Invantive Support ForumsLog In / Sign Up

Deals: Teamleader Focus Deals

popular read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Deals

Can only retrieve data.

API Source

  • Endpoint: deals.list

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
created_before date
estimated_closing_date date
estimated_closing_date_from date
estimated_closing_date_until date
phase_id ``
responsible_user_id ``
term `` Search for term in title, reference and customer name.
updated_since datetime

Table Columns

The columns of the table Deals are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
c_omzetwaarde_volgens_methode_2 decimal itgen_teamleader_c_omzetwaarde_volgens_methode_2 filters on the platform, writable
c_success varchar2 itgen_teamleader_c_success filters on the platform, writable
closed_at datetime Closed at filters on the platform, writable
created_at datetime Created at filters on the platform, writable
currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable, currency_exchange_rate.from
currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable, currency_exchange_rate.rate
currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable, currency_exchange_rate.to
current_phase_id varchar2 Current Phase ID filters on the platform, writable, current_phase.id
current_phase_type varchar2 Current Phase Type filters on the platform, writable, current_phase.type
department_id varchar2 Department ID filters on the platform, writable, department.id
department_type varchar2 Department Type filters on the platform, writable, department.type
estimated_closing_date datetime Estimated Closing Date filters on the platform, writable
estimated_probability decimal Estimated Probability filters on the platform, writable
estimated_value_amount decimal Estimated Value Amount filters on the platform, writable, estimated_value.amount
estimated_value_currency varchar2 Currency of Estimated Value Amount filters on the platform, writable, estimated_value.currency
id varchar2 ID filters on the platform, writable
lead_contact_person_id varchar2 Lead Contact Person ID filters on the platform, writable, lead.contact_person.id
lead_contact_person_type varchar2 Lead Contact Person Type filters on the platform, writable, lead.contact_person.type
lead_customer_id varchar2 Lead Customer ID filters on the platform, writable, lead.customer.id
lead_customer_type varchar2 Lead Customer Type filters on the platform, writable, lead.customer.type
lost_reason_id varchar2 Lost Reason ID filters on the platform, writable, lost_reason.reason.id
lost_reason_remark varchar2 Lost Reason Remark filters on the platform, writable, lost_reason.remark
lost_reason_type varchar2 Lost Reason Type filters on the platform, writable, lost_reason.reason.type
pipeline_id varchar2 Pipeline ID filters on the platform, writable, pipeline.id
pipeline_type varchar2 Pipeline Type filters on the platform, writable, pipeline.type
purchase_order_number varchar2 Purchase Order Number filters on the platform, writable
reference varchar2 Reference filters on the platform, writable
responsible_user_id varchar2 Responsible User ID filters on the platform, writable, responsible_user.id
responsible_user_type varchar2 Responsible User Type filters on the platform, writable, responsible_user.type
source_id varchar2 Source ID filters on the platform, writable, source.id
source_type varchar2 Source Type filters on the platform, writable, source.type
status varchar2 Status filters on the platform, writable
summary varchar2 Summary filters on the platform, writable
title varchar2(120) Title filters on the platform, writable
updated_at datetime Updated At filters on the platform, writable
web_url varchar2 Web (URL) filters on the platform, writable
weighted_value_amount decimal Weighted Value Amount filters on the platform, writable, weighted_value.amount
weighted_value_currency varchar2 Weighted Value Currency filters on the platform, writable, weighted_value.currency

Keys

Key Column Refers to Kind Description
Deals_current_phase_id_fk current_phase_id DealPhases.id Key
Deals_department_id_fk department_id Departments.id Key
Deals_lead_contact_person_id_fk lead_contact_person_id Contacts.id Key
Deals_lead_customer_id_Companies_txt lead_customer_id Companies.id Textual The id of a row of Companies, when lead_customer_type is 'company'.
Deals_lead_customer_id_Contacts_txt lead_customer_id Contacts.id Textual The id of a row of Contacts, when lead_customer_type is 'contact'.
Deals_lost_reason_id_fk lost_reason_id LostReasons.id Key
Deals_pipeline_id_fk pipeline_id DealPipelines.id Key
Deals_responsible_user_id_fk responsible_user_id Users.id Key
Deals_source_id_fk source_id DealSources.id Key

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: