Marketo API "SOQL" Query

Hi Frank,

SQL style query is not supported.  You will need to use the available SOAP calls at http://developers.marketo.com/documentation/soap/ 

Also, there is no straight up call to get campaign results using a camnpaignID.  You will need to use the getLeadChanges call (http://developers.marketo.com/documentation/soap/getleadchanges/) .  In the sample call response on this page, you will notice that there is an attribute that looks like this:

<campaign>Japanese form fillout.test time zone</campaign>

The name is in the form of <Program Name>.<Campaign Name> and you will need to parse this value to find the activities resulted from a campaign.

Calvin

Calvin, thanks for your response, it helped. I got the calls working fine, but I've run into two problems that I can't resolve:
1) Calling getLeadChanges, since it is so large, exceeds the HTTP Callout limit of 10 by Salesforce
1b) I see the Campaign I need in the changes, but not fields I need!

2) I tried to call getLeadActivity since that is only for one lead. But that occassionally exceeded the HTTP Callout limit also!
2b) The fields I need are not there.

I guess the most important thing is figure out how to get the fields I need. They are two custom fields, UUID and UUID Status. If I could narrow the search to only these two field and for only the campaign I need, that would be perfect. Is that possible?

Thanks!
Frank

Hi Frank,

I thought you were looking for activities specifically related to the campaign such as "Send Email" or "Change Data Value".  If you just want custom field value on a per lead basis, then all you need to do is call getLead - http://developers.marketo.com/documentation/soap/getlead/

However, it sounds like you are looking for a Smart Campaign that changed the data value of some IDs.  In this case, you will use getLeadActivity or getLeadChanges narrowing down the response to the "Change Data Value" activity only.  Below is a snippet of the filter in XML for "getLeadActivity":