Extensibility

Hi Team, We started to create a new Database schema using the Connected systems concept introduced in 21.3 However we have to use the Execute Store Procedures we need to provide the Data source Name : For example like jdbc/Appian Like this i am unable to find out the Data source/JNDI Name for the Seperate schema which is created. Could someone help me out with the datasource name of my schema created. For Example the Data source Name / Schema name created in the DB is SchemaOne.

Hello, I’m evaluating the Appian tool for a customer, and one of the criteria I’m looking at is the ability to import BPMN, as well as BI. Tried to install the BPMN plugin from the AppMarket - but all I get is "This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile." 1. What does that mean? or: "Thank you for your interest! Please confirm that you would like to be contacted about this app?" and I choose Yes.  A couple weeks passed by and nothing happened. 2. any idea?

Hi Can any one help me on how to read EML file in Process Model? I need to map the body directly to a folder instead of downloading it.

Hello Appian practitioners,  Following the notes from this discussion, I tried creating a WEB-API to load a locally available WSDL within the 'Call Web Service' smart service. My web-api returns the following httpResponse a!httpResponse( /* * Set an HTTP header that tells the client that the body of the response * will be a CSV attachment. */ headers: { a!httpHeader( name: "Content-Disposition", value: "attachment; filename=" & char(34) & local!username & ".xml" & char(34) ) }, /* * Create a CSV value of 'local!user' and place it in the response body. */ body: rule!TS_test_ProfileXML() /* XML Contents */ ) However, the call web-service is still not able to detect the WSDL.  Appreciate all your help!

I have a GET web API which is consumed by third party, my GET API calls other POST API and there I am triggering a process and generating a user task, in my GET API i am also generating a process report to get task id using process id i get from POST API and than generating a url for  the task and redirecting url as response of GET API.  But sometime i am getting 500 error message and after initial analysis I get to know process report is slow and by the time web api triggers process and query report, entry is not added in report and so task id is return as null because of this, third party getting 500 server error. Any suggestion how can I resolve this error ?

Hello all, im currently looking for a way of protecting a PDF with password, in the current version (19.4) we are using the protect PDF plugin, but we need to upgrade the version to 21.4, and it seems that the plugin is no longer available,  i've been looking at similar addons, or some appian feature to protect a PDF but didn't find anything, any suggestion? thank you in advance.

Hi, We are trying to use executestoredprocedure for a procedure written in SQL server. The procedure takes 2 parameters of type 'bigint' and executes successfully within the database client but it fails to execute stating 'cannot convert nvarchar to bigint'. Any idea how to bypass this issue?

Hi Community, I'm developing a plugin and have it installed on my local Appian but was wondering how I can debug my plugin on eclipse. I want to put breakpoints so I can see if my variables are being populated as it is run in process model. Does anyone know how to set it up or is there a guide on Appian? Thank You

I've made an API in Appian, but am having the hardest time understanding how exactly one connects to it externally.  According to the documentation: https://docs.appian.com/suite/help/21.4/Web_API_Authentication.html I should be able to connect to it this way: example.appian.com/.../endpoint -H "Appian-API-Key: ${API_KEY}" I put in my endpoint and API key, but every time I get an authentication error, so clearly I must be doing something wrong.  Could someone walk me through the exact steps to get this to work? 

Hi All, I am creating Document Download WebAPI which will be called by external system to download Appian Document . I want to capture few parameters such as data, time , document , user  whenever the document is downloaded (for an audit purpose) .I am trying to use a!startprocess or a!writetodatastoreentity() in the same webAPI but it doesn't work . Can I call a smart service a!startProcess or a!writeToDataStoreEntity in web API's of the method GET? What should be approach in this case ? Any help would be appreciated. Thanks in advance!

Hi,  I have a requirement to create a PDF with one table and known number of columns. But the number of columns are 15 for one of the case.  Till now, my approach is to create DOCX using dynamic template where I have already oriented the page in landscape with narrow margin but still fitting 15 columns on one page is not looking visually good.  So, wanted to check if there is any better approach to do this.. Also, I have already asked the user if those 15 columns are really required or we can cut down to few if possible. Thanks & Regards, Nafis

Hi I'm using 'Import excel to database' smart service in the process model. When I run the process:- 1. It works when we unfreeze the first header row otherwise it throw error 2. It sometimes throw error like "???Invalid Content ID???" or "Index: 1, Size: 1" Does anyone have suggestions regarding the proper configuration of excel required while uploading ?

Does anyone have a good example of a plugin where the output of the smart service is a CDT that was defined by the plugin? bonus points if it's a nested CDT.  I'm getting really close to getting this to work. I have the CDT being successfully created by the plugin, and the smart service shows the correct type on the output tab at design time.  When I execute the process model, I get a runtime exception: 7:39:50,921 INFO  [stdout] (default-threads - 36) 2021-12-13 17:39:50,919 [default-threads - 36] ERROR com.appiancorp.suiteapi.common.TypedValueParameterConverter - Cannot convert TypedValue17:39:50,921 INFO  [stdout] (default-threads - 36) java.lang.IllegalArgumentException: Argument is not an array17:39:50,922 INFO  [stdout] (default-threads - 36)      at java.lang.reflect.Array.getLength(Native Method)17:39:50,922 INFO  [stdout] (default-threads - 36)      at com.appiancorp.suiteapi.common.RecordConverter.convertPara

Hi, I have been using DocuSign developer account (using Basic Authentication) for testing purpose and its working like charm, but when migrated from developer to production account I am not able to authenticate using Basic Authentication. The error message says "The specified Integrator Key was not found or is disabled".  Please hep me with it.

We're using Azure B2C SAML based application with Identity provider-initiated flow. Please refer: https://docs.microsoft.com/en-us/azure/active-directory-b2c/saml-service-provider-options?pivots=b2c-custom-policy We'll embed this identity provider-initiated flow URL to our client websites, when customers click this identity provider-initiated flow URL that will take them to the Azure B2C SSO login page. We'd would like to know if there is any way to identify the requesting URL where the identity provider-initiated flow URL is triggered from, please? For example. when www.client1.com and www.client2.com calling this identity provider-initiated flow URL. Within Azure B2C portal OR Custom login page if there any possibilities to identify this Azure Idp initiated URL is triggered by www.client1.com OR www.client2.com. For example, on successful sign-up, call the Appian Web API to pass the client / customer-id and sign-up email-id paramete

I'm getting this kind of  numbers when i get data from an integration i want to  convert it into   numbers  to make an excel file and be able of edit the numbers  when i try converting todecimal() or round(val,2)   any  of this  conversion methods work what can i do  in this case ?

Hi Community, I'm trying to use Advance document Templating Plugin's smart service PDF from DocX to convert a DocX to PDF. I've attached the example DocX I'm using below and the resulting PDF. The conversion occurs I get a new PDF but a table is missing and the images are displaced. On the community someone mention using DOCX From Dynamic Template smart service before it, but I still get the same results probably because I just have a blank value of "<project></project>" for XML Data Model input. Has anyone else run into a similar issue or know of a fix for this?  Thanks, Eric Example Doc: [View:/cfs-file/__key/communityserver-discussions-components-files/19/sampleTables.docx:320:240] Resulting PDF: [View:/cfs-file/__key/communityserver-discussions-components-files/19/NewDocToPDF.pdf:320:240]

HI All, Where can i find release notes for older versions of Plugins.I want to compare the version differences between the latest and previous versions. Thanks, Sai Kiran Pannala.

Hi ,  we have an on-premise environment and we have installed the this plug-in ( google chart component ) in our environment, and when we started working on it we are facing below error, i have attached a screenshot of the issue .we are using 21.3 version. thanks in advance

There is an requirement to send existing or uploaded docs to external system with metadata , with SFTP protocol I think we cant send metadata , What would be the better apprach

I have requirement to integrate Twilio with Appian to send SMS. How could I reach Twilio features in Appian? Can you guide me how to integrate and implement this task?  Thanks.

Problem statement: I have a requirement wherein we receive file in Appian from a third party system. For security reasons we want to restrict only few file extension.  I have created a WEB API using a ' Document Upload' Template , so that external systems can push documents to Appian.  I want to return error code in response when some hits this WEB API and upload files with extension other than .xlsx.  I have used  document(http!request.body, "extension"), however this does not restrict document to be added to target folder.  Is it possible that , WEB API returning error code and  not even allowing files with specific extension to be added to target folder.

we have requriment in our project , where we need read many documnets and search for partcular text in these docs, we need know what is the limit of number docs we can pass if we loop the getpdftext() in PM asychronusly , is ther any threshold for document size for getdpftext() function has the limit and is there any performacne issue can occur while processing of mutiple pdf docs here.

Hi All, i am using path segments to extract data from the request and i'm testing the API through postman everything worked fine in dev environment but when it goes to the higher environment its not working for example abc/bcd/cde http!request.pathsegments[3] returns cde in lower environments but in higher environment it returns bcd endpoint is almost same in all environments. path segment index is changing on the environments is there any server side setting for this anyone can help me please ? Thanks in advance

Hi, I have used "urlforrecord" in the email template to provide a link/url to the users. But, then email has been generated and clicked on the url, it is trying to open the record in "tempo" instead of "site" =urlforrecord(cons!AT_EMPLOYEERECORDTYPE,pv!employee2.employeeId) How can I provide link to the "site" instead of "tempo". Thanks