Query Advanced Entity activity

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

Description

Function:

Specifies an optional description for your activity.

Accepted Values:

More than one line of text.

Default Value:

None

Accepts Process Data Variables:

No

Connection Timeout (Seconds)

Function:

Specifies the number of seconds permitted to complete an action before the connection stops.

Accepted Values:

An integer that represents a number of seconds.

Default Value:

600

Accepts Process Data Variables:

No

Salesforce

Function:

Specifies the access token that connects to your Salesforce application.

Accepted Values:

A list of access tokens configured for your environment.

Default Value:

None

Accepts Process Data Variables:

No

Add Token

Opens this Screen:

New Salesforce Access Token

Function of this Screen:

Configures a new access token for Salesforce.

Query

Function:

Specifies the select statement that defines the SQL query the activity does to get records from Salesforce.

Accepted Values:

A valid SQL select query.

Default Value:

None

Accepts Process Data Variables:

Yes

Example:

SELECT Id, Name FROM Account 
  WHERE Id IN ( SELECT AccountId FROM Contact WHERE LastName LIKE 'apple%' )
  AND Id IN ( SELECT AccountId FROM Opportunity WHERE isClosed=false)

Execute Query

Function:

Makes sure the query is correct, and shows the necessary error message if an error occurs.

If the query completes, the result shows in the Result Query box.

Query Result

Function:

When you click Execute Query, this field shows the response from your query in XML format.

You can change the XML to customize your response.

Accepted Values:

A valid XML query response.

Default Value:

None.

When you click Execute Query, a default query response shows.

Accepts Process Data Variables:

Yes

Schema Mapper

Function:

Connects the query to your process schema.

Accepted Values:

Click the Ellipses button to open the Schema Mapper screen.

Use this screen to connect the query to your process schema.

Default Value:

None