How to Send incident data to Azure Storage account

ayanm
Giga Contributor

‎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

@Ankur Bawiskar 

@Maik Skoddow 

@Mark Roethof 

@Gaurav Shirsat 

@tltoulson  

@Dr Atul G- LNG 

@swathisarang98 

@SwarnadeepNandy 

@Community Alums 

 

 

0 Helpfuls
  • 595 Views
1 REPLY 1

SwarnadeepNandy
Mega Sage

‎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.

Hope this approach helps.

 

Kind Regards,

Swarnadeep Nandy

0 Helpfuls