Code: Select all
SKU_MAP = {
'efccb6f7':'Product 1',
'6050e30712fa':'Product 2',
'f8a100f':'Product 3',
}
< /code>
def export_to_csv(users):
with open('/tmp/users.csv', mode='w', newline='') as file:
writer = csv.writer(file)
writer.writerow(['User Name', 'Assigned Products'])
for user in users:
# Convert skuId to readable names using the SKU_MAP dictionary
product_list = [SKU_ID.get(license['skuId'], license['skuId']) for license in user['assignedLicenses']]
writer.writerow([user['userPrincipalName'], ','.join(product_list)])