Extensibility

Hi All,We are using Fill PDF plugin in our project. We are getting the contents.error.alertMsg error sometimes. In some previous thread, its mentioned that this will come when there is some null value. I provided " " values for null values, but still getting the same error. Any insights on this issue.

Hello, I have the following code that calls an integration and it returns a file which saves in the file local variable. I must be able to click the same link then generate and download the file stored in local!file integration: a!localVariables( local!file, a!richTextDisplayField( value: a!richTextItem( text: "Download Document", link: a!dynamicLink( saveInto: { rule!ADC_Gerar_Relatorio_Campanha( idCampanha: "2C918D8783461A630184BEC5E4453392", onSuccess: { a!save(local!file, fv!result.body), }, onError: {} ) } ) ) ) ) What solution would you recommend me? I have tried through an WebAPI as well:a!localVariables( local!relatorioCampanha, local!docId: rule!ADC_Gerar_Relatorio_Campanha( idCampanha: http!request.queryParameters.cid, onSuccess: { a!save(local!relatorioCampanha, fv!result), }, onError: {} ), a!httpRespo

Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content.  For example: Excel Cell Contains "Testing - Monday", then in staging table contains "Testing Monday" Excel Cell Contains "Testing$", then in staging table contains "Testing". Is anything we missed. Can anyone help on this.          

Hi I have UI screen interrace which consist of custom plugin and Appian SAIL component (button). Is there a way to pass event to plugin in response to outside UI events. I want to invoke a function inside my custom plugin when submit button is clicked.   How can I archive this?  

How to pass parameters dynamically to HTML to pdf smart service?

I want to create a password protected zip and while executing this plugin, it creates the zip but it is not password protected zip file. Also, while I trying to extract the files from zip, getting error for all the files in zip. I am facing the same issue with another plugin (Zip Utility -> Create Zip File) from same provider.Please check the screenshots below: 

When trying to import data from CSV to Oracle DB, getting  Error executing SQL java.sql.SQLSyntaxErrorException: ORA-00904: "column_name": invalid identifier . CSV File has headers and they are same as column names in DB table. Has anyone encountered this issue? Also noticed that the column names in sql statement are framed within " quotes like below Caused by: Error : 904, Position : 49, Sql = select "column_name1", "column_name2", "clumn_name3", "column_name4" from "table_name" where 1=0 , OriginalSql = select "column_name1", "column_name2", "clumn_name3", "column_name4" from "table_name" where 1=0 , Error Msg = ORA-00904: "column_name4": invalid identifier Note: Facing this issue only when file has headers in it.

We have a connected system in which daily a process will start to extract 3 table data from database table and place in a sharepoint folder location.But on a particular day,it didn't extract the data and throw an error like this"class javax.net.ssl.SSLException connection reset".What is the issue and how to resolve?

Hello. My question is, can I change the default body for the 404 NOT FOUND error? Appian default response looks like this: If I want to return a custom JSON instead of the text "404 - Not Found", can I do that? Is possible to change the default body errors for the 404 or others http errors? Thanks in advance!

We are trying to utilize the Pinecone integration from Appian, but running into a problem where it requires environment to be defined. We have reached out to Pinecone who has informed us that they have a new SDK where environment is not required and that the Appian call needs to be updated. Are there plans to updates this integration point? Can you give some guidance, we have a project that requires this integration. Here's the information from Pinecone: "Pinecone no longer requires the environment to be part of the connection. Our latest SDKs all connect to a global control plane instead. This means a single project can now host indexes in different environments/cloud regions, and you only need to set the API key to use your indexes." Can somebody help us with the update to the pinecone plugin

Hi, We are looking into creating a custom Smart service plug-in to serialize/deserialize using the AVRO Java libraries. We have seen that the code can be sent through the AppMarket Submissions Site for approval, but in the documentation page that details how to build this type of plug-ins it says the for Appian cloud customers it has to be tested in a licensed local installation of Appian. "In order to individually build a custom smart service plug-in, a licensed local installation of Appian is required. Appian Cloud customers who have a local installation must develop and test the custom smart service locally and coordinate with Appian Technical Support to deploy it on their site." If anyone know the steps that we must follow to get a custom Smart service plug-in reviewed and approved, or if anyone has already done this before and can tell us about the process it would be really helpful. Thanks in advance

With the pinecone integration that is available with Appian it requires an environment to be set and pinecone no longer provides environments. Pinecone no longer requires the environment to be part of the connection. Our latest SDKs all connect to a global control plane instead. This means a single project can now host indexes in different environments/cloud regions, and you only need to set the API key to use your indexes. But when we try to connect environment is required and throws an error.

Hi, We are getting data from External services in a file format. So is it possible to start the process model once I get a file from external source ?

Hi Community,I am facing issue while using the SSH Key Pair authentication for SFTP. So when I am trying using Basic Credentials, I am able to establish the connection with Remote Directory and able to Send and Receive File. But for same username when I am trying through SSH Key Pair authentication I am getting error as "invalid privatekey: [B@41050c98". I have generated the Key Pair through Puttygen software, and the Remote directory Team has configured the Public Key on there end. Please if anyone have any idea regarding this help meThanks, Prathamesh

Hi, I have a requirement of sending documents (filetypes like pdf, jpeg, xlsx, docx, ppt etc) from Appian to external system (AWS API) through integration object, so I want to know what is the maximum file size I can send it through an integration object. I have read in documentation that Appian supports file upload up to 1 GB, so will Appian supports sending file through integration object up to 1 GB as well? Also, if I want to upload a 1GB file through an uploader component, how much time the component will take to load the file into the interface from users local system. Will the users session be active till the 1 GB file upload to the interface completes? Thanks.

Hello, It is currently not possible to use OAuth 2 Client Credentials to authenticate towards Appian for one of our connected systems.. The following request is made to create the token: POST /suite/authorization/oauth/token?grant_type=client_credentials HTTP/1.1 Host: ... User-Agent: Go-http-client/1.1 Content-Length: 0 Authorization: Basic .... Accept-Encoding: gzip The grant_type is passed as query parameter No Content-Type HTTP header is present (The body is empty) Appian returns an error, because it expects the Content-Type HTTP header to be present: {"error_description":"Missing HTTP Content-Type header","error":"invalid_request","error_uri":"https:\/\/docs.appian.com\/suite\/help\/24.1\/Web_API_Authentication.html#client-credentials"} Can the check be changed in Appian, so that the header Content-Type is not required if the body is empty?

I am facing issue while using the SSH Key Pair authentication for SFTP. So when I am trying using Basic Credentials, I am able to establish the connection with Remote Directory and able to Send and Receive File. But for same username when I am trying through SSH Key Pair authentication I am getting error as ".filetransfer.sftp.SendFileOverSFTP - com.jcraft.jsch.JSchException: Algorithm negotiation fail". I have created Third-Party Credentials in Appian using the username only and uploaded the private key along with a constant associated with it. Here is my File Transfer Configurations CDT: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'( serverHostName: "xyz.com", serverPort: 22, scsExternalSystemKey: "aws-cmd", usePerUserCredentials: false(), privateKeyFile: cons!MS_SFTP_USER_PRIVATE_KEY_FILE )

I need to generate a secure embedded link and need to put that in an Appian interface. I mimicked what given in this documentation here (https://help.sigmacomputing.com/docs/example-embed-api-and-url) and created an expression rule for the same. It works but there are some organization level restriction to not put up client id and client secret in constants. Could you please share any alternatives which can be used to store the credentials in Appian or any workaround for the same? I tried to look into Third Party Credentials store but it seems like it can be accessed via a plugin alone.

Hello Everyone,  I am trying to show a hyperlink field in a word document which generates from 'Docx from dynamic template', the URL for the hyperlink will be dynamic passed from a rule. I tried using the merge field logic to show dynamic hyperlink but couldn't find a solution. The link always redirects to downloads/URL something like - C:\\Users\Downloads\mergeField. I would like to know if there is a way to link a dynamic URL. Thanks in advance. I tried the merge fields based on the blog below, but it didn't work. blog.softartisans.com/.../ The hyperlink is always redirecting to downloads as shown below. Tejaswi

Good morning everybody, With the plugin Dynamic Document Generator I can not modify the fonts, I can not add unicode symbols of special characters like the checkbox, the html page is saved in a single page, the borders of the tables are displayed differently from the html, do you know how I can solve all these issues that I can put chech box, generate more than one page and the borders when I want to move from HMTL to PDF. Thanks 

Hello, SFTP Send File smart service is failing with the error Connection refused. Third-party credentials are setup and have not changed. The plugin has access to the third party credentials. We are passing the values to the smart service as below:             File Transfer Configurations: 'type!{plugins.ps.appiancorp.com/.../}FT_Config'(             serverHostName: cons!SFTP_HOST_NAME, (text)             serverPort: cons!SFTP_SERVER_PORT_NUMBER, (integer)             scsExternalSystemKey: cons!SFTP_EXTERNAL_SYSTEM_KEY, (text)             usePerUserCredentials: false(), (boolean)            )            Remote File Path: /filePath/fileName.pdf            Document To Send: Document Can you please let me

Hi, is it possible to invoke multiple a!startProcess inside appian web api?

Hi Team, I am getting a below error:  [Appian Work Item - 617826 - WorkID 530 - execution02 - process 537400621 - model 281 : UnattendedJavaActivityRequest] ERROR com.vuram.pgp.util.KeyBasedLargeFileProcessor - message integrity check passed. Is anybody else is facing this issue? Is there any way that i can resolve this error? Thanks, Sayali

If I have four tables in a database how do I export them in a single sheet of Excel? 1

Which is difference if we add query parameters in Query Parameters side  or if we add as relative path ??