REST V2 query for online users

Question

Is there a way to get only online users from the database using API V2? I would normally use a WHERE online_status = 'online' but this returns offline users too! My query is also not suitable as it takes the first 1000 and loops to find online users. I have a database of 30,000 members and this just wont do. Here is my query for my component.

<#assign query = "SELECT login, view_href, avatar, online_status, registration_data, rank FROM users limit 1000" />

Can anyone suggest a way of modifying my query to only get online users?

chiaras · Answer

Sounds like a bug, since it's documented here as supported (http://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv2&amp;collection=users#constraints-online_status).
/cc&nbsp;SuzieH&nbsp;
&nbsp;
As a workaround, I would use v1:&nbsp;http://community.lithium.com/t5/Developer-Documentation/bd-p/dev-doc-portal?section=commv1&amp;leaf-id=Community.users.online#Community.users.online

chiaras · Answer

hi,
&nbsp;
no it's not possible within the same call. You would need to perform a "dedicated" call for each user to get the id:&nbsp;/users/id/&lt;id&gt;/ranking/id

jaread83 · Answer

Thanks ChiaraS but I need to use V2 to get the rank ID's back for my loop as I have applied classes to each container for some of the upper ranked users (mods, admins, VIPs etc). I did use V1 but couldn't figure out how to get the rank IDs back. Is there a way to get the rank ID in V1? I could post my full component here if that would help?

jaread83 · Answer

Thank you very much! I have converted my entire V2 api component to V1 and it all seems to be working as expected now.Thank you for your time!

Forum Discussion

REST V2 query for online users

Related Content

query with date field

query any user's online status

Issues with batched queries

/users/online vs. /users/online/count

Users not receiving Atlas emails

Recent Discussions

Connecting Khoros data to CRM (Salesforce)

How do I get the article ID in Freemarker in a TkbArticle?

400/404 error on POST request

Online User Count is Completely Wrong

TinyMceEditor is undefined