Re: Sending web activity to ms sql database

Anonymous
Not applicable

Sending web activity to ms sql database

Is there a way to pull all web traffic activity and send the information to a MS SQL database? Can this be done using the SOAP API?
Tags (1)
5 REPLIES 5
SanfordWhiteman
Level 10 - Community Moderator

Re: Sending web activity to ms sql database

Certainly it can be done.  Note the REST API is preferred, but the SOAP API is still supported.

Either way you want the method `Get Lead Activity` filtered by what you consider web-related activity types (mainly Visit Web Page and Clicked Link, but possibly also Filled Out Form).

You'll be getting XML or JSON results to parse and return into the database, and you need to keep track of checkpoints (timestamps) to not duplicate records.  

If you're a developer already building this kind of middleware will be doable (you can do it in PHP, Node, Java, .NET, whatever). 
Anonymous
Not applicable

Re: Sending web activity to ms sql database

Hi Michelle
 
My company get activity log via SOAP API everyday.
Unfortunately REST "Get Activity" API is not same functionality.
https://community.marketo.com/MarketoIdeaDetail?id=08750000000KBDXAA4
 
SanfordWhiteman
Level 10 - Community Moderator

Re: Sending web activity to ms sql database

@Takehiro are you talking about the lack of filter-by-lead? I agree this would be nice to also have in REST but if the OP wants to pull "all web traffic activity" as stated, there's no need for a filter.

 
Anonymous
Not applicable

Re: Sending web activity to ms sql database

@Sanford
Exactly! I misread.
Michelle, I recommend REST API because JSON is lighter than SOAP XML.
Anonymous
Not applicable

Re: Sending web activity to ms sql database

Thanks for the responses guys!