Solved

FTP Connector datatypes for parameter

  • 24 March 2020
  • 4 replies
  • 100 views

Userlevel 2
Badge +5

Is there a document stating the proper datatypes for the parameters of the FTP connector?

icon

Best answer by Jasper 27 March 2020, 08:49

View original

4 replies

Userlevel 7
Badge +11

Hi Onno,

Do you need the exact datatypes or is this sufficient?
https://docs.thinkwisesoftware.com/docs/sf/process_flows.html#ftps-connector

Userlevel 2
Badge +5

Hoi Jasper,

If you want to use the connector, you have to handle the output in a task. The parameters for this task need to be defined with their own domains. But these can only be created properly, when you also know the database datatypes.

Like taskparameter url; domain url; database datatype varchar(128) for instance.

Userlevel 2
Badge +5

Same applies also to the input parameters, b.t.w.

Userlevel 7
Badge +11

Hi Onno,

You are free to choose the datatypes of the variables, as long as the relevant data of the input and output parameters can be converted to the datatype. 

For the FTP connector, for example, you could use a VARCHAR domain with sufficient length for the URL, FTP method and filename, a VARBINARY(MAX) for the file data and an INTEGER for the timeout value. For enumeration options, a VARCHAR variable can be used. We have added the string representation of all enumeration options to the documentation.

Reply