Plug-ins

Hi, i am exploring building the component plug-in for the below activities: 1. i will pass the parameter to the plug-in and based on that parameter the plug-in should get the data from the database and show it on the plug-in itself 2. if i modify the data on the plug-in it should update the same data on the database. Please suggest the approach for the above requirement. please let me know if any sample plug-ins

I have installed IAM Application from the Appian App Market and also created another application with integration in it. Now I need to know how to configure this integration app into IAM app to get the integration error if there are any integration errors? Thanks in advance.

Hello, I want to generate CSV file and send it via mail.  There are smart services through we can generate CSV file but in this case my data is not stored in tables.  Please see below:  Functionality to generate CSV file on demand and send it to the User. In this Case since data is not yet saved in Appian tables, fetch inputs from Process Variables and generate the CSV when User clicks the button. Can anyone help me in this? Thanks

Hi all. I would like to capture via API the error that has occurred within a process instance in Appian. I have tried to do it with several methods through the ProcessExecutionService, but I can't find a way to do it. The error I want to capture is the one I can see within the process instance in the errors tab Could you help me please?

I want to add text field with clickable icon but I am unable to find witch plug-in i nee to use,can any one help me with this.I need text field like this.

I am looking for a way to convert Base 64 format string to document in Appian.  Note: The base 64 format string is coming as a JSON input request string when external system hits Appian web API. So, I don't have any integration object here to auto-convert the same to document using default Appian functionality in integration object. I need to receive this format, convert into document, store in Appian document folder and show the same in UI (without using integration).

Hi! I have task to generate excel file, I am using Text Doc from Template. Almost all parameters I am passing like ###parameter###  but I  also have checkbox in template in which I should pass true/false and I am not sure how to do that.

Hi Everyone, I m using the SFTP Plug-in to send a file but I ma getting the following error. This plug-in [sftp] is not registered to access secured values for the given external system key [ExternalSystem]. Check the external systems plug-ins list in the Administration Console. (APNX-1-4229-003) Here I have added the external system in third-party credentials and added this plugin in the list also but still same error. Which is causing this error?  thanks in advance.

Hello everyone, I am using plugin HTML to PDF. I have used two nodes in process model "HTML DOC from template" and "HTML to PDF". In first node("HTML DOC from template") I am passing process variable for  ###name###  (pv!customer.name) and so on for others. Successfully converted HTML to PDF file but I am having issue with multiple entries. Like: I have total 10 records but in pdf all records shown up in one line with comma separator. Note: Created a rule for this where I get all records but getting issues passing this rule in process model node ("HTML DOC from template"). for example: <table> <tr> <td> <h3> Name </h3> </td> <td> <h3> Address</h3> </td> <td> <h3> Unit </h3> </td> </tr> <tr> <td> ###name### </td> <td> ###address### </td> <td> ###unit### </td> </tr> </table

Hello there! I am using Export Data Store Entity to Excel/CSV Smart Service to export the data in Excel sheet. If I check database, there are records, but through the smart service, in Excel sheet, I am getting the message "No data available due to empty data source, applied filter/selection criteria, or fields visibility." Also, I have applied filters for specific data shown in excel sheet on the basis of id.  = a!queryFilter( field: "caseid", operator: "=", value: pv!transactionDetails.caseID_int) Please assist me in this. Thanks

I am looking to read a specific column of Excel in Appian. suppose I have 3 columns in Excel roll no. , name, and email. So, I want to read all the values in the column email as an array of Strings. 

Getting the following message when clicking the download button:  This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile. Within edit profile, there is no section to update the Member Organization, the minute you select update your able to see the join organization. I'm not here to find bugs in your application!!! Can we resolve this so that i can download the jar file.  I simply wanted to download a plugin!!!

Hi, This is mainly for the Appian team. I just noticed there is a bug in this plug-in. The moment it comes across a blank row, it treats it as the end of file. For eg, if rows 1-100 have data in any of the columns and row 101 is completely blank and 102-1000 rows have data in any column again, it only processes data from  1-100 and ignores the data in 102-1000. This seems to be a bug because previous versions would read from rows 1 to 1000. What can be done to resolve this?

Greetings, I am looking to utilize the Log Reader plugin to read the login-audit.csv files in logs. I noticed the function returns the structure CsvContents, but it is treating my first row as a header when there is none. How do I go about making it so that the first row will be part of the rest of the rows and not as a header?

I am working on Connecting Twilio to Appian, I have Inserted everything correctly and connected system authenticate properly. But the Twilio field is not working. It says invalid parameter for Sid, how can i resolve this.

I need to read and save data from XLS document. I tried using "Export excel to Database" smart service, but it is giving error "???The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (eg HSSF instead of XSSF)???". I also tried to convert the XLS document to CSV document using the "Convert excel to CSV" smart service and also tried to read XLS file in expression rule using fn!readexcelsheetpaging but still getting same error. Is there any way we can read XLS document? 

Hi, I have a requirement for generating barcode or QR Code. At present I am using Barcode Utilities plugin which is available in App Market. But this is not cloud approved. Can anyone suggest me if any other plugin available or any alternatives for this?

Hi i have polled emails using filter and poll plugin in a process model. The body is saved as a .EML file in a folder.  Is there anyway to extract the body of the EML file in to a table. Or to convert the .EML file into different format so that it can be extracted in to a table. I cannot use ReadEML plugin due to jar file conflict. any suggestions??

Hello team, I have a requirement where in the from there is a section where user need to fill order details (item, price, quantity). I need to provide an option to user to fill these details manually (this part is done) or by using an excel template. The tool should be able to read the content of the excel and fill it in the form before submitting the form itself. I know there is an excel plugin to read content but if I understand it correctly it can be read only after submitting the form. Is there a way how i can enable for the user to lead data form excel without levaing the form (staying on the same screen)? Thanks for nay answer

I am new to use this Range slider  , noUiRangeSliderField() I am trying to install the new plug in and use this range slider   My basic query is how do we save the slider value back to any rule input or local variable   , i do not see value or save into parameter  onClick: a!save( ri!value , What parameter we can pass as Value  ? )  onClick: null,onChange: null,onSlide: null noUiRangeSliderField( label: "Temperature", labelPosition: "ABOVE", validations: {}, height: "AUTO", minRange: 0, maxRange: 200, startHandle: 0, endHandle: 200, pips: null, tooltips: null, sliderOptions: null, sliderOrientation: null, verticalHeight: null, step: null, behavior: null, additionalRange: null, shape: null, sliderColor: null, backgroundColor: null, disableSliderTooltip: null, disableSlider: null, readOnly: null, onClick: null, onChange: null, onSlide: null )

Hi, I am tying to run the Mysql to Excel plug-in: with basic SELECT Queries it works: but if I sent something similar to this:   SET @pivot_sql = 'SELECT * FROM report'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;   it shows MariaDB syntaxis error.   any idea how workaround for this ?

Facing an Issue with basic user, While I was trying to get inactivated user from custom Picker, It is throwing an error like insufficient privileges for basic User Login.But for Administrator user type it is working fine and I have Updated that plugin to its recent version as well.

I want to parse CSV file and load into CDT without DB. Please suggest a plugin which is not deprecated.

Hi, i am trying to develop a smart service plugin  for the first-time. I wrote a sample appian plugin xml how ever to add more xml tags and their attributes in appian plugin xml, we need to look at xml schema namespace of appian plugin xml, can someone please  help me know where can I get the xml namespace to look for more xml tags and their attributes to add in appian plugin xml file

Hi Team, We are using Log Reader plugin to read the site_usage.csv log (https://community.appian.com/b/appmarket/posts/log-reader).  However unable to read sites_usage.csv from path "audit/sites_usage.csv" using readcsvlog plugin, after  Appian upgrade to 23.3 , however we were able to read audit/user_management.csv This function is working on older version of Appian (23.2) Please let us know if there is any way to read the site_usage.csv log besides this plugin. Site_usage.csv User management CSV