Attachment via Rest Message

kirankr2061
Tera Contributor

Hi all, I’d like your thoughts on this.

We’ve received a requirement where we need to extract data from a specific table in ServiceNow and send it to an Azure console (such as a storage account) as a CSV file. This process needs to be automated to run every Saturday.

What would be the best approach to achieve this? Specifically, how can we generate the CSV file and send it as an attachment to the Azure endpoint on a scheduled basis?

Any suggestions or best practices would be appreciated!

4 REPLIES 4

Bhimashankar H
Mega Sage

Hi @kirankr2061,

 

To automate extracting data from table and sending it azure, you can use the flow in integration hub.

For this you need to have the "Azure blob storage spoke". Setup a connection string or alias for azure. The container name within the storage account where you’ll upload the CSV file.

 

As alternative you can use the scheduled export set as well, it is documented here.

How to Export the table data from Schedule Jobs? , 

Schedule an Export - Snow Document ,

Scheduled Data Export-customized csv file ,

Microsoft Azure Blob Storage Spoke ,

Generate CSV file through script 

 

Please go through the above reference that will give you a clear idea.

 

 

Thanks,
Bhimashankar H

 

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks! 

Bhimashankar H
Mega Sage

Hi @kirankr2061 ,

 

I hope you saw my reply. 
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. It will help future readers as well having similar kind of questions and close the thread.

Thanks,
Bhimashankar H

Ankur Bawiskar
Tera Patron
Tera Patron

@kirankr2061 

best approach is to use Export set and place the file in mid server

Then ask the Customer's team to grab this and write powershell script to push it to Azure.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@kirankr2061 

Thank you for marking my response as helpful.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader