Data filters help you to fetch specific data in web services connector. The synchronization task processes the data based on the filter field assigned.
Note: Advanced data filters are not supported by Web Services Connector.
Perform the following steps to use data filters:
1In the synchronization task, select Data Filters tab.
The Data Filters tab appears.
2Click New.
The Data Filter dialog box appears.
3Specify the following details.
Field Type
Description
Object
Select Object for which you want to assign filter fields.
Filter By
Select the Filter Field.
Operator
Select the corresponding operator.
Filter Value
Enter the Filter value.
4Click OK.
Note: When web service is the source, you can pass parameters to the web service through the data filters.
Data Filters Tips
There are two ways to pass the data using filter fields.
•You can directly hard-code the values in the data filter and pass them into fields. For example, Address_***_IN parameters.
•You can also filter by Body_CSV_Path_IN and Header_CSV_Path_IN, providing the filter value as directory path along with file name. The file provided in the filter value must consist of the data set to send information to the web service.
There are also two custom fields to support file attachments.
•AttachmentDownloadFolder_IN: This field contains name of the folder in which the downloaded file will be saved. The relative path will be formed with combination with the download Path given in connection.
•AttachmentFileName_IN: This field contains the name of the file which has to be uploaded to the end point. The relative path will be formed with combination with the upload path given in connection
There are two output custom fields generated irrespective of the WSDL related to the attachment support.
•AttachmentDownloadDataInBytes_OUT: This field contains the data of the attachment in the Base64 encoded in a string format.
•AttachmentDownloadFileName_OUT: This field contains the name of the file of attachment data that is stored in the field AttachmentDownloadDataInBytes_OUT.
Note: when you upload a file, all the necessary information must be according to WSDL design. The field must contain the attachment data in bytes of Base64 and the value should be entered as “BYTES"