As per our requirement we have a salesforce column name ("account.ID") but while passing the column name in the edit schema of tSalesforceInput component its showing error as Talend is not accepting (".") in the column name ("account.ID"). This also creates a problem while adding the column dynamically. Please help me in this regards.
column name should not be account.id.
Field name - id
Table name - account
in Schema field name should be id not account.id. have a look in below screenshot.
Module is account
Schema(field names) is from repository account schema.
so salesforce run the query as module.fieldname and retrieve data for to Talend.
Talend Studio is a Java code generator, a Talend job will be translated to a Java Class, a column on the schema will be a variable in the class, a variable with comma or special character is not allowed in Java.
Thanks for the reply , but the problem i am facing is while dynamically allocation of columns in edit schema , if more than 200 columns are there i need to manually insert them as there is a dot special character in the query. Can you suggest a method to dynamically allocate column in tSalesforceinput component ?