Plug-ins

Hello. I am having a trouble while using this plug-in. i am trying to get data from a cell in an excel file but the file is in the xlsb format and the plug in gives me the following error : Expression evaluation error at function 'readexcelsheetpaging': com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence. is there anyway to use this plugin for these files? Or is there any work-around to get this same functionality? This is a step in my process model where the user has submitted the excel document. 

Hello, I have a requirement where I want to build a html file out of a template which would have some special characters i.e Greek characters.  The html file is generated properly and even the alphabets are also displayed eg: alpha , beta etc.  But when the same file is converted to PDF using the HTML to PDF plugin the Greek alphabets are not displayed. We are currently using: HTML Doc from Template to generate the HTML document. HTML to PDF plugin to convert the HTML into a PDF. Can any one suggest what we can do here ,any configuration we can use? Regards, Salil Raje

HI Team, We are trying to connect SFTP to Appian Server using the SFTP Smart service, We are getting the error - "  Auth fail for methods 'publickey,password' " We are providing all the required configration mention below. 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "hostname", serverPort: 22, scsExternalSystemKey: "key", privateKeyFile: private key , usePerUserCredentials: false(),) Plugin Verions - 4.1.0 We have tried multiple times to connect using ppk , pem files , still we are getting the Auth fail issue. Help us with some guidance , if anyone gonne throught this.

I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB. Is this an expected behavior of this smart service? Is there any way to import or read a csv file with null values?

Hi everyone, I'm running into an issue with the "Import Excel to Database" smart service plugin in Appian. When I upload a .xlsx file that has been marked as "Confidential - Internal" in Excel (using sensitivity labels or classification settings), the plugin fails with the following error: "The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (e.g. HSSF instead of XSSF)" However, when I upload the same file marked as “General”, it processes successfully. Both files are .xlsx format. The only difference is the sensitivity label (General vs. Confidential - Internal). The error suggests the file is being interpreted as .xls (OLE2 format), even though it has an .xlsx extension. It appears that applying a "Confidential" label might be modifying the file in a way that makes it unreadable to the

Dear anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. If someone else has sent about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated.   [Error details]　*This is written in the body of the HTTP response. "{"error":"invalid_grant","error_description":"Please check the 'box_sub_type' claim. The value for 'box_sub_type' is invalid"}"   [Procedure] 1.Obtain a JWT using the createtoken() function of the “Box” Plug-ins. 2.Execute the Box API to obtain Box's Access Token.   *An error occurs here.   [Already Confirmed] 1.Applications created in Box have been approved by the Box administrator. 2.'box_sub_type' and 'sub' classifications must match.   Thank you very much in advance for your assistance. Best reg

Dear Anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. I get an error stating that the JWT is an invalid value, but when I check with jwt.io I can see that it is a valid value. If someone else has sent a support request asking about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated. [Error details]　*This is written in the body of the HTTP response. body: "{"error":"invalid_grant","error_description":"Signature verification failed"}" ・Confirmed JWT in jwt.io Thank you very much in advance for your assistance.

Hi everyone, I'm trying to load json to db using this Appian smart serivces. My sample json data i have given below. It has multiple dynamics parameter for example user have multiple types of phone number. if it flattens json file then its working without any issue but sub paramters are not working as expected. Added more details below Main Issue while accessing the json sub parameters which is dynamic In smart service Load JSON to a database, "JSON key/Column Name mapping" Field for json fields key i have tried like this Phone.number as well as Phone[].number but while executing Process model considered as "FirstName", "Phone" as column instead of each table column fields like FirstName, PhoneType PhoneNumber. I cant able to navigate inside of sub paramters while mapping json key to table columns name Plugin name: JSON Tools Smart service name: Load JSON to a database my sample appian rule { "FirstName": "First_

I am getting this error on html to pdf converter node - java.lang.Exception: java.lang.IllegalArgumentException: null incompatible with Global antialiasing enable key Following is the html body retrieved from email Best regards,Isac Hi Eunice/Team, All set: Hi team Pls set up both tranches Thanks, Eunice Trader Additional Comments Term Sheet;<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="">schemas.microsoft.com/.../omml" xmlns="">www.w3.org/.../REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--/* Font Definitions */@font-face {font-family:"Cambria Math"; pa

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 

Can we get the UUID of Groups in Appian via any function or plugins in an expression rule.

We recently upgraded an environment to 25.2 and when we use the  Create & Read Email Files Utilities from the App Market we are getting an error "An error occurred while creating a note" on the front end and  Could not create EML java.lang.IllegalStateException: Error while searching for service [jakarta.activation.spi.MailcapRegistryProvider] in the tomcat logs. Has anyone received these errors or know of a way to fix them.  We use this plugin quite a bit to create custom notifications to the users.

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.

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

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?

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?

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] 

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) ) ), ) } ) ))

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

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 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!