This help site is based on the available in-product assistance as of December 2016. Please note that this site is provided as a convenience and it does not go through rigorous layout testing.


Back Forward Home Print
Nintex Workflow 2010 > Workflow Actions
Query BCS

* This topic applies to Nintex Workflow Enterprise Edition only

* This action requires Microsoft SharePoint Server

The Query BCS action will retrieve data from the Business Connectivity Service (BCS).

To use the workflow action:

  • Locate the action in Workflow Actions Toolbox (located on the left hand-side);
    • Click on the Category listings to reveal the actions; OR
    • Search for the action using a keyword.
  • Select the action, drag it onto the design canvas and drop it onto a design pearl.

Alternatively

  • Left-clicking the pearl, mouse-over Insert Action and then the Categories to reveal the actions, click the required action from the list.

To change the settings used by the action:

  • On the action’s title click the down arrow to activate a drop-down
  • Select Configure; OR
  • Double-click the action's icon.

For more information on the other options in the drop-down, please refer to the Getting started with the Nintex Workflow designer.

 Action Settings

Credentials

A valid username and password are required to access the BCS. This identity must have access to the external content type. If the external content type is configured to pass through credentials, the identity must also have access to the underlying data source.

Application name

The BCS application to query.

Instance name

The instance of the application to query.

Entity name

The name of the external content type to query.

Filters

the filter used to determine which instances of the selected entity to retrieve data from. Multiple filters can be added by clicking the Add filter link. Only entities matching all of the filters will be retrieved.

  • Filter name: The property of the entity to filter on.
  • Filter value: The value that the filter property must match for the entity to be retrieved.

Entity property to retreive

The property of the entity to query. More than one entity property may be retrieved.

To specify entity property:

  1. Enter desired property in the Entity property to retrieve box.
  2. Click the Add button and the entity peroperty will appear below the Entity property to retrieve box.
  3. Specify a workflow variable to store the values of the entity property to be retrieved.

Note: If a variable that is not a collection is selected, only the first result will be stored.