Please enable JavaScript to view this site.

Navigation: Schema: Projects > Tables

ProjectServiceById: Simplicate Project Service by ID

Fetches a single service by id

Catalog: Simplicate

Schema: Projects

Label: Project Service by ID

This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.

Select Simplicate API URL: /projects/service/{id}

Insert Simplicate API URL: /projects/service/{id}

Update Simplicate API URL: /projects/service/{id}

Delete Simplicate API URL: /projects/service/{id}

Field Selection Method: NotRequired

Base Path: data

Select Simplicate API Operation: get /projects/service/{id}

Parameters of Table Function

The following parameters can be used to control the behaviour of the table function ProjectServiceById. A value must be provided at all times for required parameters, but optional parameters in general do not need to have a value and the execution will default to a pre-defined behaviour. Values can be specified by position and by name. In both cases, all parameters not specified will be treated using their default values.

Value specification by position is done by listing all values from the first to the last needed value. For example with `select * from table(value1, value2, value3)` on a table with four parameters will use the default value for the fourth parameter and the specified values for the first three.

Value specification by name is done by listing all values that require a value. For example with `select * from table(name1 => value1, name3 => value3)` on the same table will use the default values for the second and fourth parameters and the specified values for the first and third.

Name

Data Type

Required

Default Value

Documentation

id

string

 

The template's id

 

Table Function Columns

The columns of the table function ProjectServiceById are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

amount

float

Amount

 

budget_financial_hours

string

Budget Financial (hrs)

 

budget

float

Budget

 

created_at

string

Created at

 

default_service_id

string

Default Service ID

 

end_date

string

End Date

 

expected_invoice_date

string

Expected Invoice Date

 

explanation

string

Explanation

 

id

string

ID

 

invoice_date

string

Invoice Date

 

invoice_in_installments

boolean

Invoice in Installments

 

invoice_method

string

Invoice Method

 

name

string

Name

 

price

float

Price

 

project_id

string

Project ID

 

related_service_id

string

Related Service ID

 

revenue_group_id

string

Revenue Group ID

 

revenue_group_label

string

Revenue Group Label

 

service_number

string

Service Number

 

start_date

string

Start Date

 

status

string

Status

 

subscription_cycle

string

Subscription Cycle

 

track_cost

boolean

Track Cost

 

track_hours

boolean

Track Hours

 

updated_at

string

Updated at

 

use_in_resource_planner

boolean

Use in Resource Planner

 

vat_class_code

string

VAT Class Code

 

vat_class_id

string

VAT Class ID

 

vat_class_label

string

VAT Class Label

 

vat_class_name

string

VAT Class Name

 

vat_class_percentage

float

VAT Class Percentage

 

write_hours_end_date

string

Write Hours End Date

 

write_hours_start_date

string

Write Hours Start Date

 

 

15-06-2022 20:27 Version 22.0.232-PROD+3445