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}
