Forum Discussion

tripp-bishop's avatar
tripp-bishop
Mentor
11 years ago

sorting REST call

Hi guys,   I'm trying to find out if/how I can sort the following REST call: /blogs/id/myblog/topics?page=1&page_size=50&restapi.response_style=view   I've tried adding the following query par...
  • samudhraa's avatar
    samudhraa
    11 years ago

    Hi tripp-bishop ,

     

    I think the below REST call might help you.

     

    /blogs/id/myblog/search/messages?q=is_root:true&sort_by=date

     

    It searches for messages that are topics(root messages) within your blog and sorts them by date. I believe the date is in chronological order. 

    As a side note , If you need it in reverse chronological order , change the sort_by parameter to "sort_by=-date" . 

    PS : I have found sort_by parameter to work , usually with search calls .

     

    Hope that helps.

     

    Thanks,

    Sam

NicoB's avatar
NicoB
Lithium Alumni (Retired)
11 years ago

Hi tripp-bishop 

did you try with:

<#assign count = rest("blogs/id/myblog/topics/count")/>
<#assign last = rest("/blogs/id/myblog/topics?page=${count}&page_size=1&restapi.response_style=view").node_message_context.message />

 This will get you the vary first blog article but obviously if you want to get the first N articles you need to do the appropriate calculations and play with the page_size and page parameters.

Thanks,

Nico