Extensibility

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 Everyone, I have created connected system with Client Credentials Grant and successfully authorized but when I configured connected system to integration, getting success but body display html format. Can anyone suggest to how to get token. My scenario : I will get token from connected system and then I need to pass that token to remaining API's as Headers.  Regards, Devi.

Hello. In my particular use case. I need to integrate Appian to Azure. Mainly because I want Azure to conduct a query for me. The reason for this is that I am dealing with a database type that is not supported by Appian so I need to find a workaround. The workaround is to pass the query from appian to azure, make Azure execute the query and retrieve the required data from the database, and pass the results back to Appian.  I am fairly new to both Appian and Azure.  Can anyone here give me a rough guideline as to where to start? 

Hi All, I am doing third party integration and need to retrieve PDF document. i am doing in below way.  Document get stored in target folder but when i open this document, this give below message. I thought to store this document in process variable by using Integration smart service. please find below. i got following below error. Kindly help me. Thank in advance.

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  I have integration with post method, I'm getting success response with token in body  but I need to call this integration in Expression rule and fetch the token field and pass that token into remaining API's.  ->I have tried to call in expression rule but getting output as "Smart Service". How to call the post method integration in expression rule. can anyone suggest on this issue. Regards, Devi.

Hi Everyone, I have integration object  with basic authentication with user name and password so I need to encrypt the password in integration. How to do the encrypt the password in integration. can any one suggest on this. Regards Devi. 

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

Hi community, Can somebody explain me the difference between body parsing to Appian value and the use of a!fromJson to convert the whole response body to Appian values? Kind Regards, Erik

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.

when I check for the Authorization on the Connected System I click on Authorized Again (Where I am assuming I get the Token) how can I automated this procedure ?

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

I'd like to send documents from our Appian environment to another system using that system's web service. It was easy to make this work with small documents whose contents I can easily stream in body of a single request. However, the web service will not accept request bodies longer than a few MB and some of the documents I need to send are much larger than that (up to several hundred MB). The web service offers endpoints that support sending the document in pieces so that I could, for example, send a 10 MB document with 10 sequential calls, each containing one of the 10 parts of the document. However, the web service documentation just provides examples in C# and Javascript, which we obviously cannot use here. Is there a way to split a document into parts? I've searched the cloud-supported plugins and don't see anything like this.

I'm trying to expose a view from the Appian DB via a Web API.  The Web API requires a Data Store Entity Constant. So I try to create a constant with a Data Store Entity type, but I need a Data Store Entity created with the View Data Type. I create the view data type without issue and add it to the Data Store but it will not save and publish (I get a 'Appian.vwMyView' is not of type 'BASE TABLE' (APNX-1-4178-000) error). Also I do not want the view created as a table as it is already created in my DB as a View. How would I add an existing view into a Data Store? 

I Have an integration that is calling an outside system and when I try to call the connexted System I need to get a GRANT TOKEN, I know I can display a link to get this token, but is there another way to get this token, perhaps on a process model? or just calling it via a rule

Hi team, I am referring service backed record tutorial , Test Request should not return a success message in Configuration of integration path, please help me to get this successful message

Interested in learning if anyone has connected PowerBI to MariaDB cloud database. If yes, which windows server was PowerBI installed? Was it using Appian Enhanced Data Pipeline (EDP)?

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?

Hi, I'm trying to integrate docker container packaged mail server with Appian application by updating custom.properties and password.properties. SMTP mail server currently integrated with Slack and works as expected(i.e. receiving slack notifications) when testing it separately using "curl" from CLI. However, Trying to test SMTP mail server integration from Appian thru process model - Send Email Smart Serrice node. I could not receive any output / email and no error messages on docker log and Tomcat logs. We've already turned on below DEBUG settings, log4j.logger.com.appiancorp.process.runtime.activities.SendEmailActivity=DEBUG  log4j.logger.com.appiancorp.ap2.mail=DEBUG It seems Appian is not communicating with SMTP mail server as we could not see any entries on docker logs. Process Model Send Email smart service status is “unattended”, this has been initiated as per tomcat logs and no error messages as shown below. 2021-08-05 14:58:41,403 [Appian Wo

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 ?