Contributed by @asharifian, SnapLogic
This pattern provides an integration between John Galt Atlas and Salesforce. Atlas is a supply chain demand planning application. This integration will insert and update annual forecast data from Atlas to Salesforce.
- The retrieval of data from Atlas uses the export custom view in JSON API.
- Once the forecast data is pulled from Atlas, the integration will do the following in Salesforce: upsert to Opportunities, create opportunity line items (if they don’t already exist in Salesforce), and insert/update the data to opportunity line item schedules. In general, the opportunity object must first be creted, then the opportunity line item, then the opportunity line item schedule.
- This integration will generally be run sparingly, maybe once a month to ensure the fiscal year’s forecast data is up to date.
A view from John Galt Atlas would need to be created beforehand. The view would contain the data points that you would like to retrieve from Atlas. From there, the “export custom view in JSON” API can be called to get the data from Atlas. The opportunity line item schedule (OLIS) object cannot be upserted in Salesforce, as that is a limitation on the Salesforce side. That is why you see separate Salesforce Create and Salesforce Update snaps for the OLIS object.
Source: John Galt Atlas Forecast Opportunity
Target: Salesforce Opportunity, Opportunity Line Item, Opportunity Line Item Schedule
Snaps used: REST Post, Mapper, CSV Parser, Filter, Salesforce SOQL, Pipeline Execute, Router, Salesforce Update, Salesforce Create, Union, Tail, Salesforce Upsert