Paul K space : Data

Billing Entity

Type		Required Fields	Response Fields
Lookup	Departments	Billing Account	Departments
Lookup	Enrolment Account	Billing Account ID Tenant ID	Enrolment ID

Billing Dept

Type		Required Fields	Response Fields
Lookup	Department	Billing Account ID Department ID	Departments

Tenants

Using the provided resource details, query Azure and list all tenants which the user can access
Parse the json response to include tenant_id tenant_name
Populate Google Sheets API_Data page fields
Any Sheet requiring tenant ID and Name mapping can be done via lookup
Tenant_ID variable stored under Doument.UserProperties fields

Additionally

lookup enrolment account

	Type		Required Fields	Response Fields

function getTenants() {
  var azure = getAzureService();
  var tenant_list_url = "https://management.azure.com/tenants?api-version=2020-01-01"
  var response = UrlFetchApp.fetch(tenant_list_url, {
    headers: {
      Authorization: 'Bearer ' + azure.getAccessToken(),
      ContentType: 'application/json',
      'content-type': 'application/json'
      },
      'method' : 'get'
      }
    );

  var parsedData = JSON.parse(response.getContentText()); //JSON.parse(json);
    console.log(parsedData);
    console.log(parsedData.value.length)
    console.log(parsedData.value[0].id);
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('tenants');
    sheet.clearContents();
    var targetValues = [];

    for (var i = 0; i < parsedData.value.length; ++i) {
      targetValues.push(parsedData.value[i].id, parsedData.value[i].displayName,)
      var result = sheet.appendRow(targetValues);
      targetValues = [];
    }
}

Roles

Type		Required Fields	Response Fields
Lookup	Tenants	None - uses active account	Tenants List
Lookup	Enrolment Account	Billing Account ID Tenant ID	Enrolment ID

Subscriptions

Management Groups

Type		Required Fields	Response Fields
Lookup	Tenants	None - uses active account	Tenants List
Lookup	Enrolment Account	Billing Account ID Tenant ID	Enrolment ID

Azure AAD [terraform provider]

Groups

Roles

Users