invantive documentation
Invantive Support ForumsLog In / Sign Up

DealById: Teamleader Focus Deal by ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Deal by ID

Can only retrieve data.

API Source

  • Endpoint: deals.info

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table DealById 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

Release Notes

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