Best Practices

Hello,  I am having trouble with the following use case : we receive 3 large Excel files daily (~60 000 rows and 40 columns), that we need to read and write into Appian Cloud Database. So far, we've been doing that this way :  1. Use an ETL to read the file and batch the extracted JSON data 2. Send the data in batches to Appian with an API exposed by Appian 3. The API triggers a process that write the data to the table (Using the node Write to Data Store Entity) However, this approach is starting to cause some memory issues, as there is more than 150 processes trigerred daily, and each of these processes contains large process variables (even with batching, we still have 150 processes dealing with 500 rows each). I am wondering what would be the best way to deal with this issue according to best practices. I've thought about using a!writeToMultipleDataStoreEntities directly in our API instead of triggering a process, to avoid having too many process running, but

Hi, I am currently interested about best practices for process deployment, and I've read a thread (please see the link below) about a critical issue. I've read a reply explaining that "key-value pair mapping" is a best practice for connecting Interface/SAIL with process to avoid deployment issues. Could you explain me what this best practice is about please ? or just give me a litlle example ? Deployment issue :[mention:92d5c8846e574db9a3de2720dbfefcc8:46448885d0e64133bbfbf0cd7b0fd6f7] Process Best practice :[mention:d6e94ce985b94acfbda1889c02640965:f586769b0822468ab7f3a94d480ed9b0] Regards

Hi, I have section of questions using 15 fields of a cdt (cdt has total 30+ fields).  Based on a dropdown value change, I want to make all 15 fields to null.  Is there any way I can make all 15 fields to null in one go, instead of writing 15 a!save.

Hello Devs, I have created a webAPI of template type : "StartProcess". Now this webAPI is starting the process when triggered but I want to open a form as a result of it. How can I achieve that?  Do I have to handle it inside body ? inside httpResponse of onSuccess? how to achieve that. Here is my current code for the webAPI: a!startProcess( processModel: cons!PFM_APPIANFORMTOLAUNCHROUTER_PM, processParameters: { formToLaunchLabel_txt: http!request.queryParameters.formToLaunchLabel_txt, formToLaunchParameters_txt: http!request.queryParameters.formToLaunchParameters_txt, processInstanceAppianId_int: http!request.queryParameters.processInstanceAppianId_int, }, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, body: a!toJson( { taskID:getactivetaskidsforprocess( fv!processInfo.pp.id ) } ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader( name: "Content-Type", value: "application/jso

Is there any possibility that load() and with() will be discontinued ??  is there any possibility that load() and with() will be deprecated We have a!localvariables to do the same thing more efficiently.

Hi Team, I have below text and I want to convert it into a Date and Time. Example: Text:  "01/07/2025 12:00:35 PM" Date and Time: 01/07/2025 12:00:35 PM or 01/07/2025 12:00:35 PM GMT+00:00

I have an process model , getting ids and looping via batch vise. Im npt getting a error or data is not updating the same process model is showing in the Health Check Report that {<PROCESS MODEL NAME>tGet list of caseIds scheduled to process- (11 nodes in loop)}

I have got a input string like "[key1:value1,key2:value2]", how to get the value by key?

Are there any official, generic guide lines when it comes to retention of information stored in the database and the documentation stored in knowledge centers (when to archive, eliminate, how to handle such situation)? It's obvious we'd have to tailor it to our specific application but I wanted to start by observing any suggestions given by Appian.  Best Regards.

Hi All, I am having a specific situation where I need your feedback and suggestions. There is a Record A pointing to Table A and Record A is having relationship with Record B (Table B). For some reasons I have created Record B1 pointing to same Table B and added the relationship in Record A. What could be the issue / performance issue with this type of relationship? Note: This is only one relationship I have explained in above example,  in actual we have more then 10 such relationships.

Hello, I have a use case where i have to provide all record Id's and record name in Picker Field. Users can select from it. I have been fetching only id and name column from DB table . Now the records count is less ,so it is fine. But in future if I have more Records what would be the Best Approach I can take on this.  Thanks in Advance!

The Output is True ,why

Hi How to use MNI and activity chaining effectively.In process model i got this message . I worry about performance.Thanks

In Appian we can use a records fields by square bracket notation or index or dot notation. what to use where ,what is the best practices , i heard indexing is the best.in some places its not working ,i don't have clear understating  

for explaining sake im using this examples  Let's say local!role : index( local!lookupDetails, wherecontains( cons!IHL_TXT_R_ALL_CATEGORIES[1], index( local!lookupDetails,"role" null ) ) ) i need to use one values from the record in my UI many places for that can i  hold it in one local and pass wherever needed. or can i use it directly wherever  i needed if so i need to call index,whereconains in many places right dont it consume memory  and it will make the code repetitive lines get increasewhat is the best practice. 

To Hide/Show Component  We can use showwhen,and/or,match,if for logic which is best and what to use where

Is it advisable to do the following on a task script node? It hasn't given me any problems so far. Suppose I have two variables pv!variable1 and pv!variable 2 In my first custom output I have 1+1 saved in my pv!variable1and in my second output I have pv!variable1 + 5 saved in my pv!variable2 . When using the two variables in my outputs, could there be a problem that it does not finish saving or executing correctly?, assuming that it could be a more complex rule, or a query in my first output. My specific question is whether these outputs are executed in sequence, always waiting for the first one for the second to begin.Is there any certainty about the order of execution of the inputs and outputs of a script task?

what is the main difference and what to use where

Hello everyone, I have appian servers in main site and i want to built DR for the servers, i am planning to replicate the servers by replication tool called ZERTO from main site to the DR site and i will change the servers IPs in the DR, and once the issue happened to the main site, i will power on the servers in DR and work from there; So, is it workable solution. Thank you

We are facing multiple production incidents due to objects at different versions in all different environment.  Can any one please suggest what is the best governance practice we should follow to avoid these issues. Here, Appian support team make direct changes in Production objects mainly constants according to the incidents raised but they are not moved to lower environments. hence, when developer take changes from lower environments, it overwrites the production object, causing issues.  There are multiple heavy applications with more than 500 objects. How to keep all environments in sync? 

I’m working on a large project that has evolved over time and is composed of several independent subprojects, each developed by a different team. While these applications have their own distinct purposes, they are interconnected and together form part of a complete workflow. For context, an example would be: • Application A manages the creation of a request to build a building. • Application B is responsible for drafting the project with the architects. • Application C handles the necessary permissions for the construction. • Application D manages the hiring of staff to carry out the construction. In total, there are about ten independent applications that together form a single functional process. The challenge we’re facing now is the creation of a “parent” application that centralizes and visualizes the information from these applications, providing a global view of the project’s status and details of each phase. My concern i

Does appian have any SEO mechanism to boost the portal on the internet?

Estoy trabajando en un proyecto grande que ha evolucionado con el tiempo y está compuesto por varios subproyectos independientes, cada uno desarrollado por un equipo diferente. Si bien estas aplicaciones tienen sus propios propósitos, están interconectadas y juntas forman parte de un flujo de trabajo completo. Para contextualizar, un ejemplo sería: • La aplicación A gestiona la creación de una solicitud para construir un edificio. • La aplicación B se encarga de redactar el proyecto junto con los arquitectos. • La aplicación C gestiona los permisos necesarios para la construcción. • La aplicación D gestiona la contratación de personal para realizar la construcción. En total, hay unas diez aplicaciones independientes que en conjunto forman uZn único proceso funcional. El reto al que nos enfrentamos ahora es la creación de una aplicación “padre&rdq

Hi Appian Community, Please be informed that we have used Cancel Process Smart Service, after this Smart Service runs all instance are successfully cancelled but cancelled instance are always available in process monitoring. Is there any way to delete the cancelled instance automatically once its cancelled by Cancel Process Smart Service? Data Management Selected as Delete Process after 3 days. Will Appian itself automatically delete both the cancelled instance & other parent instance with are cancelled and showing as "Active with Errors" process with error showing as "The sub-process started by this activity has been cancelled" by cancel process smart services? Thanks and Regards, Vigneshkumar R

Currently using a!forEach and a!isNullOrEmpty to replace all null values in an array of integers with 0, but would love to learn the most efficient way to do so. Is apply() the way to go here? A different function? Many thanks for any and all help!