Sending web activity to ms sql database

[Anonymous]

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?

[SanfordWhiteman]

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]

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]

@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]

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

[Anonymous]

Thanks for the responses guys!