We have a nested MCC structure w hundreds of "customers" (aka accounts). I'd like to get the mcc id for each customer. I don't want the "logged in" customer id but instead the direct owning mcc id for each so I can ensure the remote structure complies with our business structure. (Our mcc ids, of course, repr different business segments.)
Currently the query looks like:
customer_client.descriptive_name, customer_client.currency_code,
customer_client.time_zone, customer_client.status
FROM customer_client
WHERE customer_client.hidden = false and customer_client.manager = false
and customer_client.test_account = false and customer_client.status = 'ENABLED'"
I was hoping customer_client.resource_name would be customers/{mcc}/customerClients/{customer_id} but it just duplicates the customer_id into both fields.
Don Mitchell
Sr. Princ. SW Arch
CarGurus