LiQL v2 call with sso_id

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

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

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 satya,

I need an api where i can get kudos, badges, roles and rank in a single call. Do we have such api in v1?

Thanks,

shravani

Hi shravani

Unfortunately, we can't get all those in the single V1 API call. 

Do you want to get those kudos, badges, roles and rank only using sso_id? you don't want to use user id(which is also unique)? Just trying to understand the requirement :)

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

Thanks,
Srujana Satya

shravani - I think you could use the V2 API call for getting this info.

Try this - SELECT kudos_received.sum(weight), kudos_given.sum(weight), roles, rank, user_badges from users where id = '<id>'

Hi satya,

We need to show these values in unified customer profile which is in another system.

Please let me know if there is any other approach which could solve this problem.

Thanks,

shravani

Hi srujanayeruvaka,

but i want to get this info using sso_id.

Hi shravani,

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

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

where you can get the user id of the required user. Then pass that user id into v2 API call as mentioned by srujanayeruvaka and get all the required results.

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

Thanks,
Srujana Satya

Thank you satya