ContributionsMost RecentMost LikesSolutionsRe: How to Install the Lithium Community SDK on Windows Hello Folks, I have created a guide for how to install the SDK on windows operating system based on the Ideas shared here. I have consolidated those as a guide. Guide Link:https://developer.khoros.com/khoroscommunitydevdocs/docs/install-the-khoros-community-sdk-on-windows How We Built It: Since you were gone component Learn about how to build and add theSince you were gone component on your community home page. Re: How to extract metadata with API Metadata section is not supported in the extracted/exported data as of now. We are planning to add this section to the extracted/exported data in the future. Re: How to extract metadata with API You can refer to theCare Analytics Reportwhere there are instructions about how to export the data. Hope this helps. Re: Can You Get Author Roles From A Messages Subquery Currently, you cannot fetch the author.roles from messages sub-query and you need to make a separate call to get the role details. Re: Access LiQL JSON with JavaScript? Create a custom endpoint (I'm naming it as q) in the studio: <#assign query= restadmin("2.0","/search?q=" + "SELECT id, login, email, rank.name, rank.simple_criteria.role.id FROM users"?url).data.items/> ${query} Create a custom component (naming it as component_q) in the studio: <#assign communityId = community.id /> <#assign communityUrl = http.request.url /> <#assign lengthOfDomain = communityUrl?index_of("/") /> <#assign communityDomain = communityUrl?substring(0,lengthOfDomain) /> ${communityUrl} ${communityId} <@liaAddScript> ;(function($){ $.ajax({ type:"POST", url:'${communityDomain}/plugins/custom/qa/johndowden/q', contentType: 'application/json', success: function(res) { console.log(res); console.log("Results are listed"); }.bind(this), error: function(xhr, status, err) { console.error(xhr, status, err.toString()); console.log("Unable to view the results"); }.bind(this) }); })(LITHIUM.jQuery); </@liaAddScript> Note:The URL must be your community URL of the endpoint in the studio. When you add thecomponent_qto any page in your community using studio, you can view the results in the console. Hope this helps. If this answers your question, would you please mark it as an accepted solution. Re: Bulk Data API - new user questions You are right. The fromDate and toDate are mapped to the event.time.ms timestamp. event.time.ms - represent the time of user activity occurred in the community (in UTC). Bulk API won’t support pagination, it is always whole data served as a stream for the requested timestamp. Hope this helps. Re: LiQL query for User Drafts widget stgrayStanGromerI'm currently checking with the engineering team on this. I will let you know once I have an update. Re: Access LiQL JSON with JavaScript? charlesssgrahamYou can add your query ("SELECT id, login, email, rank.name, rank.simple_criteria.role.id FROM users") to a custom component in studio using the below API V2: <#assign query = restadmin("2.0","/search?q=" + "SELECT id, login, email, rank.name, rank.simple_criteria.role.id FROM users"?url).data.items/> <#list query as q> ${q.id} ${q.login} ${q.email} ${q.rank.name} <#if q.rank.simple_criteria.role?? && q.rank.simple_criteria.role.id??> ${q.rank.simple_criteria.role.id} </#if>, </#list> Then you can add this custom component to your desired page in your community in studio. Hope this helps. How We Built It: User Profile Hover Card Learn about how to build a hovercard that will display the information about a user when you hover the mouse cursor over their avatar or username.