Extensibility

An error occurred while evaluating expression: expiredContracts:rule!TCT_ContractDashboard_Status_Expired( waitingOnCustomerAndApprovar: pv!waitingOnApprovaAndWaitingOnCustomer) (Expression evaluation error in rule 'tct_contractdashboard_status_expired' at function a!forEach [line 3]: Error in a!forEach() expression during iteration 10: Expression evaluation error in rule 'tct_docusign_getenvelopedefinition': com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.util.concurrent.TimeoutException: null)

test

Hi Professionals, We are trying to use 'Xhtml to Docx' smart service(plug in) but its not creating the document. When we initiate(start debug) the process model ,it does not start,but in "Process Instances" tab we can see this process as active, and then it does not show any error or issue as well. When we tried to find this in System Logs we found the below issue, and  we do not have any idea what this issue means. Any help here would be appreciated. Thanks Exception in thread "ThreadPoolTaskExecutor-173716" java.lang.NoClassDefFoundError: org/apache/commons/codec/binary/Base64 at org.docx4j.convert.in.xhtml.XHTMLImageHandlerDefault.addImage(XHTMLImageHandlerDefault.java:87) at org.docx4j.convert.in.xhtml.XHTMLImporterImpl.addImage(XHTMLImporterImpl.java:1789) at org.docx4j.convert.in.xhtml.XHTMLImporterImpl.traverseBlockBox(XHTMLImporterImpl.java:1331) at org.docx4j.convert.in.xhtml.XHTMLImporterImpl.traverse(XHTMLImporterImpl.java:915) at org.do

Hi, We are going to use OAuth2 for a customer and reading the Appian doc, I can see this : - "OAuth 2.0: Client Credentials Grant" : is used when access is being requested on behalf of an application,  - "OAuth 2.0: Authorization Code Grant" : is used when access is being requested on behalf of a user, - "OAuth 2.0: SAML Assertion flow" :  used with SAML... Could you explain me the main differences between each of them please ?  (with possibly examples [emoticon:0f36700dfeb3494fa10d47dd9e1f90a1]) Regards

Hello everyone, I need to integrate my appian app with DocuSign. So I created connected system using DocuSign type. Then I created integration to this connected system using "Create and Send Envelope" operation to create a draft envelope with recipients with defined order. It works fine - but subsequently I need to implement multi-factor recipient authentication -> require phone authentication for my signers. Checking DocuSign documentation I can see that I need to add "identityVerification" part in envelope definition that is sent in POST method. The "identityVerification" part requires workflowId parameter. The question is: How to get this workflowId parameter using Appian?The docusign documentation says that to obtain my workflow ID I need to make a request to the identity_verification endpoint on the Accounts resource of the eSignature REST API using your {API_ACCOUNT_ID} to retrieve the workflow ID. The response

Hi All, When starting to run a health check, getting below expression error: Expression evaluation error [evaluation ID = 2f8ea:98060] in rule 'ahc_ui_requesthealthcheck' at function 'gethealthcheckcollectionstatus' [line 67]: The function 'gethealthcheckcollectionstatus' is unavailable. Could you please advise on what needs to be done and steps to be followed on how to run the health check from admin console?

Hi everyone, I'm looking for documentation or guidance regarding the download document from s3 bucket. My node is completing but no file is appearing in the target folder. So, what could be the issue?

Hi, When you call a REST API and have such a reply below. How would the best pratice to cast the response to a CDT please ?Do you consider this ER must always return a generic CDT reply (solution A),or do you consider this ER must return 2 different CDTs according the reply, but in this case, we would have to handle a condition (Solution B) Response Ok from API : body: {  "id" : 1212  "url" : "https...."} Error Response from API : body: {  "developerMessage": "file already used",  "errorCode":102 } Solution A : type!response(  OK: {  /* Filled if OK */    id : 1212    url : "https...."  },  ERROR {  /* Filled when Error */    developerMessage: "file already used",   errorCode: 102 } Solution B : 2 different CDTs type!errorResponse(  developerMessage: "file already used",  errorCode: 102) type!

Hello, I am using the PDF from XSL-FO Transformation with Fonts Smart Service from the Dynamic Document Generator (https://community.appian.com/b/appmarket/posts/dynamic-document-generator) plugin, version 1.9.1 I have no examples of using this Smart Service and the plugin documentation doesn't have specific examples. I have tried to use the only complete code I can find in the community: https://community.appian.com/discussions/f/plug-ins/17891/pdf-from-xsl-fo-smart-service  This produces a PDF without errors, but when I try to open it I get a "Damaged file" from Acrobat Reader. This is how I configured the Smart Service: Xml Document: a constant to test.xml file, with the code from the example Xsl Document: a constant to _xslStyleSheet.xsl file, with the code from the example Xsl Parameters: null Font Document: null Font Italic Document: null Font Bold Document: null Font Bold Italic Document: null Create New&

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.