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

Hi bhupen ,

I was just wondering if you have used paging in your rest call. The usual REST result is 25 items (nodes) per page.You can use page size and page numbner to page through your results. Here is an example .

/restapi/vc/threads/recent?page=1&page_size=50

page_size - specifies the number of items per page.

page         - specifies the page number.

So in this example , I am asking for 50 thread items per page.You can keep iterating the page number and get the total list .

If you are using a custom component , then there is a separate components for pagination which might be of use to you.

Hope that helps.

Thanks,

Sam

Hi samudhraa  Thanks for your reply.

your trick works for me at halfway:
/restapi/vc/threads/recent?page=1&page_size=50

Now I have one more concern, we can set only page_size =<1000. But In my case there is more than 1050 pages and also i can't make pagination for records because iam exporting the user in csv format. I am using edpoints and downloading it in csv format.

Now Iam able to export 1000 user only but my thread contains more than 14000 user and 1050 pages.

Help is appreciated.

Regards

Bhupen

Hi,

Now I got the solution for this, but its not complete yet. I can export the user using below REST API but the concern is I have to change the page number "page=1&page_size=1000" inside endpoints, so how can I change page number dynamically inside endpoints.

<#list restadmin("/threads/id/${RequestParameters.id}/participants/recent/?page=1&page_size=1000")

Regards

Hi bhupen 

Here is one way to do it , though I am not sure how efficient it would be , because we would be making rest calls within a loop , which is usually not advisable.

<#assign totalCount = 12000/>

<#assign itemsPerPage = 1000 />
<#assign noOfPages = (12000/itemsPerPage) />       or ( <#assign noOfPages = (12000/1000) />)
<#list 1..noOfPages as pageNum>

<#assign getUser = rest("/threads/id/${RequestParameters.id}/participants/recent/?page=${pageNum}&page_size=1000") />

</#list>

Hope that helps.

Thanks ,

Sam

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