* 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);
Select the action, drag it onto the design canvas and drop it onto a design pearl.
Alternatively
To change the settings used by the action:
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 retrieve
The property of the entity to query. More than one entity property may be retrieved.
To specify entity property:
- Enter desired property in the Entity property to retrieve box.
- Click the Add button and the entity property will appear below the Entity property to retrieve box.
- 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.