Discussion Categories

implement an Appian Expression Rule that validates the sequence of header values, ensuring that: The first value is "SAP Number", The second value is "Qty", The third to sixth values, if present, are "Spare", "Price", "Delivery Date", and "Remarks" , The third to sixth values are optional and may be missing,

We call the expression rule (ER) "cursor_value_from_previous_call" from the "Cursor" integration. This ER invokes another expression rule, "CursorValue," which extracts the cursor value from the integration's response body. The extracted value is then passed to ER "cursor_value_from_previous_call," which returns the JSON value in the following format: Request Body: { "cursor": { "value": "" }} Value is null for the first call, for other subsequent calls, we pass the value that we have extracted from the first call. Kindly refer the flow diagram below: I am not able to achieve this without using the logic of while loop. For loop is not helping as the variables are immutable. Any insights are highly appreciable.

Hello we have a document editing software that we wanted to embed into Appian, however at the time we could not because it only allowed links of the form https://blah We need to put in a link of the form ms-word://blah or ms-excel://blah etc etc Is that still not possible?

Hi Everyone, Since the 24.3 upgrade, we have been having trouble accessing Appian on safari browser after logging in, the screen stays blank. We have reported this issue to the Appian support team. Has anyone else experienced this problem and if so has it been resolved for you? Is there any workaround? Thanks and Regards, Anju

We recently upgraded an environment to 25.2 and when we use the  Create & Read Email Files Utilities from the App Market we are getting an error "An error occurred while creating a note" on the front end and  Could not create EML java.lang.IllegalStateException: Error while searching for service [jakarta.activation.spi.MailcapRegistryProvider] in the tomcat logs. Has anyone received these errors or know of a way to fix them.  We use this plugin quite a bit to create custom notifications to the users.

Can I call an expression rule from an integration's request body?  Note: The response of the expression rule is a JSON body. Method: POST

I want to display the data on the search screen when I return from the summary view using the back button.

Hi [mention:765e189a8fe04dcb81da7360e05696f4:e9ed411860ed4f2ba0265705b8793d05]  mukeshr0002 [mention:83200b87486f491ab4742c4178286957:e9ed411860ed4f2ba0265705b8793d05]  I am trying an experiment with Appian RPA on using ms outlook api. I added the ms outlook api dependencies, but the maven is not downloading those jars. Only jidoka-client-api jar is downloaded, no other module apis are getting download. Please let me know what i am missing here POM  4.0.0 com.appian ctnq-ms-outlook 0.0.1 CTNQMSOutlookExtraction 2.15.1 1.2 17 jidoka 9.15.3 4.13.1 UTF-8 3.6.2 4.10.0 commons-logging commons-logging com.novayre.jidoka.module jidoka-client-api com.novayre.jidoka.module jidoka-msoutlook-api junit junit test commons-io commons-io ${commons.io.version}

Hi All, I'm using for the first time the Export Data Store Entity to Excel Smart Service to add data to an existing excel template (saved as a doc in appian) (Exporting data to a formatted Excel sheet). Once I add the data to the excel it seems it adds it in the same row and erases anything on the same row that was there before, I'm trying to add the new data only in one column, different rows instead in one whole row. Does someone know if this is possible or how I should be configuring the parameters. customCellPositions List of Text String (Optional) Array of cell positions where custom cell values should be added. customCellValues List of Text String (Optional) Array of values to be added on the specified custom cell position. Or if you could recommend a different smart service to achieve this? Thanks in advance

Hello, I am working on an integration where I need to set a custom value for "boundary". The HTTP request is of Content-Type: multipart form data. The other system expects the boundary value to be "cpi".  In Headers, I set Content-Type as "multipart/form-data; boundary=cpi". However, in the HTTP request that Appian generates, Appian seems to be using a random boundary value, and ignoring the value that I have set.  HTTP request that I see:  I see this data in API trace logs.  The integration works through Postman, and I see the correct boundary set. Postman screenshot.  Thank you in advance for your help. Regards,Harish

Hello Appian community, I have a question regarding the implementation of a translation framework on record values in Appian. Currently, we are using database-backed records to store and display various referential data (such as status or list of values). I would like to apply a translation framework to dynamically translate these values into different languages when displaying a grid of record values. I am concerned about having to create a complex a!match statement to connect these values with Translation Set entries. Has anyone had experience with this or can provide guidance on the best practices for implementing such a solution using Translation Sets? Any advice or resources would be greatly appreciated. Thank you in advance!

Hi Appian Gurus, When I try to upload a file with more than 30 MB, I am getting this Appian inbuilt validation message which is totally misleading is it possbile to customize or edit this validation message in Appian On Prem environment.

Hi, I'm looking for more details about IDP, implementation directions and where can I find more help/documentation regarding this. I am new to IDP anything that you can provide would be helpful.  Thank you.

I have an interface that calls 2 different intergrations. There is data that return for both integrations, but it randomly returns null after calling it multiple times.  I have inserted where I am calling the integrations. a!localVariables( local!historyData: a!refreshVariable( value: index( rule!GET_incomingRequestHistoryByID(requestId: ri!requestId).result, "body", {} ), refreshOnReferencedVarChange: true() ), local!requestDetails: a!refreshVariable( value: index( rule!GET_allIncomingRequestsByID(refundRequestId: ri!requestId).result, "body", {} ), refreshOnReferencedVarChange: true() ), This is what my error looks like when 1 integration returns as null This is what my local variable looks like when both integrations return data: 

Complete our 2024 Learner Experience Survey to help us deliver relevant and high quality learning experiences to you! Whether you're a new Appian developer or a seasoned pro, your experiences and insights are invaluable. This is your chance to share what you love, what could be improved, and any ideas you have for making our learning environment the best it can be. The first 20 participants will receive a free Appian certification voucher to be used on any exam (a $200 value)!

Hi everyone,Is there any way to maintain an audit trail of user queries and responses monitoring for review purposes of any chat bot mentioned above.thanks in advanced

I am storing the values to sql in gmt format ,when I fetch  The data back and show it in grid Iam changing to clients timezone but it stores in db as gmt while querying and showing in grid making difference in the time I checked separately but the issue is in sql we need to conver to local timezone and use it.Is there any way,please suggest I'm using view to fetch data and show in front-end

Hi everyone, I have a use case where I need to send files to external system for validation. I'm submitting the form which is chained to itself, so that files are persisted in the Appian file system and then I'm sending this to an external system. User gets to see the progress percentage.So the problem is when Appian is very very slow ( due to other colleagues playing around, Appian internal apis are taking some time to write it  down. Any way I can check file exist in actual so that I can have some sort of delay retries?

Extract data from database tables and populate a PDF form. The PDF should contain editable and fillable dropdown fields that allow users to select values dynamically

I noticed that if I use sql to update data, the data in record type need to sync manually.  I want to know is there any way that the record type can sync automatically once I update data in db. In sync options tab I only saw Schedule full syncs, but It can't suit my require.

Hi, I am getting this issue when selecting value from dropdown for one particular user at function a!gridField_19r1 [line 71]: A grid component [label=""] has an invalid value for "columns" and "value". All "data" arrays must not contain more items than the specified "batchSize", but "batchSize" was 10 and the largest column data array had 17 items.

I have four tables; Event, Parish, Parish Profile and Parish Event. Event holds all possible events a parish can sign up for.  It has a unique key of Evemt_ID and fields Event (name of the event) and Start_Date Parish holds Parish data and has a unique key of Parish_ID. Parish Profile holds some additional information about what type of speaker they would like at their event.  Not every Parish has a Parish Profile. Parish Event hold the history of all the events a Parish has signed up for.  Not all Parishes with a profile sign up for all events.  Some chose to participate last year, but not this year. It has a unique key of Paris_Event_ID and foreign keys, Event_ID and Parish_ID. I want to display in the Parish Profile Record List the latest Event the Parish signed up for. I currently use an expression rule to display this value in the column. However, i can't sort and the filter i wrote pulls all Parish Profiles with that has the event in its relationship.

Hi,  I am doing some research in to the Google Chart Plugin ... https://community.appian.com/b/appmarket/posts/google-charts-component-plug-in?CommentId=209280fe-6dcb-45e6-9bf7-81336dc6e24d Would anyone know if an item on a chart could be stored in to a variable? I can see there is an onSelection parameter, I am curious as to how an item from a chart could be saved down such as an ID to enable further drilldown behaviour? Thanks.

Hi AllWhen i am doing filtering not getting expected output.Below code is mentioneda!queryEntity( entity: cons!LOCALE_TRANSLATION_NEW, query: a!query( selection: if( rule!P3_utils_checkIsNullOrEmpty(ri!columns), {}, a!querySelection( columns: a!forEach( items: ri!columns, expression: a!queryColumn(field: fv!item, alias: fv!item) ) ) ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "label_txt", operator: "=", value: ri!label_txt, ), }, ignoreFiltersWithEmptyValues: true ), pagingInfo: if( rule!P3_utils_checkIsNullOrEmpty(ri!pagingInfo), a!pagingInfo( startIndex: 1, batchSize: cons!P3_BATCH_SIZE[7] ), ri!pagingInfo ) ), fetchTotalCount: and(ri!isFetchTotalCount))=======================================When i searched "Research". It is giving me expected outputIs it default behavior of Appian ? Expected result - It should not return anything because there is no label like "Research  "

Hello, We need to download .msg files (Outlook mail) from an External System using an integration that receives the document as base64. The current problem is that Appian is able to download that document but without its extension, using the "convert base64 values to Appian documents". I suspect it's because the MIME Type "application/vnd.ms-outlook" is not supported by the integration object as established in the following documentation I found: https://docs.appian.com/suite/help/25.1/Integration_Content_Types.html#document-(auto-detect) https://www.iana.org/assignments/media-types/media-types.xhtml Is there any way to workaround this? Any help is appreciated Thank you!