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.
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.
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?
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
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!