topic Re: Convert Subscription IDs to WCH Organization IDs in Webex for Developers

Convert Subscription IDs to WCH Organization IDs

Phig Newton — Mon, 13 Nov 2023 18:01:51 GMT

I have a weekly list of about 100 CCW Subscription IDs that I need to get the Control Hub Org IDs for.

I can search Partner hub for the subscription, open their Control Hub and go to 'account' and copy the Org ID from there, but it seems the APIs should have a faster way, either one-by-one or as a list.

Any ideas?

I have rudimentary Python skills and advanced Excel skills, if either of those is a good path. And also, I plan to grab more fields once I get rolling. 'Reporting' is the main function.

Re: Convert Subscription IDs to WCH Organization IDs

Janos Benyovszki — Tue, 14 Nov 2023 11:38:33 GMT

@Phig Newton can you check the orgs API here https://developer.webex.com/docs/api/v1/organizations/list-organizations ? If you are a partner for those orgs, you should be able to list them.

Re: Convert Subscription IDs to WCH Organization IDs

Phig Newton — Tue, 14 Nov 2023 14:52:37 GMT

Thanks. That's a start, but I'm looking for a list of Subscription IDs with Org IDs, like this:

Subscription ID, Company Name, Org ID
Sub900001, XYZ Company, 0123abcd-01ab-0e11-1234-aa2b-0123abcd1231
Sub900002, XYZ Company, 0123abcd-01ab-0e11-1234-aa2b-0123abcd1231
Sub900003, XYZ Company, 0123abcd-01ab-0e11-1234-aa2b-0123abcd1231
Sub900004, Acme Corp, 91e6a3c1-22cd-4a1e-124a-4321-b7a42b44a382
Sub900005, Acme Corp, 91e6a3c1-22cd-4a1e-124a-4321-b7a42b44a382
Sub900006, Acme Corp, 91e6a3c1-22cd-4a1e-124a-4321-b7a42b44a382
Sub900007, Acme Corp, 91e6a3c1-22cd-4a1e-124a-4321-b7a42b44a382
Sub900008, PEOPLE INC, 813a73e1-91e6-a3c1-77e1-ae91-61bac1133388
Sub900009, PEOPLE INC, 813a73e1-91e6-a3c1-77e1-ae91-61bac1133388
Sub900010, PEOPLE INC, 813a73e1-91e6-a3c1-77e1-ae91-61bac1133388
Sub900011, PEOPLE INC, 813a73e1-91e6-a3c1-77e1-ae91-61bac1133388
Sub900012, PEOPLE INC, 813a73e1-91e6-a3c1-77e1-ae91-61bac1133388
Sub900013, PEOPLE INC, 813a73e1-91e6-a3c1-77e1-ae91-61bac1133388
Sub900014, Friend Industry, 11ea3159-71e6-39e1-62c9-210b-33aeb15e3a15
Sub900015, Friend Industry, 11ea3159-71e6-39e1-62c9-210b-33aeb15e3a15
Sub900016, Friend Industry, 11ea3159-71e6-39e1-62c9-210b-33aeb15e3a15
Sub900017, Friend Industry, 11ea3159-71e6-39e1-62c9-210b-33aeb15e3a15
Sub900018, Friend Industry, 11ea3159-71e6-39e1-62c9-210b-33aeb15e3a15

A full list would best.
Searching by Sub would be good too.

Re: Convert Subscription IDs to WCH Organization IDs

Raffaele Lagana — Thu, 16 Nov 2023 11:07:47 GMT

The closest API we to allow this, is the /list-licenses API. You can List all subscription IDs by orgId. It also returns the name of the subscription.