Tag Archives: marketo

Boomi: Query Marketo Leads by Static List

In Boomi Marketo connector, you can query a list of leads by using the static list which gives you the option of either using:

1. Static List Name
2. Static List Id

staticlist

Static List Name
You can do this by simply providing the name of the List that you have created in Marketo. However, if the list is created under a campaign, you have to provide the name of the campaign and the list. For example:

staticlist2

if you have the setup as shown in the screenshot above, the name that you should provide is “Campaigns for Activity Extract.Leads with Web Visits”.

Static List id
If you would like to use the list Id, you can retrieve the Id:
– click on the list
– look at the URL in browser
– retrieve the number between ST and A1

For example: https://app-abd.marketo.com/#ST1234A1, the Id for the list would be 1234.

Integrating with Boomi, hear our customers @ Dreamforce

Hear Amrith Nambiar from Mindjet talk about running integration in a 100% cloud environment and Bill Vanderwall from Scientific Learning on integrating in a hybrid cloud and on-premise environment:

Some interesting take aways:

  • Nate Bride talks about the Boomi community approach and gives a plug to the WDCi built JIRA connector that is available via the Boomi public atomsphere – thanks Nate.
  • Bill talks about selecting Boomi over Cast Iron due to the user interface but most importantly due to the Total Cost of Ownership – Boomi is more affordable.
  • Both Bill and Amrith talk about the complexity of bidirectional integration of data, ie which system is the master and how to ensure data integrity in this model.
  • Amrith’s 4 keys to success:
  1. Focus on the business process.
  2. Limit your scope to only what systems are needed for your first project.
  3. Get the right partner (thanks Amrith).
  4. Accept that the interfaces/integration processes will be tuned over time –  don’t expect to build out everything in the first phase if you have complex or dependent business processes.
  • Amrith mentions the custom reporting and error handling infrastructure we have put in place to enable Mindjet to check and validate synchronised data between Salesforce and Netsuite.
  • At the end of the recording, you can hear Walter Dewildt from WDCi answer a question on how to decide if you should push volumes of data to your target application or simply expose data in the source and retrieve as necessary.

Want to know more, check out the Mindjet case study http://www.boomi.com/customers/success/standardizing-back-office-application-integrations-minimal-it-support