How to Send incident data to Azure Storage account

[ayanm]

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

@Ankur Bawiskar 

@Maik Skoddow 

@Mark Roethof 

@Gaurav Shirsat 

@tltoulson  

@Dr Atul G- LNG 

@swathisarang98 

@SwarnadeepNandy 

@Community Alums 

[SwarnadeepNandy]

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.

Hope this approach helps.

Kind Regards,

Swarnadeep Nandy