ProjectServiceById: Simplicate Project Service by ID
read only REST
- Catalog:
Simplicate - Schema:
Projects - Label: Project Service by ID
Fetches a single service by id
Can only retrieve data.
API Source
- Endpoint:
/projects/service/{id} - Operation:
get /projects/service/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table ProjectServiceById 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 | |||
budget |
double |
Budget | |||
budget_ |
varchar2 |
Budget Financial (hrs) | |||
created_ |
varchar2 |
Created at | |||
default_ |
varchar2 |
Default Service ID | |||
end_ |
varchar2 |
End Date | |||
expected_ |
varchar2 |
Expected Invoice Date | |||
explanation |
varchar2 |
Explanation | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice Date | |||
invoice_ |
char |
Invoice in Installments | |||
invoice_ |
varchar2 |
Invoice Method | |||
name |
varchar2 |
Name | |||
price |
double |
Price | |||
project_ |
varchar2 |
Project ID | |||
related_ |
varchar2 |
Related Service ID | |||
revenue_ |
varchar2 |
Revenue Group ID | |||
revenue_ |
varchar2 |
Revenue Group Label | |||
service_ |
varchar2 |
Service Number | |||
start_ |
varchar2 |
Start Date | |||
status |
varchar2 |
Status | |||
subscription_ |
varchar2 |
Subscription Cycle | |||
track_ |
char |
Track Cost | |||
track_ |
char |
Track Hours | |||
updated_ |
varchar2 |
Updated at | |||
use_ |
char |
Use in Resource Planner | |||
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 | |||
write_ |
varchar2 |
Write Hours End Date | |||
write_ |
varchar2 |
Write Hours Start Date |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: