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?
This topic has been closed for comments

4 replies

Jasper
Superhero
  • 678 replies
  • 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
  • Author
  • Vanguard
  • 20 replies
  • March 24, 2020

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
  • Author
  • Vanguard
  • 20 replies
  • March 24, 2020

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


Jasper
Superhero
  • 678 replies
  • Answer
  • 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.


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