Extensibility

Hi Everyone, Is there a way where appian can fetch the password of the loggedInUser. If possible, please suggest an approach

I need the correct format to create inputs when calling the Execute Stored Procedure plugin from an expression rule.  Here is my entire rule. I want to send an integer as an input (and ri!num is an integer) into a stored procedure and retrieve the results as the dataset is too large for Appian to handle comfortably.a!localVariables( local!spResult: fn!executestoredprocedure( dataSourceName: "jdbc/Appian", procedureName: "jsonValTest", inputs: { id: ri!num } ), local!result: if( local!spResult.success, local!spResult.result[1], local!spResult.error ), local!result )Here is my stored procedure: The SQL query when run as a query minus any parameters works. Have I fouled the SQL procedure or do I have the syntax wrong on the execute stored procedure (or both)? Thanks in advance.

Hello All, We have Appian setup on premises and want to expose & reuse processes to new Appian mobile app. Is there any way to embed on-premises processes/interfaces in Appian mobile app?  Thanks, Bhushan

Hi Appian DevsI need a bit reference from you to use the right plugin to convert a docx file to pdf which can carry the correct formatting including font style, font family, special characters, ###tags### and text colors correctly during the conversion from docx to pdf.Can you help me in picking out the right plugin?

Hi, in our system,  we have a functionality to create a document from an url of Reporting Service. We use the following smart service: In Input Body, we use the function httpgetbinary() (from plugin Web And XML Extensions), where endpoint is the url of Reporting Service that generate the document. However, the plugin doesn't exist anymore and Appian suggests to use Integration Object to substitute it. However, when we try to use it, we receive the following error:   So, we find Microsoft SSRS Document Integration Plugin, but there isn't no documentation about this plugin and we don't know the value of input Device Info. Could you help me to understand what kind of value it's necessary to insert? Or Is there another way to get a document from Reporting Service with NTLM Authentication? Thanks in advacne. Regards, Juri Monti

Hi, How can we take a screenshot of the interface when we click on the button?

I'm trying to  connect to a system that  requires oauth 2.0  but  i want client credential in order to just connect with one global account for all the user to retrieve  the information. the site that I'm trying to access doesn't allow "oauth 2.0: client credential grant", right now only   the   "oauth 2.0: authorization  code grant "   is available. The way that quickbooks works is:   Step 1: the  site  can give me an access token and a  refresh token for  like a hundred  days  that's  why i'm trying to figure out  a  way to pass this tokens through the integration is there any way to do it ?.  

Want to know the best approach for E-sign functionality (Like username and passwords should be in each and every task before submit button ).  

We have a process that successfully intakes excel files but below is a use case where the file is not uploaded/error occurs: Use Case 1 - Fail 1. download the excel file from elsewhere (.e. shared site) 2. File is stored on desktop/downloads folder 3. Open Appian > Select file to be uploaded from downloads folder 4. File upload fails Use Case 2 - Pass 1. Open same file that failed in Excel on desktop 2. Rename the file in anyway (i.e. add number 1 to end of title) 3. Open Appian > select new renamed file to be uploaded from downloads 4. File upload is successful Why is use case 1 failing? Can we change something so it is accepted?

I need to download the Eclipse plugin development tool bundle for a new development machine. It was previously available at "s3.amazonaws.com/.../site.xml" but now is not locatable. I've read through the "Extending Appian" documentation and it looks like Appian has removed all mention of how to actually set up your plugin development environment for some reason.

let me explain myself  i want to  use an oauth authentication token  globally for all the users that log into my  appian site and let them post and edit   information  using just that one  token 

Hi All, Did anyone tried passing the parameter as in condition for a query database smart service For example : update tablename set status="test1" where case_id in ac!caseId How to pass the case ID values of multiple and what is the type of the parameter for this?

I am running into this error on interfaces with the rich text plug-in. Has anyone seen this before? Could it be related to popup blockers? "Failed to load plugin: code from url...." This only happens sometimes when running on google chrome (Appian version 21.4)

We are following the same link ( community.appian.com/.../kafka-tools) to set up the connectivity with KAFKA. We installed KAFKA in the windows system and in same system, Appian is installed. We're trying to connect to KAFKA without SSL/ SASL_SSL. Following are the configuration details we have specified in the data section of configure publish to KAFKA smart service. Secure Credentials Store Key: "kafkacredstore" Servers: "localhost:9095" Topic: "DETestTopic" Payload: "===========Test Payload==============" Security Protocol: "PLAINTEXT" SASL Mechanism: TrustStore: KeyStore: Attached screenshots: 1- Third-Party Credentials configuration 2- KAFKA server.properties we are getting below error. Problem: An error occurred in executing an Activity Class. Details: [Invalid sasl mechanism] Recommended Action: Examine the activity class to correct the error and then resume. Priority of this problem: High Priority

I've got a sort of weird problem that I can't figure out. I have a webAPI built that kicks off a process model for creating new users. When I test it within Appian, I get a JSON response with all the info about the process model. { "pp" : { "id" : 268442112, "name" : "Create User Bob Newman", "priority" : 1, "initiator" : { "id" : "******" }, "startTime" : "2022-01-06T18:04:14.980Z", "timeZone" : "US/Eastern", "starred" : false, "parentName" : "", "execId" : 1, "status" : 0 }, "pm" : { "id" : 5238, "uuid" : "0005e780-67c2-8000-2559-7f0000014e7a", "name" : "PP Web API User Generation", "description" : "Create a new user with a web API", "version" : "16.0", "creator" : { "id" : "*****"

An API I was building required a query of a datastore and to avoid getting a 500 error, I needed to add the service account as a viewer to the datastore. While I don't particularly care about access to the entity that is getting queried, there are other entities within the datastore that I would rather not have potential external access. My question is, is there a danger of accessing other entities within a datastore through that service account somehow? Would it be safer to create a separate datastore for the service account that only contains the entity that it needs to access? Or would it not make a difference either way and I'm just being paranoid? 

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?