Post count by author for board and status

Hi there,

I would need to get a count of posts from a given author, in a given board, in a given status. There doesn't seem to be any API call that could achieve this. Any help appreciated.

sunny_mody
10 years ago
Hi adawans

After searching alot in the rest api documentation, below is an API I could figure out and hope this helps you out.

community.lithium.com/restapi/vc/users/id/[user_id]/topics/in/boards/id/[board_id]/for/message_statuses/key/[status_key]/count

Note : In above API, values in square brackets e.g. [user_id] are variable. So please enter exact user id, board id and status key as per your requirement to get correct response.

Please let me know if this works for you.

Thanks,
Sunny

Claudius
Boss
10 years ago
Are you referring to the "Message status" property to determine whether a message has been reviewed already as described here: https://community.lithium.com/t5/Community-API/bd-p/developers-rest-api?leaf-id=Message.message_status#Message.message_status ?

I don't know of a way to combine those multiple parameters into one. You could apply some logic in an endpoint, but this looks like a scenario where the Lithium Developer Network gurus should look into using Lithium Query Language.
- adawans
  Adept
  10 years ago
  That is exactly what I would need. Hope to hear from a guru :)
  - sunny_mody
    Advisor
    10 years ago
    Hi adawans
    
    After searching alot in the rest api documentation, below is an API I could figure out and hope this helps you out.
    
    community.lithium.com/restapi/vc/users/id/[user_id]/topics/in/boards/id/[board_id]/for/message_statuses/key/[status_key]/count
    
    Note : In above API, values in square brackets e.g. [user_id] are variable. So please enter exact user id, board id and status key as per your requirement to get correct response.
    
    Please let me know if this works for you.
    
    Thanks,
    Sunny
sunny_mody
Advisor
10 years ago
Hi adawans ,

You can use below mentioned API to get count of posts by a user in a particular board.

/restapi/vc/users/id/21/posts/in/boards/id/[board_id]/count

Check this URL to see the output

http://community.lithium.com/restapi/vc/users/id/16152/posts/in/boards/id/studio/count

However I am not sure what do you mean by given status. Is it like some specified time frame, for e.g. one week, one month, etc ?
Please let me know in details about this so that I could provide you with some specific solution.

Thanks,
Sunny
- adawans
  Adept
  10 years ago
  The status as in Message Status.
  This API call retrieves all threads in a given board by status key, I would need to narrow it down to a specific user:
  
  http://community.lithium.com/t5/Community-API/bd-p/developers-rest-api?leaf-id=Board.threads.for.message_statuses.key.status_key#Board.threads.for.message_statuses.key.status_key

Forum Discussion

Post count by author for board and status

Related Content

LiQL Post Count, Kudo count, an solution count for user

How can I list and count ALL bookmarks in the system?

Built a service/status tracker status based on tags

Custom count

ReST API call to Edit Message Author

Recent Discussions

Error message when adding a query to handlebars component (Aurora)

API v1 docs gone since Atlas migration to Aurora

Connecting Khoros data to CRM (Salesforce)

Does anyone know how to change the display title of Custom Fields in Aurora?

Can someone walk me through authenticating and using Postman with Aurora?