Query Attribute

Some drivers require special formats for the Query attribute of the Import element.

When the Import element is connecting to a database, the Query attribute must contain a valid SQL statement for the target database.

For other values of the import Type, the drivers may require a specific syntax. These special cases are shown in the table below.

ADSI

ADSI queries follow the LDAP syntax for a search filter:

• The string must be enclosed in parenthesis
• Expressions can use the relation operators <, <=, =, >=, > and the compound operators & and |.

For example, to return all objects of category ‘user’, and class ‘person’, with a non-blank email address:

(&(objectCategory=user)(objectClass=person)(mail=*))

CSV (text file)

The syntax is:

select * from FileName

Example:

select * from Asset.csv

Do not include the path to the file in the query (the path is specified in the connection string for this Type of import).

Excel

The default query (case insensitive) is:

select * from NameOfWorksheet

Example:

Select * from [Sheet1$]

In addition, Excel supports field enumeration and functions such MID or ABS.

WebService

The query may be either:

• The name of the method to be called
• The full SOAP request to the web service.

XML

No queries are supported.