Extensibility

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'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

Hello guys, I have a page html and I want call web api appian, but retrivied this error: can you help me? thanks

Is it possible to read a password protected excel? I tried using function readexcelsheetpaging() as below readexcelsheetpaging(  excelDocument:<<doc>> sheetNumber:0, pagingInfo:a!pagingInfo(1,-1),   password:"ABCD@1234") However, I am getting error: Expression evaluation error at function 'readexcelsheetpaging': The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB was not able to produce a value for typed value TypedValue[it=3,v=ABCD@1234] as java class java.lang.Integer.

Hello everyone, Is there a plug-in, or an option in Appian, to implement a RFC 3161 Protocol compliant external Time Stamp, when applying a Digital Signature to a PDF document? The Timestamp should be embedded in the PDF document itself. There should be a possibility to choose the Hash algorithm which can be one of the following: SHA1 SHA256 SHA512 MD5 Any help is appreciated.

Hi,We are getting below error when trying to read document from MFT folder. It was working fine and suddenly breaking.[Appian Work Item - 245513 - WorkID 6 - execution02 - process 537248294 - model 8379 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=536905115, classname=com.appian.ps.plugins.sftpsmartservices.ReceiveFileOverSFTPBasic java.lang.StringIndexOutOfBoundsException: String index out of range: -1Could you please help me here?

Hi all,  May i know how to extract data from an xml file Thank You In Advance

How to retrieve the sign document back to the appian

Hello All, My requirement is client is sending an csv file to Appian which we need to insert in Appian table. I am using "Import CSV to Database V6" smart service. But now client want to send the file with some header and footer. Can anyone tell me how to read a csv file in Appian which is having header and footer. In Appian we don't need to save the header and footer we can simply ignore that. But how to ignore that in the Appian because client is sending same file to multiple platforms, so we need to do that in Appian itself. Thanks in advance Regards Sahil Batra

I need to copy the First Sheet from an Excel Document and add the same to the new Excel Document as its FIrst Sheet. can you please suggest the best approach and the smart services. Note: The First sheet will contains the data, so it should not be altered while copying

Hi Guys, Please help me on the below! I need to import list users from excel to the process model and then add them to numberous group. Can you please help me on the same??

I have created a Connected System that uses OpenAPI.  I then created an Integration that uses the OpenAPI CS to call a User Authentication API that returns a service token.  That token is then used to authenticate  other APIs that are available for the application.  Every API must have the token referenced in the header in order to authenticate.  I am trying to create an Expression Rule that can be used as a wrapper to call the User Authentication API and return the token.  I would like to use this rule as the Header value when creating additional integrations for the other APIs so that the authentication can occur every time the integration is called.  When I test the expression rule, I get an error that reads: "The jsonText parameter must not be null or empty." Here is a screen shot of the Integration, which works when I manually insert a valid bearer token: Here is the expression rule that fails: It seems like the API is