xMsg javascript has not been loaded.
Fetches all services
Catalog: Simplicate
Schema: Sales
Can retrieve data and change data using insert, update and delete.
Select Simplicate API URL: /sales/service
Insert Simplicate API URL: /sales/service
Update Simplicate API URL: /sales/service
Delete Simplicate API URL: /sales/service
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /sales/service
Insert Simplicate API Operation: post /sales/service
Update Simplicate API Operation: put /sales/service/{id}
Delete Simplicate API Operation: delete /sales/service/{id}
The columns of the table function 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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amount |
float |
|
☐ |
|
created_at |
string |
Created at |
☐ |
|
default_service_id |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_date |
string |
|
☐ |
|
invoice_method |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
price |
float |
|
☐ |
|
sales_id |
string |
|
☐ |
|
subscription_cycle |
string |
|
☐ |
|
track_cost |
boolean |
|
☐ |
|
track_hours |
boolean |
|
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152