Query BCS
Enterprise Edition for Nintex Workflow 2016 is required for this feature.
Microsoft SharePoint Server is required for this feature.
Retrieves data from the Business Connectivity Service (BCS).
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.