Integrations

Hi, does anyone know what's the difference between using WhatsApp Business Connected System (plug-in) and Connected System with the base URL https://graph.facebook.com/

Hi All, I am trying to send a document to external system that accepts form-data. I am using the content type "Multipart Form Data (multipart/form-data)". I would like to change the file name only for the integration call (without renaming the document in Appian). However, Appian automatically sends the document with its document name, not able to update/rename the file name.  Is there a way to override the filename in the request? Thanks in advance for your help!

I've created a web API that retrieves data from a process model, but when I call this API during integration,it returns the following error: Error Code: errorIntegrationError Title: Error processing integration response Message: The response body could not be converted to an Appian value Detail: The jsonText parameter was not valid JSON. Received: <...>. I have attached the code a!startProcess( processModel: cons!PDBPOC_gDrivePermissionPM, isSynchronous: true(), onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader( name: "Content-Type", value: "application/json" ) }, body: a!toJson( if( a!isNotNullOrEmpty(fv!processInfo.pv.userData), fv!processInfo.pv.userData, { message: "userData process variable is empty or not set." } ) ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader( name: "Content-Type", valu

Hi All, I am getting this error when i select convert JSON to appian I am getting error invalid JSON format but when I select raw value i get response . Is Swagger file not formated well to return the JSON which Swgager file version will appian 23.2 will use and consume  ion response error-result-guidance The response body could not be converted to an Appian value The jsonText parameter was not valid JSON. Received: <... Time 498 ms Prepare: 4 ms - Execute: 494 ms - Transform: < 1 ms Value: Result This value is available as a node output when using the Call Integration smart service in the process modeler and as fv!result when configuring onSuccess and onError parameters inside a saveInto on a SAIL component or as part of a Web API. (Text) m)

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.