Upsert Multiple Records activity

An activity that creates or changes one or more records, if they exist, in an AgilePoint NX entity. AgilePoint NX recommends to use Upsert Multiple Records as an alternative to Create Record so you do not create duplicate records.


Upsert Multiple Records activity

Configure the Upsert Multiple Records activity

To configure the Upsert Multiple Records activity, do the procedure in this topic.

Prerequisites

Good to Know

How to Start

  1. On the Application Explorer screen, do one of these:
  2. Do one of these:
    • Add an activity:
      1. In the Process Builder, in the Activity Library, open the AgilePoint Data Entities AgilePoint Data Entity icon tab.
      2. On the AgilePoint Data Entities AgilePoint Data Entity icon tab, drag the Upsert Multiple Records Upsert Record icon activity onto your process.
    • Change an activity:
      1. In your process, double-click your activity.

General Configuration

Specifies the basic settings for the Upsert Multiple Records activity.

Figure: General Configuration screen

General Configuration screen

Fields

Field Name Definition

Display Name

Function:
Specifies the activity name that shows in your process.
Accepted Values:
One line of text that can have spaces.
Default Value:
None
Accepts Process Data Variables:
No
Example:
This is a common configuration field that is used in many examples. Refer to:
  • Examples - Step-by-step use case examples, information about what types of examples are provided in the AgilePoint NX Product Documentation, and other resources where you can find more examples.

Description

Function:
Specifies an optional text description for your activity.
Accepted Values:
More than one line of text.
Default Value:
None
Accepts Process Data Variables:
No

Upsert Multiple Records Configuration

Specifies the information to create or change one or more records, if it exists, in AgilePoint NX.

Figure: Upsert Multiple Records Configuration screen

Upsert Multiple Records Configuration screen

Fields

Field Name Definition

Standard Entities / Custom Entities

Function:
Specifies whether to show standard entities or custom entities in the Entity Name list.
Accepted Values:
  • Standard Entities - Shows standard entities in the Entity Name list.
  • Custom Entities - Shows custom entities in the Entity Name list.
Default Value:
Standard Entities
Accepts Process Data Variables:
No

Entity Name

Function:
Specifies the name for your entity from the list.
Accepted Values:
An entity name from the list.
Default Value:
None
Example:
Refer to:

Request Mapping

Function:
Connects your schema to the entity fields.
Accepted Values:
Click the Schema Mapping Schema Mapping icon button to open the Schema Mapper.

Use this screen to connect the request to the data model for your process.

Default Value:
None

Response Mapping

Function:
Maps AgilePoint NX entity fields to your schema.
Accepted Values:
Click the Schema Mapping Schema Mapping icon button to open the Schema Mapper.

Use this screen to connect the response to the data model for your process.

Default Value:
None