Extensibility

Hi, I am trying to export SQL to Excel but the base template would be XLSM due to macros which will hide/show columns based on certain rules. The actual file being generated by the plugin is XLSX and due the file file containing macro excel throws file corrupt error. If I manually change the generated file extension to XLSM everything works fine. Is there a way to change XLSX to XLSM within Appian or contain macros in XLSX template files. Thanks.

We are building a bulk document export functionality for our application, for which we are using the Add Documents to Zip Plugin.  It seems that Add Documents to Zip Plugin supports certain file types but not others.  So far I have not had an issue with docx, excel, PDF, or image files, but html files do not seem to be supported as part of this plugin.  Is anyone aware of what file types are or are not supported by this plugin? Additionally, when two files of the same name are added, the document paths of the two files are identical and cause an error.  Is there any way of getting around this?  Thanks! Carson

Hello, I want to call a rest API that use NTLM. Integration cannot be used in this case. I do not found anything else. How can achieve ? Regards

Hello, We have a requirement to call some integration rules from UI. I am able to call a single Integration rule and able to receive the response. But, in our requirement, we have 3 separate integration rules one of the response parameters from the first integration rule is the request parameter for the second integration rule and the second integration rule response is the request parameter for 3rd rule.  So, In the UI Interface, the user should be able to click a button that should call these three integration rules subsequently and we have to show the response of the 3rd integration rule on the UI. Please guide us to achieve this requirement. Thanks in advance. 

Hi Guys, I am quite new to Appian. I have tried using this HTTP link bigquery.googleapis.com/.../data which the link to access my project,however, everytime I put that in and test the data it throws an error. I do have the account I am getting it from Authenticated. I am lost from here. Has anyone run into this issue and found the resolution to it?

We have created a service call using 2-Way SSL. The request message has been hard-coded with the required fields, but when we try to run the service, the following error message is provided:  Caused by: org.apache.axiom.om.DeferredParsingException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1] Message: Premature end of file. Is there a way for us to see our request body or further details? The error message is unfamiliar and we are not sure how to debug. 

We have a requirement to authenticate with a 2-way SSL. We've been trying to generate the certificate from our side using OpenSSL 3.0. Is this version compatible with Appian? Despite the correct password, we seem to be getting a failure to load certificate due to incorrect password.  We have attempted this in two ways now. First, we generated a CSR from OpenSSL and provided this to our signing authority to create the certificate. We added the private key block with the appropriate headers, and we still get the error above.  Second, we attempted to generate the certificate locally as described by this support post: https://community.appian.com/support/w/kb/330/kb-1108-how-to-create-a-self-signed-certificate-for-saml-authentication. Still we get the same error.

Hi,how can i convert the xml into base64 and send it in the request body,i get the output in base64 i need to convert it into pdf and have to preview the pdf. Any suggestion would be helpful.

Hello, It is not the first time I do that but today I cannot download a plugin. I always receive an authentication error: "Authentication failed. Please check your credentials and try again". I'm well connected with the new connection way with 2 factors identification. Have you the same issue ? Regards

Hi, I am trying to integrate with DocuSign. I have been able to create & authenticate connected system successfully. But when I am trying to call API Send Document For eSignature, I am getting this error not sure what is the issue. Please help me with it.

Hi,  i am trying to send data to Data base using Web API POST method. but, i am receiving below error. below screen shot, that refers to giving data in JSON format. could you please explain why i am getting that error message.

Hi, I tried to call web API Get method from Postman . It returns result and working fine. But when i try to call from appian . it throws error. errorIntegrationError title"The external system encountered an error"(Text) message"Failed to connect to https://api.XXX detail"HTTP/1.1 500 Internal Server Error"(Text) What could be the issue? Thanks, Dharsana.G

Hi, I have created a!writeToDataStore in webAPI which is writing to DB when I test through API,to invoke this API I created an integration of Method POST and URL accepting ri! as parameters. I am unable to write to DB when I test through integration.Can someone please help where I am going wrong. Later I want to use this integration in my interface. Thanks in advance!

I have created a WebAPI - Write to Database - POST When I send an array of data, it only takes the first dataset. How to process all the records in the array? a!localVariables( local!value: cast( 'type!{urn:com:appian:types:YM}XX_WebAPI', a!fromJson(http!request.body) ), a!writeToDataStoreEntity( dataStoreEntity: cons!XX_WEBAPI_TC, valueToStore: local!value, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!storedValues ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error writing to the data store" } ) ) )) Sample Data Set: [ { "Column1": "AA",   "Column2": 1111 }, { "Column1": "BB",   "Column2": 2222 }, { "Column1": "CC",   "Column2": 3333 } ] Thanks

Hello, I am confused as to how we can populate the body of a POST http call? I have an API that will receive a post request with data in the body. I want this data to be dynamically created in Appian.  I would appreciate the help. 

Hello people!  I am trying to find a way to connect data from a BigQuery table I have, I found a potential way to do it: By using its API.  I was able to connect correctly, using a service account , when I then create the integration and I test the connection, I do get the response with  kind"bigquery#tableDataList"(Text) etag"sU8HN6M/RRhXMIrmq4pJgfrw=="(Text) totalRows "5444"  (And I also get this ) rowsList of Dictionary - 5,444 items So, as you see the response brings the rows on it, but then when I go to the data source, it does not show me the rows, only kind, etag and totalrows columns, any idea on how to create the table based on the response I get?

Has anyone come across the following error while opening a .docx file generated via ADT (DOCX Document From Template): Unspecified error Location: Part: /word/footer4.xml, line:0, column: 0 This error is only introduced after the doc is generated using ADT. The template being used works fine when opened using word.

Hi, We have succesfully created an integration with sharepoint as described in this link  https://docs.appian.com/suite/help/21.2/sharepoint-connected-system.html We would like to implement the DELETE operation of a document during the process inside a sharepoint folder. How can we accoplish that? all the listed operations doesn't allow it

We  have a 2 environment with same IdP (ADFS)  our certificate was expiring hence a new PEM cert was loaded into Appian on TEST the SAML Authentication works but the same does not work on DEV. They both have identical configuration and metadata files from IdP. While looking at the tomcat logs on the environment that has issues i see following SAML errors in the logs. 2021-09-29 18:50:29,928 [ajp-nio-0.0.0.0-8009-exec-202] ERROR org.opensaml.xmlsec.encryption.support.Decrypter - Failed to decrypt EncryptedData using either EncryptedData KeyInfoCredentialResolver or EncryptedKeyResolver + EncryptedKey KeyInfoCredentialResolver 2021-09-29 18:50:29,929 [ajp-nio-0.0.0.0-8009-exec-202] ERROR org.opensaml.saml.saml2.encryption.Decrypter - SAML Decrypter encountered an error decrypting element contentorg.opensaml.xmlsec.encryption.support.DecryptionException: Failed to decrypt EncryptedData        at org.opensaml.xmlsec.encryption.support.Decrypter.

Hello, We have configured SFTP Functions plugin and using the smart service "Receive Files in Folder Over FTP". Though this has worked how it has to at first, now we were not able to retrieve files from FTP and the error we see is " Name or Service not known ". Don't know if this is something related to network side credential change/ some change in the plug-in itself. Please let me know if there are any leads on this! TIA Jahnavi

Hello, Usually connected system for http type accepts only http/https url  do we have anyway to connect using URL starts with wss (web socket connections)

Hi All, I have a requirement where i need to pass two different images over different location in docx dynamic template. «[#list logo as logo]» image«[/#list]»   location 1 . «[#list lang as lang]» image«[/#list]»  location 2. As there are two images to be added , i am passing ={logo:pv!photo,lang:pv!photo} to the Image input parameter of the smart service. But only the logo paired image is getting displayed and the other one doesn't show up. So can anyone help me in the syntax or the annotations needed to get these images rendered?

Hi, I am developing a function plugin for appian. I am following the steps in this page https://docs.appian.com/suite/help/20.2/Custom_Function_Plug-ins.html am confused about one thing. Where do I actually include the java files for my plugin? I am inclined to put them under the functionPlugin package, but the documentation is confusing.  This is my current path. I have appian SDK and google 3rd party library under referenced libraries. Is it fine to include 3rd party libraries, and did I locate them in the right folder? The reason I am confused if I included the dependencies in the right folder is that in the url above. it is mentioned in step 14 to "Add any JAR files required by your custom function to the src/META-INF/lib/ folder." Technically my function depends on the ORTools library, but can't i just use it as a referenced library?  this is what they recommend on the website.  do the dots in  "com.example.plugins.<YOUR_

Hi, My use case is the following. I need to automatically assign new daily batch of tasks to workers. Each task, worker has a set of skills. The task's skills must match the worker's.  Additionally, the algorithm must assign/distribute tasks as equally as possible.  I have come up with a way to do this by reducing this to a graph/flow problem. Problem is, it is super hard/impossible to implement this in an expression rule. As such, I want to develop a custom function in appian in Java.  Which way is better to this, via Servlet or custom plugin?  Thank you,

Hello everybody,in one cloud of ours (running Appian 21.2) we are facing this issue.We have uploaded the plugin: "Text File Utilities 2.0.0" in order to use the readtextfromfile() function.When we type the name of the function readtextfromfile in a rule, the name of functionis suggested by Appian, but when we execute the function, the following message appears:"Expression evaluation error at function 'readtextfromfile': The function 'readtextfromfile' is unavailable."I also looked at in the tomcat-Stdout.log of today but I did not find nothing related to this plugin nor to the function. Last, this problem does not arise in my personal Community Edition.Could you please give me some advice or suggestion? Any help is greatly appreciated, thank you in advance.Best regards,Paolo