mthammareddy
Employee
Joined 7 years ago
User Profile
User Widgets
Contributions
Batch sync new leads from Marketo to Amazon Redshift
Created by @mthammareddy When there is a new lead activity batch in Marketo, synch the batch into Amazon Redshift. Configuration This pattern also requires the Get Marketo Access Token pattern. Sources: Marketo Targets: Redshift Snaps used: Pipeline Execute, REST Get, JSON Splitter, Mapper, Redshift - Insert Downloads MarketoBatchLeads_To_RedShift.slp (9.3 KB)2.1KViews0likes0CommentsSync 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)2.3KViews0likes0CommentsSync new/updated lead from Microsoft Dynamics CRM to Marketo
Created by @mthammareddy For a lead created or updated in Microsoft Dynamics CRM, SnapLogic searches for a matching lead in Marketo by email address. If no matching lead is found in Marketo, SnapLogic creates a new lead. If a matching lead is found in Marketo, SnapLogic updates that lead. Configuration You will need to define the following pipeline parameters: authorization, in the form of Bearer xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx:xx endpoint, in the form of https://xxx-xxx-xxx.mktorest.com Sources: Microsoft Dynamics CRM Lead Targets: Marketo Lead Snaps used: Dynamic CRM Read, Filter, Mapper, JSON Generator, REST Post Downloads Microsoft_CRM_Lead_Record_Marketo.slp (9.9 KB)1.9KViews0likes0CommentsAdd lead in Marketo and record in Dropbox
Created by @mthammareddy This pattern creates a lead in Marketo, then SnapLogic adds the lead into Dropbox as a new file. Configuration You will need to define the following pipeline parameters: authorization, in the form of Bearer xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx:xx endpoint, in the form of https://xxx-xxx-xxx.mktorest.com Then you need to pass the user details with the parameters first, last, email, title, company, and country. Sources: Mapper Targets: Marketo Lead, Dropbox Snaps used: REST Post, Mapper, Worksheet Writer, JSON Generator, Copy, JSON Splitter, Sequence, Join Downloads Marketo_Lead_Created_Record_Dropbox.slp (19.9 KB)1.9KViews0likes0CommentsLead added/updated in Marketo creates record in Google Sheets
Created by @mthammareddy This pattern creates a lead in Marketo, then SnapLogic adds the lead into Google Sheets as a new row. Configuration You will need to define the following pipeline parameters: authorization, in the form of Bearer xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx:xx endpoint, in the form of https://xxx-xxx-xxx.mktorest.com GoogleSheetsName, the name of the Google Sheet to write to sheetName, the name of the individual worksheet to write to within that Google Sheet Then you need to pass the user details with the parameters first, last, email, title, company, and country. The initial Mapper contains data to create a user. You can either replace these values every time or define pipeline parameters to pass the values in. Sources: Mapper Targets: Marketo Lead, Google Sheet Snaps used: REST Post, Mapper, Worksheet Writer, JSON Generator, Copy, JSON Splitter, Sequence, Join Downloads Marketo_Lead_Created_Updated_GoogleSheets.slp (19.7 KB)2.7KViews0likes0CommentsSync leads from Salesforce to Marketo
Created by @mthammareddy For a new lead created in Salesforce, SnapLogic searches for a matching lead in Marketo by email address. If a matching lead is not found in Marketo, SnapLogic creates a new lead. Configuration Specify your access token and endpoint URL in the Pipeline Parameters. The initial Mapper contains and expression to lookup a particular user. You can either replace the ID value every time or define pipeline parameters to pass the value in and change the expression to: "Id='" +_SFDC_ID + "'" where SFDC_ID is the name of the pipeline parameter. Sources: Salesforce Lead Targets: Marketo Lead Snaps used: REST Post, Mapper, Salesforce Read, JSON Generator, Join, Pipeline Execute Downloads Sync_Leads_from_Salesforce_to_Marketo.slp (11.5 KB) Note: This pattern also uses the pattern to get the Marketo access token found here: Get Marketo Access Token2.7KViews1like0Comments