Forum Discussion

khill's avatar
khill
Mentor
7 years ago

Bulk Kudos by Kudo Given Date Range and Message ID

Hi everyone,   Does anyone know how to use API or admin reports to pull a list of all kudos given by Message ID over a date range?  Using the API documentation I can only find this info for a certa...
  • TariqHussain's avatar
    TariqHussain
    7 years ago

    khill - I don't think there is a where clause in API V2 which can fetch messages for kudos given a date.  

     

    Kudos call only support - images.id, message.author.id, message.id,user.id as a where clause. 

    With the messages call you can get kudos count and a message id same as your format, however, you only can fetch messages for certain date range by its post time, not by kudos given a date. 

khill's avatar
khill
Mentor

Hi AbhishekIlindra - Yep, so my issue with the standard reports is that (from what I can find so far) they provide kudos by date only (in admin report) or by single message ID only (in API) and I need message ID to match in my database.  What I want is to extract a table that would look something like:

 

Message ID|#Kudos

11111 | 2

11112 | 1

11114 | 3

 

etc. over all posts that received kudos within a certain date range.

 

Any ideas?

 

Kate

TariqHussain's avatar
TariqHussain
Boss
7 years ago

khill - I don't think there is a where clause in API V2 which can fetch messages for kudos given a date.  

 

Kudos call only support - images.id, message.author.id, message.id,user.id as a where clause. 

With the messages call you can get kudos count and a message id same as your format, however, you only can fetch messages for certain date range by its post time, not by kudos given a date. 

  • khill's avatar
    khill
    Mentor
    7 years ago

    Hi TariqHussain,

     

    Thanks (as always) for your help, I am not sure what I would do without you!  Okay so with your guidance I have gotten to the LiQL call that provides message ID and sum of kudos which gets me pretty close to what I need.

     

    SELECT kudos.sum(weight), id from messages

     

    Trying to think of some work around ideas for getting more kudo info...  there isn't a way to add kudo ID to this call is there?  I don't think there is, but just in case!