Attachment via Rest Message
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2025 03:24 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-31-2025 12:54 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-03-2025 11:59 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2025 12:14 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2025 01:04 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader