Extensibility

Hi,      We want to surface/view (not store ) salesforce documents in Appian . We already have an Salesforce connected system , we uses  SOQL integrations to expose the data points . I was just wondering can we use SOSL with the same connected system to return the documents (using RETURNING Document clause in SOSL).  Not sure whether SOSL can return docs . Or we need integrations with salesforce REST api to get the documents in Appian . Our users just have to view the documents on demand. We don't want to save them as Appian docs. Can anyone worked on similar use cases . Your inputs will be appreciated. Thanks in advance, Mike 

I need to create a dynamic DOCX document that includes a table with 11 columns, where each column should automatically adjusts its width. I have attached a code snippet that generates a DOCX document with a table showing only 8 columns. The remaining 3 columns exceed the page width, so they aren't visible. Please help me to fix it.   SAP Number Part Number Description Manufacturer Group Spare Qty Delivery Date Price Total Remarks ", a!forEach( items: local!selectedEquipments, expression: concat( "", "" & fv!item.sapnumber & "", "" & fv!item.partnumber & "", "" & fv!item.description & "", "" & if( a!isNotNullOrEmpty(fv!item.manufacturer), fv!item.manufacturer, "--" ) & "", "" & fv!item.group & "", "" & if(fv!item.spare, "Yes", "No") & "",

Hi Every one, We are getting similar issue mentioned in -  [mention:60d851851e654d28b5c4a0dae2c486c7:46448885d0e64133bbfbf0cd7b0fd6f7]  We are getting 2 times the status code in postman and also when it goes to front end (UI part not a Appian - it is build in adobe cqms ) the status code is coming as duplicate for both the success/failure case. webapi- code Can any one  help and let us know, why are getting  this issue . Any help would be appreciated.

Product: Apryse WebViewer Component Plug-in Product Version: 5.5.1 I am using Apryse webviewer in Appian for document comparison. I am passing 2 appian doc id as parameters. But as soon as the interface is loaded it shows " Error while loading document ". But when I am manually uploading the two doc it works fine. Here's the screenshot of the error. . This is the code used for apryse webviewer ... webviewer( label: "WebViewer", labelPosition: "ABOVE", validations: {}, height: "AUTO", hidden: null, key: null, url: null, serviceAPIKey: null, appianDocId: { 224563,788333 }, preflattenDocuments: null, documentFolder: cons!FOLDER, uploadChunkSize: null, userDisplayName: null, enableReadOnlyMode: null, enabledElements: false(),

Is it possible to use an HTTP Connected System with Appian.Component.invokeClientApi in a custom component plugin, or do you need to use a custom connected system plugin?

When attempting to run the example test case I get exceptions, the biggest one of them being in the script. I followed all the instructions correctly and I am not the only one in our group running into the same issue.

Hi All, Good Day! I am trying to create a servlet and that servlet will return a value from the Appian server. While deploying the plugin in Appian env, I am getting the below error:[Appian Plugin Hot Deploy] ERROR com.atlassian.plugin.parsers.XmlDescriptorParser - There were problems loading the module 'servlet'. The module and its plugin have been disabled. [Appian Plugin Hot Deploy] ERROR com.atlassian.plugin.parsers.XmlDescriptorParser - There was a problem loading the descriptor for module 'servlet' in plugin 'Constant Servlet Plugin'. There must be at least one path specified: <servlet class="com.example.plugin.ConstantServlet" key="ConstantServlet"><path>/constantValue</path></servlet> com.atlassian.plugin.util.validation.ValidationException: There must be at least one path specified: <servlet class="com.example.plugin.ConstantServlet" key="ConstantServlet"><path>/constantVal

Hi Everyone, I'm receiving filename and content_base64 from an API which I'm calling it in Integration and in the response of the integration using following way Can I provide Name of the document as I receive in the response of the API where i get the filename.  I tried to access it but didn't workout thanks in advance.

Hi all, I'm trying to create a token for my Box integration using Box plug-in createtoken() function: privateKey and publicKey points to PEM docs containing publicKey and privateKey from box developer console / JSON config file downloaded from Box Dev Console sub: enterprise ID kid: publicKey ID from JSON config file iss:client ID from JSON config file I assume setup of my PEM files might be wrong, here are my steps:1. Generate Public/Private key pair in developer console2. Copied both keys to separate .txt files3. converted them into pem files4. uploaded to appianare these correct? I'd appreciate any advice,Thanks

We are trying to download documents from s3 inside the interfaces using getpresignedurlfors3 functions, we are able to download almost all other type of documents except we have identified that when we are trying to download pdf docs we are getting error- Failed to load PDF document.(PFA the screenshot).Fyi we are using chrome.Please advise what should be the fix for the issue..

Hi Everyone! I am facing an issue in microsoftDocumentEditorField(). Issue: The excel is loading for so long. It has two columns and two rows. Code:  microsoftDocumentEditorField( tokenInfo: generatemicrosoftdocumenteditortoken( viewMode: "View", document: 202370 )) Note: I tried using the Id/constant containing document for Document Parameter.

Has anyone successfully used the Mastercom connected system to support a full claim lifecycle?[mention:005befc4f9474f6c888fcbc1f908efa9:f7d226abd59f475c9d224a79e3f0ec07]I've noticed that the ability to create an update the initial claim needed to submit a chargeback isn't included. Wondering if anyone else has had the same issue and was able to get around it? Since Mastercom uses OAuth 1 I was hoping to be able to use this connected system to facilitate getting around Appian's lack of Oauth 1 capabilities.

Hello, We are receiving a response via an Appian Integration Object, but the Korean characters in the response appear to be garbled or broken. According to the API provider, the response is encoded in UTF-8, and Appian also uses UTF-8 as the default charset. However, the Korean text is not displaying correctly. Could you please advise what might be causing this issue and how we can resolve it? Thank you.

I recently installed MSgraph Poller plugin and done the setup, its fetching mails and saving EML and attachment as Documents. but its fetching all the Emails . My requirement is to only fetch Unread emails from "INBOX" folder. As per documentation there is no any such filter i can pass to the smart service. Other approach i Tried is creating integration object with MSGraph HTTP API (connected system). but implementing a simple fetch and save attachment/EML  takes multiple api calls to graph api  and on top of ot need to parse and write those data to DB for further case creation. Anyone Worked on similar requirement? what would be best approach if i want to create case in appian based on mail and its content and save those contents in appian.

Hi everyone, we are using kafka tools plugin. Sometimes we are able to receive some messages via kafka and sometimes we don't get anything. For times that we don't reveive any message, you cannot see instance in Appian. Is there a log file on cloud on which we can confirm that we received or didn't receive kafka message into our environment ?

Hi everyone [emoticon:c4563cd7d5574777a71c318021cbbcc8], I am using Export Data Store Entity to Excel smart service to get the document and stored it in Appian.In this, I have marked one of the column's visibility as false. Now, when I try to read the excel sheet using readexcelsheet(), It's not giving me the hidden columns.Anyother way to hide the columns in document but retrieve it in readexcelsheet()

Hello All, Is there any occasion CALL INTEGRATION node will stall and gets stuck for any reason (300s, 400s and 500s HTTP)? I expect it moves on irrespective of the call result. I don't plan on handling exception in the node but examine the result/error after the call.  Would like some recommendations from the community. Thanks.

Created a Custom Plugin jar, based on the instructions mentioned in https://docs.appian.com/suite/help/24.4/Custom_Smart_Service_Plug-ins.html . Deployed the jar in admin/plugins folder as per the instructions. The plugin does not load and show up Process Modeler. The server and Appian(on-prem) instances starts up normally.

Hi community, I'm having some issues regarding the deployment of a custom component plugin. When I deploy it via Admin Console or Hot deploy (by placing manually the plugin in the path \appian\_admin\plugins), it is not being updated on the enviroment. It always use a previous version. Why is this happening? And what could I do to end this behaviour? 

I have created a integration for integrate google chat space but it shows an error like :-  "error-result-label You are not permitted to perform the requested operation error-result-guidance The external system understood the request but refused to authorize it HTTP/1.1 403 Forbidden" When I click on "Click here to authorize," the authorization is successful, but it still shows the same error afterward. Am I forgetting to pass any necessary parameters?

Hello. I am having a trouble while using this plug-in. i am trying to get data from a cell in an excel file but the file is in the xlsb format and the plug in gives me the following error : Expression evaluation error at function 'readexcelsheetpaging': com.github.pjfanning.xlsx.exceptions.OpenException: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Invalid byte 1 of 1-byte UTF-8 sequence. is there anyway to use this plugin for these files? Or is there any work-around to get this same functionality? This is a step in my process model where the user has submitted the excel document. 

Hello, I have a requirement where I want to build a html file out of a template which would have some special characters i.e Greek characters.  The html file is generated properly and even the alphabets are also displayed eg: alpha , beta etc.  But when the same file is converted to PDF using the HTML to PDF plugin the Greek alphabets are not displayed. We are currently using: HTML Doc from Template to generate the HTML document. HTML to PDF plugin to convert the HTML into a PDF. Can any one suggest what we can do here ,any configuration we can use? Regards, Salil Raje

HI Team, We are trying to connect SFTP to Appian Server using the SFTP Smart service, We are getting the error - "  Auth fail for methods 'publickey,password' " We are providing all the required configration mention below. 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "hostname", serverPort: 22, scsExternalSystemKey: "key", privateKeyFile: private key , usePerUserCredentials: false(),) Plugin Verions - 4.1.0 We have tried multiple times to connect using ppk , pem files , still we are getting the Auth fail issue. Help us with some guidance , if anyone gonne throught this.

I have a csv file with delimiter '|'. When I try to run the smart service by passing a csv file where few fields are null, it is returning the error message 'Error executing SQL'. But when I replace the null with random text values it is writing the data to DB. Is this an expected behavior of this smart service? Is there any way to import or read a csv file with null values?

Hi everyone, I'm running into an issue with the "Import Excel to Database" smart service plugin in Appian. When I upload a .xlsx file that has been marked as "Confidential - Internal" in Excel (using sensitivity labels or classification settings), the plugin fails with the following error: "The supplied data appears to be in the OLE2 Format. You are calling the part of POI that deals with OOXML (Office Open XML) Documents. You need to call a different part of POI to process this data (e.g. HSSF instead of XSSF)" However, when I upload the same file marked as “General”, it processes successfully. Both files are .xlsx format. The only difference is the sensitivity label (General vs. Confidential - Internal). The error suggests the file is being interpreted as .xls (OLE2 format), even though it has an .xlsx extension. It appears that applying a "Confidential" label might be modifying the file in a way that makes it unreadable to the