Plug-ins

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

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.