Marketo to OpenSearch integration — real-time, two-way sync

Yes. Stacksync provides a managed, real-time two-way integration between Marketo and OpenSearch: authenticate both systems, choose the objects to sync (such as Marketo's Programs and Program Members and Smart Campaigns), map fields visually, and changes propagate both ways in milliseconds — no code required.

Change detection on Marketo: Polling: Get Lead Changes and Get Lead Activities from a paging token seeded by a sinceDatetime, plus Get Deleted Leads, or Bulk Extract filtered on createdAt/updatedAt. Marketo's Webhooks are Smart Campaign flow-step outbound HTTP calls to a URL, not a general record-change subscription, so there is no push feed of arbitrary CRUD. On OpenSearch: No native change feed; reads rely on queries with scroll or point-in-time polling. Each detected change propagates to the other side in milliseconds, with field-level conflict resolution and an inspectable event log.

On the OpenSearch side: Documents, Index aliases, Index templates, Ingest pipelines, plus custom fields where OpenSearch exposes them. On the Marketo side: Companies, Opportunities and Opportunity Roles, Custom Objects, Activities and Lead Changes. Stacksync auto-detects both schemas and converts types between the two systems.

Yes. Each object mapping can be bidirectional or restricted to a single direction (both systems accept writes). Read-only mirrors, one-way pushes, and full two-way sync can be mixed in the same integration.

Common patterns for Marketo and OpenSearch: Query Marketo like a database; Build audiences from your own data; Engagement and results next to the customer. Contacts, leads, audiences, and campaign metrics from Marketo live in OpenSearch as ordinary tables or collections, joinable with the rest of your data and reachable without touching the vendor API.

Marketo: Marketo REST API (JSON over HTTPS) for Leads, Companies, Opportunities, Custom Objects, Activities, Lists, Programs, and Campaigns, plus an asynchronous Bulk Import (leads) and Bulk Extract (leads/activities/program members/custom objects) API and an Asset REST API for emails, forms, and landing pages. Authentication: OAuth 2.0 client_credentials (2-legged): GET the Identity URL /oauth/token?grant_type=client_credentials with a Custom Service client_id and client_secret to receive an access token valid for 3600 seconds, then send it as Authorization: Bearer on each call. The instance base URL is https://{munchkinId}.mktorest.com; passing the token as an access_token query parameter is deprecated (removal July 31, 2026). OpenSearch: REST API over HTTP(S) with JSON payloads. Authentication: Basic authentication with the security plugin, or AWS IAM request signing on Amazon OpenSearch Service. Stacksync manages authentication, retries, and rate limits on both sides.