Since Intercom does not have a native "Export to Qlik" button, you must use one of three methods: API extraction , Reverse ETL , or Manual CSV export . Below is the actionable content you can use for documentation or implementation.
Exporting Intercom Data to Qlik: Technical Guide Overview To analyze customer support, sales engagement, and product usage from Intercom alongside other business data in Qlik, you need to ingest Intercom objects (Conversations, Users, Companies, Events, Tags). Method 1: Using Intercom REST API (Best for Automation) Qlik can call REST APIs natively using the REST Connector (Qlik Web Connector or Qlik Sense REST Connector). Step 1: Get Credentials from Intercom
Go to Intercom Developer Hub → Your Apps → App . Generate an Access Token (type: Bearer Token ). Note your API Version (e.g., 2.10 ).
Step 2: Configure Qlik REST Connector In Qlik Data Manager or Script Editor: | Setting | Value | | :--- | :--- | | Method | GET | | URL | https://api.intercom.io/[object] | | Pagination | Use next URL param (Intercom uses cursor-based pagination) | | Headers | Authorization: Bearer <Your_Token> Accept: application/json Intercom-Version: 2.10 | Step 3: Qlik Script Example (Load Users) // Load Intercom Users LIB CONNECT TO 'REST_Intercom'; Users: SQL SELECT * FROM "contacts" (where "role" = 'user') WITH CONNECTION ( HEADER "Authorization" "Bearer YOUR_ACCESS_TOKEN", HEADER "Intercom-Version" "2.10" ); export intercom to qlik
Common Intercom Endpoints:
/conversations – Support tickets/chats /contacts – Users & leads /companies – Organizations /events – Activity logs /tags – Classification labels
Pagination Handling in Qlik Intercom uses next URL in response body. Use a loop in Qlik script: Let next_url = 'https://api.intercom.io/conversations?per_page=50'; Do while Len(next_url) > 0 REST [Load data using next_url]; // Extract 'next' URL from JSON response next_url = JsonExtract([response], '$.pages.next'); Loop Since Intercom does not have a native "Export
Method 2: Manual CSV Export (One-time or Scheduled) For small datasets or a one-off analysis:
In Intercom:
Go to individual sections (Conversations, Users, Companies). Use the Export button (usually under Settings → Export Data). Export type: CSV or JSON. Method 1: Using Intercom REST API (Best for
In Qlik:
Upload CSV to Qlik Cloud or add as a data file. Use LOAD FROM [file.csv] (txt, codepage is utf8, embedded labels, delimiter is ',');