Skip to main content
Solved

FTP Connector datatypes for parameter


Forum|alt.badge.img+5

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

Best answer by Jasper

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.

View original
Did this topic help you find an answer to your question?

Jasper
Superhero
  • March 24, 2020

Hi Onno,

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


Forum|alt.badge.img+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.


Forum|alt.badge.img+5

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


Jasper
Superhero
  • March 27, 2020

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings