Automatically Upload Custom Object data from SFDC to Marketo Custom Object

Automatically Upload Custom Object data from SFDC to Marketo Custom Object

Business Case: Find a solution to automatically upload custom object data from salesforce to Marketo Custom object.

Solution: As we know that to upload the custom object data in Marketo we would need to upload it manually or via the custom object bulk APIs if the object is not associated with a lead, contact, or account Object in Salesforce.

To make it cost-effective, secure and without relying on 3rd party tools, I used apex to run the code in the backend and upload the data in the Marketo custom object.

image.png

I created a custom object in salesforce (Lead Tracking), the purpose of the object is the track whenever we have an interesting moment or change in stage (MQL), and we send the data via Lead tracking webhook from Marketo to salesforce.

image.png

In Salesforce, it appears like below and creates an open task as well.

image.png

At the end of the day, SFDC runs the scheduled job which basically extracts new records which are being created on a given day and uploads them in the Marketo custom object and sends an email once done.

image.png