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
Request Body - 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.
  • projectActualsId
  • projectActualsCode,projectId
  • projectActualsCode,projectCode,workspaceCode
Show Source
Nested Schema : configuredFields
Type: array
The list of configured fields for a project actuals.
Show Source
  • 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
An object containing cost fields in the form of key-value pairs.
Match All
Show Source
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.
  • projectActualsConfiguredFieldValueId
  • columnDefinitionId
  • columnName
  • columnLabel
Show Source
  • Allowed Values: [ "DELETE" ]
    Provide value for this field during object update to delete the assigned configured field value.
  • Unique identifier of the column. This value should not be provided in create operation request data, however, it is required for update requests.
  • Minimum Length: 1
    Maximum Length: 100
    The user-specified UDF column label.
  • Minimum Length: 1
    Maximum Length: 100
    The user-specified UDF column name.
  • Read Only: true
    Deprecated. As of 23.10.
    This holds values for Cost type configured fields in the base currency conversion. Input should be provided in numberValue field, in currency of record.
  • Deprecated. As of 23.11.
    This holds value of Cost type configured fields in the project level currency conversion. Input should be provided in numberValue field, in project actuals record level currency.
  • Read Only: true
    Deprecated. As of 23.10.
    This holds values for Cost type configured fields in the workspace1 currency conversion.
  • Read Only: true
    Deprecated. As of 23.10.
    This holds values for Cost type configured fields in the workspace2 currency conversion.
  • Read Only: true
    Deprecated. As of 23.10.
    This holds values for Cost type configured fields in the workspace3 currency conversion.
  • This holds values for Date type configured fields.
  • Read Only: true
    Maximum Length: 4000
    Deprecated. As of 23.10.
    Provides the error message for why the formula calculation resulted in an error.
  • Read Only: true
    Deprecated. As of 23.10.
    Determines if formula calculation hit an error calculating a value for this field.
  • 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.
  • The unique identifier for the Project Actuals Configured Field.
  • The system-generated identifier for an Actual.
  • Maximum Length: 4000
    This holds values for Boolean, List and Text type configured fields.
  • Read Only: true
    Deprecated. As of 23.10.
    Date when the record was last updated.
Nested Schema : ApiEntityProjectActualsCostInput
Type: object
Title: ApiEntityProjectActualsCostInput
Show Source
  • projectActuals
    The supporting details for the project actuals.
  • The unique identifier of project actual data.
  • Read Only: true
    Deprecated. As of 23.11.
    Total Amount is calculated as the sum of the Amount of each actual line item. The value can be positive or negative. This field is in base currency and is calculated from totalAmountProject field based on the specified exchange rate.
  • Read Only: true
    Deprecated. As of 23.11.
    The total amount value for a project. Calculated as the sum of the amount of each actual line item. This value is based on the project currency.
  • Read Only: true
    Deprecated. As of 23.11.
    The total amount value for a project. Calculated as the sum of the amount of each actual line item. This value is based on the record level currency.
  • Read Only: true
    Deprecated. As of 23.11.
    The total amount value for a workspace. Calculated as the sum of the amount of each actual line item. This value is based on the workspace1 currency.
  • Read Only: true
    Deprecated. As of 23.11.
    The total amount value for a workspace. Calculated as the sum of the amount of each actual line item. This value is based on the workspace2 currency.
  • Read Only: true
    Deprecated. As of 23.11.
    The total amount value for a workspace. Calculated as the sum of the amount of each actual line item. This value is based on the workspace3 currency.
  • Read Only: true
    Deprecated. As of 23.10.
    Date when the record was last updated.
Nested Schema : projectActuals
The supporting details for the project actuals.
Match All
Show Source
  • 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.
  • projectActualsId
  • projectActualsCode,projectId
  • projectActualsCode,projectCode,workspaceCode
Show Source
Nested Schema : configuredFields
Type: array
The list of configured fields for a project actuals.
Show Source
  • 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
An object containing cost fields in the form of key-value pairs.
Match All
Show Source
Back to Top

Response

Supported Media Types

200 Response

The object was successfully updated.
Body ()
Root Schema : ApiEntityERPSyncApiResponse
Type: object
Title: ApiEntityERPSyncApiResponse
Show Source
  • 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.
  • 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.
  • The primary key field name associated with the integrated object.
    The field is non-persistable and thus maximum length is not applicable.
  • The unique identifier for the integrated object.
  • Maximum Length: 255
    The unique identifier of the object in an external source.
  • The response code representing the state of the API operation.
  • 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.
Match One Schema
Show Source
Nested Schema : ProjectIdentifier
Type: object
Title: ProjectIdentifier
Show Source
Nested Schema : CBSSheetCodeIdentifier
Type: object
Title: CBSSheetCodeIdentifier
Show Source
Nested Schema : ResourceIdentifier
Type: object
Title: ResourceIdentifier
Show Source

201 Response

The object was successfully created.
Body ()
Root Schema : ApiEntityERPSyncApiResponse
Type: object
Title: ApiEntityERPSyncApiResponse
Show Source
  • 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.
  • 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.
  • The primary key field name associated with the integrated object.
    The field is non-persistable and thus maximum length is not applicable.
  • The unique identifier for the integrated object.
  • Maximum Length: 255
    The unique identifier of the object in an external source.
  • The response code representing the state of the API operation.
  • 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.
Match One Schema
Show Source
Nested Schema : ProjectIdentifier
Type: object
Title: ProjectIdentifier
Show Source
Nested Schema : CBSSheetCodeIdentifier
Type: object
Title: CBSSheetCodeIdentifier
Show Source
Nested Schema : ResourceIdentifier
Type: object
Title: ResourceIdentifier
Show Source

400 Response

Invalid Input.
Back to Top