webapi /integration design for requirement

Question

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?

Harshmodi · Answer

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 :

Mathieu Drouin · Answer

Wouldn't you have 1 row per email where you can put the associated id? 
 Ideally that service would send you back a list of ids that are associated to emails which you can then use to update your DB. 
 Otherwise, you would have to rely on the order on which it was sent and recieved which I don't recommend.

Mathieu Drouin · Answer

I would request that they send you a response that includes the email + id. You can then just store that in a table on your side after your receive the response and still capture the initial emails in a paragraph. 
 {
 {
 email: "test2@test.com",
 id: 1
 },
 {
 email: "tes2@test.com",
 id: 2
 }
 }

Mathieu Drouin · Answer

Unsure what your requirement is but having a table with two text fields with comma delimited values is not a recommended design. 
 You can capture the emails and them in a comma delmited format to the API but I would request to the 3rd party that they send you the response in the format outlined above so that you know which ID is associated to which email.

webapi /integration design for requirement

Top Replies