Forum Discussion

pkrish80's avatar
pkrish80
Contributor
11 years ago

how to get data returned by rest api call based on timestamp

Hi All,   I am using a REST Api in my Java Code as a part of the HP Community. I am able to retrieve all the messages from the posts. I would like to know how can I use this api to get messages bet...
pkrish80's avatar
pkrish80
Contributor
11 years ago

Hi All,

 

This is what I am using to get the range of messages in the last month sorted by post_time.

 

http://<<communityname>>/restapi/vc/boards/id/"+categoryType+"/posts/recent?rangeTime=1M&sort_by=-post_time&page_size="+numOfCalls+"&page="+pageNum+"&restapi.response_format=json&restapi.format_detail=full_list_element&restapi.response_style=view

 

This doesn't seem to work. Can someone chime in on this?

 

Thanks,

Prasanna

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

Hi pkrish80 

What about this call:

http://community/restapi/vc/search/messages?q=board_id:ID%20AND%20latestPostDate:[1234567%20TO%2012344567]&sort_by=-topicPostDate

 

Please not that you would need to calculate the latestPostDate parameter which specify in interval in millisecond. Freemarker has functions for performing transformations to get milliseconds of a date (http://community.lithium.com/t5/Developers-Knowledge-Base/datesupport-FreeMarker-context-object/ta-p/9349).

 

Thanks,

Nico