Integrations

Hi Everyone, I'm receiving filename and content_base64 from an API which I'm calling it in Integration and in the response of the integration using following way Can I provide Name of the document as I receive in the response of the API where i get the filename.  I tried to access it but didn't workout thanks in advance.

We are trying to download documents from s3 inside the interfaces using getpresignedurlfors3 functions, we are able to download almost all other type of documents except we have identified that when we are trying to download pdf docs we are getting error- Failed to load PDF document.(PFA the screenshot).Fyi we are using chrome.Please advise what should be the fix for the issue..

Has anyone successfully used the Mastercom connected system to support a full claim lifecycle?[mention:005befc4f9474f6c888fcbc1f908efa9:f7d226abd59f475c9d224a79e3f0ec07]I've noticed that the ability to create an update the initial claim needed to submit a chargeback isn't included. Wondering if anyone else has had the same issue and was able to get around it? Since Mastercom uses OAuth 1 I was hoping to be able to use this connected system to facilitate getting around Appian's lack of Oauth 1 capabilities.

Hello, We are receiving a response via an Appian Integration Object, but the Korean characters in the response appear to be garbled or broken. According to the API provider, the response is encoded in UTF-8, and Appian also uses UTF-8 as the default charset. However, the Korean text is not displaying correctly. Could you please advise what might be causing this issue and how we can resolve it? Thank you.

Hello All, Is there any occasion CALL INTEGRATION node will stall and gets stuck for any reason (300s, 400s and 500s HTTP)? I expect it moves on irrespective of the call result. I don't plan on handling exception in the node but examine the result/error after the call.  Would like some recommendations from the community. Thanks.

I have created a integration for integrate google chat space but it shows an error like :-  "error-result-label You are not permitted to perform the requested operation error-result-guidance The external system understood the request but refused to authorize it HTTP/1.1 403 Forbidden" When I click on "Click here to authorize," the authorization is successful, but it still shows the same error afterward. Am I forgetting to pass any necessary parameters?

Dear anyone, I am currently trying to execute Box API that uses JWT, I saw an article that said that you need to set "Third-Party Credentials" when executing the Box API. However, the connection is not working properly, so if you know which field to set in the Credentials, please let me know.   Thank you very much in advance for your assistance. Best regards,

I'm using a Google Sheets connected system in Appian with OAuth 2.0 authentication. The integration works initially, but I'm encountering an issue where the connection requires reauthorization almost every hour. Has anyone faced a similar problem with token expiration or session persistence? Is there a recommended way to maintain or refresh the token without requiring manual reauthorization so frequently? Appreciate any suggestions or best practices to resolve this.

In integration if the response is in xml format, how to convert it to appian value and save in a record type

We call the expression rule (ER) "cursor_value_from_previous_call" from the "Cursor" integration. This ER invokes another expression rule, "CursorValue," which extracts the cursor value from the integration's response body. The extracted value is then passed to ER "cursor_value_from_previous_call," which returns the JSON value in the following format: Request Body: { "cursor": { "value": "" }} Value is null for the first call, for other subsequent calls, we pass the value that we have extracted from the first call. Kindly refer the flow diagram below: I am not able to achieve this without using the logic of while loop. For loop is not helping as the variables are immutable. Any insights are highly appreciable.

Can I call an expression rule from an integration's request body?  Note: The response of the expression rule is a JSON body. Method: POST

Hello, I am working on an integration where I need to set a custom value for "boundary". The HTTP request is of Content-Type: multipart form data. The other system expects the boundary value to be "cpi".  In Headers, I set Content-Type as "multipart/form-data; boundary=cpi". However, in the HTTP request that Appian generates, Appian seems to be using a random boundary value, and ignoring the value that I have set.  HTTP request that I see:  I see this data in API trace logs.  The integration works through Postman, and I see the correct boundary set. Postman screenshot.  Thank you in advance for your help. Regards,Harish

I have an interface that calls 2 different intergrations. There is data that return for both integrations, but it randomly returns null after calling it multiple times.  I have inserted where I am calling the integrations. a!localVariables( local!historyData: a!refreshVariable( value: index( rule!GET_incomingRequestHistoryByID(requestId: ri!requestId).result, "body", {} ), refreshOnReferencedVarChange: true() ), local!requestDetails: a!refreshVariable( value: index( rule!GET_allIncomingRequestsByID(refundRequestId: ri!requestId).result, "body", {} ), refreshOnReferencedVarChange: true() ), This is what my error looks like when 1 integration returns as null This is what my local variable looks like when both integrations return data: 

Extract data from database tables and populate a PDF form. The PDF should contain editable and fillable dropdown fields that allow users to select values dynamically

Hello, We need to download .msg files (Outlook mail) from an External System using an integration that receives the document as base64. The current problem is that Appian is able to download that document but without its extension, using the "convert base64 values to Appian documents". I suspect it's because the MIME Type "application/vnd.ms-outlook" is not supported by the integration object as established in the following documentation I found: https://docs.appian.com/suite/help/25.1/Integration_Content_Types.html#document-(auto-detect) https://www.iana.org/assignments/media-types/media-types.xhtml Is there any way to workaround this? Any help is appreciated Thank you!

Hi All, We have requirement to create cases based on the mails received in one or more mailboxes in Appian. Kindly guide us on use case or plugin which will help us to achieve this solution. In addition, we have to classify mails based on the subject line of the mails.

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)