Integrations

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

Hi All I have one scenario to be handled that -> If the user provides the amount as 0, load – (Minus) value in the payload. I have written this logic but its not working that means values are not loading.a!localVariables( local!crfxRateActivation_cdt: if( rule!APN_isBlank(ri!crfxRateActivation_cdt), rule!CR_APP_QE_getFxRateActivationData( requestId_int: ri!requestId_int, cif_int: ri!cif_int ), ri!crfxRateActivation_cdt ), rule!CR_APP_INT_setFxRatesRequestBody( preferredRate_txt: index( local!crfxRateActivation_cdt, 1, "preferredRate_txt", {} ), fxCodes_txt: index( local!crfxRateActivation_cdt, "tariffCode_txt", {} ), fxRates_int: a!forEach( items: index( local!crfxRateActivation_cdt, "tariffAmountProposed_dec", {} ), expression: if(fv!item = 0, "-", fv!item) ) ) ) The value which I am trying to send is at last logic,Please correct me I

Requirement - Appian application has to fetch data from the external system and it has to be real time (If there is a change in the external system it should reflect immediately in Appian). How to handle this scenario? Do I need to schedule process model every 5 seconds or is there a way to monitor the changes in external system?

Hi Community, has anybody managed to decode (extract claims) a JWT in Appian? I'm looking at the decodeJWT() function from the JWT Plugin (provided by Appian), but it confuses me that instead of the externalSystemKey, it requires url of a JWKS repository. I have no clue how to create or access one in Appian.  I have the private key (used to sign the token) and public key (that is used for token verification by validatejwtsignature) stored in Appian as Third-Party Credentials.I'm able to generate the token (createtokenwithcustomclaims) and validate the token (validatejwtsignature) but don't know how to extract the claims from token. Complete picture (to answer why I'm using JWT) - I'm trying to integrate an Appian Portal into a third-party application that handles user authentication - I need to exchange some data (third-party app -> Appian app) and decided to utilize JWTs (the data is not confidential - we need only to ensure repudiation

Hello, We are trying to set up an integration with OneSpan Sign. When i set up Web API Authentication > Appian OAuth 2.0 clients> The Client Secret is auto-generated and is 356 characters. the Client Secret in OneSpan Sign has a limitation of 256 characters. How do we address this?

I'm trying to connect to a system called QuickBooks that requires oauth 2.0 in order to access information from it. I know that appian allows "oauth 2.0: client credential grant", in order to connect just with one global account for all the user to retrieve  the information. But "oauth 2.0: client credential grant" is not available in QuickBooks online at the current moment, I can only access through the "oauth 2.0: authorization code grant". The site lets me get tokens that I could use for a period of time  and I would like to see if there is a way to pass those tokens The way that QuickBooks works is:   1:the  site  can give me an access token (valid for 60 minutes) and a  refresh token (valid for 100 days). 2 the refresh token needs to send a request in order to obtain the new access token.  Because of this  I'm trying to figure out  a  way to pass this tokens throu

Hi Team, An integration object is created with OAuth 2.0 authentication, every time the connected system is authenticated, then the integration works for 1hour and after that the integration fails. Please let me know if anyone faced similar issue and how to resolve this.

Hi all, We have a connected system with OAuth 2.0 Client Credential Grant. From the connected system we can Authorize with no error. Now, the token we get is valid for 24 hours. The problem is, after 24 hours, the integration calls fail with Authorization error. And when I go to Connected System and click on Authorize and run the integration again, it works perfectly. Does anyone know why this may be happening? I checked and the security of the integration and connected system is set properly. Thanks!

Hi. I was trying to upload a file to Box from Appian, but the following error occurred, so I am posting this. I'm getting a Media Type error, but I'm not sure if the Request Body is written incorrectly or if I'm not connecting to Box's upload API. If anyone knows please let me know. Details below.・Integration Object ・Box account Free version for individuals   I'm guessing that the upload API cannot be executed with the free version of Box, so if you know anything about that, please let me know.   We apologize for the inconvenience, but please.

Hi Team,  The api call is working fine in post man but it is failing in appian with below error, there is no issue at the source side as well any suggestion why appian is throwing the below error [title=Connection timed out, message=The integration execution time exceeded the configured timeout, detail=No details available] Thanks,

In a template i need to give a link for Docusign to display as a link what should that be configured as in Appian side?We're getting radio button from radioGroupTabs, but we need to send link as text tab, say as tooltip parameter. But I'm not sure which parameter to use for the link  

Hi Team, We have integrated dynamo Dv with Appian and accessing dynamo DB table. In appian front trying to create a Web service backed record but receiving an error : Can anyone guide me is der a way we can pass pagination and batch size to AWS from appian integration

Hi, we have been with an error for a while and we need some help to solve it. We are trying to generate the senders token for a Docusign Integration, but it gives us an success response (code 200), but in the response, we dont get the token. We are using the data used in the attached image In the emailAddresss Rule input we are using the same email of the developer account of docusign, and in the accessToken rule input, we pass an admin access token that we obtain in another integration.  If there is an easier way to implement this integration with docugin i would apreciate it if you can tell it.  Thank you!

Hello! I have an API which is returning an array of documents through an integration call with the response looking something like this:  { documents: [ { documentName: "document1.pdf", documentContent: "[BASE64ENCODEDCONTENT]" }, { documentName: "document2.pdf", documentContent: "[BASE64ENCODEDCONTENT]" } ] } The issue I'm having is that here in the integration where you can make appian to automatically convert the binary data to Document type, appian will recognise multiple files (content of them) through the fv! domain, but there is no way to set the document name for each document through the fv! domain.  What I want to be able to do is to set the document names similarly like I do here in the screenshot for the documentContent, which then correctly goes through the response and converts the data to document type.. What is the expected way to do this in appian? 

The US Department of Labor (DOL) has an application called "GPMS" that is built using Appian. The application's url is cmp.dol.gov/.../. My company builds a related web application. There's duplication between the GPMS (Appian) application and our web application. For example, the GPMS application has "case" records and so does our application. We want to make it easy for a user to navigate from a case in our application to the corresponding case in the GPMS (Appian) application. The users have entered the GPMS (Appian) "case IDs" (8 digit numbers) into our system. Is there a way to construct a link using only the numeric case ID that would open the corresponding case record in Appian? For example, let's say there's a case with ID "123456789" in GPMS (Appian). The current url to the page in GPMS is something like the following: cmp.dol.gov/.../{...long encrypted parameter...}/view/summary There's no way for

Hi All, I am getting this error in integration, which is get and sending huge data , because of this the PM is failing as it is returning null value in the PM. The output is too large to display, so the value has been truncated. Switch to the Raw or Expression options to see the entire value any pointer will be helpful on this  Thanks, Pooja

We have a requirement to archive all versions of a document in a separate CMS.  We have an integration that can upload a document, but it only works on the latest version of a document. We are not able to upload previous versions.  I was planning to use a plugin to "unpack" documents to a temporary folder where each version is a new document.  Is anyone aware of an existing, cloud-approved plugin that can handle this?  Are there any other integration or plugin alternatives that would meet this requirement?