CCornerstone - Can you elaborate more? do you want to use this query inside lithium using Freemarker or you want to access from the third server?
of course, sorry for the unspecific question. the data must be accessed from third parties
CCornerstone - For that, you must need to authenticate using OAuth 2.0 flow to access the API V2.
Here is the documentation for the OAuth 2.0 flow https://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=oauth2
TariqHussain CCornerstone nope, you don't need the OAuth stuff =)...
Paste the code below in an endpoint in Studio > Endpoints and set the endpoint's "View Content Type" to "application/json" in the dropdown below the content field. Then click "View <endpoint.name> 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.
<#-- fetch all tkb articles sorted by views, adjust the WHERE conditions as needed, in your case one should be enough as Tariq already stated -->
<#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 />
<#assign response = restd("2.0", "/search?q=" + query) />
${response}
