How to call integration in interface

Question

t = a!localVariables(
 local!data: ri!_Requests,
 local!errorMessage: "test",
 local!result,
 local!emails: ri!_Requests.emailAddresses,
 local!integration,
 local!individualMail: if(
 a!isNullOrEmpty(local!emails),
 {},
 reject(
 fn!isnull(_),
 split(local!emails, char(10))
 )
 ),
 local!invalidEmails: substitute(
 tostring(
 reject(
 fn!isnull(_),
 a!forEach(
 items: local!individualMail,
 expression: if(
 regexmatch(
 pattern: "^s[A-Z0-9\_-]+(\.{0,1}[A-Z0-9\+_-]+)*[@]{1}[A-Z0-9.-]*[A-Z0-9-]+[.]{1}[A-Z]{2,6}$",
 searchString: fv!item,
 regexFlags: "si"
 ),
 null,
 fv!index
 )
 )
 )
 ),
 ";",
 ","
 ),
 local!validation: if(
 isnull(local!invalidEmails),
 {},
 "Emails must be in a valid format, and each email must be on a new line. "
 ),
 a!formLayout(
 label: "Request",
 contents: {
 a!sectionLayout(
 contents: {
 a!columnsLayout(
 columns: {
 a!columnLayout(
 contents: {
 a!boxLayout(
 label: "",
 labelSize: "SMALL",
 contents: {
 
 a!paragraphField(
 label: "Email Addresses",
 labelPosition: "JUSTIFIED",
 placeholder: "Email Addresses should be one per line (can be pasted from Excel)",
 value: local!data.emailAddresses,
 saveInto: {
 rule!_bulkgetemployees(
 "Emails":"test@test.com",
 ),
 a!save(local!data.emailAddresses, save!value),
 a!save(
 ri!_Requests.emailAddresses,
 save!value
 )
 },
 refreshAfter: "KEYPRESS",
 height: "TALL",
 required: true,
 requiredMessage: "Email Address is Required",
 validations:if(
 (a!isNotNullOrEmpty(local!invalidEmails)),
 "Emails must be in a valid format, and each email must be on a new line. ",
 {}
 )
 )
 
 },
 style: "#134f5c",
 marginBelow: "STANDARD"
 )
 }
 )
 }
 )
 }
 )
 },
 buttons: a!buttonLayout(
 primaryButtons: {
 a!buttonWidget_23r3(
 label: "Submit",
 style: "PRIMARY",
 submit: true,
 validate: true(),
 saveInto: {
 a!save(
 ri!_Requests.requestorName,
 rule!GBL_displayUserFirstLast(loggedInUser())
 ),
 a!save(
 ri!_Requests.requestorEmail,
 loggedInUser()
 ),
 a!save(ri!_Requests.createdOn, now()),
 a!save(
 ri!_Requests.requestStatus,
 cons!_AUDIT_STATUS_TYPES[1]
 ),
 a!save(
 ri!_Requests.requestType,
 cons!_REQUEST_TYPE
 ),
 a!save(ri!_Requests.isActive, true()),
 
 },
 loadingIndicator: true()
 )
 },
 secondaryButtons: {
 a!buttonWidget_23r3(
 label: "Cancel",
 style: "NORMAL",
 submit: true,
 validate: false,
 value: true,
 saveInto: ri!cancel
 )
 }
 )
 )
) I need validation in such a way that it validates each mail address is in mail format and one mail address per line. example : "test@test.com" "test2@test.com" If there are any errors then throw validation error ,if all email addresses are in mail format then how to pass these mailaddresses to integration where body is "emails": "test@test.com, test@test.com" and save the response of this mailsaddress in DB

Yashwanth Akula · Answer

Hi ZAINAB

1) you can call integration object in to the interface using "rule!", example : rule!INT_InterationObject, and pass the data what you want into it, same like working with expression rules.

2) you can use the "People Functions" plugin and use "validateemailaddress" function to validate the email address instead of regex.

Mike Schmitt · Answer

ZAINAB said: How can I pass emailaddresses as "test@test.com test2@test.com ....." to the integration 
 why not just concat them together with joinArray and a separator of " "?

Mike Schmitt · Answer

ZAINAB said: rule!ASR_bulkgetemployees(Emails: local!formattedEmailString) 
 You haven't shown us what the configuration is for "local!formattedEmailString" so we would have no way of knowing what its value is or what error you're getting. 
 Have you verified its value is correct before the field's "save" operation takes place? What is its configuration?

Mike Schmitt · Answer

Did you look at the value of local!formattedEmailString before trying the integration, to see if it contains the value you expect? I notice that the only time it's changed is upon form load, so it should already hold its correct value presumably before you interact with the paragraph field.

Mike Schmitt · Answer

And if you copy out the exact same value and run it in the integration rule by itself, it works?

Mike Schmitt · Answer

ZAINAB said: in the " " 
 does this mean the integration expects a slightly different value from what the local variable holds? can you post some screenshots of the interface's current exact value and the value you're entering in the integration that's working?

Mike Schmitt · Answer

In case this makes any difference to your integration, these values are separated by a comma but not a space. The values you're created in local!formattedString are separated by a comman AND a space. This could easily make a difference if the integration is not expecting to clean extra spaces between emails.

Mike Schmitt · Answer

Please try it with this definition of local!formattedEmailString instead. Here we're preparing your concatted list of email addresses, but then putting it in a dictionary at the "emails" property, and wrapping that up into a JSON string, which it looks like the integration expects (guessing based on your screenshot). 
 local!formattedEmailString: a!toJson(
 {
 emails: joinarray(local!individualEmails, ",")
 }
),

Mike Schmitt · Answer

You still need to call the integration rule with parameterized naming. 
 this is how you had it before (correct): 
 this is what you're trying now (which will fail for any rule that doesn't have exactly 1 parameter, hence the error message you're getting) 
 The fact that we're wrapping the "emails" value in a JSON string that also has the property of "emails" doesn't mean you don't have to use the named parameter when calling the integration rule. Whether or not the integration is set up to use this or not, is up to its internal code (which you still haven't shared here, but would help a lot if possible).

Konduru Chaitanya · Answer

Hello ZAINAB , 
 Could you please check the type of the Rule input that you have configured in the integrations. Does it match to take the inputs that you are passing.

Mike Schmitt · Answer

ZAINAB said: How can I pass it as rule input to integration 
 The thing you're currently doing (with the paragraph field) should be sufficient for passing it into the integration. The problem is that you're not passing the data in formatted correctly, and you haven't really given us sufficient description yet of what the integration requires.

How to call integration in interface

Top Replies