This script creates very basic roles with no extra capabilities and restricts the role to viewing only the indicated source category’s data. <\/p>\n\n\n
\n################################################################################\n# This script reads an Excel file containing role data, then uses the Sumo Logic\n# API to create roles based on the data. It checks each row for a role name and\n# uses the source category to set data filters. The script requires a config.py\n# file with access credentials.\n################################################################################\nimport pandas as pd\nimport requests\nimport json\nfrom config import access_id, access_key # Import credentials from config.py\n\n# Path to Excel file\nexcel_file_path = 'NewRoles.xlsx'\n\n# Base URL for Sumo Logic API\nbase_url = 'https:\/\/api.sumologic.com\/api\/v1'\n\n################################################################################\n# Function to create a new role using the Sumo Logic API.\n# \n# Args:\n# role_name (str): The name of the role to create.\n# role_description (str): The description of the role.\n# source_category (str): The source category to restrict the role to.\n# \n# Returns:\n# None. Prints the status of the API call.\n################################################################################\ndef create_role(role_name, role_description, source_category):\n \n url = f'{base_url}\/roles'\n\n # Role payload\n data_filter = f'_sourceCategory={source_category}'\n payload = {\n 'name': role_name,\n 'description': role_description,\n 'logAnalyticsDataFilter': data_filter,\n 'auditDataFilter': data_filter,\n 'securityDataFilter': data_filter\n }\n\n # Headers for the request\n headers = {\n 'Content-Type': 'application\/json',\n 'Accept': 'application\/json'\n }\n\n # Debugging line\n print(f"Attempting to create role: '{role_name}' with description: '{role_description}' and filter: '{data_filter}'")\n\n # Make the POST request to create a new role\n response = requests.post(url, auth=(access_id, access_key), headers=headers, data=json.dumps(payload))\n\n # Check the response\n if response.status_code == 201:\n print(f'Role {role_name} created successfully.')\n else:\n print(f'Failed to create role {role_name}. Status Code: {response.status_code}')\n print('Response:', response.json())\n\n################################################################################\n# Reads an Excel file and processes each row to extract role information and\n# create roles using the Sumo Logic API.\n# \n# Args:\n# file_path (str): The path to the Excel file containing role data.\n# \n# Returns:\n# None. Processes the file and attempts to create roles based on the data.\n################################################################################\ndef process_excel(file_path):\n # Load the spreadsheet\n df = pd.read_excel(file_path, engine='openpyxl')\n\n # Print column names to help debug and find correct ones\n print("Columns found in Excel:", df.columns)\n\n # Iterate over each row in the DataFrame\n for index, row in df.iterrows():\n role_name = row['Role Name'] # Correct column name for role name\n source_category = row['Source Category'] # Correct column name for source category to which role is restricted\n\n # Only create a role if the role name is not null\n if pd.notnull(role_name):\n role_description = f'Provides access to source category {source_category}'\n create_role(role_name, role_description, source_category)\n\n\n# Process the Excel file\nprocess_excel(excel_file_path)\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"This script creates very basic roles with no extra capabilities and restricts the role to viewing only the indicated source category’s data.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2076],"tags":[664,2074,2075],"class_list":["post-11340","post","type-post","status-publish","format-standard","hentry","category-sumo-logic","tag-python","tag-sumo-logic","tag-sumo-logic-api"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/11340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11340"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/11340\/revisions"}],"predecessor-version":[{"id":11341,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/11340\/revisions\/11341"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}