Dynamically Mapping Fields from Salesforce Query Activity Output
While I was working on Salesforce.com integration, the TIBCO BusinessWorks plug-in provides a "Query All" and "Retrieve All" activities to query Salesforce objects. The "Query All" lets you use a SOQL statement freely, while "Retrieve All" only allows you to specify the list of fields and optionally the object IDs. The only filter you can use for the latter are the object IDs, which doesn't seem to be the case most of the time. Both activities have a generic output and are not specific to a particular Salesforce object. It has an "any element" field which you can coerce based on a specified schema and you would need a WSDL file generated from Salesforce to do this. However, the problem starts when Salesforce keeps on updating the WSDL at the same time, so you will need to map the newly added field all the time! The solution I have come up with for this dilemma was not actually quite that simple but it offers more flexibility in th