Extensibility

Hello Everyone, I am new to Appian I am trying to use Integration object where I have used QR Code Generator API I want to use that body ID 4424 but when I am calling that in Expression rule it is giving reaction tree so can you please help me how can I get that body ID.

Hi All, Is anyone aware of Export Database Data to CSV smart service? We are using this smart service in one of our processes and saving the data in one table using Import Database Data from CSV. Export in CSV is working fine but when importing the data in table, it is giving format error on date column. We want to find how this Export Database Data to CSV works to understand if this format change is occuring when generating the CSV. We are currently analysing all the possibilities of this issue. Kindly assist. Thanks and Regards,Diksha

Hi, I am unable to convert csv to excel using smart service "Generate Excel from CSV" after downloading plugin "CSV to Excel", version: 1.0.1. It was working earlier with version 1.0.0. Please update us with a solution to this since it is impacting business requirements. Regards, Akansha Kumari

Hi, I've created an Integration component and I have a PDF to send to a remote REST API (by POST method). So I've created an Appian document, and I've upload a PDF file (Test1.pdf) as it. When I call the remote API, I get an error in the response : "developerMessage : Extension non authorized - filename: "Test1.pdf.zip"  " Do you know why this component is adding ".zip" extension to the PDF file ? Of course, I've tested it before in Postman and all works fine. In my request body (in Appian), I've set my param like this : Name : "document"   Content Type : Document (auto-detect) Value : (RI is uploaded with Test1.pdf) I've tried another way : Content Type = Custom (with  application/pdf) but I obtain another error : "Internal error: Required request part 'document' is not present" Any idea ?

Hi anyone know how generate qr code with embedded logo in the center of the qr?

Hi All, These are the steps which we have done to generate the Doc. Step 1: Created a Docx using Create Dynamic Doc from Template. Step 2: In That Docx we have a table, we have a paragraph and we have an Image which populates dynamically which is like a signature.                                                                                                    «[#if signature?has_content]» Your sincerely,   «[#else]» No Signature added «[/#if]» Step 3: the Docx

Hi All, We have a Use Case in which we need to do the excel header validation for the Excel File which is having 358 columns and 12000 rows of data. When we tried to execute the below code: fn!readexcelsheetpaging( exceldocument: ri!excelFile, sheetNumber: 0, numberOfColumns: 358, paginginfo:a!pagingInfo( startIndex: 1, batchSize: 1, sort: null ) Output : It is not returning any data for 12000 rows, however it is working for max 8000 rows in excel file. Do anyone has faced same issue or error ?

Hi All Good morning! Can you please let me know if anyone has used the  googleGanttChartField or timelinechartfield plugin in Appian to create a gantt chart using dynamic data, (i.e) data from a record type. If so , can you please providing the guidance or a sample code snippet to configure the same ? Thanks for your help! Regards Soniya PS

I have requirement That One question with multiple answers using poll option Can we do polling in Appian. Thanks, Divya

We are attempting to create an SSIS package for our on-premise MSSQL Database to create a connection to the Appian Cloud Maria DB. Is it possible to create an ODBC connection to facilitate this integration? Unfortunately, we cannot utilize the built in Connected System for integrating MSSQL due to our VPN being outbound only.  Thanks!

Hello All, The requirement is to send the entity data with the header and footer. Header and footer contain dynamic data. Header is not columns name; columns name will be the 2-line code. The file needs to be csv Pipe separated file. Sample file. H|2022-11-16|Filename Name|Age|City|Department Sahil|26|City1|Dept1 IBM|27|City2|Dept2 Appian|28|City2|Dept3 T|2022-11-16|Number In the above sample file data, the bold one is the header and footer. Thanks in advance

Dear Team, Am getting the following error message while calling a Endpoint from browser, only in one environment we are facing this issue and rest all working fine. Any advise would be helpful. {"resource":"\/suite\/webapi\/invalidWMUrl","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"} Thanks, Sunil

Hi there! We are looking for a plugin for QR Scan, We need scan and detect a QR from appian interface. Have we any way to do that? without take or upload photos? Usually we have seen this in many apps and Appian should have a way to do that. Thanks in advance!!

How can i get the data from the api into the interface ? like in my scenario i want the movie details once i enter my movie name , and the thing as i had created the intergration using the link and it's working .now i just want to know how can get the values in my interface once i click the movie and submit button.

We have what is effectively an API broker or proxy tool between our Appian instance and an API we consume.  The broker/proxy requires API Authentication to properly identify our system and allow access to the API's that it brokers.  It does not however leverage it's own API keys to the services it represents.  As a result, we have to pass a second API key through as a header.However, I have security concerns about the storage and security of this second key. Has anyone had experience and advice to secure this secondary key?  It appears as clear text in the request headers,  must be available in the integration or connected system (unlike the primary API key - which is masked and unreadable in the Connected System), and I cannot use the secure credential store to secure it.  Even if I store it in a constant,  I'm concerned about the potential security. Advice greatly appreciated.

After updating the plugin getting the following errors (Note: It was working fine in the earlier version) : Import CSV to Database v6  - Changed to Date Format must be one of the following 'yyyy-MM-dd', 'yyyy-MM-dd HH:mm:ss', 'yyyy-MM-ddTHH:mm:ssZ', 'HH:mm:ss'.Snippet of Datetime format - "2021-12-10 14:20:42.740"    Load CSV File To Database (Using Out-of-Box Appian Datasource) - java.lang.Exception: This method only work with MySQL databases.

Hi Team, I am looking for a plug-in or Public Appian API or function to list all Folders in an Application including rule, process model, KC, document folders. I tried with below function which returned only the folders inside KC of an application when given searchCriteria with APP_PREFIX&*. Please do the needful findcontentbyattribute( searchAllContent: false(), contentType: "folder", attributeName: "name", searchCriteria: "<APP_PREFIX>*") Thanks, Bharathwaj RK

Hi Everyone , i want to extract pdf file data into database. if any smart service or plug-in is available in appian  ?  like: ( we have importfromXL to XL files ) please suggest the best way to achieve this. Thank you

Hi I am trying to find inactive users using getuserlastlogin function. It returns date for some user and for some user it returns null. Am I missing anything?

redirect an link of tempo record to site 

We are trying to connect to a hive DB via a Rest API hosted in Openshift cluster, the .pem for the hosted environment have been imported to Appian environment via Client certificate and trusted certificate Still we are unable to establish the connectivity to the Hive DB due to SSL connectivity error. We have created certs for the Rest API hosted environment and imported the same to Appian , but still Appian is unable to establish the connectivity via Rest API call. Appian version used : 21.4 When trying to connect to the given host ip via openssl s_client -showcerts -connect <ipaddress> following was observed CONNECTED(00000003)write:errno=104---no peer certificate available---No client certificate CA names sent---SSL handshake has read 0 bytes and written 0 bytes--- Can we know why Appian is unable to connect to Rest api and what certs are needed for Appian to trust the cluster in which this Rest API is hosted?

Hello, is it possible to listen to an email address? Maybe something like, whenever there is an email with a certain subject then do something.

Can we hide a table along with its header dynamically in a word document if no rows are available for that table??

Hi All,Getting the below error while calling integration.Thank You.

Hi, i have a requirement to extract a particular cell(integer) from an excel sheet the specified cell is in G column 46th row. Please update on the solution.