Plug-ins

In short, is there a way to use the Deployment Automation Manager to run a flyway repair command to recover from failed DDL executed via Flyway, or is there anything planned for a future version of the plugin to allow this? Some more background: I have been through the documentation of the Automated Deployment Manager here: https://community.appian.com/w/the-appian-playbook/198/deployment-automation Using what is documented, I have been successful in using the `-flyway_path` and `-ddl_ds` options to deploy database changes to an appian instance hosted by appian cloud, against the underlying MariaDB. In the process of proving the above, I learnt that MariaDB does not rollback DDL when it rolls back database transactions. As a consequence flyway leaves the flyway_schema_history in a state that requires manual intervention and that blocks further flyway migrations until a repair is done. Flyway has a documented way from recovering from failed migrations, which is

We have MS Poller configured for one of our application. We noticed that MS Poller smart service is not able to ingest .MSG files as an attachment, however associated mail is ingested. (Email attachment inside another email).  Kindly assist.

Hi, I am trying to export SQL to Excel but the base template would be XLSM due to macros which will hide/show columns based on certain rules. The actual file being generated by the plugin is XLSX and due the file file containing macro excel throws file corrupt error. If I manually change the generated file extension to XLSM everything works fine. Is there a way to change XLSX to XLSM within Appian or contain macros in XLSX template files. Thanks.

We are building a bulk document export functionality for our application, for which we are using the Add Documents to Zip Plugin.  It seems that Add Documents to Zip Plugin supports certain file types but not others.  So far I have not had an issue with docx, excel, PDF, or image files, but html files do not seem to be supported as part of this plugin.  Is anyone aware of what file types are or are not supported by this plugin? Additionally, when two files of the same name are added, the document paths of the two files are identical and cause an error.  Is there any way of getting around this?  Thanks! Carson

Hello, It is not the first time I do that but today I cannot download a plugin. I always receive an authentication error: "Authentication failed. Please check your credentials and try again". I'm well connected with the new connection way with 2 factors identification. Have you the same issue ? Regards

Has anyone come across the following error while opening a .docx file generated via ADT (DOCX Document From Template): Unspecified error Location: Part: /word/footer4.xml, line:0, column: 0 This error is only introduced after the doc is generated using ADT. The template being used works fine when opened using word.

Hello, We have configured SFTP Functions plugin and using the smart service "Receive Files in Folder Over FTP". Though this has worked how it has to at first, now we were not able to retrieve files from FTP and the error we see is " Name or Service not known ". Don't know if this is something related to network side credential change/ some change in the plug-in itself. Please let me know if there are any leads on this! TIA Jahnavi

Hi All, I have a requirement where i need to pass two different images over different location in docx dynamic template. «[#list logo as logo]» image«[/#list]»   location 1 . «[#list lang as lang]» image«[/#list]»  location 2. As there are two images to be added , i am passing ={logo:pv!photo,lang:pv!photo} to the Image input parameter of the smart service. But only the logo paired image is getting displayed and the other one doesn't show up. So can anyone help me in the syntax or the annotations needed to get these images rendered?

Hi, I am developing a function plugin for appian. I am following the steps in this page https://docs.appian.com/suite/help/20.2/Custom_Function_Plug-ins.html am confused about one thing. Where do I actually include the java files for my plugin? I am inclined to put them under the functionPlugin package, but the documentation is confusing.  This is my current path. I have appian SDK and google 3rd party library under referenced libraries. Is it fine to include 3rd party libraries, and did I locate them in the right folder? The reason I am confused if I included the dependencies in the right folder is that in the url above. it is mentioned in step 14 to "Add any JAR files required by your custom function to the src/META-INF/lib/ folder." Technically my function depends on the ORTools library, but can't i just use it as a referenced library?  this is what they recommend on the website.  do the dots in  "com.example.plugins.<YOUR_

Hi, My use case is the following. I need to automatically assign new daily batch of tasks to workers. Each task, worker has a set of skills. The task's skills must match the worker's.  Additionally, the algorithm must assign/distribute tasks as equally as possible.  I have come up with a way to do this by reducing this to a graph/flow problem. Problem is, it is super hard/impossible to implement this in an expression rule. As such, I want to develop a custom function in appian in Java.  Which way is better to this, via Servlet or custom plugin?  Thank you,

Hello everybody,in one cloud of ours (running Appian 21.2) we are facing this issue.We have uploaded the plugin: "Text File Utilities 2.0.0" in order to use the readtextfromfile() function.When we type the name of the function readtextfromfile in a rule, the name of functionis suggested by Appian, but when we execute the function, the following message appears:"Expression evaluation error at function 'readtextfromfile': The function 'readtextfromfile' is unavailable."I also looked at in the tomcat-Stdout.log of today but I did not find nothing related to this plugin nor to the function. Last, this problem does not arise in my personal Community Edition.Could you please give me some advice or suggestion? Any help is greatly appreciated, thank you in advance.Best regards,Paolo

Hello everyone. Is it possible for me to set the Source Document in Send File Over SFTP in my Appian folder and find the files based on the file name list provided by a process variable. Any help will be highly appreciated. Thank you.

Hello everyone, I attempted to use Send File Over SFTP and set a folder but I am getting an error below. Is it really possible to send a folder will multiple files inside using Send File Over SFTP? If yes, may I ask for guidance how to do this? Or any solution how can I send multiple files to SFTP because the way I see it we can only send one file at a time. Any help will be highly appreciated. Thank you.

Hello everyone, I am working with an SQL developer and he created a stored procedure where each time a I saved a record in his staging table, I need to execute his stored procedure to transfer the records to our main table. I am just not exactly sure how I will add it in my process model.  I am adding records to his staging table through process model too by using Import CSV to Database v6. Next step should be calling his stored procedure to transfer the records to main table. Any help will be highly appreciated. Thank you.

Interested if anyone has investigated connected system plugin for Google BigQuery (DB Connection via JDBC)?  Any information will be useful 

We are facing issues with PDF from Single DOCX plugin when generating a PDF doc form DOCX. This plugin is working whit out any issues until 21.2 Version. We recently upgraded one environment to Appian latest version 21.3. After this upgrade the PDF from Single DOCX (with Fonts) smart service is breaking when generating  document. The same DOCX document we will be able to convert in other environments(21.2). We are not sure what is the root cause. Could any one know the root cause for this issue. The following is the log error from the tomcat-stdOut.log Fri Sep 10 17:03:08 GMT 2021 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disa

We are exploring calling Appian as a Client API from a custom component (docs.appian.com/.../reference-js-api.html, and I'm looking into ways to get a user's service context in order to exectue some backend services (i.e. ContentService). I could probably make some calls via Integrations/Web APIs instead, but I'm trying to work with document manipulation, so everything needs to happen server-side and it seems clunky to have my ClientAPI call an Appian WebAPI vs use public API calls. I see few other components out there are executing ServiceContextFactory.getServiceContext(username)**; but when I've tried to replicate that, but my component is returning a 500 error and this exception: --- "com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.lang.VerifyError: Bad return type Exception Details: Location: com/appiancorp/s

Hi, Could someone please me resolve this issue? We are facing severe issue in the application. Because of this we are not able to upload the files to the an outside system. execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.plugin.wss.smartservice.AbstractCallSOAPWebService - Error invoking web service com.sun.xml.ws.client.ClientTransportException: The server sent HTTP status code 401: UnauthorizedThanksFaisal

hi, i want to overwrite/update the existing appian users email address in our environment.  i loaded the users into pv from csv document. want to iterate this user update in the process model. i am looking for update user profile smartservice. but am unable to find the plugin in community. can anyone help me here?

Hello team,  I was wondering if receiving files from SFTP can fetch files by batch or just one file at a time. Also, can we specify what files to be fetched only based on the file date when it was uploaded to the server? Thank you.

Hi All, OKTA is not able to verify APPIAN using event Hooks?  we have create get and post api in Appian ,but still its not able to connect . I think missing very small part. Did any one connected earlier then please help

Hello everyone. I was advised that I need to start creating a process to fetch file from SFTP and retrieve date from the fetched file. However, they are still discussing with another team to provide us the details for the server to be used so I was wondering if I can use my own computer as file source or any free 3rd party that I can use to start developing. If there is can you kindly discuss what are the details that I need to set it up.  Any help will be highly appreciated.  Thank you.

readexcelsheetpaging( excelDocument:cons!BOOK_4, pagingInfo:a!pagingInfo(1,-1), sheetNumber:0, numberOfColumns:4 )

Hello, I'm currently using Environment cleanup app from App Market and I was able to clear older versions of process models. But, I do not see the versions of constants/ rules being deleted.  Any help appreciated.  I'm currently using content tools plugin version 1.4.0 Note: Delete Rule/ Constant node is being executed, but the versions are not being deleted. Thanks.

Hello - We are trying to configure the MSgraph Mail Poller Plugin . The required values in the credential store are tenant , Client Secret and Application Id . We have given all the values but we are getting an exception as below :- 2021-08-09 19:28:56,733 [Appian Work Item - 1020 - execution02 : UnattendedJavaActivityRequest] DEBUG com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartService - Connecting to MS Graph authentication provider2021-08-09 19:28:56,743 [Appian Work Item - 1020 - execution02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.msgraphmail.MSGraphMailPollerSmartService - Unexpected error polling for mailjava.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.MSGraphMail