Discussion Categories

Hello, I'm trying to generate document from XML code, I'm able to get the expected data if the data was single dictionary, but i have a requirement to generate document for a list of data items. I have already seen many of the community posts, I followed the same pattern to generate doc using xml code, but I'm getting an error, says that syntax error in template. Please let me know what i have done wrong here. ERROR: Syntax error in template "fr.opensagres.xdocreport.document.docx.DocxReport@3ad77c4f!word/document.xml" in line 4, column 1468:Encountered "\" \\b @before-row</w:t></w:r><w:r><w:rPr><w:noProof/></w:rPr><w:t>${d.@name}</w:t></w:r><w:r><w:rPr><w:noProof/></w:rPr><w:t>[/#list] \\b @after-row</w:t></w:r></w:p></w:tc><w:tc><w:tcPr><w:tcW w:w=\"", but was expecting pattern: <ID> I have shared the XML code and t

I have a requirement where user can pass document and it gets uploaded to an Appian's folder. I have created a WebAPI (Document Upload) and positive scenario is working as expected. For Negative Scenario (When we are not passing any document): 1. In the WebAPI , it is handled as "400- Document not provided" but when testing we are getting status-200 (Untitled document from web API.txt). Q. From where we are getting this "Untitled document from web API.txt" document. Where is it handled? Q. How to fix default handling?

Hi All, Is there any way we can count the pages of the uploaded document? It can be PDF, Excel, Docx, etc.  I know the document viewer field has been provided by Appian, on the preview we only can display PDF. I am looking is there any way that we can show all format documents in new tab or can count the no of pages of the document. Thanks.

Hi All, I am preparing a weekly report for User login frequency. The data is fetched from a cloud DB table which is getting enriched (picking data) from login_audit.csv. The intention of the report is to fetch all active users, and the entitlement mapped to these users. Following query is used to fetch the data and we have a requirement to add the last login details to this query. SELECT USER_NAME, FIL_UNIQUE_ID, GROUP_NAME, IS_ACTIVE, LAST_LOGIN FROM UAGR_USER_GROUP_MAPPING 

Hello,I am developing a robot that performs a registration on a website. The problem is that sometimes when I click the "Sign In" button, it shows the message "Invalid or expired reCAPTCHA token." This is not a reCAPTCHA that involves puzzles or checkbox clicks; it's just a message. If I click manually, it sometimes allows me to proceed. I have tried implementing pauses and mouse movements, but they don't always work. I would like to know if there is a viable solution to bypass this reCAPTCHA. Is it possible to add a support file to the robotic task that solves reCAPTCHA? If so, do these solutions have a cost, and which ones do you recommend? Or is there another solution?Thanks

I cannot able to use user filter in a!eventhistoryList(), even though i have added only one a!eventdata() why is that, how can i solve this ??

Hi All, I have created a new AI skill object for text generation in the Appian Dev environment. The skill was successfully created and tested with different temperature settings, and it works as expected. I have integrated it with my process model, published, and saved the model. However, when attempting to deploy the AI skill to the Test environment, the deployment fails with an import error. During deployment, there are no warnings or dependency issues shown. The deployment log indicates the following message: Problems (1):aiSkill 8292bde1-7e28-4b70-a94f-890b679ab860 "NH_Generative_AI_Skill": An error occurred while creating aiSkill [uuid=8292bde1-7e28-4b70-a94f-890b679ab860]: Name is insufficiently unique (APNX-1-4071-032) (APNX-1-4071-007) I have attempted to resolve the issue by changing the name of the AI skill, but the problem persists. Could someone assist me in identifying the potential cause of this issue? Additionally, out of curiosity, could you let me know whic

Hi  I am using Export DSE to Excel smart service. Now in the configuration part, I am using the querySelection to select the columns to be written to the final excel document Now this querySelection takes in queryColumn  Example :  a!queryColumn( field: "opsTicketId", alias: "Ops Portal Ticket ID" ) This alias is basically the header displayed on the excel sheet, but whilst using such aliases containing a ` ` space .. the smart service errors out and as a result I have to use underscore  Is there any way I could retain this space ? I do not want underscores on my header ... need it to be a proper header

Hi Experts, I have created user filter in record type the code is below: a!localVariables( local!firstName:a!forEach( items: a!queryRecordType( recordType: 'recordType!{7391bdbe-44f0-47c3-aef9-b6cac0cccc64}CA Clearance Profile', filters: a!queryLogicalExpression( operator: "OR", filters: { a!queryFilter( field: 'recordType!{7391bdbe-44f0-47c3-aef9-b6cac0cccc64}CA Clearance Profile.fields.{5d466bb8-f401-4b6a-b55d-02d26b0727d0}managerXid', operator: "=", value: loggedInUser() ), a!queryFilter( field: 'recordType!{7391bdbe-44f0-47c3-aef9-b6cac0cccc64}CA Clearance Profile.fields.{42db565a-ee39-42ef-ae07-dd9cb839ac67}managerTid', operator: "=", value: loggedInUser() ), a!queryFilter( field: 'recordType!{7391bdbe-44f0-47c3-aef9-b6cac0cccc64}CA Clearance Profile.fields.{6db2376a-bf6e-47f5-939f-2363e5fa5721}telusVp',

Hi All, We have Requirement to show the picker field as Multiple Value selection where the value is storing as”Test1;Test2;1;55”. Please find the below details & suggest any alternatives.  Requirement: To show the picker field selectable as Multiple value. Analysis: For the Suspect product column, the values are storing in the table as “Test1; Test2;1;55” which means combination of static and product ids. Since the valued stored as single string in the table while showing in the grid we are retrieving the data by using queryfilter with “Includes” operator in the a!recordData() so the in the picker it is working only for one value & returning the data. And “In” operator is also not working to return the multiple data. Plan: Creating the trans table and storing all the records of suspect product with one-to-many relationship way. Issue: As the Existing data having 34000+ records in the Master table and each record may have mor

I am experiencing an integration error while attempting to connect to a Start Process Web API within the same environment. I have tested the connection using Postman, and it works fine.

Hi everyone. I added a new Decimal field to one of my DB tables, but when I try to map this source field to the corresponding record field in Appian the Number (Decimal) type is not available in the dropdown (please see the screenshot below). Does anyone know what could be the reason for that? Even Appian recognizes the source field as Decimal, but still doesn't give me a proper option in the choice list. I would appreciate any advice on this matter. Thank you.

Hi Experts, I have created a WEB API in which i am validating IP Address and email. Based on that I have created Integration which called that WEB API . Then In integration if I pass IP parameter null and only email is passes than it gave an error.  Please help me how can handle it . Below is WEB API : a!localVariables( local!invalidipAddress: a!flatten( a!forEach( items: split( split( http!request.queryParameters.targetIp, " " ), char(10) ), expression: rule!CDM2_ER_IP_Address_Validator(fv!item) ) ), local!isInvalidEmail: if( a!isNotNullOrEmpty(http!request.queryParameters.email), not(rule!CDM2_ER_Email_Address_Validator(http!request.queryParameters.email)), false() /* If no email is provided, assume valid */ ), local!confirmIP: { ipInfo:if( and( a!isNotNullOrEmpty(http!request.queryParameters.targetIp), length(local!invalidipAddress) > 0 ), "Entered IP Addresse

I´m doing the Appian Developer Course, and in the Build an Application Step by Step part 5 I have this error, related to the Record Type: Expression evaluation error at function a!gridField_23r3 [line 51]: A grid component [label="null"] has an invalid value for "columns". A grid column [label="Image"] has encountered an error. Expression evaluation error at function a!imageField [line 52]: User Does Not Have Rights to Perform this Operation. Can someone help me with this error?

When we upgraded the plugin from version 3.0.3 to the latest version that is 4.1.0, we started facing the following error: 2025-01-17 19:24:41,547 [http-nio-8080-exec-804] ERROR com.appiancorp.ps.plugins.filetransfer.sftp.ReturnRemoteFolderContentsOverSFTP - com.jcraft.jsch.JSchException: Auth fail for methods 'publickey,password,keyboard-interactive'Please advise.

Hi, I have a very simple need : I have a main Interface (Intf_A) displayed from an User Input task user of a process (Pr_A). In that interface I have a Button (related Action) used to display another Interface (Intf_B) which is a start Form of another Process (Pr_B). In Intf_A I have a Text field, and when I click on the Button, I need the text value to be passed to the IntF B. How may I do this without saving first the Text value in DB ?

Appian UX Design Lab is a YouTube livestream series where you can get live feedback from Appian UX design experts. Submit your interface for a chance to be featured in a live review and ask questions directly to the experts, or join us to learn from our experts as they provide actionable UX/UI design feedback. The next episode will air on January 16th, and will focus on the color use. A well-defined color scheme can improve the readability of landing pages and dashboards, highlight calls to action, and stimulate interactions in a less intrusive manner. For this round of UX design lab, please submit a landing page or dashboard that uses color to highlight key information or encourage a specific interaction. What's in it for you? Submit Your Design: Create or replicate a UI in the Appian Community Edition environment, and then share the link to your work by going to https://ap.pn/41foJH5. Get Expert Feedback: Selected applicants will receive a live UX review from one of Appian&rsquo

HI all,  while uploading the document via upload file is there any option to check the Invalid multipart content type and file ending combination? if user uploading the multipart content  document  we have restrict the user not to upload the document.. Thanks In advance.

Hi all please help me modify my code to give 3 breadcrumbs as I have achieved to give 3 breadcrumbs but on clicking on 2nd I'm coming back to 2nd but clicking on 1st I'm not able to come back to 1st. I attached my code where there are 3 rule inputs , in which showsubmodule and show pdf is boolean and selection is list of number  { a!localVariables( local!currentNodeId: if( ri!showSubModule = true, if(ri!showPDF, 3, 2), 1 ), local!nodes: a!forEach( items: enumerate(local!currentNodeId) + 1, expression: choose( fv!item, a!map(name: "Knowledge Base", identifier: 1), a!map(name: "Sub Modules", identifier: 2), a!map(name: "Show PDF", identifier: 3) ) ), a!cardLayout( contents: { a!richTextDisplayField( labelPosition: "COLLAPSED", value: { a!forEach( items: local!nodes, expression: if( fv!isLast,

Hi , Can anyone help on how to achieve this please . Thank you in advance for your help. a!localVariables( local!values: { true(), false() }, local!labels: { "Yes", "No" }, local!dropd1: null(), local!dropd2: null(), a!columnsLayout( columns: { a!columnLayout( contents: a!dropdownField( label: "Dropdown 1", choiceLabels: local!labels, choiceValues: local!values, placeholder: "Select a value", value: local!dropd1, saveInto: { local!dropd1, a!save( local!dropd2, a!match( value: local!dropd1, whenTrue: fv!value, then: false(), default: null() ) ) } ) ), a!columnLayout( contents: a!dropdownField( disabled: and(local!dropd1, not(local!dropd2)), label: "Dropdown 2", choiceLabels: local!labels, choiceValues: local!values, placeholder: "Select a value", value: local!dropd2, saveInto: { local!dropd2 } ) ) } ))------- This works but  Hi , For example If i have local!labels: { "Yes", "No" ,"Others", &

Hi,  When trying to convert the DOCX from the Template it is not retaining the Font Color while using DocX from dynamic template Smart Service. Below is the template Format with the Font ColorDoes anyone have the solution how to retain the Font Color

We upgraded the SFTP Functions plugin to 4.1.0, now we are getting below error while recieving or sending files using SFTP: "Algorithm negotiation fail: algorithmName=""server_host_key"" jschProposal=""ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256"" serverProposal=""ssh-rsa""" The same smart service (SFTP) worked fine with the Plugin version 3.0.3. Any idea on how to fix the issue?  [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05] [mention:92ac9d4559ff43edb28eaa01ed77691b:e9ed411860ed4f2ba0265705b8793d05]  [mention:cd654a5ec99f4d9eb3afb367bbce9958:e9ed411860ed4f2ba0265705b8793d05] [mention:65f6155ee76a44fdb6ad252c54a7b56d:f7d226abd59f475c9d224a79e3f0ec07] [mention:a9315dfc069b47ac8a942fc16202b2e9:46448885d0e64133bbfbf0cd7b0fd6f7] [mention:132192b29a8949549f7724f828fb782a:46448885d0e64133bbfbf0cd7b0fd6f7:l

Hi All , I am facing a strange issue with my interface ,Yesterday I have worked on one of the interface ,I have clicked on save and publish also ,later some time I have opened that interface and I am not able to see any code in expression of that . It opened like unnamed interface, but code in that interface is working fine in the dependent interface. When I am trying to open that interface it is opening like a new interface(unnamed interface).I am not able to deploy the same interface from another environment also. Can anyone please let me know the solution for this issue?

This error occurs on start process. Please somebody explain this error.

Hi guys, I'm on Appian version 23.2, I need to create a process that deletes all documents in a folder, all, not one. I have not found any component to do it, can you help me? Is there an option to do this?