Mutations - Merge App

The Merge App mutation is used to create, update, and delete records for historical object types such as Bi-Temporal and Transactional Temporal objects.

To manage records for these object types, the system provides a GraphQL mutation API in the format merge_app_ + API name, where the API name is defined during object creation.

How to create records-

• Select the corresponding object API.

• Provide values for all required fields in the input.

• Execute the mutation to create a new record and the primary key is returned.

mutation MyMutation {
  merge_app_bitemporalobj(
    input: {p_age: 10, p_bitemporalobj_external_id: "ext_11", p_name: "tmpo_111", p_is_deleted: false}
  ) {
    clientMutationId
    bigInt
  }
}

How to update records-

• Select the object API.

• Enter the external ID to identify the record.

• Update the required fields with new values.

• On execution, the primary key will be returned.

• Ensure all other fields are also provided with their existing values; otherwise, those fields will be set to null.

mutation MyMutation {
  merge_app_bitemporalobj(
    input: {p_age: 12, p_bitemporalobj_external_id: "ext_11", p_is_deleted: false, p_name: "tmp_updated"}
  ) {
    clientMutationId
    bigInt
  }
}

How to delete records-

• To delete a record, provide the external ID of the record.

• Set the is_deleted flag to true.

• Execute the mutation to mark the record as deleted.

mutation MyMutation {
  merge_app_bitemporalobj(
    input: {p_age: 12, p_bitemporalobj_external_id: "ext_11", p_is_deleted: true, p_name: "tmp_updated"}
  ) {
    clientMutationId
    bigInt
  }
}