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)

API v1 docs gone since Atlas migration to Aurora

Does anyone know how to change the display title of Custom Fields in Aurora?

Can someone walk me through authenticating and using Postman with Aurora?

Seeking Advice on Restricting Access to a posts to those who have the permalink.