This repo is used for generating the WebEx Chat report from two DevNet public rooms namely Support and Program rooms in Excel format
workbook = xlsxwriter.Workbook( 'folder_path/' + room_data_get + "_" + month_name + str( year_val_get) + '.xlsx') worksheet = workbook.add_worksheet(month_name + str(year_val_get))
def web_chat(url_val,bear_auth,month_check,room_data_get,year_val_get): get_date_list = [] get_Id_list = [] get_parentID_list = [] response = requests.get(url_val, auth=BearerAuth(bear_auth)) print(response.status_code) if response.status_code == 401: message = 'Fail_server' return message else: data = response.json() #print(data['items']) for i in range(len(data['items'])): k = str(data['items'][i]['created']) month_val = k.split('-') if month_val[1] == str(month_check): get_date_list.append(data['items'][i]['created']) get_Id_list.append(data['items'][i]['id']) if "parentId" in data['items'][i]: get_parentID_list.append(data['items'][i]['parentId']) get_date_list.reverse() get_parentID_list.reverse() get_Id_list.reverse() month_number = str(month_check) datetime_object = datetime.datetime.strptime(month_number, "%m") month_name = datetime_object.strftime("%b") workbook = xlsxwriter.Workbook( 'folder_path/' + room_data_get + "_" + month_name + str( year_val_get) + '.xlsx') worksheet = workbook.add_worksheet(month_name + str(year_val_get)) row = 0 col = 0 heading_list = ['Date', 'Email of question', 'Domain', 'Question asked', 'Room', 'Answered by', 'Answer Given'] count = 0 for title in (heading_list): worksheet.write(row, col + count, title) count = count + 1 row += 1 for k in get_Id_list: for j in range(len(data['items'])): if k == data['items'][j]['id']: print("=============================================================") print("------------------Question------------------------") print(data['items'][j]['created']) split_date = str(data['items'][j]['created']) date_val = split_date.split('T') print(date_val[0]) worksheet.write(row, col, date_val[0]) print(data['items'][j]['personEmail']) worksheet.write(row, col + 1, data['items'][j]['personEmail']) worksheet.write(row, col + 2, " ") if "text" in data['items'][j]: print(data['items'][j]['text']) worksheet.write(row, col + 3, data['items'][j]['text']) worksheet.write(row, col + 4, room_data_get) for l in range(len(data['items'])): if "parentId" in data['items'][l]: if data['items'][l]['parentId'] == k: print("------------------Answer------------------------") print(data['items'][l]['personEmail']) worksheet.write(row, col + 5, data['items'][l]['personEmail']) if "text" in data['items'][l]: print(data['items'][l]['text']) worksheet.write(row, col + 6, data['items'][l]['text']) row += 1 workbook.close() get_date_list.clear() get_Id_list.clear() get_parentID_list.clear() filename_val = room_data_get + "_" + month_name + str(year_val_get) return filename_val
url_get_data ='https://webexapis.com/v1/messages?roomId=Y2lzY29zcGFyazovL3VzL1JPT00vNGZlOTQ2MTAtZjA2MS0xMWU1LWI4Y2UtMTEzZjhkZmMxNGJl&before='+date_format_value+'&max=1000' url_get_data ='https://webexapis.com/v1/messages?roomId=Y2lzY29zcGFyazovL3VzL1JPT00vYzQ2OTk3NTAtZGIyNy0xMWU1LWI0ZjQtZmJmMjI3Y2ZmYWYz&before='+date_format_value+'&max=1000'
{ "items": [ { "id": "Y2lzY29zcGFyazovL3VzL01FU1NBR0UvN2UyOTUwNDAtN2YwYS0xMWVjLWFlZTEtMjUwZjQ4ZjY4OGNk", "roomId": "Y2lzY29zcGFyazovL3VzL1JPT00vNGZlOTQ2MTAtZjA2MS0xMWU1LWI4Y2UtMTEzZjhkZmMxNGJl", "roomType": "group", "text": "Hello. I'm trying to utilize capabilities from the IOS-XE 17.3 YANG schema but I'm running a Cisco 3850 IOS 16.9. How can I utilize the 17.3 schema if the latest IOS for the 3850 is 16.12?", "personId": "Y2lzY29zcGFyazovL3VzL1BFT1BMRS9iMjI2NWJlNS03ZGY4LTQzNTEtYjYyMC1kOGJkZTYxM2FiNTc", "personEmail": "#############", "created": "2022-01-27T00:45:58.468Z", "updated": "2022-01-27T00:50:16.145Z" }
Webex REST API, an Authentication HTTP header is used to identify the requesting user. This header must include an access token. This access token may be a personal access token from this site (see below), a Bot token, or an OAuth token from an Integration or Guest Issuer application.
Code Exchange Community
Get help, share code, and collaborate with other developers in the Code Exchange community.View Community