Plug-ins

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I have a scenario to use ReadExcelByHeaders.  But it is throwing me an error:Expression evaluation error at function 'readexcelbyheaders' [line 3]: java.lang.NullPointerException: Cannot invoke "java.util.Map.entrySet()" because "expectedHeaders" is null

Hi All, I am connect sftp with the help of SFTP (https://community.appian.com/b/appmarket/posts/sftp-smart-services) , seems able to connect sftp server as getting success status but no files getting downloading into Appian from folder & specific file as well. No logs in log file as well. What can be issue here ? Thanks in advance. Abhay 

Can anyone please tell me how to implement microsoft teams plugin successfully. If there is any document please share the link

I implemented the Google Maps Component Plugin in the Dev and Test environments, and everything worked as expected. However, after deploying to Production, Google Maps is not functioning. Upon inspecting the browser console, I see the following error: Failed to load resource: the server responded with a status of 404 (Not Found) - Googlemap.svg. I’ve checked the server configuration, and it appears to be identical to the other environments. Any idea what could be causing this issue?"

Hello Community, I have developed a custom plugin for Appian and have completed initial testing within the Appian testing environment. Now, I would like to test this plugin outside of the Appian platform to ensure its robustness and compatibility in different scenarios. Could anyone suggest tools, frameworks, or best practices for testing Appian plugins externally? Are there any recommended approaches for simulating the Appian environment or mocking necessary services for comprehensive plugin testing? Any advice or shared experiences would be greatly appreciated! Thank you,

I have a Process model where the flow of nodes is like this: I am sending a file to SFTP temporary folder, and adding a delay time node for 10 seconds and next i am using a Rename and Move file over SFTP smart node where i am renaming the file and then moving it from temporary SFTP folder to another permanent folder. At this point, the system is throwing the below error: 'Error renaming file in the remote server. See application server log for more details. Error Message: Specified file path is invalid.' My guess here is that the file is not having enough time to move from one folder to another, because if I just restart the node its working fine. How do i add a delay in the 'Rename and Move File Over SFTP' so that the file will have enough time to move from one folder to another. 

Hello Everyone, I have a requirement to generate excel file contains 2 sheets in it. In my case there is already one file generating using Export DSE to Excel, below approaches i tried but no luck. Can anyone help me on this Approaches:- 1.2 DSE nodes with merge excel documents but this won't suffice my requirement2.Used Combine excel sheets plugin but this is not working as expected getting error as Invalid Null arguments & output of this node have integer type Hoping to get responses from you guys thanks

Hi Team, We are using Kafka Tools plugin to utilize consume and Publish Kafka services. We can able to perform publish Kafka service without any issues. But when comes to Consume Kafka we have questions as follows, Consume Kafka service shows isSuccess output as true but it didn't received Kafka server. To find reason which log we should check? What is the difference between Group ID and Topics? whether we have to pass both as same? Deserializer Class Name field is not mandatory? if we pass "io.confluent.kafka.serializers.json.KafkaJsonSchemaDeserializer"  as deserializer it throws error like io.confluent.kafka.serializers.json.KafkaJsonSchemaDeserializer not found by com.appiancorp.cs.plugin.kafka [50] And in the process model, why TM_Transaction variable is not populated with value after consume Kafka service showing it is success?

I need to create a dynamic DOCX document that includes a table with 11 columns, where each column should automatically adjusts its width. I have attached a code snippet that generates a DOCX document with a table showing only 8 columns. The remaining 3 columns exceed the page width, so they aren't visible. Please help me to fix it.   SAP Number Part Number Description Manufacturer Group Spare Qty Delivery Date Price Total Remarks ", a!forEach( items: local!selectedEquipments, expression: concat( "", "" & fv!item.sapnumber & "", "" & fv!item.partnumber & "", "" & fv!item.description & "", "" & if( a!isNotNullOrEmpty(fv!item.manufacturer), fv!item.manufacturer, "--" ) & "", "" & fv!item.group & "", "" & if(fv!item.spare, "Yes", "No") & "",

Product: Apryse WebViewer Component Plug-in Product Version: 5.5.1 I am using Apryse webviewer in Appian for document comparison. I am passing 2 appian doc id as parameters. But as soon as the interface is loaded it shows " Error while loading document ". But when I am manually uploading the two doc it works fine. Here's the screenshot of the error. . This is the code used for apryse webviewer ... webviewer( label: "WebViewer", labelPosition: "ABOVE", validations: {}, height: "AUTO", hidden: null, key: null, url: null, serviceAPIKey: null, appianDocId: { 224563,788333 }, preflattenDocuments: null, documentFolder: cons!FOLDER, uploadChunkSize: null, userDisplayName: null, enableReadOnlyMode: null, enabledElements: false(),

Is it possible to use an HTTP Connected System with Appian.Component.invokeClientApi in a custom component plugin, or do you need to use a custom connected system plugin?

When attempting to run the example test case I get exceptions, the biggest one of them being in the script. I followed all the instructions correctly and I am not the only one in our group running into the same issue.

Hi All, Good Day! I am trying to create a servlet and that servlet will return a value from the Appian server. While deploying the plugin in Appian env, I am getting the below error:[Appian Plugin Hot Deploy] ERROR com.atlassian.plugin.parsers.XmlDescriptorParser - There were problems loading the module 'servlet'. The module and its plugin have been disabled. [Appian Plugin Hot Deploy] ERROR com.atlassian.plugin.parsers.XmlDescriptorParser - There was a problem loading the descriptor for module 'servlet' in plugin 'Constant Servlet Plugin'. There must be at least one path specified: <servlet class="com.example.plugin.ConstantServlet" key="ConstantServlet"><path>/constantValue</path></servlet> com.atlassian.plugin.util.validation.ValidationException: There must be at least one path specified: <servlet class="com.example.plugin.ConstantServlet" key="ConstantServlet"><path>/constantVal

Hi all, I'm trying to create a token for my Box integration using Box plug-in createtoken() function: privateKey and publicKey points to PEM docs containing publicKey and privateKey from box developer console / JSON config file downloaded from Box Dev Console sub: enterprise ID kid: publicKey ID from JSON config file iss:client ID from JSON config file I assume setup of my PEM files might be wrong, here are my steps:1. Generate Public/Private key pair in developer console2. Copied both keys to separate .txt files3. converted them into pem files4. uploaded to appianare these correct? I'd appreciate any advice,Thanks

Hi Everyone! I am facing an issue in microsoftDocumentEditorField(). Issue: The excel is loading for so long. It has two columns and two rows. Code:  microsoftDocumentEditorField( tokenInfo: generatemicrosoftdocumenteditortoken( viewMode: "View", document: 202370 )) Note: I tried using the Id/constant containing document for Document Parameter.

I recently installed MSgraph Poller plugin and done the setup, its fetching mails and saving EML and attachment as Documents. but its fetching all the Emails . My requirement is to only fetch Unread emails from "INBOX" folder. As per documentation there is no any such filter i can pass to the smart service. Other approach i Tried is creating integration object with MSGraph HTTP API (connected system). but implementing a simple fetch and save attachment/EML  takes multiple api calls to graph api  and on top of ot need to parse and write those data to DB for further case creation. Anyone Worked on similar requirement? what would be best approach if i want to create case in appian based on mail and its content and save those contents in appian.

Hi everyone, we are using kafka tools plugin. Sometimes we are able to receive some messages via kafka and sometimes we don't get anything. For times that we don't reveive any message, you cannot see instance in Appian. Is there a log file on cloud on which we can confirm that we received or didn't receive kafka message into our environment ?

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I am using Export Data Store Entity to Excel smart service to get the document and stored it in Appian.In this, I have marked one of the column's visibility as false. Now, when I try to read the excel sheet using readexcelsheet(), It's not giving me the hidden columns.Anyother way to hide the columns in document but retrieve it in readexcelsheet()

Created a Custom Plugin jar, based on the instructions mentioned in https://docs.appian.com/suite/help/24.4/Custom_Smart_Service_Plug-ins.html . Deployed the jar in admin/plugins folder as per the instructions. The plugin does not load and show up Process Modeler. The server and Appian(on-prem) instances starts up normally.

Hi community, I'm having some issues regarding the deployment of a custom component plugin. When I deploy it via Admin Console or Hot deploy (by placing manually the plugin in the path \appian\_admin\plugins), it is not being updated on the enviroment. It always use a previous version. Why is this happening? And what could I do to end this behaviour? 

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