Extensibility

Hi Team, I have configured a webApi to download CSV document on click, it's working when I use it in web browser but the same is not working when I use it in mobile device (Appian Mobile application). Could you please suggest the alternative ways to achieve a document download on single click? Thank you in advance

Hi all, I'm trying to set up an Integration that can send files from Appian to an Azure Blob Storage. I have the URL to the storage and the required SAS token, but I am not sure how to set it up properly in Appian. I created a HTTP Connected System and set the SAS token as a parameter. However, when I try to test the request via an Integration I'm receiving a 409 "Public access is not permitted on this storage account."  I was able to successfully connect and upload/delete/modify data via the Azure Storage Explorer with the same token, so I'm confused why this isn't working. An issue with a firewall? Mistake in configuration?  Appreciate any insights, maybe someone else had the same issue before and was able to solve it. :)  Best, Matthias

Hey AC, Does anyone know if we can use TAB as a delimiter option in the 'Import CSV to Database' Excel tools plug-in? The comma (,) is already provided by default which works nicely but was wondering if there is an option for TAB.If so, what would the character look like?

Good afternoon, I am having a problem when using the plugin, both for encrypttext and decrypttext. I am trying to access via SCS and I always get the error "Error encrypting value: This plug-in [com.unionbankph.plugins.aesencrypt] is not registered to access secured values ​​for the given external system key [Key]. Check the external systems plug -ins list in the Administration Console." even though the plugin is correctly in the credential's plugin list. I am currently using them in the following way local!base64Key: decodebase64string("pruebaencript"),local!eas: fn!encrypttext(valueToEncrypt: local!valor,scsKey: "pruebaencript",scsField:"Key",iv: local!base64Key), Thank you so much

I am trying to generate pdf from docx. The input DOCX file is the output from a MERGE DOCX smartservice. So basically its a merged doc(few docs are merged to single docx). Issue is PDF to DOCX/PDFfrom single docx/PDF from Multiple docx is puling only the first document from the Merged doc to convert to PDF. Rest of the docs in Merged docs are not getting converted in PDF. Any solution for converting merged DOCX file to PDF ?

Hello we have integration with an external system and once we add the document, we use Get file to retrieve the document. In the Get File Integration if I use convert Binary to Appian document it works fine and stores the document in Appian. But we do not want to store the document in Appian, we just want it to be a downloadable link. Converting the binary to a document using todocument() to display in a!documentDownloadLink.. results in an error saying ID Not found.

Hi All.We want to understand if we can receive message from AWS SQS and start a process model in Appian. Can we use receive message event configured to receive to message from external to process type to achieve this and if yes, can anyone please tell how to test that?

Hi All, Currently i am working on requirement where user select some columns on UI and that columns contains Space, +, & ,-, with these special characters.  Example: Alpha + Beta Alpha & Beta Hello World(y/n) any many more with special characters. but while exporting data through export to excel plugin when configured above headers name its throwing an error. Error Message: Either selection or filters are invalid: The alias [Aplha/Beta] cannot be used because it contains illegal characters.  The alias must contain only letters, numbers, and underscores, and must start with a letter. (APNX-1-4505-009) Is there's any way that we can achieve this piece of functionality.

Hi I need to validate if the correct excel is uploaded by validating its content . I have different excel upload for different activity. If the user uploaded wrong Excel and do the submit it should display that excel is not for this activity .  Is there any way to do that. Can anyone suggest a way and how to implement it.

We have an oauth2 authorisation with client Id , client Secret  & scope to connect to an api. We already have a connected system configured for this . This is working fine & we are getting expected response from api. Traditionally in our organisation we have a process model per application  which runs every 60 mins which generates the token  & writes to the token table. This token from db is accessed and set in the the header of the request as Authorization: Bearer ******. But it seems our code is working even if that Authorization header is deleted from the integration. It seems the connected system is adding the Authorization header to the integration request and the process model to token generation is not required at all. Does this a ring a bell ?

Hello, I'm trying to generate document from XML code. 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@6c1fb8c6!word/document.xml"" in line 4, column 4957:" & fn!char(10) & "Encountered ""name"", but was expecting one of these patterns:" & fn!char(10) & " "".""" & fn!char(10) & " ""..""" & fn!char(10) & " <DOT_DOT_LESS>" & fn!char(10) & " ""..*""" & fn!char(10) & " ""?""" & fn!char(10) & " ""??""" & fn!char(10) & " ""!"&quot

Hi Everyone, I am facing an issue with the "Import Excel to Database" plugin. When reading the Excel file from the mail poller, it is not loading into the staging table. However, if we copy the same file to the local system, open it, and save it again, the data is successfully loaded into the staging table. Upon reviewing the system logs, I found the following error: [Senario:File was not ingested scenario]. 09:08:21.599 [Appian Work Item - 191302 - WorkID 79 - execution01 - process 268462146 - model 172 : ExpressionGroupRequest] ERROR com.vuram.plugins.documentencrypt.CheckDocumentEncryptionUtil - Unable to process document Any Ideas would be appritiated. Thanks in Advance!

While invoking a POST webAPI from Postman, I am getting error as below: "Unable to get Issuer certificate" . Authentication used here API-Key. Passing as Header: Appian-Api-Key What can be possible reasons?

Hi, im new in appian. I create a get api integration which recieve multiple lists those lists recive another ones. Also i create a expression rule to parse this information with my CDT. On my forms i call this rule and it works with text information but not with lists.  This is my interface: This is my rule expression: This is my CDT:

Hi there. I'm creating a new Connected System object to connect to an Oracle database. I have to fill the fields related to the Connection URL, User and Password. Considering that when I deploy the application to the production environment I will need to change the connection settings, is there a way to get this information from a properties file instead of setting this object again in the production environment when the application is deployed? Thanks in advance.

Issue with DOCX Page Count Plugin - Incorrect Results Hi Team, We're encountering an issue with the DOCX page count plugin we're currently using. This is impacting our document processing and causing problems with element positioning. Problem: The plugin is incorrectly reporting a page count of "1" for some DOCX documents when they actually contain a significantly higher number of pages (e.g., 22 or 25). Impact: This incorrect page count directly affects our element positioning logic, leading to misaligned elements within the documents. Our use case relies on accurate page counts to properly position elements. Investigation: We have thoroughly examined the affected documents and found no issues that would explain the incorrect page count. The page count reported within the document's properties/info section is correct (e.g., 25 pages). This suggests the problem lies within the plugin itself. Urgency: This issue is blocking our workflow as

I need a plugin or a way to delete packages using a function in an interface. We are building an interface where we specify the packages that are already deployed, so it can be deleted automatically for storage purposes.

Does appian support wild card certificates? in the form of *.dev.orgname.com

I have a REST service that posts a lot of data to a table in Appian (136k+ rows).  The problem is the primary key in the service is not the same primary key that Appian is using.  I cannot match the keys because, the service's key is unpredictable.  Government data, yea!   For my REST post I simply need it to find the record with a matching value (if it exists) then update it, or else create a new record. a!localVariables( local!value: cast( 'recordType!{b44d0eeb-090e-4c8f-b858-1f684423adbc}DCQ Weekly Extract', a!fromJson(http!request.body) ), a!writeRecords( records: local!value, /* * Construct an HTTP response to return to the caller */ onSuccess: a!httpResponse( statusCode: 200, /* * Set an HTTP header that tells the client that the body of the response will be in JSON format */ headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, /* *In

Hi All, I need to connect and post data in to an existing table in share point. How to connect with that existing table and in where can i find those details in microsoft documentation. Thanks, Ganesh.

Hello,I am attempting to import OpenAI Sample Application.zip file into an environment version 25.1, and am getting the following error:The selected package was exported on version 25.2.0.60 and it cannot be imported or inspected on the older version 25.1.175.0. (APNX-1-4154-001)

Hi Team, Where should we see the additional configurations of the web api we create like rate limit, timeout, payload size limitations, retry threshold etc? Is it modifiable for cloud environment? Along with that, I also have few other questions below:  1. when we expose our data via API, as an additional security, do we have any methods to black list/white list system IPs? 2. what's the good practice regarding rotation of authentication credentials in web api? 3. what is the typical response time for webapi?  Thanks in advance!

Hello Everyone, I am using another client’s SFTP server for demo purposes, which uses SSH key pair authentication with a private key that works in FileZilla. I have created Third-Party Credentials in Appian using the username only and uploaded the private key along with a constant associated with it. Here is my File Transfer Configurations CDT: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "xyz.com", serverPort: 22, scsExternalSystemKey: "aws-cmd", usePerUserCredentials: false(), privateKeyFile: tointeger(cons!MS_SFTP_USER_PRIVATE_KEY_FILE) ) I am getting an error: invalid private key: [B@5bbde572. I know the private key works fine because I have used it in FileZilla.

I have two records. I prepared the data attached. The records are: one is LTM GROUP and the other is LTM USER. Both are related records. I have heard that we can store data in the base and related child record in one shot. As GroupId is the primary key in LTM Group (autogenerated), plus LTM User has a foreign key named userGroupId, and obviously, this table also has a primary key userId which is autogenerated. Can you please help me with storing data in tables with the help of writing records in a single shot? /*Group*/ { recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 25, LTM Group.name : "Admin", LTM Group.updatedby : "rt343", LTM Group.addedby : "rt343", LTM Group.dateadded : fn!date(2025, 2, 25), LTM Group.disabled : false ), recordType!LTM GROUP( LTM Group.applicationkey : 1, LTM Group.appiangroupkey : 26, LTM Group.name : "RTR User", LTM Group.updatedby : "rt567", LTM Group.addedby : "rt567", LTM Group.dateadded : fn!date

Hi Team, I need to fetch data from a GraphQL API endpoint, but I'm unsure about the connected system required for the connection. The client has provided the ClientId and ClientSecret for AWS Cognito and mentioned that they are using SRP (Secure Remote Password) Authentication. However, I'm not sure what additional information is needed to establish the connection to the GraphQL service. Can you please provide more details?