REST-API: Sorting TKB Articles by number of views via API

Question

Hi everyone,&nbsp;I am not a developer so not really sure how to use the rest-api. I would like to retrieve a full list of tkb articles sorted by the number of views from our online financial dictionary containing more than 1.300 definitions.See:&nbsp;https://wissen.consorsbank.de/t5/Geldlexikon/tkb-p/Boersenlexikon for the full dictionary or&nbsp;https://wissen.consorsbank.de/t5/Geldlexikon/Abandon/ta-p/6065 for a single article.As an output I would just need the number of views and the&nbsp;title of the article.&nbsp;&nbsp;Is anyone familiar with this topic? Thank you very much for your help!&nbsp;All the best, Clemens&nbsp;

tariqhussain · Answer

CCornerstone&nbsp;-&nbsp;Below is the query which will return you TKB subject by views sorting.SELECT subject FROM messages WHERE conversation.style='tkb' ORDER BY metrics.views DESC&nbsp;Here is the documentation&nbsp;https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&amp;collection=messages#constraints-conversation.styleIf you just want to get all the tkbs from&nbsp;Boersenlexikon&nbsp;board. You don't need to add conversation.style either.&nbsp;&nbsp;SELECT subject FROM messages WHERE board.id='Boersenlexikon' ORDER BY metrics.views DESC&nbsp;

ccornerstone · Answer

thank you for the quick reply!would you perhaps also know the rest-api call? (not lithium query language?)

tariqhussain · Answer

CCornerstone&nbsp;- For that, you must need to authenticate using OAuth 2.0 flow to access the API V2.&nbsp;&nbsp;Here is the documentation for the OAuth 2.0 flow&nbsp;https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=oauth2&nbsp;

luk · Answer

TariqHussain&nbsp;CCornerstone&nbsp;nope, you don't need the OAuth stuff =)...&nbsp;Paste&nbsp;the&nbsp;code below in an endpoint in Studio &gt; Endpoints and set the endpoint's "View Content Type" to "application/json" in the dropdown below the content field. Then click "View &lt;endpoint.name&gt; Endpoint" to get the link to the endpoint, you will see a gibberish output, that is JSON =)...the developers implementing the data on the third party site will know what to do with it, just send them the link to the endpoint.&nbsp;&lt;#-- fetch all tkb articles sorted by views, adjust the WHERE conditions as needed, in your case one should be enough as Tariq already stated --&gt;
&lt;#assign query = "SELECT subject,view_href,metrics FROM messages WHERE board.id = 'Boersenlexikon' AND conversation.style = 'tkb' ORDER BY metrics.views DESC LIMIT 1000"?url /&gt;
&lt;#assign response = restd("2.0", "/search?q=" + query) /&gt;

${response}&nbsp;

tariqhussain · Answer

CCornerstone&nbsp;- Can you elaborate more? do you want to use this query inside lithium using Freemarker or you want to access from the third server?&nbsp;&nbsp;&nbsp;

Forum Discussion

REST-API: Sorting TKB Articles by number of views via API

Related Content

[REST API] Problem to sort messages

Rest API Outside Community

Community REST-API: Get all tags available

API for newly published articles?

JAVA SDK for calling Khoros Rest APIS

Recent Discussions

Connecting Khoros data to CRM (Salesforce)

How do I get the article ID in Freemarker in a TkbArticle?

400/404 error on POST request

Online User Count is Completely Wrong

TinyMceEditor is undefined