Integrations

We have a requirement to authenticate with a 2-way SSL. We've been trying to generate the certificate from our side using OpenSSL 3.0. Is this version compatible with Appian? Despite the correct password, we seem to be getting a failure to load certificate due to incorrect password.  We have attempted this in two ways now. First, we generated a CSR from OpenSSL and provided this to our signing authority to create the certificate. We added the private key block with the appropriate headers, and we still get the error above.  Second, we attempted to generate the certificate locally as described by this support post: https://community.appian.com/support/w/kb/330/kb-1108-how-to-create-a-self-signed-certificate-for-saml-authentication. Still we get the same error.

Hi,how can i convert the xml into base64 and send it in the request body,i get the output in base64 i need to convert it into pdf and have to preview the pdf. Any suggestion would be helpful.

Hi, I am trying to integrate with DocuSign. I have been able to create & authenticate connected system successfully. But when I am trying to call API Send Document For eSignature, I am getting this error not sure what is the issue. Please help me with it.

Hi,  i am trying to send data to Data base using Web API POST method. but, i am receiving below error. below screen shot, that refers to giving data in JSON format. could you please explain why i am getting that error message.

Hi, I tried to call web API Get method from Postman . It returns result and working fine. But when i try to call from appian . it throws error. errorIntegrationError title"The external system encountered an error"(Text) message"Failed to connect to https://api.XXX detail"HTTP/1.1 500 Internal Server Error"(Text) What could be the issue? Thanks, Dharsana.G

Hi, I have created a!writeToDataStore in webAPI which is writing to DB when I test through API,to invoke this API I created an integration of Method POST and URL accepting ri! as parameters. I am unable to write to DB when I test through integration.Can someone please help where I am going wrong. Later I want to use this integration in my interface. Thanks in advance!

I have created a WebAPI - Write to Database - POST When I send an array of data, it only takes the first dataset. How to process all the records in the array? a!localVariables( local!value: cast( 'type!{urn:com:appian:types:YM}XX_WebAPI', a!fromJson(http!request.body) ), a!writeToDataStoreEntity( dataStoreEntity: cons!XX_WEBAPI_TC, valueToStore: local!value, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!storedValues ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error writing to the data store" } ) ) )) Sample Data Set: [ { "Column1": "AA",   "Column2": 1111 }, { "Column1": "BB",   "Column2": 2222 }, { "Column1": "CC",   "Column2": 3333 } ] Thanks

Hello, I am confused as to how we can populate the body of a POST http call? I have an API that will receive a post request with data in the body. I want this data to be dynamically created in Appian.  I would appreciate the help. 

Hello people!  I am trying to find a way to connect data from a BigQuery table I have, I found a potential way to do it: By using its API.  I was able to connect correctly, using a service account , when I then create the integration and I test the connection, I do get the response with  kind"bigquery#tableDataList"(Text) etag"sU8HN6M/RRhXMIrmq4pJgfrw=="(Text) totalRows "5444"  (And I also get this ) rowsList of Dictionary - 5,444 items So, as you see the response brings the rows on it, but then when I go to the data source, it does not show me the rows, only kind, etag and totalrows columns, any idea on how to create the table based on the response I get?

Hi, We have succesfully created an integration with sharepoint as described in this link  https://docs.appian.com/suite/help/21.2/sharepoint-connected-system.html We would like to implement the DELETE operation of a document during the process inside a sharepoint folder. How can we accoplish that? all the listed operations doesn't allow it

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 ?