Integrations

Hi,We are trying to implement sending and retrieving files from AWS S3 bucket. Is it possible to be implement the same without using any plugin? If yes, how can it be proceeded since AWS S3 is new for us. Any help would be helpful.

Hello team, CONTEXT: During the process lifecycle, we want to use blob storage for long-term storage of files that have been stored for a long time in Appian. If users want to access these old files, appian will have to make a GET request to blob storage to retrieve this file and persist it for eventual viewing or download. I'm trying to send a file to a container in Azure blob storage through an API with a PUT method and I'm facing some problems.  I tested via postman, the same endpoint, with the same settings (headers and query parameters), choosing the binary format for the payload, and uploading the file. I sent the file to the blob storage and called the Get request in Appian to retrieve it. I was able to access the file perfectly in Appian. When I tried the same thing in Appian, the following situations occurred: 1. When I selected the Content-Type: Document (auto-detect) option, the API returned a status of 403 - Forbidden. 2. When I selected the custom option

The article: Integration Object - Appian 23.3 says that if the response body is in JSON format, the maximum size of the response file should be <5MB. In our environment, there are instances when we are getting Integration response when the file size is 7MB and there are instances where we are not getting integration response when the response body is 5.12MB with the error :“Response body size limit exceeded.” Any explanation to this query is much appreciated. Moreover, When a file is encoded in base64, its size increases by approximately 33% compared to the original data size. This made me curious how the maximum limit for JSON body is 5MB and Base64 is 75MB.

I am getting the below response from Integration which is of type HttpResponse [statusLine=HTTP/1.1 200 OK, statusCode=200, headers=[object Object], contentType=application/json; charset=utf-8, body={"jobId":"01091664F27E4771A9B92AEA0CC577ED"}]. I need to get the JobId value from the above and i ll have to map it to a process variable. To achieve this, i used an expression rule and used the below code: if(a!isNotNullOrEmpty(ri!integrationResponse),a!fromJson(index(ri!integrationResponse, "body", null)),{}) It resulted in "[jobId:01091664F27E4771A9B92AEA0CC577ED]" but i only need the JobId value from it. I tried various functions but nothing seems to be working.  Can someone please suggest on how to proceed with this?

Hi, We are trying to integrate an application with DOCUMENTUM/CMIS document management system. The APIs used do not work for large documents due to the 5MB input/output size limitation in Appian's Integration objects. We would like to know if there is any way to integrate with this document management system, such as a marketplace app, plugin, or other, from Appian, to work around the size limitation. Does anyone have an idea? Thanks

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