Forum Discussion

charlesssgraham's avatar
charlesssgraham
Contributor
3 years ago

Access LiQL JSON with JavaScript?

So the LiQL queries give us back a JSON object. I'd like to just work with the results of the query with the code I write in a <script> tag on the same component.  Is this possible in Khoros? 
API
FreeMarker
JavidH's avatar
JavidH
Khoros Staff
3 years ago

charlesssgraham You 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.

charlesssgraham's avatar
charlesssgraham
Contributor
3 years ago

This absolutely helps! Thank you for your reply!