invantive documentation
Invantive Support ForumsLog In / Sign Up

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_financial_hours varchar2 Budget Financial (hrs)
created_at varchar2 Created at
default_service_id varchar2 Default Service ID
end_date varchar2 End Date
expected_invoice_date varchar2 Expected Invoice Date
explanation varchar2 Explanation
id varchar2 ID
invoice_date varchar2 Invoice Date
invoice_in_installments char Invoice in Installments
invoice_method varchar2 Invoice Method
name varchar2 Name
price double Price
project_id varchar2 Project ID
related_service_id varchar2 Related Service ID
revenue_group_id varchar2 Revenue Group ID
revenue_group_label varchar2 Revenue Group Label
service_number varchar2 Service Number
start_date varchar2 Start Date
status varchar2 Status
subscription_cycle varchar2 Subscription Cycle
track_cost char Track Cost
track_hours char Track Hours
updated_at varchar2 Updated at
use_in_resource_planner char Use in Resource Planner
vat_class_code varchar2 VAT Class Code
vat_class_id varchar2 VAT Class ID
vat_class_label varchar2 VAT Class Label
vat_class_name varchar2 VAT Class Name
vat_class_percentage double VAT Class Percentage
write_hours_end_date varchar2 Write Hours End Date
write_hours_start_date varchar2 Write Hours Start Date

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: