Sync new customer from NetSuite to Marketo
Created by @mthammareddy For a new customer created in NetSuite, SnapLogic searches for a matching lead in Marketo by email address. If no matching lead is found in Marketo, SnapLogic creates a new lead in Marketo. Configuration Update the following pipeline parameters to match your Marketo environment: authorization: the token in the form of “Bearer XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX:XX” endpoint: your Marketo URL in the form of “https://XXX-XXX-XXX.mktorest.com” Sources: NetSuite customer Targets: Marketo lead Snaps used: REST Post, NetSuite Get, Mapper, JSON Generator Downloads NetSuite_Customer_Created_Record_Marketo.slp (11.7 KB)
NetSuite Contact to ServiceNow User
Created by @tlui This pipeline looks for NetSuite Contacts that were created the day before and creates ServiceNow Users (email is the key) if they are not already in ServiceNow. Configuration This pattern was created using NetSuite WSDL: 2018, Release 1 and ServiceNow London Version. The NetSuite query range may be configured. The head within the pipeline may be configured or removed to allow a larger # of records through once the pattern is fully tested. Sources: NetSuite Contact Targets: ServiceNow User Snaps used: NetSuite Search, Mapper, JSON Generator, JSON Splitter, Head, ServiceNow Query, ServiceNow Insert Downloads NetSuite Contact to ServiceNow User.slp (12.8 KB)NetSuite Case to ServiceNow Incident
Created by @tlui This pipeline looks for NetSuite Cases in past 24 hours and brings them to ServiceNow. The pipeline attempts to bring the email of the NetSuite user but if none is found, it is defaulted for ServiceNow. Customers may want to use the NetSuite Contact to ServiceNow User pattern in conjunction with this to ensure ServiceNow Users exist for a corresponding NetSuite Contact. Configuration This pattern was created using NetSuite WSDL: 2018, Release 1 and ServiceNow London Version. The NetSuite query range may be configured. The head within the pipeline may be configured or removed to allow for a larger number of records through once the pattern is fully tested. Sources: NetSuite Issue Targets: ServiceNow Incident Snaps used: NetSuite Search, Mapper, JSON Splitter, Head, Copy, NetSuite Get, Join, ServiceNow Insert Downloads NetSuite Case to ServiceNow Incident.slp (19.1 KB)
Move Salesforce Opportunity to NetSuite Sales Order
Created by @dshen This pipeline pattern will take a closed Salesforce opportunity and create a Sales Order in NetSuite, and then update Salesforce with the NetSuite ID. Configuration The pipeline will take a closed Salesforce opportunity ID as the pipeline parameter. The pipeline will assume the Salesforce product and NetSuite item has been synchronized, and the NetSuite item internal ID is stored in each Salesforce product. The pipeline will create a new NetSuite customer if the Salesforce Opportunity Account is not already created. The pipeline will create the NetSuite Sales Order based on the approved Opportunity Quote. Each Salesforce Quote Line Item will create a NetSuite SalesOrder Line Item. Sources: Salesforce Opportunity, Account, Quote, Quote Line Items Targets: NetSuite Customer, Sales Order Snaps used: Salesforce SOQL, NetSuite Create, Salesforce Update, Mapper, Router, Join, Group By Fields, JSON Splitter Downloads SFDC Opportunity to NS SalesOrder.slp (36.8 KB)Read data from Salesforce, transform the data, then load it into NetSuite and Reltio
Created by @sreddi This pipeline pattern reads data from Salesforce, transforms the data, and loads data into multiple targets like NetSuite and Reltio. Configuration Users can adjust which endpoints to upload the data into by replacing the NetSuite and Reltio Snaps with the preferred application. Salesforce Read Mapper Snap NetSuite Create Reltio Create Sources: Salesforce Opportunity Targets: NetSuite - Salesorder, Reltio - entities Snaps used: Salesforce Read, Mapper, NetSuite Create, Copy, JSON Formatter, File Writer, Reltio Create Downloads Reading Data from Salesforce and write into NetSuite and Reltio Snaps.slp (12.5 KB)Get check object data from NetSuite and move data into Redshift
Created by @pkoppishetty This pipeline pattern is designed to get the check object data from NetSuite and move the data into Redshift data warehouse. Configuration Sources: NetSuite check Targets: Redshift table Snaps used: Mapper, NetSuite Search, JSON Splitter, Redshift Bulk Load Downloads Integration Pattern from NetSuite to Redshift.slp (8.8 KB)