Extensibility

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.

HI,  I'm trying to use Delete Rule/Constant Versions smart service to delete rules from a specific folder, I was able to execute the node perfectly, but the versions of rules/ constants are not being deleted.  Can someone suggest on what needs to be done? Note: Currently I'm using 1.4.0 version of the plugin.

Hi everyone,I am new into appian I am trying to use Integration object. I am using this url https://icanhazdadjoke.com/ for generating random jokes but it is giving me this error cn you please help me to resolve it

Hello , I am trying to use the uipath connector to connect to my onpremise uipath orchestrator. When I enter the data I get this error and I do not know the reason. Can someone help me ?

I am having trouble figuring out how to add events to the calendar template utility that I've added to my application. I'd like to be able to add events directly from the calendar interface if possible. The process model has already been created, I'm just not sure how to go about actually implementing the functionality.

I am trying to import the calendar template plugin to my application as I would like to use the calendar component in an interface. However when I try to import the zip file, it is only importing the CT application and a couple of the folders but nothing else. I ran an inspection and got the above result. In the import log I am getting the reason for the error as "User Does Not Have Rights to Perform this Operation (APNX-1-4071-007)". How would I go about fixing these issues and importing the entire package?

Hello, I am trying to use the Call Web Service smart service in a process, but I have the problem that the WSDL URL is too long and I am unable to insert it in the field completly. I am trying to use the dynamic WSDL URL but it retrieves an error. Any idea? Thank you

Hello, can the usage of plugins (once installed) restricted with a security(role/permission model or something similar? Thank youThomas

Hello All, I need to display excel within appian UI (interface may be). I need to edit the excel and save it back to where it was (knowledge Centre). How can I implement it? any suggestion is appreciated.

Hello,Looking for some help in configuring MQ in Appian 20.4.Here are the details that we configure in apache-tomcat server's suite.xml file. <Resource name="jms/MyQCF" auth="Container" type="com.ibm.mq.jms.MQQueueConnectionFactory" factory="com.ibm.mq.connector.outbound.ManagedConnectionFactoryImpl" description="JMS Queue Connection Factory for sending messages" HOST="myMQserver" PORT="1414" CHAN="myChannel" SCPHS="mySSLcertName" TRAN="CLIENT"/> <Resource name="jms/WriteQueue" auth="Container" type="com.ibm.mq.jms.MQQueue" factory="com.ibm.mq.connector.outbound.MQQueueProxy" description="JMS Queue for receiving messages from Dialog" QU="myQueueName"/> <Resource name="jms/ReadQueue" auth="Container" type="com.ibm.mq.jms.MQQueue" factory="com.ibm.mq.connector.outbound.MQQ