Navigation: » No topics above this level «

Contacts: Contacts

https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V2.Contacts%0D%0Alimit++1000

Name: Contacts

Catalog: Teamleader

Schema: V2

Primary Keys: id

Label: Contacts

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): contacts.list

Insert Service URL (OData-specific): contacts.list

Update Service URL (OData-specific): contacts.list

Delete Service URL (OData-specific): contacts.list

Field Selection Method (OData-specific): NotRequired

Table Columns

Name	Data Type	Label	Required	Documentation
added_at	datetime	Added At	☑
bic	string	BIC Number	☐
birthdate	datetime	Date of Birth	☐
first_name	string	First Name	☐
gender	string	Gender	☐
iban	string	IBAN Number	☐
id	string	ID	☑
invoicing_preferences_electronic_invoicing_address	string		☐
language	string	Language	☐
last_name	string	Last Name	☐
local_business_number	string	Local Business Number	☐	Also known as Chamber of Commerce number in many countries.
national_identification_number	string		☐	Also known as Chamber of Commerce number in many countries.
payment_term_days	decimal	Payment Term (days)	☐
payment_term_type	string	Payment Term Type	☐
primary_address_city	string	Primary Address City	☐
primary_address_country	string	Primary Address Country	☐
primary_address_line1	string	Primary Address Line 1	☐
primary_address_postal_code	string	Primary Address Postal Code	☐
salutation	string	Salutation	☐
updated_at	datetime	Updated At	☑
web_url	string	Web (URL)	☑
website	string	Website	☐

10-09-2020 00:0920.1.206-BETA+2915