Intercom is a software company that provides customer messaging and engagement tools for businesses. They offer products and services for customer support, marketing, and sales, allowing companies to communicate with their customers through various channels like chat, email, and more.
To get started with the Intercom API, you need to initialize the API handler with the required access token for authentication. You can do this as follows:
access_token: Your Intercom access token for authentication.
Check out this guide on how to get the intercom access token in order to access Intercom data.
To create a database using the Intercom engine, you can use a SQL-like syntax as shown below:
You can retrieve data from Intercom using a SELECT statement. For example:
Copy
Ask AI
SELECT *FROM myintercom.articles;
You can filter data based on specific criteria using a WHERE clause. Here’s an example:
Copy
Ask AI
SELECT *FROM myintercom.articlesWHERE id = <article-id>;
To create a new article in Intercom, you can use the INSERT statement. Here’s an example:
Copy
Ask AI
INSERT INTO myintercom.articles (title, description, body, author_id, state, parent_id, parent_type)VALUES ( 'Thanks for everything', 'Description of the Article', 'Body of the Article', 6840572, 'published', 6801839, 'collection');
You can update existing records in Intercom using the UPDATE statement. For instance:
Copy
Ask AI
UPDATE myintercom.articlesSET title = 'Christmas is here!', body = '<p>New gifts in store for the jolly season</p>'WHERE id = <article-id>;