Public
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Contributor

LiQL Post Count, Kudo count, an solution count for users in one week.

I'm having some trouble figuring out the best way to get an automated report from Lithium. I only need a few stats, and I have gotten the post count with:

"https://api.lithium.com/community/2.0/******/search?q=SELECT+count%28*%29+FROM+messages+WHERE+author...' | jq -r '.data.count"

But I can not figure out how to get the kudos or the solutions by time period.

4 Replies 4
Boss

@ntmcgee

You can use below metrics api to get kudos count in community on date range

https://<your_community_url>/restapi/vc/metrics/name/net_kudos_weight/?date_start=2018-07-01&date_end=2018-07-07.

 

.......
Expecting your Kudos and Accepted Solution to my replies.

Thank you for the reply! But I actually need to keep track of things per user.

 

I'm trying to keep track of employee activity on our community.

 

Do you have any idea how I could pull this off?

@ntmcgee,

Using V1:

Below API will return you kudos count for the last week.

 

/restapi/vc/users/id/4/metrics/name/net_kudos_weight_received?date_start=2018-07-01&date_end=2018-07-07

Below API will return you Total Posts Count for the last week:

 

/restapi/vc/users/id/4/metrics/name/overall_posts?date_start=2018-07-01&date_end=2018-07-07

 Below API will return you Total Accepted solution Count for the last week of user:

/restapi/vc/users/id/4/metrics/name/net_accepted_solutions?date_start=2018-07-01&date_end=2018-07-07

 

---

You can get Overall Post count, Kudos count and Solution count of the user using below LiQL API V2

 

SELECT messages.count(*), kudos_received.sum(weight), solutions_authored.count(*) FROM users WHERE id = '4'

Using this API will return response for one user for

 

 

user_activity.PNG

 

.......
Expecting your Kudos and Accepted Solution to my replies.

Thanks for that! Based on the paths, that looks like it would work!

For whatever reason, I am getting permission denied though.

I have admin access, I wonder if there is another role that I need to have?

Welcome to the Technology board!

Curious about our platform? Looking to connect on social technology? You've come to the right place!

Are you a Khoros customer? For direct assistance from our Support team, please visit the Support Forum.