Integrate a CBS with an External Data Source
post
/api/restapi/cbs/project/sync
Send a request to this endpoint to create or update an integrated a CBS. If an object provided in the request body does not exist in the application, an object is created using the request data. Integrated objects can only be modified using the API.
Request
There are no request parameters for this operation.
Supported Media Types
- application/json
Root Schema : ApiEntityExternallySourcedCBSSheetCodeInput
Type:
object
Title:
ApiEntityExternallySourcedCBSSheetCodeInput
This entity represents a ExternallySourcedCBSSheetCode object, a unique ExternallySourcedCBSSheetCode object can be identified by the following combinations of the fields.
Show Source
- cbsSheetCodeId
- cbsCode,projectId
- cbsCode,projectCode,workspaceCode
-
cbsCode(required): string
Minimum Length:
1
Maximum Length:60
The cost breakdown structure code is a code that is concatenated with its parent and child according to the segment definition. -
cbsSheetCodeId: integer
(int64)
The ID of the cost breakdown structure code. The CBS code is a code that is concatenated with its parent and child according to the segment definition. This value should not be provided in create operation request data, however, it is required for update requests.
-
costSheetId: integer
(int64)
The unique identifier of a cost sheet.
-
costSheetRow:
costSheetRow
A CBS sheet row object.
-
costType: string
Allowed Values:
[ "CAPITAL", "EXPENSE", "NONE" ]
The category of the cost breakdown structure code.
Expense: Represents an expense.
Capital: Represents capital.
None: Type is not divided into expense or capital. None is selected by default if no other choice is made. -
description: string
Minimum Length:
0
Maximum Length:255
The name of the CBS code. -
isActive: boolean
The active field indicates whether the CBS code is active for use.
-
parentCBSCodes: array
parentCBSCodes
List of parent cbs codes in a hierarchy. This field is not populated as part of the API response since it is a write-only field, used only for the create or update APIs.
-
parentId: integer
(int64)
The system-generated identifier of a parent cost item in a cost sheet.
-
projectCode: string
Minimum Length:
1
Maximum Length:60
The user-specified identifier of a project. -
projectId(required): integer
(int64)
The unique identifier for the project.
-
sourceId: string
Maximum Length:
255
The unique identifier of cost sheet item data in an external source. -
workspaceCode: string
Minimum Length:
0
Maximum Length:60
The user-specified identifier of a workspace. -
workspaceId: integer
(int64)
The system-generated identifier of a workspace.
Nested Schema : costSheetRow
A CBS sheet row object.
Match All
A CBS sheet row object.
Show Source
-
object
ApiEntityCBSSheetRowInput
Title:
ApiEntityCBSSheetRowInput
Nested Schema : parentCBSCodes
Type:
array
List of parent cbs codes in a hierarchy. This field is not populated as part of the API response since it is a write-only field, used only for the create or update APIs.
Show Source
Nested Schema : ApiEntityCBSSheetRowInput
Type:
object
Title:
Show Source
ApiEntityCBSSheetRowInput
-
configuredFields: array
configuredFields
An object containing configured fields in the form of key-value pairs.
Nested Schema : configuredFields
Type:
array
An object containing configured fields in the form of key-value pairs.
Show Source
-
Array of:
object ApiEntityCBSSheetRowConfiguredFieldValueInput
Title:
ApiEntityCBSSheetRowConfiguredFieldValueInput
This entity represents a CBSSheetRowConfiguredFieldValue object, a unique CBSSheetRowConfiguredFieldValue object can be identified by the following combinations of the fields.- costSheetRowConfiguredFieldValueId
- columnDefinitionId
- columnName
- columnLabel
Nested Schema : ApiEntityCBSSheetRowConfiguredFieldValueInput
Type:
object
Title:
ApiEntityCBSSheetRowConfiguredFieldValueInput
This entity represents a CBSSheetRowConfiguredFieldValue object, a unique CBSSheetRowConfiguredFieldValue object can be identified by the following combinations of the fields.
Show Source
- costSheetRowConfiguredFieldValueId
- columnDefinitionId
- columnName
- columnLabel
-
action: string
Allowed Values:
[ "DELETE" ]
Provide value for this field during object update to delete the assigned configured field value. -
columnDefinitionId: integer
(int64)
Unique identifier of the column. This value should not be provided in create operation request data, however, it is required for update requests.
-
columnLabel: string
Minimum Length:
1
Maximum Length:100
The user-specified UDF column label. -
columnName: string
Minimum Length:
1
Maximum Length:100
The user-specified UDF column name. -
costSheetRowConfiguredFieldValueId: integer
(int64)
The unique identifier for the Project Cost Sheet Configured Field.
-
costSheetRowId: integer
(int64)
The system-generated identifier of a CBS Code.
-
dateValue: string
(date-time)
This holds values for Date type configured fields.
-
numberValue: number
This holds values for Number, Integer and Cost type configured fields. Input for the cost configured field should be provided in the currency of record. For example project level currency in case of Activity, base currency for Company, workspace currency for Funds and record level currency for Project Actuals etc. configured fields.
-
textValue: string
Maximum Length:
4000
This holds values for Boolean, List and Text type configured fields.
Examples
Back to Top
Response
Supported Media Types
- application/json
200 Response
The object was successfully updated.
Root Schema : ApiEntityERPSyncApiResponse
Type:
object
Title:
Show Source
ApiEntityERPSyncApiResponse
-
identifier: object
identifier
The unique identifier of the supported object returned based on the user input.
This field can return any of the following entities determined based on the object for which the API call is invoked.
Example : ProjectIdentifier is returned when Batch Integrate Projects with an External Data Source API is invoked. -
link: string
(url)
Read Only:
true
The self-link to the object. This field is populated only in the responses generated by the batch create APIs. -
message: string
Message is populated based on result of the operation.
Success - Message will not be populated. Please refer the statusCode.
Failure - Error message or reason for operation failure is populated.
Warning - warning message is populated.
The field is non-persistable and thus maximum length is not applicable. -
primaryKeyName: string
The primary key field name associated with the integrated object.
The field is non-persistable and thus maximum length is not applicable. -
primaryKeyValue: integer
(int64)
The unique identifier for the integrated object.
-
sourceId: string
Maximum Length:
255
The unique identifier of the object in an external source. -
statusCode: integer
(int32)
The response code representing the state of the API operation.
-
updateDate: string
(date-time)
Read Only:
true
Date when the record was last updated.
Nested Schema : identifier
Type:
object
The unique identifier of the supported object returned based on the user input.
This field can return any of the following entities determined based on the object for which the API call is invoked.
Example : ProjectIdentifier is returned when Batch Integrate Projects with an External Data Source API is invoked.
This field can return any of the following entities determined based on the object for which the API call is invoked.
Example : ProjectIdentifier is returned when Batch Integrate Projects with an External Data Source API is invoked.
Match One Schema
Show Source
-
object
ProjectIdentifier
Title:
ProjectIdentifier
-
object
CBSSheetCodeIdentifier
Title:
CBSSheetCodeIdentifier
-
object
ResourceIdentifier
Title:
ResourceIdentifier
Nested Schema : ProjectIdentifier
Type:
object
Title:
Show Source
ProjectIdentifier
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
workspaceCode: string
The user-specified identifier of a workspace.
-
workspaceId: integer
(int64)
The unique identifier of a workspace.
Nested Schema : CBSSheetCodeIdentifier
Type:
object
Title:
Show Source
CBSSheetCodeIdentifier
-
cbsCode: string
Maximum Length:
60
The cost breakdown structure code is a code that is concatenated with its parent and child according to the segment definition. -
cbsSheetCodeId: integer
(int64)
The ID of the cost breakdown structure code. The CBS code is a code that is concatenated with its parent and child according to the segment definition.
-
costSheetId: integer
(int64)
The unique identifier of a cost sheet.
-
parentId: integer
(int64)
The system-generated identifier of a parent cost item in a cost sheet.
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
workspaceCode: string
The user-specified identifier of a workspace.
-
workspaceId: integer
(int64)
The unique identifier of a workspace.
Nested Schema : ResourceIdentifier
Type:
object
Title:
Show Source
ResourceIdentifier
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
resourceClass: string
Allowed Values:
[ "RESOURCE", "ROLE" ]
The class identifies the item as a resource or a role. -
resourceCode: string
Maximum Length:
60
The unique identifier for the resource or role. -
resourceId: integer
(int64)
The unique identifier for the resource or role.
-
workspaceCode: string
The user-specified identifier of a workspace.
-
workspaceId: integer
(int64)
The unique identifier of a workspace.
201 Response
The object was successfully created.
Root Schema : ApiEntityERPSyncApiResponse
Type:
object
Title:
Show Source
ApiEntityERPSyncApiResponse
-
identifier: object
identifier
The unique identifier of the supported object returned based on the user input.
This field can return any of the following entities determined based on the object for which the API call is invoked.
Example : ProjectIdentifier is returned when Batch Integrate Projects with an External Data Source API is invoked. -
link: string
(url)
Read Only:
true
The self-link to the object. This field is populated only in the responses generated by the batch create APIs. -
message: string
Message is populated based on result of the operation.
Success - Message will not be populated. Please refer the statusCode.
Failure - Error message or reason for operation failure is populated.
Warning - warning message is populated.
The field is non-persistable and thus maximum length is not applicable. -
primaryKeyName: string
The primary key field name associated with the integrated object.
The field is non-persistable and thus maximum length is not applicable. -
primaryKeyValue: integer
(int64)
The unique identifier for the integrated object.
-
sourceId: string
Maximum Length:
255
The unique identifier of the object in an external source. -
statusCode: integer
(int32)
The response code representing the state of the API operation.
-
updateDate: string
(date-time)
Read Only:
true
Date when the record was last updated.
Nested Schema : identifier
Type:
object
The unique identifier of the supported object returned based on the user input.
This field can return any of the following entities determined based on the object for which the API call is invoked.
Example : ProjectIdentifier is returned when Batch Integrate Projects with an External Data Source API is invoked.
This field can return any of the following entities determined based on the object for which the API call is invoked.
Example : ProjectIdentifier is returned when Batch Integrate Projects with an External Data Source API is invoked.
Match One Schema
Show Source
-
object
ProjectIdentifier
Title:
ProjectIdentifier
-
object
CBSSheetCodeIdentifier
Title:
CBSSheetCodeIdentifier
-
object
ResourceIdentifier
Title:
ResourceIdentifier
Nested Schema : ProjectIdentifier
Type:
object
Title:
Show Source
ProjectIdentifier
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
workspaceCode: string
The user-specified identifier of a workspace.
-
workspaceId: integer
(int64)
The unique identifier of a workspace.
Nested Schema : CBSSheetCodeIdentifier
Type:
object
Title:
Show Source
CBSSheetCodeIdentifier
-
cbsCode: string
Maximum Length:
60
The cost breakdown structure code is a code that is concatenated with its parent and child according to the segment definition. -
cbsSheetCodeId: integer
(int64)
The ID of the cost breakdown structure code. The CBS code is a code that is concatenated with its parent and child according to the segment definition.
-
costSheetId: integer
(int64)
The unique identifier of a cost sheet.
-
parentId: integer
(int64)
The system-generated identifier of a parent cost item in a cost sheet.
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
workspaceCode: string
The user-specified identifier of a workspace.
-
workspaceId: integer
(int64)
The unique identifier of a workspace.
Nested Schema : ResourceIdentifier
Type:
object
Title:
Show Source
ResourceIdentifier
-
projectCode: string
Maximum Length:
60
The unique identifier for a project set by the user who created the project. -
projectId: integer
(int64)
The unique identifier for the project.
-
resourceClass: string
Allowed Values:
[ "RESOURCE", "ROLE" ]
The class identifies the item as a resource or a role. -
resourceCode: string
Maximum Length:
60
The unique identifier for the resource or role. -
resourceId: integer
(int64)
The unique identifier for the resource or role.
-
workspaceCode: string
The user-specified identifier of a workspace.
-
workspaceId: integer
(int64)
The unique identifier of a workspace.
400 Response
Invalid Input.