How to Send incident data to Azure Storage account
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-20-2024 11:41 PM
Hi All,
We have a requirement to send incident data in CSV format to an Azure Storage account.
We have the following details:
- Connection string:
- Username:
- SFTP:
- Azure Storage account:
- Location:
Could you please guide us on how to proceed with Best method?
Thank you!
@Chuck Tomasi
@Community Alums
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-21-2024 01:45 PM
Hi @ayanm ,
You can use Azure Blob Storage Spoke: ServiceNow provides a pre-built "spoke" for Azure Blob Storage. This spoke handles the complexities of authentication and communication with Azure.
1. Install and Configure
- Azure Blob Storage Spoke: Make sure it's installed in your ServiceNow instance.
- Connection Record: In IntegrationHub, set up a connection to your Azure Storage account. You'll need:
- Connection String: This is essential for authentication.
- Storage Account Name: The name of your Azure Storage account.
- Container Name: The name of the container within your storage where you want to store the CSV files.
2. Build the Automated Flow in Flow Designer
- Trigger:
- Scheduled Job: Set it to run daily, weekly, or at any other interval you need.
- Actions:
- Look Up Records: Use a "Look Up Records" action to query the Incident table.
- Filter: Add filters if you only want to export specific incidents (e.g., incidents resolved in the last 24 hours, incidents with a certain priority).
- Transform Data to CSV: Use a "Transform to CSV" action to convert the incident data into CSV format.
- Azure Blob Storage Spoke - "Upload File": This action sends the CSV file to your Azure Storage account.
- Connection Alias: Select the connection alias you created in step 1.
- File Name: Specify a name for the CSV file (e.g., "incidents_YYYYMMDD.csv"). You can use dynamic date values in the file name.
- File Content: Map the output of the "Transform to CSV" action to this input.
- Look Up Records: Use a "Look Up Records" action to query the Incident table.
Hope this approach helps.
Kind Regards,
Swarnadeep Nandy