Generate file in ServiceNow and send to Azure BLOB API

Ankur Bawiskar
Tera Patron
Tera Patron

Hi All,

I want to generate a file example: incident file with format as csv. Once this file is generated I want this file to be uploaded to Azure Blob container. I know Azure has BLOB API, but not sure how to use that in ServiceNow. Also since here the concept of file is involved will there be a need of Mid Server. Also this extract should be sent over every 1hour or so.

For the Azure BLOB i have container name and the key to connect

I know in Helsinki there is an approach of Export Sets, It generates the attachment and puts it in Mid Server location. I have not tested that functionality.

Approach

- Generate file and send it to mid server

- have mid server script (i think java based) and consume the REST API of Azure BLOB and pick file from mid server location and send it over

Did anyone do something on similar lines. Any help would be appreciated.

Regards

Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
1 ACCEPTED SOLUTION

Hi Dan,

I had started the development work but left it in middle. So not sure on this part.

Regards

Ankur

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

View solution in original post

8 REPLIES 8

Ankur Bawiskar
Tera Patron
Tera Patron

Marking this to be assume answered.

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

Dan Franko2
Kilo Contributor

Did you ever figure out how to do this?

Hi Dan,

I had started the development work but left it in middle. So not sure on this part.

Regards

Ankur

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

Hi @Ankur Bawiskar  did you get any chance of implementing this Azure Blog i too have similar requirment as a workaround i have provided the read API just read the data with specified conditions