Discussion Categories

Hi Team,I have created a WEB API in Appian only  which is used to Write data to tables.I want to use this WEB API on Interface load. How can we do that ?Regards,Abdus Samad

What is the most efficient way to import a daily CSV with 1 million rows from s3 into an Appian? (On daily basis we have to truncate the table and load the new data).

Now,I'm learning Appian Service Backed Record Types following Appian tutorial video and reference links. ・videowww.youtube.com/watch ・linkdocs.appian.com/.../Sync_Records_Smart_Service.htmldocs.appian.com/.../Sync_Records_Smart_Service.html I have implemented it as shown in the attached screen, but it is causing an infinite loop. If anyone knows, please provide the details of how to implement it correctly.

while opening the site user facing the below issue and after some time its getting resolved automatically  DOCTYPE "... is not valid JSON appian please help me on this how we can resolve the issue , its happening frequently. Thanks! Suresh

I have few record which I build them in Appian and save into DB. Below are records which I build in Appian which has "doddapap" my id for created by and updated by fields. But on writing these records DB these fields are getting updated with "Administrator.   Can Someone help me fixing this. 

hi, I'm trying to create the custome field as screenshot below. my goal is for the same task, preparer cannot be the reviewer. so I need the ID so I can filter the record out based on loggedInUser() the criteria: same date, same task, different Stage also it would be easier to change the status from Preparer to Reviewer. Thanks,

Hi Appian Community, I'm facing an issue where the email content is being sent with only partial text, and some parts of the HTML text are getting removed. Below is the HTML text I’m using for the email body: html Copy <p><span style="font-size: 10pt;">Dear colleagues,</span></p> <p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" 0in;padding:0in;mso-ansi-language:en-us'="" style="font-size: 10pt;"> </span></span><span style="font-size:10.0pt;"></span></p> <p style="text-align:start;"><span style=""><span windowtext="" 1.0pt;mso-border-alt:none="" '="" style="">Please note that the EU approval by CHMP Positive opinion has been granted on 05 December 2024 for </span><span

My record type title displays some dynamic data that needs to be refreshed before the related action is completed, does anyone know any way to achieve this?

My goal is to write into excel in multiple sheets using the "Export Data Store Entity to Excel" ability. I may write few values from process variables too into the excel sheet - apart from what I have in the database. So I have an excel sheet as template and wanted to leverage the "Custom Cell Positions" and "Custom Cell Values" ability in the "Export Data Store Entity to Excel" smart service to put in the values in the desired position of the excel sheet. I may end up putting atleast 50 values in a sheet. But I keep getting this error, even when I attempt to put couple of values using the "Custom Cell Positions""Custom cell positions cant refer to cells below the starting cell. Otherwise, they would be overwritten by data being exported. (APNX-1-4505-037)" I tried to use this simpler option too and still get the same error.Custom Cell Positions={"A6", "B6", "A7", "B7"}Custom Cell Values

I am trying to import the newly released Case Management Studio application package, but getting below precedent missing error while inspection for most of the record types from package. The content [id= uuid=_a-0000e9ae-873e-8000-9baf-011c48011c48_97439] was not imported because a required precedent is missing: recordField [uuid=SYSTEM_RECORD_TYPE_USER_FIELD_username location=Expression Rule Definition] in record type [id=1 uuid=SYSTEM_RECORD_TYPE_USER] cannot be found. (APNX-1-4070-005) (APNX-1-4071-006) The username field is available in the User system record of the Appian environment where I am trying to import the application and it is upgraded to latest 24.1 version.There are other fields that are not available in the User system record and I am getting missing precedent error for those fields as well. Those fields are: SYSTEM_RECORD_TYPE_USER_FIELD_firstAndLastName, SYSTEM_RECORD_TYPE_USER_FIELD_isServiceAccount Attaching screenshots of fields available

Hi there,  We have a loop to constantly check an expression rule until it returns true. On each loop we have a 30 second timer to wait. All the other nodes were able to be setup to delete previously completed instances, but the timer node doesn't seem to have this option, which means the loop is breaking when it hits this node for the 1000th time. Is there any way around this? Thanks, John

Hi I want to Calculate the date difference in to Months and years  form given dates  date1: 15 Jan 2022 date2: 15 Jan 2024 date2-date1 ANS= 2 years In Appian date difference  date2-date1 is calculating only days  730

I have a record type which contains about 45000 records. I need to build a dropdown that shows all 45000 records but maximum limit in batchsize in queryRecordType() function is 5000. How can I display 45000 records in a dropdown list?

HI, i'm devloping an application to store and track all the devices in the comapny, and users needs to update device details like current assignee, status, location and device condition, My question is what if one of the users wants to update the asignee and location or device condition at one time how can i capture the event ID in this case? i need to store in the logs that assignee has been updated and location has been changed, what is the best solution here? 

I am experiencing issues across all my Record Types in Appian. Below are the details of the errors: When access any Record Type, I receive the following error: The data source cannot be reached or its configuration is invalid. Please contact your system administrator. There is an option to "Change Source Configuration," but upon accessing it, no modifications can be made and says: Editing the source of the record type will break all configured relationships.You do not have access to the configured data source. You can choose other data sources and tables, but you will not be able to select the original table again. When trying to access the Data Preview of the Record Types, another error appears: The System Has Encountered an Error HTTP Code: 500 APNX-1-4198-000 Error Evaluating UI Expression Expression evaluation error [evaluation ID = 2DENF]: Array is expected as second parameter, but received: . Additional Information: These errors seem t

I have a requirement where i  am updating the constant by using update constant smart service .The constant is having multiple values when i am updating the constant all values are getting updated with new value.Is there any way where we can update the constant at particular position. Example: I have a constant with values {"Apple","Grapes","Orange"}, by using update constant  smart service i need to update constant value Grapes to Pomegranates remaining values should not be modified. Thanks in advance

Why does the below peice of code does not work with records as rule input.  if( fn!isnull(ri!array), true(), length(ri!array) = 0) If I pass empty record in ri!array it should return me true, but it is returning false.

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

Looking to create a DSE to existing Appian cloud database or any recordset in the Appian Community Version. Not able to find any instruction or guidance where I can accomplish this. Can I get some information or help on this?

We have a synced entity based records with 13,000 and 50,000 rows respectively. However when trying to export the excel from the record list without applying filters will not do anything (not downloading even a blank excel), However in some cases applying filters download the excel but sometimes not. I looked into tomcat-stdOut.log I see this error message. 2024-03-28 17:52:52 WARNING [http-nio-8080-exec-558] com.sun.jersey.spi.container.servlet.WebComponent.filterFormParameters A servlet request, to the URI example.appiancloud.com/.../download-grid, contains form parameters in the request body but the request body has been consumed by the servlet or a servlet filter accessing the request parameters. Only resource methods using @FormParam will work as expected. Resource methods consuming the request body by other means will not work as expected. Not sure how to resolve this or what needs to be corrected. Any ideas or suggestions?

Hi, We have 3 interfaces and 1 RecordType. 2 Interfaces call a RecordType and the latter calls a third interface. Example:    InterfaceA => RecordType => InterfaceC    InterfaceB => RecordType => InterfaceC  My Question: How the InterfaceC may know which source Interface (A or B) have called the RecordType please? The 2 interfaces A and B calls the RecordType with a RecordLink like : link: a!recordLink( recordType: cons!TST_RECORD_TYPE, identifier: fv!row.id ) The RecordType calls the InterfaceC using the Summary action (Tab View).

Hi,I have a situation where I have 2 groups, one is an administrator group and the other is a basic user group.There is a basic user action to submit a comment and upon submitting, an email will be sent to the members of admin group and basic group.Now while a basic user adds comment and submit it, there is a process error which says - An error occurred while evaluating expression: =toemailaddress(  a!forEach( items: a!groupMembers( group: cons!HS_ADMIN_GROUP,      direct: true,      memberType: "USER"    ).data,    expression: user(fv!item, "email")  )) (Expression evaluation error at function a!groupMembers: Expression evaluation error at function 'a!groupMembers': Insufficient permission). FYI - Process model security --> Admin group - administrator access, Basic user group - Initiator access.Can someone help me fix this issue.Thanks in advance

I have created these two below Expression :  a!localVariables( local!matches: where( a!forEach( items: ri!labels, expression: search( ri!filter, fv!item) ) ), a!dataSubset( data: index( ri!labels, local!matches), identifiers: index( ri!identifiers, local!matches) ))UI Snippet :  a!localVariables( local!pickedState, local!stateLabels: { "Alabama", "Alaska", "Arizona", "Arkansas", "California", "Colorado", "Connecticut", "Delaware", "Florida", "Georgia", "Hawaii", "Idaho", "Illinois", "Indiana", "Iowa", "Kansas", "Kentucky", "Louisiana", "Maine", "Maryland", "Massachusetts", "Michigan", "Minnesota", "Mississippi", "Missouri", "Montana", "Nebraska", "Nevada", "New Hampshire", "New J

Hi all, I was wondering if it's possible to provide context to and between user filters in a record? So if the user enters a value somewhere on the interface, can this value then be used to update a record filter? Like to update the list of options that are available? And is it possible to change the list of options in a filter based on what's been entered in another? Looking at the documentation I don't think you can, but I just wanted to double check. Thanks!

I am unable to find an example illustrating the appropriate content that should be included within this file to localize the function category name