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,
Forum Discussion
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
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 IllindraHi 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,
