Extensibility

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

Dear anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. If someone else has sent about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated.   [Error details]　*This is written in the body of the HTTP response. "{"error":"invalid_grant","error_description":"Please check the 'box_sub_type' claim. The value for 'box_sub_type' is invalid"}"   [Procedure] 1.Obtain a JWT using the createtoken() function of the “Box” Plug-ins. 2.Execute the Box API to obtain Box's Access Token.   *An error occurs here.   [Already Confirmed] 1.Applications created in Box have been approved by the Box administrator. 2.'box_sub_type' and 'sub' classifications must match.   Thank you very much in advance for your assistance. Best reg

Dear Anyone, I am currently trying to execute Box API that uses JWT, But the following issue occurred when executing the Box API to obtain an access token. I get an error stating that the JWT is an invalid value, but when I check with jwt.io I can see that it is a valid value. If someone else has sent a support request asking about the same issue and it has been resolved, or alternative solutions you may suggest would be highly appreciated. [Error details]　*This is written in the body of the HTTP response. body: "{"error":"invalid_grant","error_description":"Signature verification failed"}" ・Confirmed JWT in jwt.io Thank you very much in advance for your assistance.

Dear anyone, I am currently trying to execute Box API that uses JWT, I saw an article that said that you need to set "Third-Party Credentials" when executing the Box API. However, the connection is not working properly, so if you know which field to set in the Credentials, please let me know.   Thank you very much in advance for your assistance. Best regards,

Hi everyone, I'm trying to load json to db using this Appian smart serivces. My sample json data i have given below. It has multiple dynamics parameter for example user have multiple types of phone number. if it flattens json file then its working without any issue but sub paramters are not working as expected. Added more details below Main Issue while accessing the json sub parameters which is dynamic In smart service Load JSON to a database, "JSON key/Column Name mapping" Field for json fields key i have tried like this Phone.number as well as Phone[].number but while executing Process model considered as "FirstName", "Phone" as column instead of each table column fields like FirstName, PhoneType PhoneNumber. I cant able to navigate inside of sub paramters while mapping json key to table columns name Plugin name: JSON Tools Smart service name: Load JSON to a database my sample appian rule { "FirstName": "First_

I'm using a Google Sheets connected system in Appian with OAuth 2.0 authentication. The integration works initially, but I'm encountering an issue where the connection requires reauthorization almost every hour. Has anyone faced a similar problem with token expiration or session persistence? Is there a recommended way to maintain or refresh the token without requiring manual reauthorization so frequently? Appreciate any suggestions or best practices to resolve this.

I am getting this error on html to pdf converter node - java.lang.Exception: java.lang.IllegalArgumentException: null incompatible with Global antialiasing enable key Following is the html body retrieved from email Best regards,Isac Hi Eunice/Team, All set: Hi team Pls set up both tranches Thanks, Eunice Trader Additional Comments Term Sheet;<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:m="">schemas.microsoft.com/.../omml" xmlns="">www.w3.org/.../REC-html40"><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 15 (filtered medium)"><style><!--/* Font Definitions */@font-face {font-family:"Cambria Math"; pa

The requirement is that Process should start on the Inbound email should receive by the process. And We need to show the Inbound Email uploaded into the task automatically, so i have used the "Create EML File From OOBT Poller" plugin which was giving the expected result but the formatting in the Body content is giving in a single line. Please suggest a way to align the email body content Process Model The output file from the pulgin 

Can we get the UUID of Groups in Appian via any function or plugins in an expression rule.

In integration if the response is in xml format, how to convert it to appian value and save in a record type

We call the expression rule (ER) "cursor_value_from_previous_call" from the "Cursor" integration. This ER invokes another expression rule, "CursorValue," which extracts the cursor value from the integration's response body. The extracted value is then passed to ER "cursor_value_from_previous_call," which returns the JSON value in the following format: Request Body: { "cursor": { "value": "" }} Value is null for the first call, for other subsequent calls, we pass the value that we have extracted from the first call. Kindly refer the flow diagram below: I am not able to achieve this without using the logic of while loop. For loop is not helping as the variables are immutable. Any insights are highly appreciable.

We recently upgraded an environment to 25.2 and when we use the  Create & Read Email Files Utilities from the App Market we are getting an error "An error occurred while creating a note" on the front end and  Could not create EML java.lang.IllegalStateException: Error while searching for service [jakarta.activation.spi.MailcapRegistryProvider] in the tomcat logs. Has anyone received these errors or know of a way to fix them.  We use this plugin quite a bit to create custom notifications to the users.

Can I call an expression rule from an integration's request body?  Note: The response of the expression rule is a JSON body. Method: POST

Hello, I am working on an integration where I need to set a custom value for "boundary". The HTTP request is of Content-Type: multipart form data. The other system expects the boundary value to be "cpi".  In Headers, I set Content-Type as "multipart/form-data; boundary=cpi". However, in the HTTP request that Appian generates, Appian seems to be using a random boundary value, and ignoring the value that I have set.  HTTP request that I see:  I see this data in API trace logs.  The integration works through Postman, and I see the correct boundary set. Postman screenshot.  Thank you in advance for your help. Regards,Harish

I have an interface that calls 2 different intergrations. There is data that return for both integrations, but it randomly returns null after calling it multiple times.  I have inserted where I am calling the integrations. a!localVariables( local!historyData: a!refreshVariable( value: index( rule!GET_incomingRequestHistoryByID(requestId: ri!requestId).result, "body", {} ), refreshOnReferencedVarChange: true() ), local!requestDetails: a!refreshVariable( value: index( rule!GET_allIncomingRequestsByID(refundRequestId: ri!requestId).result, "body", {} ), refreshOnReferencedVarChange: true() ), This is what my error looks like when 1 integration returns as null This is what my local variable looks like when both integrations return data: 

Extract data from database tables and populate a PDF form. The PDF should contain editable and fillable dropdown fields that allow users to select values dynamically