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?
Forum Discussion
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.
This absolutely helps! Thank you for your reply!
