I have to send email addresses as input from Appian to external system and the external system validates those email address and send back the ids of those email address. How i can implement the design ,what all are needed ,can someone help?
Discussion posts and replies are publicly visible
Hi,
To achieve this,use integration to communicate with an external system. Send your request body (input parameters) to the external system and receive the correct response if all the email addresses are correct. Retrieve the results from the output section and store them in the Appian database using write smart services.
Here is the reference :
Calling Integration :Fetching Result :
Hi /Mathurambika M : from the integration i will get response(output) as many employeeids which needs to be stored in db .In the db i need to store all this employeedsid, if i use datatype as int ,max limit is only 255 . how to store the data.can you please suggest
Hello,
You can store employee IDs as text type and later cast it to integer whenever you need to use it.
If i give datatype as int(11) will it not store all the employeesid {1234567 ,1234657 ,1325476...............upto 100 employeeids} ?
The 'int(11)' datatype in DB specifies an integer with a display width of 11 digits, but it doesn't limit the range of values that can be stored. It means the display width is 11 characters, but the actual storage and range of values are determined by the integer type.
For 'int(11)', you can store integers ranging from -2147483648 to 2147483647. If your employee IDs are within this range (which is highly likely), it will be suitable for storing them. In your case, with employee IDs like 1234567, 1234657, etc., 'int(11)' should work without any issues.