Querying registration and visit dates and from Community API v2
Hi there, I wish to query users' registration dates on our platform https://www.localguidesconnect.com. I'm assuming I want the join_date specified here. I've got a couple of questions:
- It says we need to specify the correct node.id, but I am unsure what to provide for this value. I queried the list of available node.ids and tried a few, such as community:cmxpv89733, with no luck.
- Can we fetch the join_date for multiple users at time? It says the id must also be specified but this implies the join_date can only be fetched for one user at a time.
Note I can query the id, sso_id and last_visit_time for multiple users without issue. But a couple of questions regarding visit times I couldn't immediately see answers to in the API spec:
- Is it possible to query previous visit times? For instance, the last five visit times.
- Is it possible to query an aggregate of total visit times?
Thanks!
Hey abracegirdle the join_date field can be only used for membership nodes, like grouphubs
https://developer.khoros.com/khoroscommunitydevdocs/docs/nodes-1#join_date
Here an example of a query
The field that you need to use to know the registration dates of the users is registration_data
select id, registration_data from users
About visit times you only can query the last visit time
https://developer.khoros.com/khoroscommunitydevdocs/docs/users#last_visit_time-public
