Integrate Project Actuals Data with an External Data Source
post
/api/restapi/projectActuals/sync
Send a request to this endpoint to create or update an integrated project actuals data. 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 : ApiEntityExternallySourcedProjectActualsInput
Type:
object
Title:
ApiEntityExternallySourcedProjectActualsInput
This entity represents a ExternallySourcedProjectActuals object, a unique ExternallySourcedProjectActuals object can be identified by the following combinations of the fields.
Show Source
- projectActualsId
- projectActualsCode,projectId
- projectActualsCode,projectCode,workspaceCode
-
companyName: string
Minimum Length:
1
Maximum Length:255
The name of a company. -
companySourceId: string
Maximum Length:
255
The unique identifier of company data in an external source. -
configuredFields: array
configuredFields
The list of configured fields for a project actuals.
-
currencyCode: string
Minimum Length:
1
Maximum Length:3
The user-specified identifier of a currency. -
currencyId: integer
(int64)
The system-generated identifier of the currency associated with the project actual.
-
description: string
Minimum Length:
0
Maximum Length:4000
Details about the project actual. -
effectiveDate: string
(date-time)
The date the actual is effective.
-
fixedExchangeRate: number
The exchange rate used to convert the Total Amount value from the record currency to the base currency.
-
projectActualName(required): string
Minimum Length:
1
Maximum Length:255
The name of the actual. -
projectActualsCode: string
Minimum Length:
1
Maximum Length:60
The unique identifier for an actual. -
projectActualsCost:projectActualsCostDeprecated. As of 25.8.
An object containing cost fields in the form of key-value pairs. -
projectActualsId: integer
(int64)
The unique identifier of project actual data. This value should not be provided in create operation request data, however, it is required for update requests.
-
projectCode: string
Minimum Length:
1
Maximum Length:60
The user-specified identifier of a project. -
projectCompanyId: integer
(int64)
The name of the company associated with the actual.
-
projectId(required): integer
(int64)
The unique identifier for the project.The project object can also be identified by its unique criteria.
-
projectSourceId: string
Maximum Length:
255
The unique identifier of project data in an external source. -
sourceId: string
Maximum Length:
255
The unique identifier of project actual data in an external source.Example:coarse
-
status: string
Allowed Values:
[ "PENDING", "CONFIRMED" ]
That status of the actual. Valid values are Pending and Confirmed. -
workspaceCode: string
Minimum Length:
0
Maximum Length:60
The user-specified identifier of a workspace.
Nested Schema : configuredFields
Type:
array
The list of configured fields for a project actuals.
Show Source
-
Array of:
object ApiEntityProjectActualsConfiguredFieldValueInput
Title:
ApiEntityProjectActualsConfiguredFieldValueInput
This entity represents a ProjectActualsConfiguredFieldValue object, a unique ProjectActualsConfiguredFieldValue object can be identified by the following combinations of the fields.- projectActualsConfiguredFieldValueId
- columnDefinitionId
- columnName
- columnLabel
Nested Schema : projectActualsCost
Deprecated. As of 25.8.
An object containing cost fields in the form of key-value pairs.
An object containing cost fields in the form of key-value pairs.
Match All
Deprecated. As of 25.8.
An object containing cost fields in the form of key-value pairs.
Show Source
An object containing cost fields in the form of key-value pairs.
-
object
ApiEntityProjectActualsCostInput
Title:
ApiEntityProjectActualsCostInput
Nested Schema : ApiEntityProjectActualsConfiguredFieldValueInput
Type:
object
Title:
ApiEntityProjectActualsConfiguredFieldValueInput
This entity represents a ProjectActualsConfiguredFieldValue object, a unique ProjectActualsConfiguredFieldValue object can be identified by the following combinations of the fields.
Show Source
- projectActualsConfiguredFieldValueId
- 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. -
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.
-
projectActualsConfiguredFieldValueId: integer
(int64)
The unique identifier for the Project Actuals Configured Field.
-
projectActualsId: integer
(int64)
The system-generated identifier for an Actual.
-
textValue: string
Maximum Length:
4000
This holds values for Boolean, List and Text type configured fields.
Nested Schema : ApiEntityProjectActualsCostInput
Type:
object
Title:
Show Source
ApiEntityProjectActualsCostInput
-
projectActuals:
projectActuals
The supporting details for the project actuals.
-
projectActualsId: integer
(int64)
The unique identifier of project actual data.
Nested Schema : projectActuals
The supporting details for the project actuals.
Match All
The supporting details for the project actuals.
Show Source
-
object
ApiEntityProjectActualsInput
Title:
ApiEntityProjectActualsInput
This entity represents a ProjectActuals object, a unique ProjectActuals object can be identified by the following combinations of the fields.- projectActualsId
- projectActualsCode,projectId
- projectActualsCode,projectCode,workspaceCode
Nested Schema : ApiEntityProjectActualsInput
Type:
object
Title:
ApiEntityProjectActualsInput
This entity represents a ProjectActuals object, a unique ProjectActuals object can be identified by the following combinations of the fields.
Show Source
- projectActualsId
- projectActualsCode,projectId
- projectActualsCode,projectCode,workspaceCode
-
companyName: string
Minimum Length:
1
Maximum Length:255
The name of a company. -
companySourceId: string
Maximum Length:
255
The unique identifier of company data in an external source. -
configuredFields: array
configuredFields
The list of configured fields for a project actuals.
-
currencyCode: string
Minimum Length:
1
Maximum Length:3
The user-specified identifier of a currency. -
currencyId: integer
(int64)
The system-generated identifier of the currency associated with the project actual.
-
description: string
Minimum Length:
0
Maximum Length:4000
Details about the project actual. -
effectiveDate: string
(date-time)
The date the actual is effective.
-
fixedExchangeRate: number
The exchange rate used to convert the Total Amount value from the record currency to the base currency.
-
projectActualName(required): string
Minimum Length:
1
Maximum Length:255
The name of the actual. -
projectActualsCode: string
Minimum Length:
1
Maximum Length:60
The unique identifier for an actual. -
projectActualsCost:projectActualsCostDeprecated. As of 25.8.
An object containing cost fields in the form of key-value pairs. -
projectActualsId: integer
(int64)
The unique identifier of project actual data. This value should not be provided in create operation request data, however, it is required for update requests.
-
projectCode: string
Minimum Length:
1
Maximum Length:60
The user-specified identifier of a project. -
projectCompanyId: integer
(int64)
The name of the company associated with the actual.
-
projectId(required): integer
(int64)
The unique identifier for the project.The project object can also be identified by its unique criteria.
-
projectSourceId: string
Maximum Length:
255
The unique identifier of project data in an external source. -
sourceId: string
Maximum Length:
255
The unique identifier of project actual data in an external source.Example:coarse
-
status: string
Allowed Values:
[ "PENDING", "CONFIRMED" ]
That status of the actual. Valid values are Pending and Confirmed. -
workspaceCode: string
Minimum Length:
0
Maximum Length:60
The user-specified identifier of a workspace.
Nested Schema : configuredFields
Type:
array
The list of configured fields for a project actuals.
Show Source
-
Array of:
object ApiEntityProjectActualsConfiguredFieldValueInput
Title:
ApiEntityProjectActualsConfiguredFieldValueInput
This entity represents a ProjectActualsConfiguredFieldValue object, a unique ProjectActualsConfiguredFieldValue object can be identified by the following combinations of the fields.- projectActualsConfiguredFieldValueId
- columnDefinitionId
- columnName
- columnLabel
Nested Schema : projectActualsCost
Deprecated. As of 25.8.
An object containing cost fields in the form of key-value pairs.
An object containing cost fields in the form of key-value pairs.
Match All
Deprecated. As of 25.8.
An object containing cost fields in the form of key-value pairs.
Show Source
An object containing cost fields in the form of key-value pairs.
-
object
ApiEntityProjectActualsCostInput
Title:
ApiEntityProjectActualsCostInput
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.