Integrations

I have  a requirement to send document from appian to GCP(google cloud platform) , GCP team gave the API bucket and SA key file for us and we used those credentials in connected system. Now the document which user uploads in appian we have to send that document in encoded format to GCP . How do we achive this 

I'm a senior application designer and developer with educated skills on classical Windows client-server applications. Honestly, I just started my learning path in Appian. Our use case: We have a well developed and stable running legacy application that uses a MS SQL Server 2019 as database backend. We want to "migrate" some business processes covered by the legacy app to Appian (cloud) as a showcase and proof of concept for our customers (at the first step no productive environment). The Appian application should use the data from the existing SQL Server database on our demo server. I already created a "Connected System" object that successfully connects to our SQL Server via JDBC. For setting this up I was using the SQL Server data source type and the JDBC connection string:jdbc:sqlserver://<our server public ip>:1433;databasename=<our database name>. The user and password properties are set to a valid SQL Server login that owns the target sche

Does anyone knows what's the difference between using an integration with a proxy url and enable HTTP Proxy on the admin console?

Hi! We had to migrate from Appian on cloud to on premise. Is it normal to successfully connect when using a Web API with a get (hello world) but not when using a post (upload a document)? On this case I've got a 403 - Forbidden error. 

My base url :  Base URL https://testbucket.s3.ap-south-1.amazonaws.com/   (where s3 testbucket is bucket name) relative path : /myfiles/star.pdf ( where /myfiles is folder)

Hi All, Anyone who used Azure blob storage for storing unstructured data, could you provide some insights on its ease of integrations, maintainability and performance. Also, are there any other alternatives (apart from sharepoint and Appian document repository) for storing unstructured data?

The client has AWS Db with JWT AuthenticationThere is no JWT Authentication provided in appianHow can I connect with their AWS DB now ?

Hi Process was getting errored saying the error like a!fromJson: Invalid index: Cannot index property 'body' of type Text into type Text) (Logic Output) in appian in the output of node passing the logic like below  tointeger( index( a!fromJson(it was integration:rule!UIP_GetQueueItemBy( OrgsUnitId: 100, reference: ri!reference (type of rule input reference is text) ).result.body ), "@odata.count" )) > 0 Kindly suggest on this for some instances it was working well for some it was erroring like above

I'm new to integrations and what to know about headers in it. Someone can explain the purpose of it? Thank you in advance

Hi everybody!I am getting a weird error when I try to select a connected system to create an integration object. As soon as I write anything on the connected system field: I get this error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 87317:f0efe] : Unable to find Connected System Template with the id "plugin.[uipath-connectedSystem-rwm].[UiPathConnectedSystemTemplate]@2" I don't understand why the error mentions a plugin as we are not using any plugin for integrations/connected systems.Has anyone seen anything similar?Thank you

Hello, I have a question about SharePoint integration. I have created a connector between appian and sharepoint, where I am trying to use one of the possible operations which is adding a document. To add a document it is required to provide the destination path of the folder and also the document itself. The problem is that despite the fact that I got write and read permission from the administrator for all objects on the page, I still get error: SharePoint returned a 401 HTTP error error-result-guidance SharePoint returned the following information: A potentially dangerous Request.Path value was detected from the client (?). Tank you, Michael

I am trying to fetch document metadata from sharepoint Integration which I have bult using pre built sharepoint connected system by appian. As I am retrieving the data I could not find the document data for its size, extension etc how can I achieve this as  I need the data to store document information in table.

Hi team , In SFDC integration , we are using SOQL query in operation to fetch some data for a given financial id , need to understand how to write the query to fetch data for multiple values involved.Current implementation - concat("select Id, Name, Reference_Type__c, System__c, Seq__c from SRS_Service_Request_Related_Order__c where RO_Service_Request__c " ,"='",ri!serviceRequestNo,"'");How to write above for fetching data for multiple financial id's involved , ri!serviceRequestNo will be of multiple type of string . Tried to replace above = with IN operator in where clause, it shows malformed SQL as integration error.Thanks

Hi team , In SFDC integration , we are using SOQL query in operation to fetch some data for a given financial id , need to understand how to write the query to fetch data for multiple values involved.Current implementation - concat(Select shareclass_c from breakdown_c where financial_id= ' ''' ,ri !finId) ;How to write above for fetching data for multiple financial id's involved , ri! finId will be of multiple type of string . Tried to replace above = with IN operator in where clause, it shows malformed SQL as integration error.Thanks 

Hi everyone. I have a json providing by a WebService like this : [{ "id": 1, "title": "Essence Mascara Lash Princess", "reviews": [ { "rating": 2, "reviewerEmail": "john.doe@x.dummyjson.com" }, { "rating": 2, "reviewerEmail": "nolan.gonzalez@x.dummyjson.com" }, { "rating": 5, "reviewerEmail": "scarlett.wright@x.dummyjson.com" } ], "returnPolicy": "30 days return policy"},{ "id": 2, "title": "Eyeshadow Palette with Mirror", "reviews": [ { "rating": 4, "reviewerEmail": "liam.garcia@x.dummyjson.com" }, { "rating": 1, "reviewerEmail": "nora.russell@x.dummyjson.com" }, { "rating": 5, "reviewerEmail": "elena.baker@x.dummyjson.com" } ], "returnPolicy": "30 days return policy"}] I want to create a

Hi,     Anyone here has worked on appian to salesforce integration in latest projects. Doesn't latest version of salesforce connected system covers almost all integration needs with salesforce ? like writing/updating to salesforce objects etc. Is it still recommended to use salesforce connector functions like a!sfcUpdate()?  For a brand new project, Is there still any reason to consider salesforce connector ? What are the pros & cons of using connected system versus connector regards to security , support etc ? What are connectors actually ? Are they native to Appian ? In my view , connectors seems to be outdated and better to use connected system and use salesforce SOQL/SOSL to integrate. Your thoughts & any real time experiences on this will be really appreciated. Regards, Mike

Hi Team, I am working on integrations to post data to another system. After posting the data to another system, I have to get the id from body. But the body is in text format and the id, success are concatenated. How to getch the id from body by any direct function without hampering the performance? Please suggest. Thanks in advance.

I want to know how to implement "Convert base64 values to Appian documents" without using an integration object. I have implemented a process that retrieves attachment information from an external database via HTTP connection and converts it into an Appian document.The process is as follows: 1. On the interface, execute an API request (an integration object) without "Convert base64 values to Appian documents", obtain information on 10 attachments, and store it in "local!fileList." 2. Perform a check: "If any of attachments 1 to 10 is not null, then the result is true; if it is null, then the result is false" and store the result in "local!notNullFile". 3. Press the "Get File (ファイル取得)" button.　 If the 10 file information items are judged to be false in "2.", nothing will be done.　 Only if the result is true will an API request be made with "Convert base64 values to Appian documents" enabled. 4. When th

Hi Team, I have configured a webApi to download CSV document on click, it's working when I use it in web browser but the same is not working when I use it in mobile device (Appian Mobile application). Could you please suggest the alternative ways to achieve a document download on single click? Thank you in advance

Hi all, I'm trying to set up an Integration that can send files from Appian to an Azure Blob Storage. I have the URL to the storage and the required SAS token, but I am not sure how to set it up properly in Appian. I created a HTTP Connected System and set the SAS token as a parameter. However, when I try to test the request via an Integration I'm receiving a 409 "Public access is not permitted on this storage account."  I was able to successfully connect and upload/delete/modify data via the Azure Storage Explorer with the same token, so I'm confused why this isn't working. An issue with a firewall? Mistake in configuration?  Appreciate any insights, maybe someone else had the same issue before and was able to solve it. :)  Best, Matthias

Hello we have integration with an external system and once we add the document, we use Get file to retrieve the document. In the Get File Integration if I use convert Binary to Appian document it works fine and stores the document in Appian. But we do not want to store the document in Appian, we just want it to be a downloadable link. Converting the binary to a document using todocument() to display in a!documentDownloadLink.. results in an error saying ID Not found.

Hi All.We want to understand if we can receive message from AWS SQS and start a process model in Appian. Can we use receive message event configured to receive to message from external to process type to achieve this and if yes, can anyone please tell how to test that?

We have an oauth2 authorisation with client Id , client Secret  & scope to connect to an api. We already have a connected system configured for this . This is working fine & we are getting expected response from api. Traditionally in our organisation we have a process model per application  which runs every 60 mins which generates the token  & writes to the token table. This token from db is accessed and set in the the header of the request as Authorization: Bearer ******. But it seems our code is working even if that Authorization header is deleted from the integration. It seems the connected system is adding the Authorization header to the integration request and the process model to token generation is not required at all. Does this a ring a bell ?

While invoking a POST webAPI from Postman, I am getting error as below: "Unable to get Issuer certificate" . Authentication used here API-Key. Passing as Header: Appian-Api-Key What can be possible reasons?

Hi, im new in appian. I create a get api integration which recieve multiple lists those lists recive another ones. Also i create a expression rule to parse this information with my CDT. On my forms i call this rule and it works with text information but not with lists.  This is my interface: This is my rule expression: This is my CDT: