Effortlessly create bulk issues.

import openpyxl, requests, json
url, auth = "https://yourcompany.atlassian.net/rest/api/2/issue/", ("yourusername", "yourapikey")
wb, sheet = openpyxl.load_workbook('issue_details.xlsx'), openpyxl.load_workbook('issue_details.xlsx').active
for row in sheet.iter_rows(min_row=2, values_only=True):
    summary, description, project_key, issuetype_name, assignee_id, priority, *components = row
    payload =
    {
      "fields":
        {
          "project": {"key": project_key},
          "summary": summary,
          "description":
                      {
                          "type": "doc", "version": 1,
                          "content": [{"type": "paragraph",
                          "content": [{"text": description, "type": "text"}]}]
                        },
          "issuetype": {"name": issuetype_name},
          "assignee": {"id": assignee_id},
          "priority": {"name": priority},
          "components": [{"name": component} for component in components if component]} }
    response = requests.post(url, headers={"Content-Type": "application/json"}, auth=auth, data=json.dumps(payload))
    if response.status_code != 201: print(f"Failed to create issue. Status code: {response.status_code}, response: {response.content}")
    else: print(f"Issue created successfully: {response.json()['key']}")