Extensibility

Hi,  I am doing some research in to the Google Chart Plugin ... https://community.appian.com/b/appmarket/posts/google-charts-component-plug-in?CommentId=209280fe-6dcb-45e6-9bf7-81336dc6e24d Would anyone know if an item on a chart could be stored in to a variable? I can see there is an onSelection parameter, I am curious as to how an item from a chart could be saved down such as an ID to enable further drilldown behaviour? Thanks.

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!

The requirement is that Process should start on the Inbound email should receive by the process. And We need to show the Inbound Email uploaded into the task automatically, so i have used the "Create EML File From OOBT Poller" plugin which was giving the expected result but the formatting in the Body content is giving in a single line. Please suggest a way to align the email body content Process Model The output file from the pulgin 

Hello All, We're calling an integration within a process model that receives a JSON document (approx. 95 MB in size). Using the Load JSON Document To Database plug-in to dump the data directly into a database table. The Process model completes successfully. However, we're capturing the following error in the logs: "Error parsing JSON Content or audit data" Please share your thoughts on this. Thanks In advance Lokesh

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 Everyone, We are using Appian cloud and we have a requirement to move few CSV files to Appian server folder (/apps/cgdata/folder1). I have to read as well as write files to this location. Which smart service we can use and do we need any particular access for it?

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

We upgraded the plugin to 4.1.0 and while using the latest smart service '(SFTP) Get Remote folder Contents' replacing the deprecated smart service "Get Remote Directory Contents over SFTP", we got the below error: "Algorithm negotiation fail: algorithmName=""server_host_key"" jschProposal=""ssh-ed25519,ecdsa-sha2-nistp256,ecdsa-sha2-nistp384,ecdsa-sha2-nistp521,rsa-sha2-512,rsa-sha2-256"" serverProposal=""ssh-rsa""" The same smart service (SFTP) Get Remote Folder Contents works fine with the Plugin version 3.0.3. Is there a known resolution to this error?

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.

Hi Everyone. I am facing an issue with export data store entity to excel. We are using this smart service in our application to export data to excel, it is working fine in Both DEV and SIT environment. We have set up a new env to test our code in that environment all export smart is failing and throwing this error when clicked. As part analysis i have created a sandbox application in all env and created test application in that an interface to test a!exportDataStoreEntityToExcel() function, its again failing in new environment but working fine in DEV and SIT environment.   Can anyone help me out why its throwing this error? [mention:a11f77a729fb4db2af76b09948583328:e9ed411860ed4f2ba0265705b8793d05]  [mention:b45a4f6a20b14a008e4e0ec732a8bf98:e9ed411860ed4f2ba0265705b8793d05] 

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 All,  Please advise how do I write a Query rule to fetch case Id and folder id from database ? Below is the query rule I've written to fetch the case Ids and folder Ids from database. How do I map this to a process Model? a!queryEntity_22r2( entity: cons!ABC_CASES, query: a!query( pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1,) ), selection: a!querySelection( columns: { a!queryColumn(field: "caseId"),a!queryColumn(field: "folderId") } ), logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "caseId", operator: "=", value: ri!abc_cases.caseId, applyWhen: not( rule!APN_isBlank(ri!abc_cases.caseId) ) ), ) } ) ))

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

I am using Import CSV to Database v6 to import CSV file to a database. I have a field in the table that is not part of the CSV. I tried to configure the additional column and additional value thinking that will store the value into the table but it didn't save the value in the table. Any thoughts how to populate the field in the table that is not part of the CSV using this plugin? For instance, my table has 5 columns, my csv has 4 columns and I want to store a value in the 5th column of the table (e.g. hardcoded value). Thank you.

I'm using this readlinesfromtextfile plug-in, which is currently no longer available on the App Market, I get an error during conversion where every accented letter or apostrophe is converted to this value � .Can anyone help me?

I am using TextToHex() function available in HexFunction Plugin. Is there any replacement plugin available for hexFunction ? is this cloud approved for version 25.2 ? 

Hey Everyone, Im trying to embed a powerBI into one of our Appian apps. Considering that this report has to be exposed to users who might not have powerBI licenses there is a way to expose it externally within an application by using "Embed for your customers" feature.  Understanding the different embedding solutions in Power BI embedded analytics | Microsoft Learn     This means that the only potential obstacle is Appian. I have observed that the webComponent in Appian appears to be unable to pass any data, including tokens (it can only accept url). Is there any other way for implementing such functionality? I believe that creating our own custom plugin might be an option although I dont have enough expertiese in it yet to make that judgement. Would custom plugin be able to achieve this requirement or is there any other easier way in Appian to do the same? I had a look at some existing powerBI plugins but they dont seem to be for "Embed for

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/

i'm using Export Data Store Entity to Excel plugin is giving the above error  = a!queryLogicalExpression( operator: "AND", logicalExpressions: { if( pv!isAdvanceSearch, { a!queryLogicalExpression( operator: "AND", filters: { { a!queryFilter( field: "firstname", operator: "includes", value: pv!firstName, applyWhen: a!isNotNullOrEmpty(pv!firstName) ), a!queryFilter( field: "middlename", operator: "includes", value: pv!middleName, applyWhen: a!isNotNullOrEmpty(pv!middleName) ), a!queryFilter( field: "lastname", operator: "includes", value: pv!lastName, applyWhen: a!isNotNullOrEmpty(pv!lastName) ), a!queryFilter( field: "screeningstatus", operator: "=", value: pv!scrStatus, applyWhen: a!isNotNullOrEmpty(pv!scrStatus) ), a!queryFilter( field: "country", operator: "=", value: pv!country, applyWhen: a!isNotNullOrEmpty(pv!country) ), a!queryFilter( field: &quot

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!

Hi everyone, I'm working on a project where I need to generate quote PDFs that include both dynamic data and images. I’m currently using Advanced Document Templating (DOCX from dynamic template → PDF from DOCX), and while the DOCX file looks great with the images inserted, I’m running into alignment issues when converting it to PDF — the layout shifts and the formatting isn’t consistent. Has anyone else faced this kind of issue with images during the DOCX-to-PDF conversion? Also, I’m wondering if HTML to PDF might be a better approach for this use case. If so, does anyone know how I can include images from Appian document folders in the HTML content? I need to add them dynamically, similar to how I’m doing it with DOCX templates. Any suggestions, experiences, or tips would be really helpful! Thanks in advance!

Hello, we have the MS Graph Email Poller installed and operating. However, I noticed today that the BCC_EMAILS and BCC_NAMES columns are not populating for ingested emails. Is there a configuration or setting that needs to be applied in order for those to work? Thanks

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)