Field | Description/Action |
Salesforce SOQL Query | An SOQL statement. If you need more space to type your statement, use the launch icon to the right to open a text editor window. You can type the statement directly in this field, for example: SELECT Id, Name FROM Account WHERE Name = ‘Sandy’. For variable names, use the ? variable placeholder for each variable. For example: SELECT Id, Name FROM Account WHERE Name = ? Note: If you use the ? placeholder variable in your SOQL statement, make sure that you enter the corresponding Input Field and Input Field Type information in the same order as they appear in your SOQL statement. In the example given earlier, Name corresponds to the first entry in the Input Field. Note: Do not end your SOQL statement with a semi-colon (;) or an exception will be generated. Note: You can paste text into this field from the system clipboard. However, you must not cut or copy text from this field to the clipboard for pasting into another application. |
Input Field | The name of the input field. |
Input Field Type | java.lang.String |
Output Field | Output parameters are optional. You configure an output parameter only when you want to overwrite the default field name in the output result. Note: While mapping the output fields, ensure that the data entered in the output field matches the field name provided in the SOQL statement. |
Native Field Type | The native field type of the selected field. Salesforce supports various types of native fields: string, picklist, multipicklist, reference, base64, textarea, phone, id, url, email, encryptedstring, combobox, anyType, time, boolean, int, double, currency, percent, date, datetime. You need to select the appropriate field type. |
Output Field Type | The Java data type for the selected native field type. The java field type is automatically selected, after you select the native field type. |