Extensibility

We have a requirement to embed excel on the Appian UI and this Online Office Integration Plugin seems to be useful for us. However, we are getting below error   I know this might be a silly question , from where we get WOPI Client URL. If anybody has already implemented this can you please help us here. We are trying to do a short POC so that we can show it , we are using our own office 365 account for testing purpose.

I've created a HTTP connected system by passing all the required parameters(sample values) as shown in Fig. But when I export this object and download the customization file, it does not specify SCOPE attribute at all.  Anyone has any idea, why Appian is not adding this attribute to customization file ?    Then how can we maintain this in all environments ( Each environment SCOPE attribute is different) without manual update.

Upon reading or uploading an excel file receiving the following log error 2022-01-20 21:09:00,529 [ajp-nio-0.0.0.0-8009-exec-6] ERROR com.appiancorp.ps.exceltools.expression.ReadExcelFileFunction - Failed to read zip entry sourcejava.io.IOException: Failed to read zip entry source I am uploading a .xlsx file but it is saying failed to read zip entry source. 

Hi All, I am trying to use "Receive a file from RDBMS BLOB" smart service and it is appending zero every time in the file name. Can anyone please help me on this. Any reply is appreciated. Thanks in Advance, Neha Raghuvanshi

Hello, I am using Send File Over SFTP smart service and I'm supposed to place a file in docfiles folder of F drive in the destination remote VM. So I've given the remote file path as "F:/docfiles/sample.pdf"  However File is not being transferred to remote file path and I am receiving No Such File error in Appian though I have sample.pdf available in Appian repository. Any thoughts pls ? Error transferring file to SFTP server2: No such file

Hi Folks. I want to retain the same file name while fetching details from integration. Please note contentBytes stores the document fetched. But I'm getting below error: Request your suggestion on how can I achieve this in keeping the same file name as passed.

Hi Everyone, I'm trying to invoke MS Graph REST API to fetch email with attachment and that the attachment in response body location is fetched correctly but When specifying fv!result.body.value.name in 'Name', we get error as shown above. Does it accept only static names?  As our requirement is to retain the same name of the attatchment as fetched. Need your suggestions on the above query.

I would like to know if we have any replacement or equally functioning Deprecated Export CDT to Excel. I am aware we have Export DSE to Excel but my requirement is to export the local data into Excel and we are not storing data in the table.

Hi, Mail server to database smart service is not working for 21.4 appian update. Its working fine with same configuration for 21.3.  Getting error [Cipher suits are not appropriate] may be the security needs to be updates in java.securities file.

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?