Please enable JavaScript to view this site.

Navigation: Schema: V2 > Tables

ProductById: Teamleader Focus Product by ID

Catalog: Teamleader

Schema: V2

Primary Keys: id

Label: Product by ID

This is a read-only table function. The Teamleader Focus API may not support changing the data or the Invantive SQL driver for Teamleader Focus does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader Focus API.

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function ProductById. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be evaluated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example: a `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

id

string

 

 

 

Columns of Table Function

The columns of the table function ProductById are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

added_at

datetime

Added At

 

c_artikeltext

string

 

 

code

string

 

 

configuration_stock_threshold_action

string

 

 

configuration_stock_threshold_minimum

decimal

 

 

description

string

Description

 

id

string

ID

 

name

string

Name

 

purchase_price_amount

decimal

 

 

purchase_price_currency

string

 

 

selling_price_amount

decimal

 

 

selling_price_currency

string

 

 

stock_amount

decimal

 

 

unit_id

string

 

 

unit_type

string

 

 

updated_at

datetime

Updated At

 

 

16-08-2023 19:47 Version 22.1.262-BETA+4120