Integrations

I cannot connect my Robot to MS Access in local PC where AppianRPAagent.exe exists.I am getting an error message "No suitable driver found for jdbc:ucanaccess://C:\AppianRPA\AppianRPARbot-CustomJavaCode\UcanAccess\AccessFile\targetDB.accdb". However, after implementing JDBC using the same connection string When java is executed on eclipse, to connect to MS Access is successful without issue.So I think the connection string is correct. In this case, I think there are two main reasons.-1. The external jar required to run JDBC has not been built to Appian. By the way, I'm using a library called "ucaccess".-2. In the first place, Appian RPA cannot access local files by design. I have two questions about 1.・Is the external jar unusable in Appian RPA?・Is there a way to check if the external jar is built correctly? I have a questions about 2.・Is this inference correct? If you know of any possible reasons other than the above, please let me know. Thank you.

Hi team, We are using the OOTB Sharepoint Integration feature to upload documents from Appian. Everything works as expected, but for random docs, the docs in SP are getting corrupted and we are not able to open it. Please note that we are able to open the same document in Appian. So, I strongly feel that while pushing documents from Appian to SP, it is getting corrupted. I also did compare the size: the corrupted document in SP are of lesser size compared to actual document in Appian. Did anyone faced the similar issue? I am sure that there is no change in Process / documents that are being uploaded and please note that it happens very randomly. Regards,Sriram. S

Hello, I am trying to authenticate with DocuSign through Oauth following their documentation of oauth https://developers.docusign.com/platform/auth/authcode/authcode-get-token/ The thing is that I am trying to achieve this without using a connected system. I have created an integration that makes the request of the first step which is: Which the response according to the docusign documentation should be a callback with a code: But the response I am getting on my integration is this (the code that should be received is nowhere to be found): Here is how I have configured the integration: Does anyone know how to configure the integration in order to get the correct response? What I need is the code that should come in the response. Thank you! 

I'm try to integrate Appian with BOX here  I have used Box File Utilities plugin and followed the given step provided in Manual I have created a App in box as well as all required key are generated in BOX Now in Appian I need to generate token for which I'm using createtoken() function from the Above plugin. Where .pem files need to be updated for privatekey and publickey parameter. I have generated json file in box and got private key. And generated public key from generate option available in Add and Manage Public Keys section. But still i'm getting below error while try generating token using createtoken() function Could anyone please guide me on this, Thanks in Advance

Can someone please help me out with how I can go about the Connected System integration between Appian and Blue Prism? I have tried creating a Connected System with type 'Blue Prism' and configured the API endpoint and credentials but getting below error when testing the connection.

Hi, How can we integrate Google calendar events with Appian and also join google meet events from Appian. Thanks in advance.

Hi, I need to call a danish web service (KMD Workzone). It uses the OData protocol, which is a protocol for REST APIs. The authentification protocol is NTLM. Problem is, I can't find a way in Appian to combine REST and NTLM: If I use an integration object, then it must use a connected system, and NTLM is not among the 7 supported authentification protocols. If I use the smart service "Call web service", then it seemingly supports NTLM, but only in combination with the SOAP protocol (it requires a WSDL). It seems that at one time the plugin WebAndXMLExtensions could do this, but it is not in the App Market anymore.  Regards, Søren Juul

Hi All, I need to pass a  Safe URI to source parameter of webContentField component and that URI is generated using web API. Problem here is when I am using the URI generated from web API it throws below error: "Interface Definition: Expression evaluation error at function a!webContentField: A web content field [label=""] has an invalid value for "source". Source may not be an internal Appian source. Received: mydev.appiancloud.com/.../YoU0wA." How can we pass the URI that is Internal to webContentField?   Thanks in advance Regards, Trunal Jain

Hello everyone, I'm just starting learning to work with Appian, I'm currently doing the Developer's Path. Today I encountered a problem that seems very simple. I just can't add Rule Inputs while creating a connection to an API I tried clicking in edit as an expression, but I'm just getting this Thanls

Hi all, Is there any way of integrating Appian with a IBM Informix database?

I am creating an application that shows an alert to users to authorize an Connected System so that an integration can work. now I want it to be shown to user only when they have already not authorized Connected System so ,how can I check if user has already authorized for a connected...??

Hi Team, We have a requirement where the client tool can only upload files which are in octet format. We have exposed a web api using "upload document" template of web-api which helps client team to upload files from their systems to our Appian environment.  Can someone help me with the code required for uploading a file in octet format from external system to our appian environment using a web api. We use appian version 22.2 Thank you

Hello! I would like to send JSON payload to external API after the user completes ADD NEW CLIENT form created in Appian.  { "lastName": "John", "firstName": "Smith", "birthDate": "1987-04-26", "emailAddress": "shogun@go.com", "mobilePhone": "+60-11-12345678" } So the information provided in this form would be sent externally. I created connected system HTTP and POST integration. I suppose I need to also create a CALL INTEGRATION smart service that would send this payload externally, after adding newly created client to Appian Data Store. Am I correct? Am I right?  I don't know how to capture in the integration itself the data from a given smart service in a process. So basically now what happens is when I complete the add new client form it triggers the call integration smart service at it sends to external API hardcoded JSON data from below. Do I need to call these process variables from JSON? Am I going in the right direction or am I entirely wrong?&n

Hi,  I am getting below response from Integration & I want highlighted part only in output. how we can achieve that? Regards, Kiran

I have a WEB API that starts a process with a start form and writes data to the record using the 'Write Records' smart service. When i test the WEB API, I get the following error. The Write Record configuration looks like this.

I am trying to upload an excel file to my application and then use this file as a data source for Tableau Dashboard. Problem I am facing here is that Tableau cannot access the file which I have uploaded on Appian folders. I am open to all kinds of suggestions for this, I just need to use the data from this uploaded excel file in Tableau as the datasource. further I will be displaying this Tableau Dashboard in my Interface using Web Content Component.

Hi, My data resides in Neo4j graph database. I need to connect to Appian and build a relational DB based on this graph data model. Is there a direct connectivity possible to achieve this? I'm looking for a direct integration from neo4j to Appian in the form of connectors or ETL tool or API's. Please let me know. Any help appreciated. Thanks, Sonia

Hi Everyone, I am trying to connect to sqlserver as a new data source from admin console  and providing the connection url , username and password as provided by the client. Additionally trying to create the connected system with the same credentials but both the time I am getting Test Failed. Please suggest if am missing something. Thank You!

Is it possible to connect Appian On-premise with Teradata using jdbc?

I have an integration requirement where the system to which I want to connect Appian with needs an Authorization Header which is in the format as: Signature keyId="<8>-<4>-<4>-<4>-<12>",algorithm="hmac-sha256",headers="(request-target) host date",signature=”**” Has anyone done this kind of integration? Note: The swagger provided doesnt have any authentication details in it.

Hi, everyone I would like to integrate Appain'DB to MS Access'DB.In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code. If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it? Thank you.

Hi, I want to send sms to mobile number for authentication. Can anyone know best possible way?

Hi, In my application I am sending emails with task/record links. The user can click on the link and the link takes him to the task/record or Appian login page, based on whether the user is logged in. I got a new requirement to count the number of clicks from email to Appian, without using any other technology outside Appian. For this, I came up with two Web API endpoints, first GET with link to itself in the email sent. GET returns HTML website with automatic POST page that utilizes second WebAPI, which runs a counting smart service and returns the original task/record link. This solution works only if user is already logged in into Appian, otherwise an ugly error is returned to the user, see below. My question is, is there some way to force the Appian Log in page in case no valid session is found when trying to use the GET API and then redirect him back to it - with the GET API being linked from an email. Thanks  error:  "error":"APNX-1-4187-000&qu

I have a requirement to access the database in Appian Community Edition from the Appian Cloud Edition. Can you list out the steps that I need to follow for this?

Hi All, I am trying to upload appian file to CMIS. I'm using CmiCopyDocumentFromAppian as AppianDocs suggests. =load( local!appianDocument, local!cmisFolderId, local!cmiCopyDocumentFromAppianWriter: bind( null, a!cmiCopyDocumentFromAppian( scsExternalSystemKey: cons!CMIS_SCS_KEY, usePerUserCredentials: true, atomPubUrl: cons!CMIS_URL, repositoryId: cons!CMIS_REPO_ID, objectId: local!cmisFolderId, properties: {name: "Example Document"}, appianDocument: _ ) ), { a!textField( label: "Folder Id", instructions: "The object id of the CMIS folder into which the Appian document will be copied", value: local!cmisFolderId, saveInto: local!cmisFolderId ), a!pickerFieldDocuments( label: "Select an Appian Document", instructions: "The selected document will be copied to the target CMIS site", maxSelections: 1, value: local!appianDocument, saveInto: local!appianDocument ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Copy Documen