Batch Integrate CBSs with an External Data Source
post
/api/restapi/cbs/project/syncBatch
Send a request to this endpoint to create or update one or more integrated CBSs. 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
Header Parameters
-
singleTransaction: boolean
Enabling this boolean flag will fail the request if an error occurs while processing any CBS sheet codes sent as part of the request.
Allowed Values: [ "true", "false" ]Default Value:false
Supported Media Types
- application/json
Root Schema : List<ApiEntityExternallySourcedCBSSheetCodeInput>
Type:
arrayTitle:
Show Source
List<ApiEntityExternallySourcedCBSSheetCodeInput>-
Array of:
object ApiEntityExternallySourcedCBSSheetCodeInput
Title:
ApiEntityExternallySourcedCBSSheetCodeInputThis entity represents a ExternallySourcedCBSSheetCode object, a unique ExternallySourcedCBSSheetCode object can be identified by the following combinations of the fields.- cbsSheetCodeId
- cbsCode,projectId
- cbsCode,projectCode,workspaceCode
Nested Schema : ApiEntityExternallySourcedCBSSheetCodeInput
Type:
objectTitle:
ApiEntityExternallySourcedCBSSheetCodeInputThis 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:
1Maximum Length:60The 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:
0Maximum Length:255The 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:
1Maximum Length:60The user-specified identifier of a project. -
projectId(required): integer
(int64)
The unique identifier for the project.
-
sourceId: string
Maximum Length:
255The unique identifier of cost sheet item data in an external source. -
workspaceCode: string
Minimum Length:
0Maximum Length:60The 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:
arrayList 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:
objectTitle:
Show Source
ApiEntityCBSSheetRowInput-
configuredFields: array
configuredFields
An object containing configured fields in the form of key-value pairs.
Nested Schema : configuredFields
Type:
arrayAn object containing configured fields in the form of key-value pairs.
Show Source
-
Array of:
object ApiEntityCBSSheetRowConfiguredFieldValueInput
Title:
ApiEntityCBSSheetRowConfiguredFieldValueInputThis 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:
objectTitle:
ApiEntityCBSSheetRowConfiguredFieldValueInputThis 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:
1Maximum Length:100The user-specified UDF column label. -
columnName: string
Minimum Length:
1Maximum Length:100The 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:
4000This holds values for Boolean, List and Text type configured fields.
Examples
Back to Top
Response
Supported Media Types
- application/json
207 Response
The object was successfully integrated.
Root Schema : List<ApiEntityERPSyncApiResponse>
Type:
arrayTitle:
Show Source
List<ApiEntityERPSyncApiResponse>-
Array of:
object ApiEntityERPSyncApiResponse
Title:
ApiEntityERPSyncApiResponse
Nested Schema : ApiEntityERPSyncApiResponse
Type:
objectTitle:
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:
trueThe 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:
255The 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:
trueDate when the record was last updated.
Nested Schema : identifier
Type:
objectThe 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:
objectTitle:
Show Source
ProjectIdentifier-
projectCode: string
Maximum Length:
60The 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:
objectTitle:
Show Source
CBSSheetCodeIdentifier-
cbsCode: string
Maximum Length:
60The 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:
60The 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:
objectTitle:
Show Source
ResourceIdentifier-
projectCode: string
Maximum Length:
60The 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:
60The 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.