Been working on Boomi platform for couple months now and here to share a quick tip that I learned earlier. Since Boomi now support Custom SOQL for an operation it however looses the XML profile when you import an object.
The profile can easily be fixed by doing the following.
- Add a Message shape and add your SOQL
- Add Salesforce Connector
- Add an Operation and click on Advanced link and choose Custom SOQL
- Save and run the process
- Inspect the logs and copy the xml and save it as a file
- Create a new mapping shape
- On the Left mapping click on Choose
- On Profile type select XML and choose Create New Profile
- Click on Import Profile
- Select your saved file and you are set.
Here is how my process looks like.
Give it a try!
It’s really helpful for me thanks
Hi Dinesh, thanks for this info. When I created the initial interface with Message and Get operation in Salesforce and provided SOQL. It does not give me the result in the log but it says completed successfully. So I am not able to get the XML data to create profile. What can be the reason?
Brilliant, took a while to find this page but it worked perfectly – cheers!