Integration with file transfer tool

[sajin1]

Hi All,

I'm looking for an approach to perform integration with ServiceNow and a file transfer tool.

Use case :

External vendors upload the file to the file transfer tool and the tool will trigger an email to ServiceNow with the folder name and file name.

ServiceNow should query the tool and fetch the attachment which will be processed in ServiceNow to update the ServiceNow classes.

Exception :

There is no Username and Password instead we were asked to use a key that we will get from another tool on runtime hence cannot use the OOB data source capability.

Please let us know what would be a better approach to this use case.

[Ankur Bawiskar]

Hi,

Check on below approach

1) have mid server installed

2) write mid server script include with function

3) trigger this function whenever you want to fetch

4) the 3rd party team must be sending the key; you can store it in system property; pass this to mid server script include

5) when the mid server script include runs it will attach the file using attachment API to the data source

6) once attachment is added to data source; you can run the transform map etc

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[sajin1]

Hi Ankur,

Thanks for the reply.

# 2. If you can share some links to sample mid server script includes it will be helpful.

# 5. Not sure if I understood correctly.

I believe after the mid server script include is executed it will run some SSH script and return the attachment to the ECC queue, is it correct?

[Ankur Bawiskar]

Hi,

Sample mid server script include here:

http://www.john-james-andersen.com/blog/service-now/javascriptprobe-and-mid-server-script-includes.html

Point 5: yes when the mid server script include will get the file from ftp server; create a copy on mid server; use Attachment API functionality which is Out of box on ecc queue table and attach it to data source

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur