Integrations

We  have a 2 environment with same IdP (ADFS)  our certificate was expiring hence a new PEM cert was loaded into Appian on TEST the SAML Authentication works but the same does not work on DEV. They both have identical configuration and metadata files from IdP. While looking at the tomcat logs on the environment that has issues i see following SAML errors in the logs. 2021-09-29 18:50:29,928 [ajp-nio-0.0.0.0-8009-exec-202] ERROR org.opensaml.xmlsec.encryption.support.Decrypter - Failed to decrypt EncryptedData using either EncryptedData KeyInfoCredentialResolver or EncryptedKeyResolver + EncryptedKey KeyInfoCredentialResolver 2021-09-29 18:50:29,929 [ajp-nio-0.0.0.0-8009-exec-202] ERROR org.opensaml.saml.saml2.encryption.Decrypter - SAML Decrypter encountered an error decrypting element contentorg.opensaml.xmlsec.encryption.support.DecryptionException: Failed to decrypt EncryptedData        at org.opensaml.xmlsec.encryption.support.Decrypter.

Hello, Usually connected system for http type accepts only http/https url  do we have anyway to connect using URL starts with wss (web socket connections)

Hi  I am using SharePoint Connected system for my integration to Download a File and seems it is not working. The integration rule returns SUCESS for "List Folder Contents" operation having a single document, however results under File shows 0 items (when there is one document available) While downloading the file I am getting following error:

Hi Every One, I have one integration with OAuth and token generated in header so how to fetch token from integration header. I have tried like  rule!Ma_integrationobjectname().result.header.token             but getting null value. Can anyone suggest on this.  Regards, Devi

Good morning, We are doing an integration where one of the "ri" we are using is a text type. The problem we have is that the size of that text exceeds 4000 characters and the integration does not work, is there any way to enlarge that size. Thank you very much

Hello,My team and I are trying to use a jar but without creating a plugin for Appian. Any idea how to use a .jar in a process model?

Hello. We are having a very unusual problem with the Reconcile Doc Extraction Smart Service node in our process models. Everyone in our team can run the process model, start the document extraction and run the reconcile node without issues, except for a specific user. The error is the following: An unexpected error occurred while displaying the PDF for the run. We tried the following methods/verifications in order to debug the problem: The user is a System Administrator; The user belongs to the same groups that the other users belong to; The user has Admin privileges to the document used; We tried multiple process models in order to try to isolate the problem, but the issue persist even if we use a "sandbox" process model. For the users who run without issues, the process is the following: For this particular user, the process fails on the reconciliation node: Whenever the user tries to "View Form" on the reconciliation node, the user gets immediately the error

Team, Any solution for below ? We are calling Appian environment API from another Appian environment using integration. Way we access destination system out side of network , first we will be taken to multi layer authentication and based on correct username password and mobile token we will be ale to access appian URL. Not how to call API from source because when i am passing API URL it is saying success but going to multi layer authentication , how to bypass it ?

Hi Everyone, I have created connected system with Client Credentials Grant and successfully authorized but when I configured connected system to integration, getting success but body display html format. Can anyone suggest to how to get token. My scenario : I will get token from connected system and then I need to pass that token to remaining API's as Headers.  Regards, Devi.

Hello. In my particular use case. I need to integrate Appian to Azure. Mainly because I want Azure to conduct a query for me. The reason for this is that I am dealing with a database type that is not supported by Appian so I need to find a workaround. The workaround is to pass the query from appian to azure, make Azure execute the query and retrieve the required data from the database, and pass the results back to Appian.  I am fairly new to both Appian and Azure.  Can anyone here give me a rough guideline as to where to start? 

Hi All, I am doing third party integration and need to retrieve PDF document. i am doing in below way.  Document get stored in target folder but when i open this document, this give below message. I thought to store this document in process variable by using Integration smart service. please find below. i got following below error. Kindly help me. Thank in advance.

Hi  I have integration with post method, I'm getting success response with token in body  but I need to call this integration in Expression rule and fetch the token field and pass that token into remaining API's.  ->I have tried to call in expression rule but getting output as "Smart Service". How to call the post method integration in expression rule. can anyone suggest on this issue. Regards, Devi.

Hi Everyone, I have integration object  with basic authentication with user name and password so I need to encrypt the password in integration. How to do the encrypt the password in integration. can any one suggest on this. Regards Devi. 

Hi community, Can somebody explain me the difference between body parsing to Appian value and the use of a!fromJson to convert the whole response body to Appian values? Kind Regards, Erik

when I check for the Authorization on the Connected System I click on Authorized Again (Where I am assuming I get the Token) how can I automated this procedure ?

I'd like to send documents from our Appian environment to another system using that system's web service. It was easy to make this work with small documents whose contents I can easily stream in body of a single request. However, the web service will not accept request bodies longer than a few MB and some of the documents I need to send are much larger than that (up to several hundred MB). The web service offers endpoints that support sending the document in pieces so that I could, for example, send a 10 MB document with 10 sequential calls, each containing one of the 10 parts of the document. However, the web service documentation just provides examples in C# and Javascript, which we obviously cannot use here. Is there a way to split a document into parts? I've searched the cloud-supported plugins and don't see anything like this.

I'm trying to expose a view from the Appian DB via a Web API.  The Web API requires a Data Store Entity Constant. So I try to create a constant with a Data Store Entity type, but I need a Data Store Entity created with the View Data Type. I create the view data type without issue and add it to the Data Store but it will not save and publish (I get a 'Appian.vwMyView' is not of type 'BASE TABLE' (APNX-1-4178-000) error). Also I do not want the view created as a table as it is already created in my DB as a View. How would I add an existing view into a Data Store? 

I Have an integration that is calling an outside system and when I try to call the connexted System I need to get a GRANT TOKEN, I know I can display a link to get this token, but is there another way to get this token, perhaps on a process model? or just calling it via a rule

Hi team, I am referring service backed record tutorial , Test Request should not return a success message in Configuration of integration path, please help me to get this successful message

Interested in learning if anyone has connected PowerBI to MariaDB cloud database. If yes, which windows server was PowerBI installed? Was it using Appian Enhanced Data Pipeline (EDP)?

Hi, I'm trying to integrate docker container packaged mail server with Appian application by updating custom.properties and password.properties. SMTP mail server currently integrated with Slack and works as expected(i.e. receiving slack notifications) when testing it separately using "curl" from CLI. However, Trying to test SMTP mail server integration from Appian thru process model - Send Email Smart Serrice node. I could not receive any output / email and no error messages on docker log and Tomcat logs. We've already turned on below DEBUG settings, log4j.logger.com.appiancorp.process.runtime.activities.SendEmailActivity=DEBUG  log4j.logger.com.appiancorp.ap2.mail=DEBUG It seems Appian is not communicating with SMTP mail server as we could not see any entries on docker logs. Process Model Send Email smart service status is “unattended”, this has been initiated as per tomcat logs and no error messages as shown below. 2021-08-05 14:58:41,403 [Appian Wo

I've followed the steps from https://docs.microsoft.com/en-us/azure/active-directory-b2c/saml-service-provider?tabs=windows&pivots=b2c-custom-policy While testing receiiving the error "Application registered corresponding to IssuerUri "">https://xyz.com/suite" in AuthRequest does not have assertion consumer service URL "">xyz.com/.../AssertionConsumer" specified in its metadata.</samlp:StatusMessage>" SAML Request: <saml2p:AuthnRequest xmlns:saml2p="urn:oasis:names:tc:SAML:2.0:protocol" AssertionConsumerServiceURL="">xyz.com/.../AssertionConsumer" Destination="https://<tenantname>.b2clogin.com/<tenantname>.onmicrosoft.com/B2C_1A_signup_signin/samlp/sso/login" ID="_39d15c6a-1234-4d48-9ea6-625375271234" IssueInstant="2021-07-23T15:10:23.070Z" ProtocolBinding="urn:oasis:names:tc:SAML:2.0:bindings:HTTP-POST" ProviderName="">https:/

Hello I need to query the bapi of sap using a!sapinvoke(). For this I need to configure the input parameters and I don't know how to do it. Can you help me configure scsExternalSystemKey?

Good morning, I would like to know if there is a way to dump the support tickets directly to our company's jira and in the opposite direction. Thank you very much

I have an API response that has special characters in the attribute keys. Due to which, the sync fails when I integrated the API response to site records. Here is the API -  https://data.cityofnewyork.us/resource/5kqf-fg3n.json? Response has the following attributes in the body that Appian complains due to special characters ":@computed_region_efsh_h5xi":"24670",":@computed_region_f5dn_yrer":"41",":@computed_region_yeji_bk3q":"3",":@computed_region_92fq_4b7q":"24",":@computed_region_sbqj_enih":"61" How do I remove those attributes as those are anyway insignificant for the application. Please suggest all the possible ways a) Can we do that in API integration call itself, by handing the API response and removing unwanted JSON attributes. b) In the Records and data source sync, ignore certain fields Here are the screenshots of the API response