Extensibility

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 am unable to call a WEB API that uses POST (trying to write to a datastore). I made sure the service account has all the right permission. I am getting the following error: 500 - Internal Server Error Edit: Turns out the service account simply did not have access to one of the objects called. Thank you.

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  We have a requirement to switch the API end points(i.e the integration calls(among different environments) based on user selection from UI) We can dynamically generate the URLS and authenticate via Basic Auth and store the Username and passwords on a constant  but the problem is that people with designer access can view the constant values  If we provide credentials for a single environment, by default they are encrypted and environment specific but if we configure them using expression the credentials are visible to designers which is a security concern. I am looking for the way to secure them and retrieve them back in Appian using a!scsField() -(There used to be a plug-in called HTTP Request with Secure Credentials Store  but that is archived unfortunately) We are using Azure cloud services so I am not sure if there is any connected system to integrate directly with Azure key vault to store and retrieve credentials or any plug-in to integrate with SCS from App

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

Is it possible to deploy only Db Scripts through Deployment API ?

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(

I am new to appian.I have no idea. How to register data from user interface to integration object andhow to display the registered value on the user interface. Thank a lot.

Hello All, Is there any possibility to integrate  MS teams with Appian for real-time chat enablement.

Hi All, I have to make an REST API call with an integer value 17002732024, it cannot be passed as string as the receiver wont accept it. Do we have any way to achieve this. I am able to call this API as expected from Postman but when tried from Integration object, the value is converted to the max limit value(2147483647) which is not a valid value for request. Any help is appreciated. Thanks in advance!

The client wants us to log information about everything that goes in and out of the app through APIs and integrations. Appian logs a lot of stuff by default. So far I've found:  api_key.csv - saves information about any api keys used for our APIs, including identifying information for the key itself, what endpoint it was used to access, and the ip address of the client that accessed itoauth_callback.csv - saves all oauth calls that made to other systems. includes the user that made the request, the connected system it was made too and whether it was successful or notoauth_client_credentials_grant_for_web_apis.csv - saves oauth requests made to our APIs. Includes the service account that was accessed, the endpoint that was accessed, and client ip addresses Integration_summary.csv - I am not quite sure what this is. It seems to be a summary log taken every 5 minutes of the amount of time spent on all integrations in that 5 minutes. (is there some way to reduce the frequency? Ev

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

How can I call a 3rd party Web API in Appian which returns data in JSON format or XML format? Can anyone please inform me about the steps and prerequisites to integrate the 3rd party Web API in Appian?

Hi, all.We're attempting to establish a connection to an external system from Appian using a WSDL/SOAP endpoint with basic authentication. We are following the process outlined here:https://docs.appian.com/suite/help/22.1/Choosing_the_Right_Type_of_Integration.html#appian-initiates-the-interactions-with-another-systemOur first attempt via the process model and the Call Web Service Smart Service was partially successful. We were able to put our endpoint in and choose from the available services, so some limited contact was made; however, once the service was selected and the appropriate variables automatically created, running the process model caused the process to hang on the Call Web Service node, producing no error messages or feedback of any kind and populating no local variables.Our second attempt via an expression rule and webservicequery() produced similar results, but upon testing it timed out after the service and parameters had been specified.  If we put in an inco

Hi, We have a requirement to upload files coming form an external system to Appian. I am following this tutorial:   https://docs.appian.com/suite/help/22.1/passing-a-web-api-document-into-a-process-model.html I created all the objects required (process model, cdt, etc.). How can I test this in the test Inputs section? The "Body" field says Select a document. Is this asking for a full path of the file to be uploaded? What is the syntax for setting the Body field?  

Hi   Created one web api where we are starting a process  with one CDT as an input . When sending data like {["employeeName":"test",}]in the appian body and test request its working fine. But triggering the same from post man we are getting a 500 error. Web api authentication is happened properly . a!startProcess( processModel: cons!employee_processweb, processParameters: {employeedetails:a!fromJson( http!request.body )}, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!processInfo ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error starting the process" } ) )) Postman: Configured header with Content-Type:application/json sending API Key bearer token. Body format as JSON.

Has anyone configured Appian to connect with AWS SNS?