# How to get json file from ftp to KDB?

**URL:** <https://forum.kx.com/t/how-to-get-json-file-from-ftp-to-kdb/11592>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [July 26, 2017, 8:56pm UTC](https://forum.kx.com/t/how-to-get-json-file-from-ftp-to-kdb/11592 "2017-07-26T20:56:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kc3031](https://avatars.discourse-cdn.com/v4/letter/k/aca169/32.png) [@kc3031](https://forum.kx.com/u/kc3031)\
**Post date:** [July 26, 2017, 8:56pm UTC](https://forum.kx.com/t/how-to-get-json-file-from-ftp-to-kdb/11592/1 "2017-07-26T20:56:00Z")

</div>

Greetings,

Is there a way to connect KDB with FTP with username and password and retrieve data back to KDB?

I tried:&nbsp;system “curl ftp://username:password@xxx/path/to/.csv” but it failed.

Any help would be greatly appreciated!

Best,

Kelly

---

<div class="post-metadata">

**Author:** ![Alexander\_Belop](https://avatars.discourse-cdn.com/v4/letter/a/258eb7/32.png) [@Alexander\_Belop](https://forum.kx.com/u/Alexander_Belop)\
**Post date:** [July 27, 2017, 1:49am UTC](https://forum.kx.com/t/how-to-get-json-file-from-ftp-to-kdb/11592/2 "2017-07-27T01:49:00Z")

</div>

It works for me:

`q)system"curl -s ftp://ftp:x@rtfm.mit.edu/pub/arpaprob.txt""Date: Wed 1 Oct 86 12:41:40-EDT""From: Dennis G. Perry <PERRY@VAX.DARPA.MIL>""Subject: Congestion in the Arpanet"..`

Check that your curl command works at the shell prompt.