Plug-ins

We are trying to get the token out of the Client API in the Connected System from the Component. We need the username or any user details to generate the token for those requesting the token from the Component. We can send the logged-in user information in the payload of the request, but due to security concerns, we shouldn't pass any user details in the request. Is there any way that we can get the requester details from the Connected System? We tried getting a username from ProxyConfigurationData(Java object) got from ExecutionContex(Java object). It returns a null value if a proxy is not configured. We didn't get any user details from the SimpleClientApiRequest object. Please let us know if there is any other way or workaround to get the requester details from Connected System. Also is there any possibility that we can get requester details in servlet? Thanks, Santhosh Kumar A

Hi All, Anybody faced this KB-1097 error .can you please tell me how can we fix this .In knowledge base i can see only limited details Thanks in Advance

Hi, I have a requirement  to export and download an excel file with more than 50 columns. As the Appian OOTB functionality allows to export only 50 columns I tried using the plug-in "Excel Template Merge" - Append Sheets smart service. But the downloaded file is not an excel file even though the result parameter doesn't contain any error. If anyone has a solution, please let me know.

Hello, Is it possible to embed an image (dynamically) with excel while using Export Datastore Entity to Excel Smart service or Export SQL to excel? Regards, Priyajit

When the editor loads for the 1st time, whether passing in anything (valid HTML, text) to richTextValue via local variable or rule input, the editor does not display the value. As soon as designer edits the SAIL, e.g. remove the richTextValue parameter and undo (ctrl-z), or toggle isReadOnly, the value is displayed., Usage bar shows % as >0, so it seems to think that there is value there, but is not displaying them. Steps to reproduce: Create new UI object, and add Advanced Rich Text Editor component Create a rule input of type Text Set richTextValue to rule input Supply a text value, e.g. "Hello" as rule input, set as default value Save object and close Open object - observe that "Hello" is not shown on load Toggle to Expression Mode, delete richTextValue parameter, and undo (ctrl-z) - observe that "Hello" is now displayed this comment is from [mention:33845a86f6114d5582c6d5fb658efbe2:e9ed411860ed4f2ba0265705b8793d05] and i have the s

Hi All, We have a requirement to read login audit files from all the application servers on a High Availability cloud environment. We have researched about the plugin 'Log Reader' which can read login audit files. However, from the discussions on its AppMarket page, we are unsure if it can read the log files from ALL the application servers, and not just the default one. We have also seen a note about its latest version which reads 'This version is to support HA environment'. However, we could not determine the exact steps required to read the log files from all the HA nodes. Has anyone actually implemented a similar feature using this plugin? If so, please share how you managed to read the log files from all the HA nodes. Many thanks!

Hi Team, I almost have 2 Lakhs records and 134 columns to export into excel sheet from the Appian database. I am already using Export SQL to excel as Export data store entity to excel doesnt allow me to export more than 50 rows. when i do this it exports till certain set of data for example 1 Lakh records. But after that it is not exporting the data. I tried exporting them in batches of 5000. so first 5000 will be exported into a template. and the next 5000 the output of this will become the template. we tried merging of Excel sheets to but it also fails after 10 Excel sheets. Is there any other better way to do this please. TIA [emoticon:c4563cd7d5574777a71c318021cbbcc8] Harsha

we have an requirement where we need to populate some fields from pdf using fill pdf smart service.fields not having special character or symbol are populating successfully but fields those are having special character unable to populate.so anyone can help to resolve this issue.snippet for the code are as below. { {name : "County", value : "Adam"}, {name : "Parcel No", value : "98765"}, {name : "Price/Consideration", value : "77777"}, {name : "Doc. 1 â`“ Grantor(s) Name(s)", value : "Mike"} }

Hi community, ProcessDesignService pds = ServiceLocator.getProcessDesignService(sc); TypedValue tv = pds.evaluateExpression(expression); pds.evaluateExpression(expression) is giving the following error: The type com.appiancorp.process.expression.ExpressionEvaluationException cannot be resolved. It is indirectly referenced from required .class files I am not sure what jar file is required to be included on the build path to resolve this error. Appreciate if someone could please let me know the details. Thanks, Arun

Hi , We want to develop customized card layout component with custom styling, this layout should allows other APPIAN sail component  as contents inside it as Appian card layout allows . Is there any possible way to achieve it by creating component plug-in ? 

Hi, we are using on-premise dev environment. We want to create our own custom button with some different style. Could you please suggest what all methods need to be implemented and how to register plug-in to our own environment without registering it to Appian App marketplace? Can it be achieved from Appian web designer as server access will be limited? 

Hey everyone, is there a way to automatically retrieve the XMLs of objects (Integration objects in particular) of an application?

Hey, I am using the TypeService interface and calling the getType() method to return Appian DataType value for a CDT passed into a smart service. cdt variable is of class TypedValue Long cdtTypeId= cdt.getInstanceType(); Datatype cdtType= ts.getType(cdtTypeId); But I get this error.. The type com.appiancorp.cache.CoupledValue cannot be resolved. It is indirectly referenced from required .class files This shows up in in the IDE during build for the line ts.getType(cdtTypeId). Does anyone know what is needed to get this to work. Or another way to get Datatype from the TypedValue class

Hi I have an excel file contains data as shown above. I want to update the calendar by reading the excel file by programmatically or using any plugin. Is this possible? if yes, how? Thanks. 

Hi, We are using Import Excel to Database plugin to import data to Oracle DB. We are facing issue related to the primary key auto generation. We have sequence to autogenerate the primary key. But while using the plugin, we are facing the below error "???ORA-01400: cannot insert NULL into (Table_Name.Primary_Key)???". When we are trying to have a column of primary key with value, its working fine but auto generation of primary key is not happening. Is there any limitation to the plug-in? 

Hi team, can any one please suggest me the steps or any link  to download the  plug-ins of  time line chart and  google chart component in my application and how to show Gantt chart data in interface  i am not understanding from where to start

Hi all, I have a requirement to retrieve the list of applications and display for each user the applications that he can view them. Any ideas ?

Hi  My dataset has multiple entries of working and non-working days in excel. I want to update the working and non-working days in a calendar. I am reading excel file using readexcelsheet paging function and generating calendar process variable by using read calendar method . While iterating the rows in excel as an output it just updates the first row only. How to read all the rows in excel.

We have a requirement to embed excel on the Appian UI and this Online Office Integration Plugin seems to be useful for us. However, we are getting below error   I know this might be a silly question , from where we get WOPI Client URL. If anybody has already implemented this can you please help us here. We are trying to do a short POC so that we can show it , we are using our own office 365 account for testing purpose.

Upon reading or uploading an excel file receiving the following log error 2022-01-20 21:09:00,529 [ajp-nio-0.0.0.0-8009-exec-6] ERROR com.appiancorp.ps.exceltools.expression.ReadExcelFileFunction - Failed to read zip entry sourcejava.io.IOException: Failed to read zip entry source I am uploading a .xlsx file but it is saying failed to read zip entry source. 

Hi All, I am trying to use "Receive a file from RDBMS BLOB" smart service and it is appending zero every time in the file name. Can anyone please help me on this. Any reply is appreciated. Thanks in Advance, Neha Raghuvanshi

Hello, I am using Send File Over SFTP smart service and I'm supposed to place a file in docfiles folder of F drive in the destination remote VM. So I've given the remote file path as "F:/docfiles/sample.pdf"  However File is not being transferred to remote file path and I am receiving No Such File error in Appian though I have sample.pdf available in Appian repository. Any thoughts pls ? Error transferring file to SFTP server2: No such file

I would like to know if we have any replacement or equally functioning Deprecated Export CDT to Excel. I am aware we have Export DSE to Excel but my requirement is to export the local data into Excel and we are not storing data in the table.

Hi, Mail server to database smart service is not working for 21.4 appian update. Its working fine with same configuration for 21.3.  Getting error [Cipher suits are not appropriate] may be the security needs to be updates in java.securities file.

I need the correct format to create inputs when calling the Execute Stored Procedure plugin from an expression rule.  Here is my entire rule. I want to send an integer as an input (and ri!num is an integer) into a stored procedure and retrieve the results as the dataset is too large for Appian to handle comfortably.a!localVariables( local!spResult: fn!executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "jsonValTest", inputs: { id: ri!num } ), local!result: if( local!spResult.success, local!spResult.result[1], local!spResult.error ), local!result )Here is my stored procedure: The SQL query when run as a query minus any parameters works. Have I fouled the SQL procedure or do I have the syntax wrong on the execute stored procedure (or both)? Thanks in advance.