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

[ntmcgee]

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.

[Parshant]

@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.

[ntmcgee]

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?

[Parshant]

@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

[ntmcgee]

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?