Getting datas from ftp server and creating a table user

i have datas in ftp server as json format (id, name, lastName, location, department ...etc). is it possible to get those datas one by one and create a table in retool?
every key takes place as a column, every value of every ftp / json data takes place under related column.

See this post:

You would then need to read the file(I assume)