Forum Discussion

Xprime's avatar
Xprime
Helper
10 years ago

[API] count total boards on community filtered on date range

Hello,

We need your help about the api Boards "truc et astuce" .
We would like to get the last topic of "truc et astuce" on the last 7days.

We found information about getting all the topics since the begining of communauté sosh.
https://communaute.sosh.fr/restapi/vc/boards/id/trucs-astuces/topics/count

But we don"t see where we can have the time value

Can you help us?

Thank you

  • OlivierS's avatar
    OlivierS
    Lithium Alumni (Retired)
    10 years ago

    Xprime 

     

    2 options I can think of:

     

    1- if you manage to find a metric in Admin/metrics returning what you want, you could use the API v1 metric/name method (you can filter using start_time / end_time).

     

    2- you use the API v2 "SELECT * FROM messages WHERE board.id='tutoriel'" (unfortunately you can't filter by date) and loop through the result until the last_post_date is greater than 7 days ago.