About Ben_Neal

Ben_Neal · ‎07-17-2020

Your request is fairly basic functionality in Salesforce. In fact, depending on your level of Salesforce permissions you might be able to create a Report yourself using the standard Report Type "Campaigns with Campaign Members"

Ben_Neal · ‎05-14-2019

I am attempting to sync our Salesforce Cases to Marketo using Custom Objects, however when I attempt to create the Custom Object with name "Case" I get an error message about this being a reserved word. " Display name uses a reserved word. Please choose another name." This leads me to wonder if there are other reserved words that Marketo reserves. I can't find anything in the product documentation about this so thought I'd ask the community.

Ben_Neal · ‎06-26-2018

I'm attempting to copy/replicate Lead and Contact data from Marketo to a MySQL Database via API. I'm able to to successfully retrieve the data using the Bulk Lead Extract API (http://developers.marketo.com/rest-api/bulk-extract/bulk-lead-extract/#filters) with the exception of when I retrieve the Salesforce record Id field (sfdcId) from the API the values that get returned are "null" despite the value existing in Marketo. Am I doing something wrong here or is the Marketo API limited in this regard? If this is a limitation in Marketo, isn't this a huge limitation? SFDC Id is the primary key for the authoritative source for Lead records and I'm unable to retrieve these values via API? Thanks, Ben Neal

Ben_Neal · ‎06-19-2018

Sanford Whiteman Thanks for the additional details, Sanford. It looks like the describe endpoint actually gives you the field length (50, 255, or 2000) so I can match my SQL fields for those different field lengths. Additionally, several of the data types could all be captured by using a NVARCHAR data type (email, string, url, phone) seeing as they're just non date or numeric fields. I'm actually using MySQL as the destination DB platform so I don't have the option of using sparse. I'm not as familiar with MySQL as with SQL so I'll have to research to see if MySQL has an alternative (know of one yourself?). I'm also researching character sets and going down a rabbit hole there, so I'd appreciate any other suggestion you have (seeing as your title is integration architect). Thanks again!

Ben_Neal · ‎06-19-2018

Sanford Whiteman Thanks for the API endpoint, I can the data types from there. I actually am exactly doing that, building a replicated SQL DB holding Lead and Activity data. Can you say more about issues that would arise with data types between Marketo and the SQL structure?

Ben_Neal · ‎06-18-2018

I know you can export all fields and their api names and display names, but is there a way to get the data types of the fields in bulk (i.e. in a list)?

Ben_Neal · ‎05-11-2018

I'm setting up the Salesforce sync for the first time and the default mappings for the "Acquisition Program" and "Acquisition Date" to the corresponding fields in Salesforce on the Contact and Lead are incorrect and I can't change them. Following the Marketo setup instructions, I've created two Salesforce fields ( mkto_Acquisition_Program__c, mkto_Acquisition_Date__c) on the Contact and the Lead but the field mappings aren't correct in the field mappings section in the initial sync. Ideally, the 2 Marketo standard fields would map to the corresponding Contact and Lead fields in Salesforce as what one would expect but instead their getting mapped to fields that don't exist (mkto2_.....).

Online Status	Offline
Date Last Visited	‎09-14-2020 02:38 PM

Date Registered	‎05-11-2018 01:10 PM
Date Last Visited	‎09-14-2020 02:38 PM
Total Messages Posted	7
Likes Received	1

Re: Salesforce Integration: Campaign member list v...

Reserved Words in Marketo?

Can't Retrieve SFDC ID with Bulk Lead Extract

Re: Get Marketo Field Data Types

Re: Get Marketo Field Data Types

Get Marketo Field Data Types

Initial Salesforce Sync - Incorrect Default Field ...