Extensibility

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)

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 

While I am working with MS Graph Poller Plugin , I am getting  access denied error :"ACCESS TO ODATA is Disabled[RAOP]"

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

Are there any plug-ins available to run the given commands on the Appian server level?A little background on the requirement, we are maintaining an on-premise Appian instance and whenever we need to un-archive processes we need admin's help in executing the necessary commands on the server level.We are thinking of automating that , for that we are checking, if there are any plug-in's available which can execute the user given commands on the server level. Thanks in Advance.

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

I need to create a dynamic DOCX document that includes a table with 12 columns, where each column automatically adjusts its width. Already I create the same but able to showing only 8 columns. The remaining 3 columns exceed the page width, so they aren't visible, although I have not define width anywhere in the code. Please help me to fix it.

Hi,  I'm researching about the plug-ins development and I've seen in the documentation that a local installation of Appian is required to develop and test any type of plug-in. For instance, in this page it says the following:  "In order to individually build a custom smart service plug-in, a licensed local installation of Appian is required. Appian Cloud customers who have a local installation must develop and test the custom smart service locally and coordinate with Appian Technical Support to deploy it on their site." Why is a local installation necessary? Is it because the Appian JAR (<APPIAN_HOME>/_admin/sdk/appian-plug-in-sdk.jar) has to be added as an external dependency in the IDE? The JAR file can only be obtained from a local installation? Thanks in advance

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?