Discussion Categories

a!isNullOrEmpty(a!fromJson("{}")) gives me result as false but my requirement is to check if a!fromJson is empty then it should return true. How can we acheive this?

My situation is as follows:I have a Vehicle record, an Employee record and a Driver mapping record between them. A vehicle can be reserved by a driver at a time, but in it's history there can be many previous drivers. I want to make a custom record field that shows the current driver assigned to a given vehicle so that i can use it throughout my application. However I am not sure how to do this with the aggregated custom fields. Since aggregations basically do not care for the specific thing i want (I want to show the employee name of the driver that has the latest start date on the mapping table).Is there anything i can do for this? Or do i just have to rely on relationships and generally querying relatedRecordData appropriately to satisfy this situation? 

Hi, I have readable grid in which i am using arrow icon, so if I click on that arrow so that row should go up and upper row should come down. I can get all data items from current row, but how I will get data from previous row, So I can apply swapping conditiin

Hi Team, I want to display an external PDF URL into a!documentViewerField, i tried using a!webContentField for the same, however the URL is not supported in it. I am open to first save the document to Appian and then display it. Please help me with the possible solution to this use case . Thanks in Advance.

In integration if the response is in xml format, how to convert it to appian value and save in a record type

Hi all, we're looking for the best way to maintain a large deployment between environments.  We have the package created in our DEV environment but we don't want to keep deploying this into SIT every time we fix an issue, as it's a large package and some issues may be in progress and not ready for deployment. I think ideally we want to create a package we can maintain in SIT as we deploy fixes to keep all the objects we've changed consolidated for when we deploy to UAT. Is there any way to create a package from a direct deployment or do I just need to manually create a new package in SIT and manually add all of the objects? Thanks!

I have created an email node. The recipient is configured as =toemailrecipient(cons!IAT_PURGING_NOTIF). The node executed successfully however no email is received. Can someone please advise what is wrong here. The constant is setup as type - Email address & Array having multiple recipient values.

I'd like to understand how the count of descendant rules affects interface performance and how this count is calculated.

Getting error in the script task. I'm trying to pass the below jsonPV in PM.I want to store the id values in DB as separate row

HiCan we extract data from unstructured documents using Appian IDP Gen AI features

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)!