Navigatie: Schema: Offers > Tables

Offers: Robaws Offers

Catalog: Robaws

Schema: Offers

Label: Offers

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

Select Robaws API URL: /api/v2/offers

Insert Robaws API URL: /api/v2/offers

Update Robaws API URL: /api/v2/offers

Delete Robaws API URL: /api/v2/offers

Field Selection Method: NotRequired

Base Path: items[*]

Select Robaws API Operation: get /api/v2/offers

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function Offers. 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 treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `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
calculated	boolean	☐
clientId	string	☐
projectId	string	☐
searchText	string	☐
sort	string	☐
updatedFrom	datetime	☐

Table Function Columns

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

Name	Data Type	Label	Required
activeOnProject	boolean	Active on Project	☐
address_addressLine1	string		☐
address_addressLine2	string		☐
address_city	string	City	☐
address_country	string	Country	☐
address_latitude	double		☐
address_longitude	double		☐
address_postalCode	string		☐
addressDistance_unit	string		☐
addressDistance_value	int32		☐
archivedAt	datetime		☐
assignedUserId	string		☐
assignee_archivedAt	datetime		☐
assignee_createdAt	datetime		☐
assignee_deletedAt	datetime		☐
assignee_email	string	Assignee Email	☐
assignee_fullName	string	Assignee Full Name	☐
assignee_id	string	Assignee ID	☐
assignee_locked	boolean		☐
assignee_updatedAt	datetime		☐
calculated	boolean		☐
client_address_addressLine1	string		☐
client_address_addressLine2	string		☐
client_address_city	string		☐
client_address_country	string		☐
client_address_latitude	double		☐
client_address_longitude	double		☐
client_address_postalCode	string		☐
client_archivedAt	datetime		☐
client_assignedUserId	string		☐
client_createdAt	datetime		☐
client_deletedAt	datetime		☐
client_email	string	Client Email	☐
client_fax	string	Client Fax	☐
client_generalLedgerAccount_archivedAt	datetime		☐
client_generalLedgerAccount_code	string		☐
client_generalLedgerAccount_createdAt	datetime		☐
client_generalLedgerAccount_deletedAt	datetime		☐
client_generalLedgerAccount_id	string		☐
client_generalLedgerAccount_name	string		☐
client_generalLedgerAccount_updatedAt	datetime		☐
client_generalLedgerAccountId	string		☐
client_gsm	string	Client Mobile	☐
client_id	string	Client ID	☐
client_invoiceAddress_addressLine1	string		☐
client_invoiceAddress_addressLine2	string		☐
client_invoiceAddress_city	string		☐
client_invoiceAddress_country	string		☐
client_invoiceAddress_latitude	double		☐
client_invoiceAddress_longitude	double		☐
client_invoiceAddress_postalCode	string		☐
client_invoiceEmail	string		☐
client_language	string		☐
client_legalForm_archivedAt	datetime		☐
client_legalForm_createdAt	datetime		☐
client_legalForm_deletedAt	datetime		☐
client_legalForm_id	string		☐
client_legalForm_legalAbbreviation	string		☐
client_legalForm_name	string		☐
client_legalForm_updatedAt	datetime		☐
client_legalForm_vatLiable	boolean		☐
client_legalFormId	string		☐
client_name	string		☐
client_paymentCondition_archivedAt	datetime		☐
client_paymentCondition_createdAt	datetime		☐
client_paymentCondition_deletedAt	datetime		☐
client_paymentCondition_id	string		☐
client_paymentCondition_name	string		☐
client_paymentCondition_purchase	boolean		☐
client_paymentCondition_sales	boolean		☐
client_paymentCondition_updatedAt	datetime		☐
client_paymentConditionId	string		☐
client_status	string		☐
client_statusDetails_color	string		☐
client_statusDetails_name	string		☐
client_tel	string		☐
client_title	string		☐
client_updatedAt	datetime		☐
client_vatIdNumber	string		☐
client_vatTariff_additionalMention	string		☐
client_vatTariff_archivedAt	datetime		☐
client_vatTariff_category	string		☐
client_vatTariff_createdAt	datetime		☐
client_vatTariff_deletedAt	datetime		☐
client_vatTariff_description	string		☐
client_vatTariff_id	string		☐
client_vatTariff_name	string		☐
client_vatTariff_percentage	decimal		☐
client_vatTariff_updatedAt	datetime		☐
client_vatTariffId	string		☐
client_website	string		☐
clientContact_archivedAt	datetime		☐
clientContact_createdAt	datetime		☐
clientContact_deletedAt	datetime		☐
clientContact_email	string		☐
clientContact_gsm	string		☐
clientContact_id	string		☐
clientContact_name	string		☐
clientContact_position	string		☐
clientContact_surname	string		☐
clientContact_tel	string		☐
clientContact_title	string		☐
clientContact_updatedAt	datetime		☐
clientContactId	string		☐
clientId	string		☐
clientReference	string	Customer Reference	☐
commission	decimal		☐
createdAt	datetime		☐
date	datetime	Date	☐
deletedAt	datetime		☐
endClient_address_addressLine1	string		☐
endClient_address_addressLine2	string		☐
endClient_address_city	string		☐
endClient_address_country	string		☐
endClient_address_latitude	double		☐
endClient_address_longitude	double		☐
endClient_address_postalCode	string		☐
endClient_archivedAt	datetime		☐
endClient_assignedUserId	string		☐
endClient_createdAt	datetime		☐
endClient_deletedAt	datetime		☐
endClient_email	string		☐
endClient_fax	string		☐
endClient_generalLedgerAccount_archivedAt	datetime		☐
endClient_generalLedgerAccount_code	string		☐
endClient_generalLedgerAccount_createdAt	datetime		☐
endClient_generalLedgerAccount_deletedAt	datetime		☐
endClient_generalLedgerAccount_id	string		☐
endClient_generalLedgerAccount_name	string		☐
endClient_generalLedgerAccount_updatedAt	datetime		☐
endClient_generalLedgerAccountId	string		☐
endClient_gsm	string		☐
endClient_id	string		☐
endClient_invoiceAddress_addressLine1	string		☐
endClient_invoiceAddress_addressLine2	string		☐
endClient_invoiceAddress_city	string		☐
endClient_invoiceAddress_country	string		☐
endClient_invoiceAddress_latitude	double		☐
endClient_invoiceAddress_longitude	double		☐
endClient_invoiceAddress_postalCode	string		☐
endClient_invoiceEmail	string		☐
endClient_language	string		☐
endClient_legalForm_archivedAt	datetime		☐
endClient_legalForm_createdAt	datetime		☐
endClient_legalForm_deletedAt	datetime		☐
endClient_legalForm_id	string		☐
endClient_legalForm_legalAbbreviation	string		☐
endClient_legalForm_name	string		☐
endClient_legalForm_updatedAt	datetime		☐
endClient_legalForm_vatLiable	boolean		☐
endClient_legalFormId	string		☐
endClient_name	string		☐
endClient_paymentCondition_archivedAt	datetime		☐
endClient_paymentCondition_createdAt	datetime		☐
endClient_paymentCondition_deletedAt	datetime		☐
endClient_paymentCondition_id	string		☐
endClient_paymentCondition_name	string		☐
endClient_paymentCondition_purchase	boolean		☐
endClient_paymentCondition_sales	boolean		☐
endClient_paymentCondition_updatedAt	datetime		☐
endClient_paymentConditionId	string		☐
endClient_status	string		☐
endClient_statusDetails_color	string		☐
endClient_statusDetails_name	string		☐
endClient_tel	string		☐
endClient_title	string		☐
endClient_updatedAt	datetime		☐
endClient_vatIdNumber	string		☐
endClient_vatTariff_additionalMention	string		☐
endClient_vatTariff_archivedAt	datetime		☐
endClient_vatTariff_category	string		☐
endClient_vatTariff_createdAt	datetime		☐
endClient_vatTariff_deletedAt	datetime		☐
endClient_vatTariff_description	string		☐
endClient_vatTariff_id	string		☐
endClient_vatTariff_name	string		☐
endClient_vatTariff_percentage	decimal		☐
endClient_vatTariff_updatedAt	datetime		☐
endClient_vatTariffId	string		☐
endClient_website	string		☐
endClientContact_archivedAt	datetime		☐
endClientContact_createdAt	datetime		☐
endClientContact_deletedAt	datetime		☐
endClientContact_email	string		☐
endClientContact_gsm	string		☐
endClientContact_id	string		☐
endClientContact_name	string		☐
endClientContact_position	string		☐
endClientContact_surname	string		☐
endClientContact_tel	string		☐
endClientContact_title	string		☐
endClientContact_updatedAt	datetime		☐
endClientContactId	string		☐
endClientId	string		☐
id	string	ID	☐
logicId	string	Logical ID	☐
project_archivedAt	datetime		☐
project_checkInAtWork	string		☐
project_client_address_addressLine1	string		☐
project_client_address_addressLine2	string		☐
project_client_address_city	string		☐
project_client_address_country	string		☐
project_client_address_latitude	double		☐
project_client_address_longitude	double		☐
project_client_address_postalCode	string		☐
project_client_archivedAt	datetime		☐
project_client_assignedUserId	string		☐
project_client_createdAt	datetime		☐
project_client_deletedAt	datetime		☐
project_client_email	string		☐
project_client_fax	string		☐
project_client_generalLedgerAccount_archivedAt	datetime		☐
project_client_generalLedgerAccount_code	string		☐
project_client_generalLedgerAccount_createdAt	datetime		☐
project_client_generalLedgerAccount_deletedAt	datetime		☐
project_client_generalLedgerAccount_id	string		☐
project_client_generalLedgerAccount_name	string		☐
project_client_generalLedgerAccount_updatedAt	datetime		☐
project_client_generalLedgerAccountId	string		☐
project_client_gsm	string		☐
project_client_id	string		☐
project_client_invoiceAddress_addressLine1	string		☐
project_client_invoiceAddress_addressLine2	string		☐
project_client_invoiceAddress_city	string		☐
project_client_invoiceAddress_country	string		☐
project_client_invoiceAddress_latitude	double		☐
project_client_invoiceAddress_longitude	double		☐
project_client_invoiceAddress_postalCode	string		☐
project_client_invoiceEmail	string		☐
project_client_language	string		☐
project_client_legalForm_archivedAt	datetime		☐
project_client_legalForm_createdAt	datetime		☐
project_client_legalForm_deletedAt	datetime		☐
project_client_legalForm_id	string		☐
project_client_legalForm_legalAbbreviation	string		☐
project_client_legalForm_name	string		☐
project_client_legalForm_updatedAt	datetime		☐
project_client_legalForm_vatLiable	boolean		☐
project_client_legalFormId	string		☐
project_client_name	string		☐
project_client_paymentCondition_archivedAt	datetime		☐
project_client_paymentCondition_createdAt	datetime		☐
project_client_paymentCondition_deletedAt	datetime		☐
project_client_paymentCondition_id	string		☐
project_client_paymentCondition_name	string		☐
project_client_paymentCondition_purchase	boolean		☐
project_client_paymentCondition_sales	boolean		☐
project_client_paymentCondition_updatedAt	datetime		☐
project_client_paymentConditionId	string		☐
project_client_status	string		☐
project_client_statusDetails_color	string		☐
project_client_statusDetails_name	string		☐
project_client_tel	string		☐
project_client_title	string		☐
project_client_updatedAt	datetime		☐
project_client_vatIdNumber	string		☐
project_client_vatTariff_additionalMention	string		☐
project_client_vatTariff_archivedAt	datetime		☐
project_client_vatTariff_category	string		☐
project_client_vatTariff_createdAt	datetime		☐
project_client_vatTariff_deletedAt	datetime		☐
project_client_vatTariff_description	string		☐
project_client_vatTariff_id	string		☐
project_client_vatTariff_name	string		☐
project_client_vatTariff_percentage	decimal		☐
project_client_vatTariff_updatedAt	datetime		☐
project_client_vatTariffId	string		☐
project_client_website	string		☐
project_clientContact_archivedAt	datetime		☐
project_clientContact_createdAt	datetime		☐
project_clientContact_deletedAt	datetime		☐
project_clientContact_email	string		☐
project_clientContact_gsm	string		☐
project_clientContact_id	string		☐
project_clientContact_name	string		☐
project_clientContact_position	string		☐
project_clientContact_surname	string		☐
project_clientContact_tel	string		☐
project_clientContact_title	string		☐
project_clientContact_updatedAt	datetime		☐
project_clientContactId	string		☐
project_clientId	string		☐
project_clientReference	string		☐
project_createdAt	datetime		☐
project_date	datetime		☐
project_deletedAt	datetime		☐
project_distance	int32		☐
project_endClient_address_addressLine1	string		☐
project_endClient_address_addressLine2	string		☐
project_endClient_address_city	string		☐
project_endClient_address_country	string		☐
project_endClient_address_latitude	double		☐
project_endClient_address_longitude	double		☐
project_endClient_address_postalCode	string		☐
project_endClient_archivedAt	datetime		☐
project_endClient_assignedUserId	string		☐
project_endClient_createdAt	datetime		☐
project_endClient_deletedAt	datetime		☐
project_endClient_email	string		☐
project_endClient_fax	string		☐
project_endClient_generalLedgerAccount_archivedAt	datetime		☐
project_endClient_generalLedgerAccount_code	string		☐
project_endClient_generalLedgerAccount_createdAt	datetime		☐
project_endClient_generalLedgerAccount_deletedAt	datetime		☐
project_endClient_generalLedgerAccount_id	string		☐
project_endClient_generalLedgerAccount_name	string		☐
project_endClient_generalLedgerAccount_updatedAt	datetime		☐
project_endClient_generalLedgerAccountId	string		☐
project_endClient_gsm	string		☐
project_endClient_id	string		☐
project_endClient_invoiceAddress_addressLine1	string		☐
project_endClient_invoiceAddress_addressLine2	string		☐
project_endClient_invoiceAddress_city	string		☐
project_endClient_invoiceAddress_country	string		☐
project_endClient_invoiceAddress_latitude	double		☐
project_endClient_invoiceAddress_longitude	double		☐
project_endClient_invoiceAddress_postalCode	string		☐
project_endClient_invoiceEmail	string		☐
project_endClient_language	string		☐
project_endClient_legalForm_archivedAt	datetime		☐
project_endClient_legalForm_createdAt	datetime		☐
project_endClient_legalForm_deletedAt	datetime		☐
project_endClient_legalForm_id	string		☐
project_endClient_legalForm_legalAbbreviation	string		☐
project_endClient_legalForm_name	string		☐
project_endClient_legalForm_updatedAt	datetime		☐
project_endClient_legalForm_vatLiable	boolean		☐
project_endClient_legalFormId	string		☐
project_endClient_name	string		☐
project_endClient_paymentCondition_archivedAt	datetime		☐
project_endClient_paymentCondition_createdAt	datetime		☐
project_endClient_paymentCondition_deletedAt	datetime		☐
project_endClient_paymentCondition_id	string		☐
project_endClient_paymentCondition_name	string		☐
project_endClient_paymentCondition_purchase	boolean		☐
project_endClient_paymentCondition_sales	boolean		☐
project_endClient_paymentCondition_updatedAt	datetime		☐
project_endClient_paymentConditionId	string		☐
project_endClient_status	string		☐
project_endClient_statusDetails_color	string		☐
project_endClient_statusDetails_name	string		☐
project_endClient_tel	string		☐
project_endClient_title	string		☐
project_endClient_updatedAt	datetime		☐
project_endClient_vatIdNumber	string		☐
project_endClient_vatTariff_additionalMention	string		☐
project_endClient_vatTariff_archivedAt	datetime		☐
project_endClient_vatTariff_category	string		☐
project_endClient_vatTariff_createdAt	datetime		☐
project_endClient_vatTariff_deletedAt	datetime		☐
project_endClient_vatTariff_description	string		☐
project_endClient_vatTariff_id	string		☐
project_endClient_vatTariff_name	string		☐
project_endClient_vatTariff_percentage	decimal		☐
project_endClient_vatTariff_updatedAt	datetime		☐
project_endClient_vatTariffId	string		☐
project_endClient_website	string		☐
project_endClientContact_archivedAt	datetime		☐
project_endClientContact_createdAt	datetime		☐
project_endClientContact_deletedAt	datetime		☐
project_endClientContact_email	string		☐
project_endClientContact_gsm	string		☐
project_endClientContact_id	string		☐
project_endClientContact_name	string		☐
project_endClientContact_position	string		☐
project_endClientContact_surname	string		☐
project_endClientContact_tel	string		☐
project_endClientContact_title	string		☐
project_endClientContact_updatedAt	datetime		☐
project_endClientContactId	string		☐
project_endClientId	string		☐
project_id	string		☐
project_logicId	string		☐
project_nssoDeclarationOfWorks	string		☐
project_planningName	string		☐
project_siteAddress_addressLine1	string		☐
project_siteAddress_addressLine2	string		☐
project_siteAddress_city	string		☐
project_siteAddress_country	string		☐
project_siteAddress_latitude	double		☐
project_siteAddress_longitude	double		☐
project_siteAddress_postalCode	string		☐
project_siteManager_archivedAt	datetime		☐
project_siteManager_createdAt	datetime		☐
project_siteManager_deletedAt	datetime		☐
project_siteManager_email	string		☐
project_siteManager_fullName	string		☐
project_siteManager_id	string		☐
project_siteManager_locked	boolean		☐
project_siteManager_updatedAt	datetime		☐
project_siteManagerId	string		☐
project_siteNssoIdNumber	string		☐
project_status	string		☐
project_statusDetails_color	string		☐
project_statusDetails_name	string		☐
project_updatedAt	datetime		☐
projectId	string	Project ID	☐
status	string	Status	☐
statusDetails_color	string		☐
statusDetails_name	string		☐
title	string	Title	☐
totalExclVat	decimal		☐
totalInclVat	decimal		☐
updatedAt	datetime		☐

17-06-2022 11:59 Version 22.1.46-BETA+3385

Schakel JavaScript in om deze site te bekijken.

ROBAWS API Data Model

Offers: Robaws Offers

Parameters of Table Function

Table Function Columns

Belangrijke Informatie over Veiligheid en Gebruik