Plug-ins

Hello everyone, i installed fitness for appian and configured the config.properties as shown in the documentation. But i'm getting the errors below. this is my code: !define TEST_SYSTEM {slim} !define COMMAND_PATTERN= {java -Dlog4j.configuration=file:///${automated.testing.home}/log4j.properties -cp %p %m } !path ${automated.testing.home} !| script |com.appiancorp.ps.automatedtest.fixture.SitesFixture | |setup with |CHROME |browser | |set appian url to |https://url here| |set appian version to|20 | |set appian locale to |en_US | ***! By the running the code above i am getting this error: I have jre 1.8, but jdk path is not set. Could that be the issue?

Hi, On 7/20 we upgraded from 22.1 to 22.2.  We are using the Amazon S3 Utils version 1.1 and we can no longer upload to S3 after the upgrade.  This plug-in [com.appiancorp.ps.plugins.amazonS3Utils] is not registered to access secured values for the given external system key [s3prod]. Check the external systems plug-ins list in the Administration Console. Error Occured: Error while uploading the file to Amazon S3. Error is: The security token included in the request is invalid. (Service: AWSKMS; Status Code: 400; Error Code: UnrecognizedClientException; Request ID: c1e7278c-ca73-46bd-bcf9-c510a620018a) Thanks, Scott

Hello Team, I would like to know if there is any plugin/smart service available to split data from one sheet and place it to multiple sheets in same excel? eg: suppose if I have 100 rows in first sheet of excel, I want to cut first 25 rows from it and place it in new sheet. Thank you in advance.

Hi I'm not able to deploy the  SQL to Excel Plugin as its not shown when searched in add plugin on Appian cloud environment. What might be the reason?

Hi ,I would  like to know why i'snt more available this plugin? it is marked as "Archived" on Appmarket. one month ago i have downloaded and  tested it and it was working as well...is there some other same plugin that i can use?BR//A.Milani

Hello, we have an issue with one of the plugin called Content Tools (https://community.appian.com/b/appmarket/posts/content-tools). We use a function "getdownloadersfromgroup" in an expression rule to find who downloaded the file. We did not have a problem with this function until now. Whoever wants to execute this expression (besides designers) gets this error: Error Evaluating UI Expression Expression evaluation error [evaluation ID = 99b65:7ceed] in rule 'hrzn_checkdownloadvalidation' (called by rules 'hrzn_s_coverletterac' > 'hrzn_f_authoritycorrespondencev2') at function a!forEach [line 4]: Error in a!forEach() expression during iteration 1: Expression evaluation error at function 'getdownloadersfromgroup' [line 6]: The user [...] does not have sufficient privileges to perform the requested action. Even if we set security of this expression "hrzn_checkdownloadvalidation" to All users -> Administrator, they still get the er

Can you please explain how i can export the data from excel to database? There is no documentation or step by step process which i can follow. A simple example with few rows of data and a table will suffice.

I have a setup where a particular column of a table contains a JSON object that I need to search through. I basically want to go through each row in that table and use JSONpath to filter out results, but I am unsure how to apply that to an appian query of the data. I figure I use JSONpath as an expression in a filter, something like the image below, but I don't know what I would enter for the required 'value' parameter. Is there something like fv!item which is used in foreach loops, but used in query filters that I can use here? Otherwise, if I am going about this all wrong, can someone explain how to use jsonpath within an appian query so I don't have to do something like query everything and filter it afterwards with JSONpath? 

Hi all, I have installed the GIS plugin [https://community.appian.com/b/appmarket/posts/arcgis-map-integration] into my DEV appian environment.  I am now trying to wire it up to our GIS system.  However, there is very little [as in zero] guidance on what the properties fields are supposed to contain.  I have tried putting the URL of our GIS system into the Map data property of the plugin [after putting the ArcGIS Map component onto an interface, however it doesn't accept a URL.  There is no documentation or examples that I could find that describe how I am supposed to wire this component up... can anyone suggest what I need to do to link this component to our GIS system? thanks heaps, David :-)

I'm trying to get from ad SFTP repo a file when i click on a startprocesslink i'm able to retrive date from the repo. but i want to directly download file on desktop client machine of the user onSuccess of the process.

Hi Team, I wanted to compress appian documents which are uploaded by user, so i can zip them and send to other system via exposing an api , Can we  have any plugin for this? Thanks,

i Wanted to store appian document into blob format in database, Can we  have plugin for this

When using the SFTP Smart Services plugin, is it possible somehow to get the date that a target file was last modified? I would like to check to see if the file I'm about to download is the most recent version or not.

Hi,  I need to encrypt text with an asymmetric algorithm.  I hope to use "Java Cryptography Architecture (JCA) Tools" because it exposes many algorithms to use, and I want to use RSA/ECB/PKCS1Padding.  I don't see any method to generate Public/private key and every key I passed to keyencrypt I obtain an error:   "Expression evaluation error at function 'keyencrypt' [line 5]: An error occurred: java.security.InvalidKeyException: unknown key type passed to RSA"  This is "my code" (the key it's a generated public key):  keyencrypt( cleartext :"cleartext", key: text2hex("MIICIjANBgkqhkiG9w0BAQEFAAOCAg8AMIICCgKCAgEA4IJZLsjlx+o4RSvafaAcReoNnzrI0UXu7kZyXPe31ql32X9AvhC6QQIUmLkr1Evm0zP/SgVG9YX3DSqBUgPo04iv1I1/wNKwAf1/uH9EiiqdpczefyxxnzJiKUTcx2/4mA4E4QxCIL5JsZb78WoYZrd2kToW/WD01MnSFiCgSyjGdd812GY2EVzfvlv8kYuti3icMUyitEfHhtw8cAWI6/nVrRPNs0e5NsvtZJ0nfrXsfQDR0C7+ivQK+fQabi8oRGsbTZceAvVlqVE669zoIwIFLcB+eY

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