Workflow action: LDAP query

Modified on Tue, 18 Jul, 2023 at 9:19 AM

Actions of type LDAP query allows to execute an LDAP query against an LDAP server in order to retrieve data from that server. For this purpose, an LDAP connection must have been previously configured in the system. Furthermore, it is possible to filter the return values so that only the required attributes are returned.

CONTENTS

Parameters
- LDAP query details
Action variables
- Standard action variables
- Action specific action variables

Configuration interface of the action LDAP query

Parameters

LDAP query details

Use configured LDAP query?: If this option is selected, a LDAP query preconfigured in the backend can be selected. Additionally, details about the query are displayed.
Use client LDAP connection?: If the option is selected, then the settings under Client which already defined for LDAP will be used . This means that no separate LDAP connection needs to be set up.
LDAP connection: LDAP connection, which was preconfigured in the administration.
Base DN: Specification of the root directory of the Active Directory defined for the search.
LDAP query: Text field for the LDAP query.
Filter for return values: Attributes can be added via the plus icon, which are to be delivered with the LDAP query.

Action variables

Actions of type LDAP query provide Action variables which can be used in subsequent actions.

Standard action variables

[%$<action name>.SUCCESS%]: Return whether action was successfully executed. Returns Boolean (true/false).
[%$<action name>.RESULT%]: Return all results provided by the action in structured form.

[%$<action name>.ERROR_CODE%]: The error code thrown in case of an error in the action. Empty if no error occurred.
[%$<action name>.ERROR_MESSAGE%]: The thrown error message in the action's error case. Empty if no error occurred.

Action specific action variables

[%$<actionname>.RESULT.rows[i]%]: Contains the results obtained by the query in the form of a JSON array, which may contain JSON objects. The properties / attributes of a JSON object, is determined by the returned properties of the LDAP object determined in each case.; The parameter i specifies the index of the line, starting with 0 for the first row. The other attributes can be accessed using dot notation.; Example RESULT:

{"rows":[{"mail":"[email protected]","name":"Beispiel"}],"rowsCount":1}

Access to mail attribute via placeholder: [%$<Aktionsname>.RESULT.rows[0].mail%]

[%$<action name>.RESULT.rowsCount%]: Number of rows returned by the query execution. Has the value 0 if the query returned no results or an error occurred.