Skip to main content
Insert Banner Message here.

Community

Search

Welcome to Community

Vault api for users

Answered

Comments

3 comments

  • Arunkumar Shanmugam

    Use lower case 'u' 

    SELECT user_first_name__v, user_last_name__v, license__type__v
    FROM users
    WHERE license_type__v = 'external'

     

    0
  • Rewati Charhate

    Thank you it worked. Do you know by any chanc how to query for getting data before 3 months . As the date format here is different

    I am failig at where condition , need to get data where date is before 3 months

     workflow_query=self.App_url + "/api/v18.3/query?q=SELECT id,last_login__v FROM users Where last_login__v"       
          

    0
  • Pranil Kamble

    Hi Rewati,

    Try below query:

    self.App_url +"/api/v20.1/query?q=SELECT id,last_login__v FROM users Where last_login__v > '2020-05-31T23:59:59.000Z'"

    You can tweak the query according to your needs.

    0

Please sign in to leave a comment.

Powered by Zendesk