Generate file in ServiceNow and send to Azure BLOB API

[Ankur Bawiskar]

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

[sam36]

How far is it good pratice to give the Read API

[santhosh97]

Hi Ankur,

Have you found a way to implement this? I too have similar kind of requirement. The requirement is to generate the incident details as csv format and send them to Azure storage account from service now portal.

[Ankur Bawiskar]

@santhosh97 

Yes I was able to achieve it using mid server logic but I don't have any reference scripts which I can share.

[santhosh97]

Hi Ankur,

Could you at least share the steps involved in this process? It would be a great help if you can.