-
Recently active
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) & " ""!""
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?
Hello, We had recently updated the SFTP Functions plugin to v3.0.2. After the update, the SFTP Send File smart service is failing with the error "Auth fail". Third-party credentials are setup and have not changed. The plugin has access to the third party credentials. The FT_Config CDT has got updated (due to the plugin update) and has the below structure: Smart Service Inputs: We are passing the values to the smart service as below: File Transfer Configurations: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: cons!SFTP_HOST_NAME, (text) serverPort: cons!SFTP_SERVER_PORT_NUMBER, (integer) scsExternalSystemKey: cons!SFTP_EXTERNAL_SYSTEM_KEY, (text) usePerUserCredentials: false(), (boolean) pr
Hello, we are doing first time set up of this plugin and facing connection time out issue, No error other than time out message. We are on cloud latest version and using VPN to connect cloud. We followed all steps in the installation guide not sure are there any additional DNS port settings we need too consider for successful connection. any thoughts? Thanks for help "Couldn't connect to host, port: testmail.net, 993; timeout -1"
Hi Team, Is there any plugin available for python to integrate with Appian?
Hi Everyone, I need to implement functionality to read, write, and update specific JIRA tickets through an integration between Appian and JIRA. For this, I'm referring to the JIRA API documentation: https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issues/#api-rest-api-3-issue-issueidorkey-get To authenticate, I plan to use OAuth 2.0 (Authorization Code Grant) as outlined in the documentation here: https://developer.atlassian.com/cloud/jira/platform/oauth-2-3lo-apps/ I have already created the necessary app in the Atlassian Developer Console for OAuth 2.0, and I successfully set up the connected system in Appian. However, I'm encountering an error while trying to create the integration system. Could anyone please assist me in resolving this issue and help me complete the Appian-JIRA integration? Thank you!
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.