Forum Discussion

RyanFarley's avatar
RyanFarley
Contributor
15 years ago

Getting a list of recent messages via API

I am having some difficulty in getting a list of recent messages via the API.   I located a post in these forums that showed me the following URL: http://lithosphere.lithium.com/lithium/restapi/vc...
RyanFarley's avatar
RyanFarley
Contributor

Thanks for all the help Jake.

 

The upgrade to v9 is out of my hands and unfortunately, I don't see it happening any time soon :(

 

Basically what I need is to be able to retrieve any new posts "today" (or at least since a certain date/time). Do you have any ideas for how to get all posts since a certain date/time?

 

Thanks again.

JakeR's avatar
JakeR
Khoros Oracle
15 years ago

Yeah, I see.  In a perfect world the user would have a button that gets all the posts that have occurred since they lost logged in...oh wait, that is coming in our latest v9 release. Heheh.

 

Seriously though, for the here and now, I've been thinking about your challenge.

 

When you run that call, it looks like it returns all the threads that have been updated in the last week, one thing I might suggest is running it with a little query string parameter tacked on:

 

http://community.sagesaleslogix.com/slsl/restapi/vc/threads/recent?page=1&page_size=10

 

With those parameters tacked on it looks like it returns the threads just in the last day or two (of course you can fiddle with the numbers in those parameters in order to expand or reduce the results).

 

Would something like that work for you? 

 

There are other parameters that you can use (contained within the REST API docs that you can get from your CSM).  Maybe these ones are the ones that you should be using instead of the ones that I tacked on:

 

  • topic_sort_order - Specifies the order in which threads are listed in a message list. Possible values:
    • last_post_date - Threads are sorted by the dates the threads were started in descending order, with the newest topics appearing first
    • topic_start_date - Threads are sorted by the date of the newest message in each thread in descending order, with the threads with newest messages appearing first.