LiQL v2 call with sso_id

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

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

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