Forum Discussion

morganharo's avatar
morganharo
Helper
12 years ago

Is there a way to export unique usernames from a specific thread?

Hello all, 

 

I was hoping to export a list of unique usernames from any given thread identified. 

 

While Lithium Support doesn't have a path to doing this, I was wondering if anyone knows of any workarounds? Even if the result is getting a list of ALL usernames, including duplicates. From there I could just a word or excel macro to just show unique names and go from there. 

 

Just hoping to avoid having to manually go through an entire thread and copy and paste usernames! 

 

Thank you for any help,

 

- morgan

2 Replies

Sort By
  • AdamN's avatar
    AdamN
    Khoros Oracle
    12 years ago

    If you're handy with the REST API, there's actually a call that should be able to help you with this. There's a "participants/recent" method on the MessageDiscussion class. So your REST API call might look something like:

    /restapi/vc/threads/id/45/participants/recent

    You'd still have to iterate through the response to get the list of users in a format you wanted, but that could be done pretty easily with an endpoint. Here's some more information on endpoints in case you're not familiar with them:

    http://lithosphere.lithium.com/t5/developers-knowledge-base/Working-with-Lithium-Studio-Endpoints/ta-p/60240

     

    I hope this helps!

     

    *edit*: Looks like this was moved to the Developer forum, so I removed my comment about heading over to the Developer forum for any questions on endpoints.

  • morganharo's avatar
    morganharo
    Helper
    12 years ago
    AdamN wrote:

    If you're handy with the REST API, there's actually a call that should be able to help you with this. There's a "participants/recent" method on the MessageDiscussion class. So your REST API call might look something like:

    /restapi/vc/threads/id/45/participants/recent

    You'd still have to iterate through the response to get the list of users in a format you wanted, but that could be done pretty easily with an endpoint. Here's some more information on endpoints in case you're not familiar with them:

    http://lithosphere.lithium.com/t5/developers-knowledge-base/Working-with-Lithium-Studio-Endpoints/ta-p/60240

     

    If you have more questions about building an endpoint like this, I'd suggest heading over to the Developer Discussion Forum.

     

    I hope this helps!

     

    Thanks Adam, 

     

    I'll definitely need to educate myself on that technique, but I'll give it a shot. 

     

    Open to other suggestions as well, but thanks again, Adam!