Lithium LiQL Connector
Intro
Lithium Technologies provides social customer experience management software for enterprise customers. The Lithium Community API v2 uses LiQL (Lithium Query Language), an SQL-like query language, to access your Lithium data. Use Domo's Lithium connector to retrieve data related to forums, such as leaderboards of kudos authors, lists of visiting users, and so on. To learn more about the Lithium API, visit their page (https://community.lithium.com/t5/Dev...ct-p/Developer).
You connect to your Lithium account in the Data Center. This topic discusses the fields and menus that are specific to the Lithium LiQL connector user interface. General information for adding DataSets, setting update schedules, and editing DataSet information is discussed in Adding a DataSet Using a Data Connector.
Prerequisites
To connect to your Lithium account and create a DataSet, you must have the following:
-
Your Lithium client ID and client secret
-
The base URL for your Lithium instance (e.g. community.domo.com)
-
Your Lithium Tenant ID
Connecting to Your Lithium Account
This section enumerates the options in the Credentials and Details panes in the Lithium LiQL Connector page. The components of the other panes in this page, Scheduling and Name & Describe Your DataSet, are universal across most connector types and are discussed in greater length in Adding a DataSet Using a Data Connector.
Credentials Pane
This pane contains fields for entering credentials to connect to your Lithium account. The following table describes what is needed for each field:
Field |
Description |
---|---|
Lithium API URL |
Enter the Lithium API URL you want to pull data from. For Production, enter one of the following:
For Staging, enter one of the following:
|
Client ID |
Enter your Lithium client ID. |
Client Secret |
Enter your Lithium client secret. |
Base URL |
Enter the server URL for your Lithium instance. |
Tenant ID |
Enter your Lithium tenant ID. |
Once you have entered valid Lithium credentials, you can use the same account any time you go to create a new Lithium DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Managing User Accounts for Connectors.
Details Pane
This pane contains a primary Reports menu, along with various other menus which may or may not appear depending on the report type you select.
Menu |
Description |
||||
---|---|---|---|---|---|
Report |
Select the Lithium report you want to run. The following reports are available:
|
||||
Collection | Select the collection you want to use in your query. This corresponds to the FROM clause in the query. | ||||
Fields | Select the fields you want to use in your query. These correspond to the SELECT clause in the query. | ||||
Constraints |
Enter the constraints you want to use in your query. These correspond to the WHERE clause in the query. For example: ratings.avg(value)>=4 AND conversation.style='forum' |
||||
LiQL Query |
Enter the query you want to use to pull Lithium data into Domo. The syntax is:
The SELECT line is required; the WHERE and ORDER BY lines are optional. LiQL variables are case-sensitive. For example, to return forum posts with an average rating of 4 or higher, you would enter the following:
For another example, to return the subject, ID, and conversation data for forum topics with accepted solutions...
|
Other Panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Data Connector.