Viviane Santos
PORTFOLIO

Product Manager | IT Business Analyst | ServiceNow Certified (CAD, CSA) | Data-Driven | Agile Practitioner | ITSM & Digital Transformation

Jan 30, 2025

ServiceNow Incident Data Export to Excel (via REST API)

    Description: This Python project connects to the ServiceNow REST API to retrieve incident records and export them into an Excel file using pandas. It demonstrates how to securely access, process, and export data from a ServiceNow instance.

    🚀 What This Project Does:
      - Connects to the ServiceNow Incident Table using the REST API.
      - Authenticates with basic credentials.
      - Sends a GET request with custom query filters.
      - Parses the JSON response into a pandas DataFrame.
      - Extracts relevant fields (e.g., incident_number, state, sys_updated_on).
      - Exports the data to an .xlsx file.
      - Handles pagination to retrieve more than 100 records if needed.
    🛠 Tools & Technologies Used:
      🔗 ServiceNow REST API – For accessing incident data.
      📡 REST API Explorer – For building and testing the endpoint.
      🐍 Python 3 – Core scripting language.
      📦 requests, pandas – requests for API communication/pandas for data manipulation/export.
      💻 Visual Studio Code – IDE for development.
      📁 Output: .xlsx file containing incident records.

📂 Directory Structure (Example)

📂 Directory Structure (Example)
May 20, 2025

ServiceNow to Jira Integration via REST Message (P1 Incidents)

    Description: This ServiceNow project uses a REST Message to send P1 incidents to an external system (like Jira). The data is sent as JSON to a simulated endpoint (Webhook.site) when a critical incident is created.

    🚀 What This Project Does:
      - Sends incident data from ServiceNow to an external system using REST POST.
      - Triggered automatically when a new P1 incident is inserted.
      - JSON body includes incident number, short description, and priority.
      - Tested using Webhook.site as a mock endpoint.
    🛠 Tools & Technologies Used:
      🔗 ServiceNow REST Message – For sending REST POST requests.
      ⚙️ Business Rule – Executes on After Insert for new incidents.
      🌐 Webhook.site – For receiving and testing the payload.
      💡 Variable substitution – Dynamic data injection into JSON body.
      🖥️ ServiceNow Studio – Development and configuration.

📂 Directory Structure (Example)

📂 ServiceNow to Webhook (Jira Simulation)