Post csv file in FTP server location

[Lohith]

Hi All,

How can we extract data from ServiceNow and post in FTP server location. We have installed CrossFuze data extract, but we do not want to use mid-server, instead we need to use mid-server cluster.

Any other ideas apart from CrossFuze, or can we use mid-server clusters in CrossFuze data extract?

Appreciate your inputs.

Thanks.

[Community Alums]

Hi Lohith,

You would require mid server script include for this which is combination of java+javascript

check below links and they will help you:

https://community.servicenow.com/community?id=community_question&sys_id=b4932b8cdb79df0047c8f3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=6e5c03a5db9cdbc01dcaf3231f96...

https://gyanomania.wordpress.com/2012/07/29/send-an-attachment-from-service-now-and-store-it-on-ftp-...

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep

[Community Alums]

Hi Lohith,

Any update to this ?Any follow-up required? if not

Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

[Monika13]

Hi,

We have setup something like below in our instance. Its configured by someone else, so pardon me if I miss any point and it uses only one mid server

 1) Create FTP connection using File builder FTP connections- here you have to mention details like end point, folder in mid server where data will be stored temporarily, used id and password to login

2) File Builder File Definitions- here you need to mention file name, type, file destination path, file parameters, ServiceNow table ...

3) Lastly you will need scheduled job- sample schedule job comes with plugin

https://<YOURINSTANCE>.service-now.com/sysauto_script.do?sys_id=dd976a54886b01007f44c37f5c73b843

[Lohith]

Thanks for response.

We do not want to use mid-server. can we achieve this without midserver ?