Materials: Robaws Materials
insert update delete REST
- Catalog:
Robaws - Schema:
Materials - Primary Keys:
id - Label: Materials
Search
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/api/v2/materials - Operation:
get /api/v2/materials
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 86 |
| Full scan rows per minute | 35,098 |
| Point query rows per minute | 1,132 |
| Write rows per minute | 539 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
article |
`` | |||
client |
`` | |||
employee |
`` | |||
end |
`` | |||
installation |
`` | Deprecated. Please use the types parameter to specify which types of materials you want to retrieve. For backwards compatibility, this filter parameter is retained with default value false, so when you do not specify the types parameter, you will only retrieve the materials (no installations). | ||
project |
`` | |||
search |
`` | |||
serial |
`` | |||
sort |
`` | |||
subcontractor |
`` | |||
updated |
`` | |||
with |
`` |
Table Columns
The columns of the table Materials 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 |
|---|---|---|---|---|---|
address_ |
varchar2 |
Address Line 1 | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Address Line 2 | filters on the platform, writable, address. |
||
address_ |
varchar2 |
City | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Country | filters on the platform, writable, address. |
||
address_ |
double |
Address Latitude | filters on the platform, writable, address. |
||
address_ |
double |
Address Longitude | filters on the platform, writable, address. |
||
address_ |
varchar2 |
Address Postal Code | filters on the platform, writable, address. |
||
archived |
datetime |
Archived at | filters on the platform, writable, archived |
||
article |
varchar2 |
Article ID | filters on the platform, writable, article |
||
assigned |
varchar2 |
Assigned Client ID | filters on the platform, writable, assigned |
||
assigned |
varchar2 |
Assigned Employee ID | filters on the platform, writable, assigned |
||
assigned |
varchar2 |
Assigned End Client ID | filters on the platform, writable, assigned |
||
assigned |
varchar2 |
Assigned Project ID | filters on the platform, writable, assigned |
||
assigned |
varchar2 |
Assigned Subcontractor ID | filters on the platform, writable, assigned |
||
brand |
varchar2 |
Brand | filters on the platform, writable, brand |
||
company |
varchar2 |
Company ID | filters on the platform, writable, company |
||
created |
datetime |
Created at | filters on the platform, writable, created |
||
deleted |
datetime |
Deleted at | filters on the platform, writable, deleted |
||
extra |
varchar2 |
Extra Fields | writable | The JSON text of the nested object. | |
id |
varchar2 |
ID | filters on the platform, writable, id |
||
installation |
char |
Installation | filters on the platform, writable, installation |
||
location |
varchar2 |
Location | filters on the platform, writable, location |
||
locked |
datetime |
Locked at | filters on the platform, writable, locked |
||
name |
varchar2 |
Name | filters on the platform, writable, name |
||
planning |
varchar2 |
Planning Group | filters on the platform, writable, planning |
||
serial |
varchar2 |
Serial Number | filters on the platform, writable, serial |
||
status |
varchar2 |
Status | filters on the platform, writable, status |
||
status |
varchar2 |
Status Details Color | filters on the platform, writable, status |
||
status |
varchar2 |
Status Details Name | filters on the platform, writable, status |
||
stock |
varchar2 |
Stock Location ID | filters on the platform, writable, stock |
||
supplier |
varchar2 |
Supplier ID | filters on the platform, writable, supplier |
||
updated |
datetime |
Updated at | filters on the platform, writable, updated |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Materials_ |
assigned |
Clients.id |
Key | |
Materials_ |
assigned |
Employees.id |
Key | |
Materials_ |
assigned |
Projects.id |
Textual | The referenced row, for as long as Robaws still lists it: a deleted or purged row is no longer listed, and a document may keep referring to it. |
Materials_ |
assigned |
Suppliers.id |
Key | |
Materials_ |
company |
Companies.id |
Key | |
Materials_ |
stock |
StockLocations.id |
Key | |
Materials_ |
supplier |
Suppliers.id |
Key |
Referenced By
- SettlementLineItems
materialId(Key) - Transports
truckId(Textual) - WorkOrderMaterialEntries
materialId(Textual)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: