Plug-ins

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

Hi, I'm trying yo configure the MSGraph Email Poller and I'm giving the required values in third party credentials as follows: secret tenant: 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 Does anyone knows what could be the root cause of this issue?

Hello -  We are trying to use the Poll Email from Microsoft Exchange EWS API Plugin to retrieve emails from the office 365 mailbox . Our Mailbox is on cloud and we have to connect to the EWS service URL via a proxy . So we need to set the proxy flag as yes while called this plugin . The issue is when we setup the proxy flag as Yes . The plugin is asking for proxyUsername and proxyPassword . Our server proxies do not authenticate so we don't have these credentials .  We are trying to pass them as null on the third party credential screen but the plugin keep complaining with the error " Required field proxyUsername does not exist in SCS " . It looks like when we add these fields on the third party credential screen , the key value changes to lower case but the plugin is looking for parameter "proxyUsername" . Has anyone else tried to pass the proxy details to this plugin ? 

I am patching some plug-in to meet our requirement. And it use some appian jar. for example : com.appiancorp.exceptions.jar. But I cannot find these jars in appian site, only see the API here. So how  can i get it?

Hi All, We have a requirement where we need to have a protected columns in excel. I am using CDT to excel plugin. But this works partially. Meaning I have getting the protected columns but it also marks all other columns as protected which I have not set as protected in my template & which has data. Prompt response will be appreciated. Thanks

Hi,When I tried to create a custom connected system template I’m getting error The System Has Encountered an ErrorHTTP Code: 500APNX-1-4198-000 Error Evaluating UI ExpressionExpression evaluation error [evaluation ID = LTZZ4L1B] : Error creating bean with name 'plugin.package.Template]': Failed to introspect bean class [package.Template] for lookup method metadata: could not find class that it depends on; nested exception is java.lang.NoClassDefFoundError: com/appian/connectedsystems/templateframework/sdk/configuration/FolderPropertyDescriptor$FolderPropertyDescriptorBuilderAppian version 19.1  On premises Sdk from https://github.com/appian/integration-sdk-examples/blob/master/Connected%20System%20Plug-in%20(CSP)%20Examples/Hello%20World/build.gradlebuild jar, how to guide docs.appian.com/.../develop-first-connected-system.htmlCan Anyone help me on this?Thanks in advance.

Is there any limitations on the rows or size of the csv to be used in Import CSV to Database. I am getting ArrayIndexOutOfBoundsException when I used a CSV with nearly 1,96,000 rows with 41 columns.

Hi Is there an easy way to find  what are the places pv is used in process model? Scenario is we have a pv in process model in which the values from db is stored. Need to find whether that pv is used anywhere else  Thanks in advance

While using Import CSV to Database when I am trying to have 41st column. I am getting the below error - Missing IN or OUT parameter at index:: 41 Is there any limitations on the number of columns to import or if I am missing something. Note - This is working absolutely fine for the 40 columns and its happening only when I try to have 41st column.

Hello All, Do we have any OOTB function or plug-in function to achieve series sorting ? Example : Input {1,1.1,1.1.1,4,1.2,3,2,2.1,2.2,10,13,12} Expected output : {1,1.1,1.1.1,1.2,2,2.1,2.2,3,4,10,12,13}

Hi All, Did any one know if we can integrate Appian with MS Access to fetch and update data? Read some ideas of using JDBC and ODBC connectors which were articled years ago. Please let me know if there are any other alternative solutions/ comments on this. TIA

T This smart service is working fine, only we are not able to write the 1st column(A) data of csv into database. Result displaying like below Is there any specific condition added to plugin code to read the data from 2nd column. If anyone knows the issue, could you please help me with the comments..

Hello guys, We just upgraded to 20.4 and found the plugin downloaddatasubsetfromrule is no longer working. We see the following error:        The system has encountered a problem        We’re sorry! A problem occurred while processing your last request.       Please contact the system administrator for more information. The plugin is available and loaded in the Appian. Anyone had this issue? Is there a fix for it or an alternate solution? Appreciate a quick reply. Thanks. Mahesh

Hi Team Is there any plugin or way to read .msg file which is having attachments in it?I know there is a plugin MSG File Read but for few cases it throws errorhttps://community.appian.com/b/appmarket/posts/msg-file-reader Any lead will be appreciable. Thanks

So I have figured out how to create a PDF template using the Fill-able form feature but I am very confused on how to add images.  I have an interface that allows users to upload pictures and need those to be added to the PDF that is created. I am using the PDF Doc from Template Smart Service.