Plug-ins

Hello, We are using MS Graph Email Poller for our project, and we upgraded to the latest version 3.1.0. Based on the documentation we followed all the instruction but we are getting as ErrorMessage: "Error executing the request" nothing else, could you share any insight what can cause this? Thanks, Suhas

I've been using the "SFTP Smart Services" plugin to retrieve a csv file through a process model. What I'd like to do is download the file, read the data, then write the data to the database. Right now I am stuck on the retrieving part. The "Receive File Over SFTP" node works without error (at least not any error that stops the process model) and in fact I am seeing the file appear in the document folder I sent it to. However there are some problems: 1) the file is listed as "Not in this application" (an issue I only care about if it prevents me from doing the rest of the operation, which I assume it doesn't) 2) when I look at the process details, the error output says "2: No such file" and the status says, "FAILED" 3) the document output doesn't output the file we've just retrieved.  Since the document id isn't output, I can't go further than this in the process model. Any ideas on what I am doing wrong?

Hello World, I want to convert pdf, jpg, png documents into Binary format.  What would be the right procedure to achieve this. regards Navneet Kashyap

Hi All, I am generating a document using DOCX from dynamic template smart service but the document is not generating, error says that one of the field consists of "<" symbol. When I removed the symbol then it works. Could anyone please suggest if "<" symbol is supported in docx from dynamic template smart services. Thank You

The plug-in is not compatible with Appian 22.1. what else can I do to import csv to database

I'm using Executestoredprocedure plugin in 21.3 version to execute stored procedure in Oracle database. The procedure using Cursor as out parameter to return select statement result. I found out the open cursors are remaining open in database. Any thought to solve this issue?

Hi team, can anyone suggest me is their any plug in to download folder from the sharepoint

Hi, I'm trying to configure the MSGraph Email Poller and I have given all the required values in third party credentials. secret tenant: using format login.microsoftonline.com/.../ applicationID But I'm getting below error: 2021-08-09 17:50:26,625 [Appian Work Item - 0 - execution00 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartServic e - Connecting to MS Graph authentication provider 2021-08-09 17:50:26,863 [Appian Work Item - 0 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartServic e - Unexpected error polling for mail java.util.concurrent.ExecutionException: java.lang.NullPointerException at java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java:357) at java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1908) at com.appiancorp.ps.msgraphmail.MSGraphConnector.<init>(MSGraphConnector.java:75) at com.appiancorp.ps.msgraphmail.MSGraph

Hi All, In order to read site_usage.csv log and convert it to readable format I am using readcsvlog (Log Reader - plugin) . But I am facing issue like these params are timestampColumnName, timestampStart, timestampEnd not working and I am getting massive data without these params. Is there any way to filter the csv log data based on timestamp range while reading the csv using plugin. When I read the entire set I have to loop huge number of time for getting the timestamp and filtering it based on date range which is causing performance issue. Regards Bihitak

I want to export grid data obtained from stored procedures to Excel without the need to create any CDTs (I have different tables from different stored procedures) I'm trying to use Export SQL to Excel in a Process Model in order to do this. I can provide it the query (which, once again, contains a stored procedure in almost all cases).  However, when I debug it, I always get the same error, java.lang.reflect.UndeclaredThrowableException My configuration at this momento is the following: -Node inputs Cell_Keys (empty) Cell_Values (empty) Add_as_new_sheet=true Document_name_to_create="SQL_Excel" Document_save_directory="PM Artifacts" Document_to_overwrite (empty) Excel_base_template="PM_blankexcel" (a blank Excel file created following a kind of step by step made for this situation some years ago in Appian community discussions) Include_header_row=true Jndi Name= (here I literally pasted the Connection URL I used in the Connection System obje

Hi Team, Is there any plugin or any way to upload copied image from windows clipboard snipping tool to Appian? like we do in jira , service now Regards Bihitak

Hi All, I have a requirement for converting hebrew language DOCX Document to PDF Document.I have tried to convert using "PDF from Single DOCX (with Fonts)" Smart Service from dynamic document generator(https://community.appian.com/b/appmarket/posts/dynamic-document-generator).But Hebrew Language content is replaced with ### symbol in created PDF Document using this smart service.So I created constant, added two hebrew ttf document ("NotoSansHebrew-VariableFont_wdth,wght.ttf","NotoSerifHebrew-VariableFont_wdth,wght.ttf") and added as Font Documents in that Smart Service.But still I got the same PDF document with replaced ### symbol. Could you please suggest, what kind of font document we need to upload for hebrew language to get original Hebrew Language PDF Document?  Also I have used "HTML Doc from Template"  Appian smart service to create a HTML document with Hebrew content and using the generated HTML document I tried using the "

Team, We are trying to use MS Graph poller plugin to poll mails from mailbox. We have created an application in Azure and received applicationId,client and secret. But not clear on below highlighted text? What exactly we need to do to add mailbox in the application we created in azure? Any one used it can guide please? Azure team also dont know what to do. In Azure, register an application for Appian to use client credentials. This applications needs to have all mailboxes in scope where you want it to be connecting to. Any documentation which guide how to link mailbox in application scope?

Good morning, I'm trying to obtain a report from a grid. I obtain that grid via an SQL query so I thought of using the SQL to Excel Smart Service included in a plug in for Appian Community Edition, but i haven't been able to obtain the desired result due to "java.lang.reflect.UndeclaredThrowableException". My configuration is the following (I filled the fields marked with * as I guess they are the only required ones and also a couple of the not required ones): -Add as a new sheet=true -Jndi Name= (I copied and pasted the connection url I'm using in the connected system) -sheet_name="output" -sheet number=0 -sql= "EXEC dbo.spRepRevenues '', ''" (which I know works due to the grid showing in the interface using .results) -document name to create (not required): "probandoplugin"  -document save directory (not required): "PM Artifacts" My only guesses are that either the jndi name is wrong (I als

Hello, I am having the following error com.appiancorp.plugins.LoggingPluginEventListener - Failed to load Plug-in 'test.plugin version 0.0: 'Component plug-in approval verification failed. Please contact Appian for approval process' while trying to deploy a JavaScript Component Plugin on server with temporary license as it is just for POC Is there any solution to above ,knowing that I tried to register my machine through AppMarket submission page but it gives me error Please enter a valid FQDN for a non-production environment with an active product license Thanks in advance Nancy Ahmed   Update :I got my developer token and I applied it on my development environment but I am getting same error and I do not know from where I can start investigation

Hello, I see the below error while executing the custom plugin function. I verified the connection and third-party credentials, and it all looks correct. Could anyone please help me understand what the issue could be? Error: (Expression evaluation error in rule 'cbg_po_eds_addmerchant' at function fn!cmpo_eds_ws_getbotwinstitution [line 3]: Unable to find a required instance of SecureCredentialsStore.) (Data Outputs) Server Log:  2022-05-20 21:36:25,659 [Appian Work Item - 173086 - execution05 : ExpressionGroupRequest] ERROR com.appiancorp.process.engine.ExpressionGroup - An error occurred while evaluating expression: addMerchantResponse:rule!CBG_PO_EDS_addMerchant(requestId_int: pv!requestId_int, billingAccount: pv!billingAccount, customer:pv!customer, customerMailAddress: pv!customerMailAddress, appianPrdId: pv!appianPrdId ) (Expression evaluation error in rule 'cbg_po_eds_addmerchant' at function fn!cmpo_eds_ws_getbotwinstitution [line 3]: Unable to find a

Hi everyone, I want to use a!documentViewerField()  but it only works for PDF. I want pptx files to be displayed to user. How can I achieve this?

Good Day Experts, When i tried to convert XHTML to docx i'm getting below error. Can anyone please help me how to overcome this issue ? Thanks in advance. Cheers, Kalai.[View:/cfs-file/__key/communityserver-discussions-components-files/19/error.log:320:240]

Hey there, I'm developing a custom function plugin that will require an http request to an external server. This is done using a third-party Java library. However, in order to make a successful http request, I need to configure a proxy. I have configured the proxy via the Admin console, but it seems this is not getting used by plugins, so I have to manually set the proxy settings in the plugin code. I wanted this to be an easily reusable plugin. Is there a way to pull the proxy configured in the Admin Console for use in function plugins? Thanks in advance. Cheers

Hi, We have updated Dynamic Document Generator Plugin version form 1.8.5 to 1.8.7. After upgrading DOCX from XHTML is breaking when generating document, we didn't make any changes to our existing logic. The same code is working with older version - 1.8.5 in other environment. Based on the error looks like it missed some classes. Error:  com.appiancorp.suiteapi.common.exceptions.AppianRuntimeException: com.appiancorp.suiteapi.common.exceptions.AppianException: java.lang.NoClassDefFoundError: com/lowagie/text/DocumentException @jialin.wang @Appian please fix this issue ASAP Caused by: java.lang.NoClassDefFoundError: com/lowagie/text/DocumentException at org.docx4j.org.xhtmlrenderer.docx.DocxRenderer.(DocxRenderer.java:160) at org.docx4j.org.xhtmlrenderer.docx.DocxRenderer.(DocxRenderer.java:85) at com.appiancorp.ps.xmlfo.ss.DocxFromXhtmlWithStyling.runSmartService(DocxFromXhtmlWithStyling.java:61) at com.appiancorp.ps.xmlfo.ss.AbstractDocumentGeneration.run(

Hey all, we've been seeing an error with the CDT Diff Utilities plugin on occasion (below).  This error occurs sporadically.  In one process we have seen the error occur for ONLY ONE user 25 times, when we reassign that task to another user, they can complete it with the same data with no issues.  The user completes the same tasks regularly, and sometimes the error does not occur.  Data entered is similar.  The error has occurred 25 times for this single user, while they have had 672 successful submissions.  Otherwise, 67 users have completed the same task 16,897 times without issues. In 2 other medium-use processes the error has occurred one time only each, 1 in a script task set to run as the designer (our admin account) and 1 during a form submission by a different user than the one above. I see one other post related to this error in the plugin's discussion thread, but no other results via search.  Wondering if anyone else has experie

Hello Community, I wanted to know about its efficiency when exporting complex SQL queries in Export SQL to Excel SS, as we have used this smart service to generate data for multiple sheets in excel, but if multiple people triggers the final parent process at the same time, it crashes the server, any one can guide to avoid that or any alternatives ? Is there an issue with this smart service ? Thanks in advance.

What would be the best solution for displaying the data by reading the data from uploaded excel from an Interface? Use Case: 1) Upload the Excel in the Interface. 2) Read the data from the excel.(multiple Sheets - Each sheet will not have more than 10 to 20 rows) 3) Show the data in the Interface (Each sheet will be related as one to many relationship) Note: Sheet1 will have parent table data and other sheets will have child table data

Hi I'm trying to read an excel using Parse Excel to CDT smart Service. I would like to understand in what format we need to pass the value is this parameter.