SalesServices: Simplicate Sales Services
insert update delete REST
- Catalog:
Simplicate - Schema:
Sales - Primary Keys:
id - Label: Sales Services
Fetches all services
Can retrieve data and change data using insert, update and delete.
API Source
- Endpoint:
/sales/service - Operation:
get /sales/service
Table Columns
The columns of the table SalesServices 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 |
|---|---|---|---|---|---|
amount |
double |
Amount | |||
created_ |
varchar2 |
Created at | |||
default_ |
varchar2 |
Default Service ID | |||
explanation |
varchar2 |
Explanation | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice Date | |||
invoice_ |
varchar2 |
Invoice Method | |||
name |
varchar2 |
Name | |||
position |
int64 |
Position | |||
price |
double |
Price | |||
sales_ |
varchar2 |
Sales ID | |||
show_ |
int64 |
Show Item Type | |||
subscription_ |
varchar2 |
Subscription Cycle | |||
total |
varchar2 |
Total | |||
track_ |
char |
Track Cost | |||
track_ |
char |
Track Hours | |||
updated_ |
varchar2 |
Updated at | |||
vat_ |
varchar2 |
VAT Class Code | |||
vat_ |
varchar2 |
VAT Class ID | |||
vat_ |
varchar2 |
VAT Class Label | |||
vat_ |
varchar2 |
VAT Class Name | |||
vat_ |
double |
VAT Class Percentage | |||
vat_ |
varchar2 |
VAT Code | |||
vat_ |
varchar2 |
VAT Description |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: