Forum Discussion

Kev_B's avatar
Kev_B
Advisor
7 years ago

Do date constraints work with API v1?

Hi, I'm using API v1 for the first time to pull up some user stats, and I'm trying to constrain these to a date range. I've tried using ?date_start-YYYY-MM-DD&date_end-YYYY-MM-DD at the end of the q...
VikasB's avatar
VikasB
Boss

Kev_B
yes, start date and end date is not working here with this API. But you can do it with API V2 also. 

Select * from messages where author.id = '123' and post_time > "date" and post_time < "date"
Kev_B's avatar
Kev_B
Advisor
7 years ago

Thanks Vikas, 

I'm most interested in using the count function on posts, is there an easy way to do this with API v2?

Thanks

  • PerBonomi's avatar
    PerBonomi
    Boss
    7 years ago

    This is a starting point:

    <#assign user_id = 123/>
<#assign board_id = 'help'/>
<#assign date_start = "yyyy-MM-dd"/>
<#assign date_end = "yyyy-MM-dd"/>
<#assign timezone = "+01:00"/>
<#assign query = rest("2.0","/search?q=" + "SELECT count(*) FROM messages WHERE board.id = '${board_id}' AND author.id = '${user_id}' AND post_time >= ${date_start}T00:00:00${timezone} AND post_time <= ${date_end}T00:00:00${timezone}"?url) />
<#assign post_count = query.data.count!0/>
${post_count}
  • VikasB's avatar
    VikasB
    Boss
    7 years ago

    Kev_B

    a) Use the same API shared in the last comment. See here https://prnt.sc/kxz7je
    b) Use count specific API

    Select count(*) from messages where author.id = '3' and post_time > 2018-09-21T00:15:47.369-07:00
    • Kev_B's avatar
      Kev_B
      Advisor
      7 years ago

      Great stuff, thanks both!