Convert Subscription IDs to WCH Organization IDs

[Phig Newton]

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.

[Janos Benyovszki]

@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.

[Phig Newton]

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.

[Raffaele Lagana]

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.