Extensibility

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?

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

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

Hi All, I have installed the Content Tools plugin and am using the getcontentobjectrevisionhistorydetails function to retrieve version details. I am passing a UUID and filtering the results by the modifiedOn date. However, I am encountering an issue where the modified date field is not correctly reflecting the changes made. For example, when I select the modified date as 2/6/2025, the result from getcontentobjectrevisionhistorydetails is null because it is returning same as created date value, but it should give latest version date value which highlighted in version details below. This can be seen in the information below:  creator "Balavamsikrishna_vinnapala@contractor.amat.com" (Text)              createdon "1/29/25 AM GMT" (Text)              modifiedon "1/29/25 AM GMT" (Text) Version details of one object Created 2/6/2025 10:08 AM by sala vamsi Krishna Vi... 1/29/2025 l

All, I am trying to using Google Drive connected system(https://docs.appian.com/suite/help/21.4/google-drive-connected-system.html) , to create folder, upload and download documents  to and from google drive folders. Then API  operations  (like createFolder, uploadFile, downloadFile, etc) all work perfectly  on a personal folder of an auth user, but   the same operations are not working on a SHARED folder in google drive, Has anybody got that working with a Shared drive?  I checked out some documentation on google drive APIs  at (https://developers.google.com/drive/api/v3/enable-shareddrives?hl=en)  and found out that supportsAllDrives=true  parameter is required to enable these operations on a shared drive. But there is no way in the connected system to pass this information.  Any ideas? Any suggestion?  Thanks Pal

Hi, I am trying to connect a 3rd party system which uses OAuth 2.0 Password Grant Type authentication, as it is not supported by Appian connected System. I have created a separate integration object to get the access code where I am passing below fields in request body. "client_id": {client id} , "client_secret": {client secret}, "username": {username}, "password": {password}, "grant_type": "password" Getting this error  "error":"invalid_request","error_description":"The grant type was not specified in the request". I tried creating token using POSTMAN and there it was working fine. Attaching screenshot for both. POSTMAN Response: Appian Integration Response:  

Hi! I have three questions regarding the Excel Tools plugin. Sadly the documentation is not very precise.1. How can we read headers with spaces (Example: a column with a header "User Name")? I found this question in two different threads but they are almost 10 years old, which have links to appian sites that are no longer accessible. 2. One of our clients provides us an excel that is automatically generated, and has +10 columns. I'm only interested in 3 of those columns. Is there a way we can pick and choose which info from the excel we are interested in? I'm using the Import Excel to Database smart service. I'm pretty sure that the "Excel Header Names" and "Database Field Names" parameters might be useful for this case, but I don't understand how to use them properly, and the documentation does not say a lot about them.3. The same excel that I mentioned in my 2nd question starts at row number 3. Row number 1 & 2 have som