I recently built a orchestration to go through our salesforce org and write to a salesforce object all of the object names and labels, field names and label, and field lengths and data types. The orchestration was pretty easy to build and has been incredibly useful to provide a data dictionary to our business partners. Its a different way to use castiron and something to consider if you need to do any data mapping or data migration activities.
Here's the recipe:
1 enterprise salesforce wsdl - this is your org's wsdl w/ all of its customizations
1 castiron dev studio
1 custom salesforce object to hold your object name, field names, length, data type, etc
Use the built in CastIron connector to salesforce to log in and use the session id in your subsequent webservice calls (where the enterprise wsdl was used to define the endpoint). Once you've logged in you should be able to describe all objects, iterate through each object, and grab the details you want. The last step is a the insert to your custom salesforce object where you map the object and its details.
No comments:
Post a Comment