Forum Discussion

gandhim's avatar
gandhim
Guide
8 years ago

APi for fetching User details

Hi All,   I am new to Lithium Community,  I am trying to figure out if there is any API provided by lithium community to fetch the user details. When I say users it means users/consumers who are re...
gandhim's avatar
gandhim
Guide
8 years ago

Thanks for all the replies, I need to do one more thing is to get the details of the users whose profiles are updated on a given day.

I am trying to get the users which are newly registered (doing that by fetching the users registration time for that day(LIQL)) and the users whose profile has been updated. 
Is there any LIQL query or an attribute like last modified timestamp which can help me to find out those records.

Thanks

  • VikasB's avatar
    VikasB
    Boss
    8 years ago

    Hi gandhim 

    Below API will help you to get the users who registered in a specified date range

    To get the list of users registered today( 2017-07-09)
    http:// community.lithium.com/restapi/vc/users/registered
    Parameters:

    date_start=2017-07-09T00:00Z 
    date_end=2017-07-09T23:59Z


    Unfortunately, there is no such API exist to get the list of users on the basis of profile update timestamp.

    • gandhim's avatar
      gandhim
      Guide
      8 years ago

      Thanks VikasB

       

      Is there any API on v2 for getting the new registered users?

      • VikasB's avatar
        VikasB
        Boss
        8 years ago

        Hi gandhim  No perfect way to get it using V2.

         

        But you can use a workaround using below API

        SELECT id, registration_data.registration_time FROM users ORDER BY registration_data.registration_time DESC limit N

        Now you need to filter out the records which are registered today using date comparison.