Discussion Categories

I have configured a Chat Agent named "Roster Assistant" using a!agentChatField with the following setup: The agent is connected to our Roster Record Type as a tool. Field-level instructions have been configured within the record type. Agent goals and instructions are designed to: Respond to greetings such as "Hi" or "Hello". Retrieve and return roster information for users. Problem The agent does not respond as expected. Regardless of the message sent—including simple greetings like "Hi"—the chat either takes an unusually long time to process the request or eventually returns an error. Additionally, when reviewing the execution in the Monitor tab, the agent run remains in a "Processing" state for an extended period before ultimately failing with an error. As a result, the agent is unable to provide responses for even basic interactions, making it difficult to determine whether the issue is related to the agent config

These days I have seen developers moving to using database tasks rather than a traditional User Input Task approach. What are the possible advantages of using DB tasks in terms of reducing memory footprint, creating short lived processes, performance, concurrency and auditing? Any way whether a process task report or using DB task, we'll be creating tasks to save task IDs, then how it is different and advantageous in comparison to process task report approach?

I'm building a small PoC where i need to write to an Excel spreadsheet. i need to save my data in certain cells positions.Everything i'm finding points me to use the Export dataStore to Excel Smart service and to specify those cells positions in the node input using the twocustom cell position / custom cell values.My problem is i don't have a CDT to load from, this is a purely sync records PoC. do I really have to build a CDT structure to get this to work ?

I am currently working through the Appian developer learning list, and have come to the Visualize Your Data: Reports and Dashboards lesson (https://academy.appian.com/#/online-courses/816ad062-560d-4de5-a764-531290a3e562), however there appears to be no content whatsoever. Appreciate this could be a issue specific to me, however the reviews are all very negative so figured it may not be. If anyone is able to confirm the issue/let me know where to raise it to, that would be perfect .

I am using SQL to Excel smart service and when exporting the data in excel, the headers are not coming in BOLD

We have an external event that can impact up to 1M+ Case records. For each affected Case, we need to: Update 3 fields in the Case table. Create a corresponding Event History record. We're evaluating the following approaches: Option 1 – Appian Write Records Approach A Query Cases in batches of 5000 Use MNI to process each Case in a single Write Records node to update the Case and create the corresponding Event History record Loop until all affected Cases are processed Approach B Query Cases in batches of 5000 Update all affected Cases for the batch in a Script Task Construct the corresponding 5,000 Event History records Use one Write Records node to bulk update the 5000 Case records Use a second Write Records node to bulk insert the 5000 Event History records Loop until all affected Cases are processed Option 2 – Stored Procedure Use a stored procedure to bulk update Case records and bulk insert Event History records Persist affected Case IDs and Event History

Hi all I have a requirement to build a WEB API and a Process model to update other external system. The request to the web api is: { "accountNumber": "20171941", "houseNumber": "13329892", "contractStartDate": "2022-08-25T00:00:00.0000000+01:00", "contractEndDate": "2023-08-25T00:00:00.0000000+01:00"} From the WEB API I am using the function a!fromJson to get the values for the process model from the http!request.body, as usual. When we validate the process model and it execution the dates on the request changed from 2022-08-25T00:00:00.0000000+01:00 to 8/24/2022 11:00 PM GMT+00:00. I understand that the JSON functions detects the Date but we really need to keep that format from the request. Any Idea?  Thanks Mario

Hi Team, We have a dashboard where we display Test Cases in a read-only grid. The grid is built using the recordData() function, and we have enabled the “Export to Excel” option provided out-of-the-box. Users are able to click this option and successfully download the Excel file. As part of our document cleanup process, we are deleting Excel documents generated within the application. Currently, we are able to identify and delete documents that are created via our custom export functionality. However, we have a question regarding the Excel files generated through the Record Type’s inbuilt “Export to Excel” feature: Are these exported Excel files stored anywhere in Appian (e.g., in Appian Documents or temporary storage)? If yes, is there a way to identify and delete them as part of our cleanup process? Or are these files generated on-the-fly and not persisted in Appian? Any clarification or guidance on how Appian handles these export files would be very

Hi team, We're struggling the the disk usage of our training environment as it's reaching its full capacity, there are several applications that can be deleted completely. However, there's no bulk deletion of applications including its contents, out-of-the-box. Do you know any easier way to perform these deletions?  P.D.: We would like to delete the DB objects (tables, views, etc) related to these applications as well. Thank you in advance! Regards, Tomás

We are using a DocuSign integration configured and tested successfully in the development environment with a DocuSign developer account. However, we are encountering issues during the authorization phase when using the authorization link. The authorization flow redirects correctly to DocuSign, and the login page is displayed, allowing the user to log in successfully. However, after the login, the system does not return the authorization token to the application as expected. By checking the application logs, we can see the following error during the OAuth callback processing. This error appears multiple times; below is one example: 2026-04-21 05:57:39,619 [http-nio-8080-exec-794] ERROR com.appiancorp.connectedsystems.http.oauth.OAuthServlet - Error processing request to Appian OAuth callback URL. com.appiancorp.suiteapi.common.exceptions.AppianException: Failed to decrypt. Only values of type Encrypted Text can be decrypted. (APNX-1-4260-002) It seems that the OAuth callback is reac

Hi everyone, I hope this is okay to post here! I'm a certified Appian Developer currently looking for new job opportunities and not getting much traction yet. A bit about me: Appian Developer Certified Currently preparing for Senior Developer Certification [3 years] experience with Appian Open to full-time, contract, or remote roles If anyone knows of openings, is hiring, or can refer me to the right people, I would really appreciate it! Feel free to comment or send me a direct message. Thank you in advance

Example -  Validation: Filename cannot contain special characters (for example, / \ ; : " | ? ' < > * ).  Expression evaluation error: Syntax error. Details: Expression evaluation error : Invalid character found in expression: | 

We are using Rich Text plugin(Vuram) in our application and facing multiple issues some of them are - Copy the data in specific format and paste that in the editor. This does not maintain the formatting but disturbs the copied formatting - Generating some extra metadata within HTML tags causing failure in the document generation - Nested list items is not maintained too What are the options we have available to avoid such issues as the data formatting while copy paste or manual is prime requirement with the proper HTML generated by the plugin.

Hi, we are using the function a!sapInvoke to integrate with SAP throught RFC. Weeks ago, the integration worked  and we received the results expected. For development requirements, external system add some parameters and change the lenght of some text fields (from 20 to 25). After those changes, we receive errors on specific fields, but the return message gives a value that doesn't match the one sent. So, we check with external system and the problem is on all fields. For example, if we pass the parameter of the below images, external system receive as key1 the value "ABC/AAA/456789001/20ABC". It seems it takes the first 20th char and then take the others from key2. ICould you help us to understand the nature of the problem, please? Thanks in advance. Regards

I am building POC using a grid plus component, i need help solving below two issues 1. when i try to add custom validations like preparerDueDate<RevieweDueDate it does not validate properly. Even if one row has the validation to true, the message shows on all row for that field. 2. I have a column that cannot be edited when once added, when creating a new record i need the column to be editable. how can i achieve this functionality? Thanks in Advance.

Issue with Dynamic Identifiers in Materialized View Causing Sync Failures We are consuming data from an external view that only returns records where: BPM_PROCESSING_STATUS IS NULL BPM_CASEID IS NULL This external view is built on top of a base table that contains all records. Current Implementation When a case is created in Appian, we update the base table using a Query Database Smart Service, populating: BPM_CASEID BPM_PROCESSING_STATUS (e.g., PENDINGFORAPPROVAL, REFERREDBACK, PROCESSED) Since we do not have access to define a primary key on the source table/view (due to grant restrictions), we: Created a Materialized View on top of the external view Added a synthetic identifier column: SQL 1 ROW_NUMBER() OVER (ORDER BY UNIQUE_ID) AS ID Show more lines Built an Appian Record Type using this materialized view (to leverage record filters, etc.) Created a stored procedure to refresh the materialized view Used: Execute Stored Procedure Smart

Hi, i´m facing a refreshvariable problem, this code call a rule caled rule!slc_obtenerPolizas(idSiniestro: ri!siniestro.idSiniestro) local!refrescarPolizas: false, /*REGLA QUE OBTIENE LAS POLIZAS*/ /*Y COBERTURAS*/ local!polizas: a!refreshVariable( value: rule!SLC_obtenerPolizas(idSiniestro: ri!siniestro.idSiniestro), refreshOnVarChange: local!refrescarPolizas ), rule expression is this:  a!localVariables( local!polizas: rule!SLC_GetObtenerPolizasByDeclaracionID(idSolicitud: ri!idSiniestro).data, local!ramos: a!forEach( items: local!polizas, expression: a!update( fv!item, "ramos", rule!SLC_GetObtenerCoberturaByPolizaID(idPoliza: fv!item.idSiniestroPoliza).data ) ), local!ramos ) which call a two api, we cast json into CDT.  a!localVariables( /* 1. First, configure the integration object to return successfully */ local!integrationResponse: a!refreshVariable( value: rule!CT_SLC_getCoberturaConsultarxPolizaID(

I am building POC using a grid plus component, i need help solving below two issues 1. when i try to add custom validations like preparerDueDate<RevieweDueDate it does not validate properly. Even if one row has the validation to true, the message shows on all row for that field. 2. I have a column that cannot be edited when once added, when creating a new record i need the column to be editable. how can i achieve this functionality? Thanks in Advance.

Hi Team, We have a requirement of querying all processes with an error in our application and send recurring reminder emails to fix that problem (every 5 minutes). Process Report seems to not have such feature. Can anyone please guide on a potential solution here? Thanks!

Hi  In Ui there was user picker field if i choose more than one (max selection is 3 ) and submit request after that in read only the selected users we are showing in summary dashboard there user want first name and last name to be displayed instead user name  Below is the logic i am using to display selected user details in text field a!textField( label: "Requested On Behalf:", labelPosition: "ADJACENT", value: a!forEach( items: a!defaultValue(ri!MDSRequest.requestedonBehalf, {}), expression: if( a!isNullOrEmpty(fv!item), {}, if( a!isNullOrEmpty(touser(fv!item)), {}, user(touser(fv!item), "firstName") & " " & user(touser(fv!item), "lastName") ) ) ), readOnly: true, showWhen: a!isNotNullOrEmpty(ri!MDSRequest.requestedonBehalf) ) } ), If i select two means more than one i am getting below error i selected valid users only still getting this error also before upgrade logic worked after version upgrade i am seeing this c

We have an external supplier portal in Appian where we need to implement MFA to hide sensitive sections on interface until verification is completed within the session. Preference is to avoid app-based authenticators as some suppliers are hesitant to install anything. Has anyone implemented something similar? Looking for suggestions on: Step-up MFA approach for external Appian portal users Conditionally showing/hiding sections based on completed verification App-free options like email OTP or SMS OTP that work well in Appian

We have a requirement for comparison of same record type data and get the difference of the data & columns. We are aware of "CDT Diff Utilities" which does the same operation and gives the expected output. However we are looking for similar way of plugin availability or workaround to achieve the desired functionality. Note: We are not looking for manual comparison of the record fields and the data, as we need to perform the comparison across all record types in the application and it will be become very tedious process to achieve by manual comparison.

I am looking for some guidance on generating large PDF documents in Appian.We have an existing site page that displays more than 13,000 records. As part of an export feature, we retrieve the data, generate XML content, generate a word document and then convert it to PDF (using Advanced Document Templating plugin). Currently, the export process retrieves around 3,000 records. Each record contains several large text fields (around 5 - 6 columns) so the overall amount of content is quite large. The word document is generated successfully and is about 768 KB in size and has approximately 5 million characters. The issue occurs during the word to PDF conversion. The conversion starts, but it appears to consume significant resources and causes the environment to become unavailable.  My questions are: 1. Are there any known character limits for Word to PDF conversion plugin?2. Are there any alternative plugins or approaches that are better suited for large documents? I understand

Hello, I have built a chatbot in appian. I have two objects in my interface. First is a text box, which takes user question. And, the second is a button user clicks to send question to AI bot and get response. Currently, when text box loses focus, a local variable called isProcessing is turned to true(So the user can be shown that processing is occurring). And, when the button-press returns with AI response, the isProcessing is turned to false, and the AI response is shown to user. I want to have it so that when the text box loses focus, the local variable isProcessing is turned to true, as well as data being sent to AI bot. And, then when AI bot returns, the isProcessing is turned to false, and result shown. Is this possible? Thanks for your time.

I am currently preparing for the Appian ACD101 exam and came across a question that I am not completely sure about.Questions: How do you refer to the metadata of a process model object within the process model expressions? For example: the creator, name, or description.A- Process Properties, referred to in process model expressions using the pp! domain. B- Process Variables, referred to in process model expressions using the pv! domain. C- Process Model Properties, referred to in process model expressions using the pm! domain.Which option is correct, and how would you explain the reasoning behind it? I would appreciate any insights from those who have studied this topic or have recently taken the ADC101 exam.