Hello ,
I am using the .net version of the code to fetch all Clients at all levels using the query below
const string query = @"SELECT
customer_client.client_customer,
customer_client.level,
customer_client.manager,
customer_client.descriptive_name,
customer_client.currency_code,
customer_client.time_zone,
customer_client.resource_name
FROM customer_client
WHERE
customer_client.level <= 3";
Successfully i get a list but it is flat with all clients at different levels.
My issue is i need to hierarchically create a tree with different levels. I need to know the clients that have level 2 is linked to which client on level1.
I tried using CustomerClientLink but if i provide a customer ID other than Login_CustomerId it throws USER_PERMISSION_DENIED exception. (FYI- this was not the behaviour with V2 version as i was previously using.) Please advise.
Thank you,
Vinitha.