ml-connector
Sage X3Pipedrive

Sage X3 and Pipedrive integration

Sage X3 holds your master product, customer, and supplier records. Pipedrive holds your sales pipeline. Connecting the two keeps your CRM and your ERP in sync. Customer records created in Sage X3 automatically appear in Pipedrive as organizations, and sales invoices posted in Sage X3 flow into Pipedrive so your sales team sees what has shipped and what is still outstanding. ml-connector bridges the two systems' different authentication schemes and manages the polling schedule so your data stays current without manual re-entry.

How Sage X3 works

Sage X3 exposes customers, suppliers, purchase orders, sales invoices, products, and general ledger accounts through REST api1 with HTTP Basic Authentication (customer-specific credentials) and GraphQL with OAuth2 client credentials. The GraphQL endpoint requires Sage X3 V12 or later, while REST api1 is available from V6 onward. Access tokens expire in 5 minutes and refresh tokens are valid for 30 days. Sage X3 does not support native webhooks or event push notifications, so ml-connector detects changes by polling records and checking their updatedDate and modifiedDateTime fields. The server URL, port, and folder name are customer-specific; there is no shared tenant registry. Default page size for REST api1 is 20 records, but this can be overridden.

How Pipedrive works

Pipedrive is a cloud CRM that exposes deals, organizations, persons, products, pipelines, stages, and activities through REST API with either API Token authentication (header: x-api-token) or OAuth2 bearer token. OAuth tokens have a defined lifetime and can be refreshed. Pipedrive supports both v1 and v2 API formats and offers webhooks with HMAC-SHA256 signature verification for push notifications. However, Pipedrive is CRM-only and has no native invoices, bills, purchase orders, payments, GL accounts, or employee records. Custom fields are exposed as opaque hashes and field definitions must be retrieved separately. Daily token budget and burst rate limits vary by plan: API token allows 20 to 120 requests per 2-second window, while OAuth apps allow 80 to 480 requests per 2-second window.

What moves between them

Customer and supplier records flow from Sage X3 into Pipedrive as organizations and related person records on a regular poll schedule. Sales invoices post from Sage X3 into Pipedrive deals with invoice details mapped to deal fields. Pipedrive is write-only for this integration; changes in Pipedrive do not flow back to Sage X3. Polling runs on a schedule you control, checking for new or modified records in Sage X3 since the last sync.

How ml-connector handles it

ml-connector accepts the customer-specific Sage X3 server URL, port, and folder name, and authenticates either via HTTP Basic Auth or OAuth2 depending on the Sage X3 deployment. It polls Sage X3 at your configured interval, checking updatedDate fields to detect new and changed customer and supplier records since the last sync. Customer names, addresses, and identifiers map to Pipedrive organizations, and sales invoice data maps to Pipedrive deals. Pipedrive authentication uses either an API token or OAuth2 bearer token, and ml-connector tracks token expiry and refreshes before calls fail. Pipedrive rate limits are monitored; when a 429 response is received, ml-connector backs off and retries. Custom fields in Pipedrive are matched by name, and if a field definition changes, the mapping is re-queried before the next write. Every record carries a complete audit trail including timestamps, auth credentials used, and the exact payload, so any failed sync can be replayed once the underlying issue is fixed.

A real-world example

A mid-market distributor uses Sage X3 on-premise for inventory, procurement, and invoicing, and Pipedrive to manage a sales pipeline across three regional offices. Before the integration, new customers entered in Sage X3 were manually re-entered in Pipedrive by the sales ops team, and sales reps had to hunt through email for invoice status. With Sage X3 and Pipedrive connected, every new customer in Sage X3 appears in Pipedrive automatically, and reps see invoices linked to deals so they can track what has shipped and follow up on what is still open. Month-end reconciliation is faster because the revenue recognized in Sage X3 matches the deals closed in Pipedrive.

What you can do

  • Sync customers and suppliers from Sage X3 into Pipedrive as organizations, keeping master data in both systems aligned.
  • Map sales invoices from Sage X3 into Pipedrive deals, so your sales team sees what has shipped and what is outstanding.
  • Authenticate Sage X3 with HTTP Basic Auth or OAuth2 and Pipedrive with API token or OAuth2, managing token expiry and refresh.
  • Poll Sage X3 on a schedule you control, detecting changes via updatedDate fields and syncing only what is new or modified.
  • Track every record through a complete audit trail, and replay any failed sync once the underlying issue is resolved.

Questions

Which direction does data move between Sage X3 and Pipedrive?
Customer, supplier, and sales invoice records flow from Sage X3 into Pipedrive as organizations and deals. Pipedrive is write-only; changes in Pipedrive do not flow back to Sage X3. Reference data such as customer names and invoice totals are synced in one direction on a poll schedule.
How does ml-connector handle Sage X3's lack of webhooks?
Because Sage X3 does not support native webhooks, ml-connector polls Sage X3 at a regular interval you set and checks the updatedDate and modifiedDateTime fields on each record to detect what has changed since the last sync. Only new and modified records are processed, keeping the sync efficient.
What happens if Pipedrive rate limits are hit during a sync?
When Pipedrive returns a 429 rate limit response, ml-connector backs off, waits, and retries the request. The integration tracks your plan's token budget and burst limits, so rate limit collisions are rare. If a sync fails for any reason, the full audit trail lets you replay it once the issue is fixed.

Related integrations

Connect Sage X3 and Pipedrive

Free to use. Add your credentials, ping your real systems, and see if we fit.

Get started