Forum Discussion

shravani's avatar
shravani
Guide
8 years ago

LiQL v2 call with sso_id

Hi,

I want to call an api in v2 with sso_id.

for example: select * from users where sso_id='31', but this query is not working. Is there any other method through which we can get the output.

 

Thanks,

shravani

  • Gagandeeps's avatar
    Gagandeeps
    Expert
    8 years ago

    Hi 

     

    You can try this way .

    As we are able to get those details using sso_id, first make a v1 API call by passing the sso_id

    /restapi/vc/users/sso_id/[id]

    Thanks

     

  • AbhishekIlindra's avatar
    AbhishekIlindra
    Boss
    8 years ago

    shravani : Kindly check this Discussion. Hope it will work.

     

     

    If my post is helpful and answers your question, please give "Kudos" and "Accept it as a Solution."

    Thanks & Regards,
    Abhishek Illindra

    • shravani's avatar
      shravani
      Guide
      8 years ago

      Hi AbhishekIlindra,

      I am getting sso_id from v2 call, but i want to use sso_id in where condition in the query.

      for example: select * from users where sso_id='31',

      and i am getting the following response, 

      {
      "status" : "error",
      "message" : "invalid query syntax for SELECT * FROM users WHERE sso_id = '31'",
      "data" : {
      "type" : "error_data",
      "code" : 604,
      "developer_message" : "'sso_id' is not a valid constraint for the object 'users'. in: SELECT * FROM users WHERE sso_id = '31'",
      "more_info" : ""
      },
      "metadata" : { }
      }

       

      Thanks,

      shravani

      • satya's avatar
        satya
        Expert
        8 years ago

        Hi shravani,

         

        I don't think so we have a V2 API call available to get the info using sso_id. I have tried a couple of queries but no luck from my side. I think you can go with V1 query :) 

         

        Give kudos if you find my posts helpful or mark as solution if it answers your query.

        Thanks,
        Srujana Satya