Forum Discussion

bhupen's avatar
bhupen
Advisor
11 years ago
Solved

Is there a way to export more than 25 unique usernames in csv/txt

I want to export a list of unique usernames for any given thread identified. Solution I had:  I have managed it using REST API with this call:  /restapi/vc/threads/id/23/participants/recent.   C...
  • bhupen's avatar
    bhupen
    11 years ago
    samudhraa Thank you very much. I resolved this using this:
    <#assign x=10>
    <#list 1..x as pageNum>
    <#list restadmin("/threads/id/5719/participants/recent/?page=${pageNum}&page_size=1000").users.user as user>
    <#if user.login??>
    ${user.login}
    </#if>
    </#list>
    </#list>
bhupen's avatar
bhupen
Advisor
11 years ago
samudhraa
Thanks again for help. This is not showing me anything now. Neither error neither output. Now I can see only .csv is blank without any result. If this is not possible so can you suggest me how can I implement restcall outside loop.
My concern is only to export users in csv. I have more then 15000 users and 1200 pages.
Help is appreciated
samudhraa's avatar
samudhraa
Expert
11 years ago

Hi bhupen ,

That was a snippet of code outlining the logic. You are supposed to loop through the api variable. The below is a working one , though I have changed the REST call. 

<#assign totalCount = 12000/>
<#assign itemsPerPage = 1000 />
<#assign noOfPages = (12000/itemsPerPage) />

<#list 1..noOfPages as pageNum>
<#assign getUser = rest("/threads/recent?page=${pageNum}&page_size=10").threads />
<#list getUser.thread as thread>
${pageNum} ${thread.@href} ${thread_index}
<br/>
</#list>
</#list>

 

Again , I would not advise that this is the efficient way to do it. I will let you know if I come up with a better way to do it. You could always contact Lithium support and get their idea on this.

 

Thanks,

Sam

  • bhupen's avatar
    bhupen
    Advisor
    11 years ago
    samudhraa Thank you very much. I resolved this using this:
    <#assign x=10>
    <#list 1..x as pageNum>
    <#list restadmin("/threads/id/5719/participants/recent/?page=${pageNum}&page_size=1000").users.user as user>
    <#if user.login??>
    ${user.login}
    </#if>
    </#list>
    </#list>