Extensibility

Hi, We are using Appian on-prem version and implemented SAML authentication for single sign. We have a requirement that our on-prem server will be accessible to multiple development team and we want to implement application security. What i understood from Appian documentation that Groups are used to implement role based security from Appian application. my questions are 1. Is there any other way to implement Application security other than Groups? 2. Can we create groups automatically by integrating with Azure AD, and during user login group will be created and users will be mapped? Thanks, Bipindra Singh

I am calling an OpenAPI Integration that needs a session authentication token to run successfully.  I can call a different OpenAPI to retrieve the bearer token, but I cannot find a way to pass it into the Call Integration step. I created the Integration with a Header and Query Parameters. The integration test is successful, with the header and query parameters included in the request. When I add the Call Integration step to the Process Modeler, there is a message that reads "Map rule inputs/outputs using the Data tab": When I go to the Data Inputs tab, neither the Header nor Query Parameters that are defined in the Integration are listed: The Outputs tab does include the information from the response. Any idea why the inputs tab does not include the Header or Query Parameter values from the integration?  Any idea how to pass values through the Call Integration step of a Process Model? Thanks!

Hello Community, I wanted to know about its efficiency when exporting complex SQL queries in Export SQL to Excel SS, as we have used this smart service to generate data for multiple sheets in excel, but if multiple people triggers the final parent process at the same time, it crashes the server, any one can guide to avoid that or any alternatives ? Is there an issue with this smart service ? Thanks in advance.

For suppose we have two drop down fields F1 and F2 in an editable grid. And we have two integrations namely A and B.   A contains data of F1 and F2 fields we need to fetch data from integration A and displays the data in each row as soon as interface loads. And by clicking add new row link in grid .the field F1 as it is drop down we need to fetch the dropdown values from integration B Let me know is it possible if yes any helpful tips to solve this.

Hello All I am new into Appian I am fetching data from integration object where i get all nearby vaccination centers name, type of vaccine, available slot and it is free or paid. But when I fecth the details i get all the details in one row only. So how can i show center name row wise please help me I am new into appian and facing problem in these See Here I am getting center name in one row only. How to show in different row. I am sharing the code also please tell me where and what should i do the changes a!localVariables( local!result: rule!CVMS_vaccinationCenter_INT(district_id: ri!district_id,date: ri!date), a!formLayout( label: "Form", contents: { a!textField( label: "Enter Your District Id", labelPosition: "ABOVE", value: ri!district_id, saveInto: ri!district_id, refreshAfter: "UNFOCUS", required: true, validations: {} ), a!textField( label: "Enter The Date for which want to check availability", labelPosition: "ABOVE&quot

What would be the best solution for displaying the data by reading the data from uploaded excel from an Interface? Use Case: 1) Upload the Excel in the Interface. 2) Read the data from the excel.(multiple Sheets - Each sheet will not have more than 10 to 20 rows) 3) Show the data in the Interface (Each sheet will be related as one to many relationship) Note: Sheet1 will have parent table data and other sheets will have child table data

Hello Everyone I am new into appian. I have used an integration object which shows me different vaccination centers available near by me and type of vaccination and availability and all the other things. I want to show this result to user in proper way in interface that this are the vaccination center name and type of vaccine in a proper way. But I dont know how to show integration object in interface and how to show the result in proper way like all vaccine center name then type of vaccine in that hospital. Please help me 

Hi, I have a requirement of Appian integration with outlook. We are sending / triggering an email notification to user(s) with Approve & Reject links. When the users try to click on the Approve or Reject links, is it possible to update the status in Appian without really login into Appian. Is there any service in Appian related to Outlook integration to achieve this functionality.

I am new to appian. I want to know how to refer integration object to user in interface. In my case user will give his district id and date and he will get all the vaccination center near by him and available slot and type of vaccine. I want to show this integartion object result in Interface to user in a proper way how can I do that?

I'm trying to figure out how to link an Appian Cloud database to Tableau.

Hi I'm trying to read an excel using Parse Excel to CDT smart Service. I would like to understand in what format we need to pass the value is this parameter.

Hi, I have created a simple Component plugin but getting below error while drag and drop plugin on interface Missing system configuration This component requires the dynamic content domain to be properly configured. Contact your system administrator. We are using On-premise Appian server. This is basic backgroudColor plugin copied from Appian Github. Please suggest what steps are required to rectify this issue.

Hi, In our Use case we have a requirement of conversion of base64 to doc. We were able to find this smart service in the 22.1 cloud version. Can anyone confirm if this smart service is available in OnPrem(22.1) version as well? this smart service is not present in OnPrem version of 20.4. Regards, Chetana

Hi Team, Is there a way in Appian where we can retain the file extension as the extension that we are using in our template.We have a requirement where we are using the excel base template with in-built macro having the file extension as .xlsm and when trying to generate the excel through appian process the file extension is getting changed to .xlsx.Any suggestions? Thanks

Hi All, I have configured the appianseleniumapi with example projects given.  AppianSeleniumapi 22.1.1  jar file's Basefixture/sitefixture/tempofixture not contains readlines() function. Common.io.utils jar contains readlines(). I have installed common.io 2.11.0. I am getting the below error. Exception in thread "main" java.lang.NoSuchMethodError: 'java.util.List org.apache.commons.io.IOUtils.readLines(java.io.InputStream, java.nio.charset.Charset)' at com.appiancorp.ps.automatedtest.common.PropertiesUtilities.loadProperties(PropertiesUtilities.java:28) at com.appiancorp.ps.automatedtest.fixture.BaseFixture.<init>(BaseFixture.java:66) at com.appiancorp.ps.automatedtest.fixture.TempoFixture.<init>(TempoFixture.java:104) at com.appiancorp.ps.automatedtest.fixture.SitesFixture.<init>(SitesFixture.java:11) at com.appiancorp.example.HelloAppian.main(HelloAppian.java:22). Kindly help to resolve.

Can someone explain how to configure the "Add Documents to Zip" node? I just want to add the selected images to zip file. Thank you.

Hi All, I am trying Automation with Appianseleniumapi. I have downloaded AppianSeleniumApi from appmarket and  have followed the steps provided in the document https://community.appian.com/w/the-appian-playbook/2304/automated-testing-with-appian-selenium-api. when running the project in eclipse , i am getting this below error kindly help.

Hi, Is there any smart service or plugin that can mass delete first X rule/process model versions. Thanks

We are looking at using the Parse Excel to CDT to parse excel data into a table.  Does anyone know if this process has protection to prevent SQL Injection? Thank you

Health Check report shows the following message about Deprecated Plug-Ins with no further details. How can I find out which plug-ins are being flagged here?

I want to click on card choice fields, can someone tell me what script should I write? The following is the card choice field that we are using a!cardChoiceField(label: "Activity Choices", labelPosition: "COLLAPSED", data: local!activities, cardTemplate: a!cardTemplateTile( id: fv!data.zlkActivityType, primaryText: fv!data.zlkActivityType, icon: choose( fv!index, "briefcase-medical", "microphone", "briefcase-medical", "microphone", "microphone", "briefcase-medical", "microphone" ), showWhen: isnull(fv!data.zatParenttype) ), value: local!selectedActivity, saveInto: local!selectedActivity, maxSelections: 1, align: "CENTER", showShadow: true )

Need to read the data from the excel and save it into an variable

Hi, We have a project requirement where we need to pass an array of images into a grid, each row with a different image. The grid is already configured, but we can't seem to manage to pass dynamically an array of images into the grid - they are appear repeated across all rows and for each row, we want the image that corresponds to that row position. For row 1, we want image 1, for row 2, image 2... Current output Expected output Currently, we are defining the barcode image column like this: And the node is configured currently as: My suspicion is that Appian can't iterate automatically throughout the array and position each image in each row but I'm not really sure how this can be achieved. Kind regards

New to Appian, have been through the developer training but have not taken the test yet. I have a request to be able to upload a Excel file and then parse the data and insert into a table. I have been looking at the Parse Excel to CDT to do this since this is the option our Appian has. Trying to wrap my head around this and have been trying to find examples. Does anyone by chance use this and is there documentation some place for this? Does anyone have a sample process model showing the steps on how it was done? Also trying to figure out the configuration on the plugin as well. Basically the user will upload the excel file, then parse data from excel into CDT then use the CDT to write to the database. Thank you for any help.

Hi, Can anyone let me know if integration to SAP Netweaver is possible from Appian? The Appian version I am referring to is 20.4/21.4. Or let us know if it is possible only with the latest versions. Regards, Chetana