Discussion Categories

How to export data to excel in a grid with more than 50 columns? (grid source is database)? Please advise?

I’m testing an Appian AI Agent that needs to read data from an XLSX document. I have two copies of the exact same XLSX file stored in two different folders in Appian. When I point the AI Agent to the file in Folder A, it works as expected and can read/extract the data. When I point it to the identical file in Folder B, it does not work (the agent appears to find nothing in the file / doesn’t extract data). Both documents are valid Appian documents of type .xlsx, AI Agent uses Semantic Search to read the data, and the file contents are identical. The only difference is the folder they’re stored in.  Has anyone seen this behavior before or can suggest what to check? Any guidance on why the same file would work in one folder but not another would be appreciated. I created new folders, checked the folder security, but I can't find the issue. 

Hi I'm experimenting with the AI Agent Studio object and setup a test case to read excel file, but when it tries to use the Semantic Search Tool I always receive this response.An error occurred while executing the tool [SemanticSearch]: The user [username] does not have sufficient privileges to perform the requested action.And return error from the tool. Is there anything that need to be setup or allowed?

I am using Export DSE to Excel node so currently, the data in each tab of the Export uses the default horizontal (normal) formatting.  The user would like to have the columns transposed to Vertical formatting when the Excel is created. Excel tab show the data in vertical rather than horizontal.  So, column A would have all of the column headers, Column B  & Column C should hold the related data and so forth. Kindly give your suggestions From this to  To this

Hi Guys, what is the prefered way to create and use constants in an appian application. I have created the following record types "Order", "Order Lines", "Order Type" and "Order Status". The "Order" Record Type has an orderTypeId (Number - integer) and orderStatusId (Number - integer) fields and relationships added to these tables.  I have now created two constants called "CONS_ORDER_TYPE" and "CONS_ORDER_STATUS" which binds directly to the above mentioned Record Types. How would you use these two constants in eg. a dropdown list?  I mean, if you create a constant of type array and add text values {"Created","On Hold", "Fulfilled"} what is the purpose to create the "Record Type" entities for the constants (Order Type and Order Status) since you can just use the data type "text" for the orderStatusId and orderTypeId fields on the "Order" record type

Hi! Is it possible to use Databricks as a data source with Appian? I know it's not directly supported but maybe there's like a workaround possible? Any help would be great!

Hi, in our environment the IdP changed some usernames from lowercase to uppercase. Appian configured for SAML authentication with "Retain Casing" option, returns error code 401. Do you have any experience that the configuration option at docs.appian.com/.../SAML_for_Single_Sign-On.htmlcan resolve the issue, and can these changes be made hot or do some services need to be restarted? Thanks!

Hi everyone, I am developing a Custom UI SDK component (JavaScript/Web Component) to create a custom image gallery. My goal is to have this component working seamlessly in both Appian Sites and Appian Portals in version 25.4. The Problem: I have tried using existing plugins and my own custom code, but images are not rendering. When passing the Document IDs to the SDK, the component fails to display the images. I suspect this is due to session/authentication restrictions or how the source URL is being handled, especially considering the architectural differences between Portals and Sites. Technical Details: Version: Appian 25.4. Component type: UI SDK (JavaScript). Current approach: Passing a list of Document IDs and trying to resolve them within the component. Issue: The <img> tags remain empty or return 401/403 errors when the component is loaded. What I need help with: What is the best practice for passing Appian Documents to a Custom UI SDK so they are accessible i

Hi All, Greeting! We have faced this issue with one of the users. They are able to see the requests that they created. But when they are added as watcher for records, they are receiving an email with link from that link they are unable to open the record and facing this and they have necessary permissions as viewer in the respective group.  Could anyone please suggest any answer for this. Best regards, Kiranmai Palanki.

The Dynamic Letter Generation module uses multiple styletexteditors where users can select which sections should appear in the generated letter. There are no formatting issues in the final generated letter. However, in the preview section, there is a numbering issue where an extra number appears even though there are no additional <li> elements present.Please find the screenshot of the code below,

Hi, I'm new to the Appian. I'm unable to see the 'New Data table' option as mentioned in this documentation: Create-record-data-source.html  So, I Selected Database option and I'm unable to proceed after that. No options provided here to select. Help me resolve this and provide me the steps to create an database and make connection to the interface. Share any documentation URL or online course for this.

Hi Everyone, I have few questions regarding the two AWS S3 related plugins available in Appian. Currently there are two plugins that appear to provide similar functionality for uploading and downloading documents to Amazon S3: Amazon S3 Utilities (Smart Services) AWS S3 Bucket Management (Connected System / Integration based) Both plugins seem to support operations such as uploading documents to S3 and downloading objects from S3. However, they follow different approaches in terms of configuration and usage. My questions are: 1. What is the main architectural difference between these two plugins? 2. Are they intended for different use cases (e.g., process-based vs integration-based)? 3. Is the AWS S3 Utilities plugin considered a legacy approach compared to the Connected System based plugin? 4. For new implementations, which plugin is generally recommended by Appian? I would appreciate any insights on when to use each approach in the real time. Thanks in advance! Ananda

Hi Team  we have requirement of generaing pdf file.we have designed a flow for that first we are generating the docx file from that will bys using PDF from DOCX service trying to convert pdf file. In this process we could see docx file generating successfully we are giving docx file as input to PDF from DOCX smart service.Docx file is generating successfully but pdf file is not generating.I can see PDF from DOCX is not running sucessfully with error message of "Exception exporting package".Can someone help me what could be the reason . Thanks for the response in advance.

I am using the Import Excel to Database plugin along with a Connected System to download Excel files from a client’s Google Drive. Here is the behavior I am observing: When the Excel file is created using Microsoft Excel, the file is downloaded successfully via the Connected System, and the plugin works as expected. All the data present in the Excel file is imported correctly. However, when the Excel file is created in Google Sheets, or when an existing Excel file is opened/edited and saved using Google Sheets, the file is still downloaded successfully, and I can see the complete data in the file. But in this case, the Import Excel to Database plugin treats the file as null and does not return any data. In both cases, the file extension is .xlsx. Is this a known limitation of the Import Excel to Database plugin when handling .xlsx files generated or modified by Google Sheets? If so, is there any workaround or recommended approach to handle Excel files comi

i Was getting this error in record sync Alert Details Could not sync because too many rows were updated in the source at the same time. To prevent this from occurring, limit the associated smart service or integration to not update more than 50,000 rows at a time. Process Name: [Not Available] Modified Source Rows By Primary Key: 49814, 49815, 49816, 49817, 49818 and mo

I have 3 doubts in Appian environment. Can you help me, please? 1. In Appian, can you work with branches associated with process versions, similar to GitHub? 2. Is it possible to have two versions of the same process running in production and choose at any time which one the application should use? 3. If a new version of a process is deployed to production, can migrations be performed for the processes that are active at that moment? Thanks in advance.

Hi Team  I am trying to convert word to pdf  i have used this plugin Convert DocX to PDF Aspos. i am getting  this error ErrorCode=99, ErrorMessage=Cannot invoke "com.appiancorp.suiteapi.content.ContentUploadOutputStream.close()" because "cos" is null] .I have configured necessary inputs. Thanks for the response in advance.

I have a table in DB. Which has column called x which is of varchar type(255). I am fetching records in Appian using a!queryentity function. I just want to exclude records which are having "" mapped for column x. I tried like below which are not working. Still its fetching the rows which are having empty string mapped for the column. Can someone help? a!queryFilter(field: "x", operator: "not null"), a!queryFilter( field: "x", operator: "not in", value: "" ) a!queryFilter( field: "x",operator: "<>",value: "")

Hello, we are starting the use of composer, and could use some light on this: When an application is started with composer and it's objects created, how do we know what objects need to be completed or created?

“I was getting this error in the Record Sync History when the user synced the record from the UI, where we run the model to sync the data in batches. The error was shown in the record history, but there was no failure in the process instance. I selected the checkbox option to skip the failure in the smart service sync, and the sync failure has now been skipped. However, we still need to figure out why this error is occurring even though we are syncing the data in batches. Alert Details Could not sync because too many rows were updated in the source at the same time. To prevent this from occurring, limit the associated smart service or integration to not update more than 50,000 rows at a time. Process Name: [Not Available] Modified Source Rows By Primary Key: 49814, 49815, 49816, 49817, 49818 and mo

Hello, We are experiencing an issue with the PDF From HTML plug-in, as it generates the entire output on a single page. I would like to understand whether there is a way to render the content across multiple pages, preferably using a standard A4 page size. The problem becomes more pronounced when the generated content is very large and exceeds approximately 200 inches in page length. In such cases, Adobe has limitations when opening the file and truncates content at the top of the page. As a workaround, Adobe is only able to display the full content when opening the file in a web browser. I would appreciate any guidance or recommended solutions to address this limitation. Thank you.

I have a couple of table on maria DB and want to check if the table are being used or not used by Appian. Is there a way to check if the table is being used to deleted or not deleted.

Hi everyone, I’m using to readexcelsheetpaging plugin to read the Excel sheet, one column having decimal values, the displayed value is rounded (around 2 decimal places), which differs from the actual raw value stored in the cell.   What I see: Excel cell shows: 9.79 Underlying value in the cell: 9.7881336 readexcelsheetpaging returns: 9.79 (display) Is there a way to read the actual value of a cell?

Hi Team, I have a main record type called Case, which is based on the Case table as its source. For reporting purposes, I created another record type called Closure Report, and this record type is also using the same Case table as its source. In our process model, we are using the Write to Record smart service to write data into the Case table. The Case record is syncing automatically without any issues. However, the Closure Report record is not syncing automatically. When I check the data preview of the Closure Report record type, I can see the latest updated values in the table. If I perform a manual sync for the Closure Report record type, then it works and the latest data is reflected properly. Previously, we created similar report-type records using the same approach, and they were working fine. This issue is occurring only for records created from last month onward. Could you please help me understand why the Closure Report record is not syncing automatically even though the data

Team, We are getting .eml file from our mailbox which we pooling using outlook pooler. Now we have identified a plugin which captures the body of .msg file only. Is there anyway we can convert .eml to .msg in Appian? or any other way of reading .eml is available ?