Integrations

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.

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.

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!

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?

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?

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!

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:  

Sorry if I'm missing something obvious/another tread on this topic, but I haven't been able to find anything related after digging for a while and banging my head against the wall on this. Is there a way to natively pass variables into an integrations relative path?  The goal is to have some user input field for that variable to pass through to the external endpoint, who's required format is along the lines of:  base_path / relative_path / {variable} / relative_path2 I'm looking to avoid as much custom code as possible, but any help/advice would be appreciated!

Hello Everyone! We are using consume KAFKA plug-in, however the source system is publishing data to Kafka in Gzip format. In Appian we are reading data from consume KAFKA plugin able to store kafka messages in database. The body of the Json data is in Gzip format. Can anyone suggest how to decompress the data while reading data from database.  Example:  {"topic":"testTopic","partition":0,"offset":23,"key":"123","value":"\u001f�\b\u0000\u0000\u0000\u0000\u0000\u0000"} Thanks for your help!

Hi, have configured the office Add-in where am getting the task in Email, but the task, which gets loaded in Outlook is looking for credentials (Appian cred). I wish to know whether this Add -in could be used only for task for non-Appian users (the one who don't have an account created in Appian server) ( tasks of nature where Yes/No response is required ) Thanks

Hi all!I tried creating a Google reCaptcha Connected System. It asked for 3 things1. reCAPTCHA Project ID2. reCAPTCHA Site Key3. reCAPTCHA API Key The Project ID and Site Key is found in https://console.cloud.google.com after enabling reCAPTCHA Enterprise API and doing necessary configurations. But I couldn't find the reCAPTCHA API Key anywhere. Can anyone help me on this

Hello people! I'm trying to use OpenID Connect with my connected system. I have already configured OpenID Connect on my Admin Console, and it is alright, but when I try to use it in my connected system, I receive the following message: "Neither an access token nor a refresh token was found for the OpenID Connect provider." I have a question about this: Does the connected system in Appian use a POST client_secret_basic or client_secret_post? client_secret_basic: The client secret is sent as part of the HTTP Basic Authentication header. client_secret_post: The client secret is included in the body of the POST request.

Hi Team,I have created a WEB API in Appian only  which is used to Write data to tables.I want to use this WEB API on Interface load. How can we do that ?Regards,Abdus Samad

What is the most efficient way to import a daily CSV with 1 million rows from s3 into an Appian? (On daily basis we have to truncate the table and load the new data).

Hi Experts, I'm facing issue while calling the integration object from UI which seems to be getting timeout where as when I test the actual Integration Design object I'm not seeing any such issue. The timeout is configured as 300 secs in the integration object. Will enabling the "HTTP Request/Response Logging" can help in this case to identify the root cause? If yes, then who can access this log and from where and what information can they get from this Log?

I have a requirement where user can pass document and it gets uploaded to an Appian's folder. I have created a WebAPI (Document Upload) and positive scenario is working as expected. For Negative Scenario (When we are not passing any document): 1. In the WebAPI , it is handled as "400- Document not provided" but when testing we are getting status-200 (Untitled document from web API.txt). Q. From where we are getting this "Untitled document from web API.txt" document. Where is it handled? Q. How to fix default handling?

I am experiencing an integration error while attempting to connect to a Start Process Web API within the same environment. I have tested the connection using Postman, and it works fine.

I want to ask few questions related to google doc :-  I want to append value on multiples line on google doc. there is a table of 3*3 and I want to add data on each cell of table in google doc.

Hi Experts, I'm trying to add validation on my Appian Portal Page which doesn't support Regex Functions and hence I have created a Web API which is validating weather entered IP is valid or not and calling it on the UI using an Integration Object, when I test the API using Postman, I receive the correct response. However, when I use Appian's Integration Object to call the same API, the response body comes back without any value. Valid Test Value: "1.1.1.1"  Postman Response: { "ipInfo": true }  Appian Response:  HTTP/1.1 200 200 Date: Thu, 02 Jan 2025 13:43:42 GMT Content-Type: text/html;charset=UTF-8 Connection: keep-alive Server: Apache Strict-Transport-Security: max-age=31536000; includeSubdomains; preload Cache-Control: private X-Trace-Id: a1956c41e9dd44f6226e475d8d145803 Referrer-Policy: strict-origin-when-cross-origin X-Frame-Options: SAMEORIGIN Content-Security-Policy-Report-Only: style-src 'unsafe-inline' 'self' https://web-as

I am currently working on integrating Appian with an external system by exposing Appian RecordType data through a Web API. However, I am running into an issue because the Community Edition does not provide access to the Admin Console, and without access, I cannot generate an API key needed for authenticating my API requests.Is there any way to achieve this ?

I have a few queries related to customizing the user interface in Appian, specifically for enhancing the end-user experience. Does Appian provide flexibility to create custom UI widgets, if required, to build an intuitive user interface for the end user? Is it possible to integrate custom HTML, CSS, and JavaScript code into Appian’s latest version and extend the UI functionality beyond the pre-built widgets and patterns provided by Appian's SAIL UI framework? Thankyou in Advance!.