Extensibility

In short, is there a way to use the Deployment Automation Manager to run a flyway repair command to recover from failed DDL executed via Flyway, or is there anything planned for a future version of the plugin to allow this? Some more background: I have been through the documentation of the Automated Deployment Manager here: https://community.appian.com/w/the-appian-playbook/198/deployment-automation Using what is documented, I have been successful in using the `-flyway_path` and `-ddl_ds` options to deploy database changes to an appian instance hosted by appian cloud, against the underlying MariaDB. In the process of proving the above, I learnt that MariaDB does not rollback DDL when it rolls back database transactions. As a consequence flyway leaves the flyway_schema_history in a state that requires manual intervention and that blocks further flyway migrations until a repair is done. Flyway has a documented way from recovering from failed migrations, which is

Hello, I am upgrading a web API that was created sometime ago, it has all the process nodes in one very big process. I have managed to split it up to smaller sub-processes successfully, but the thing is that after splitting it to multiple process I started to add more functionalities (as this was the main goal in the first place), but once all the new functionalities were integrated the web API started "act out" or become unstable, where the web API sends a response back before the whole process reaches an end and before the "response body" variable is filled so I keep getting an error saying that function toJson() can't convert null data, I should mention that I have all of my nodes in all of the processes and sub-processes chained. my question is: is there a resource limit or time limit (keep in mind the API requires about 1-3 seconds to complete) and if so how can I modify this. ------------------------------------------------------ helpful screenshot

Hi Appian team, Web API that connects to process model -I need to pass input parameter different and get a different output parameter can anyone help me out with this , now whatever am passing as input parameter to processparameter same am getting as output parameter as process info.Please edit below code accordingly below is the currently used web API code snippet: a!startProcess( processModel: cons!xxxxxxxxx processParameters: {xxxxxxxxxx : a!fromJson( http!request.body ) }, onSuccess: a!httpResponse( statusCode: 200 , headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!processInfo ) ), onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error starting the process" } ) ))

I pulled the data from Big Query's data source using the HTTP Get Method it works I was able to translate the data to Appian's formatData is displaying Now with the Expression editor, would this be the Data side of things, Will I be able to set the variables for the data in there and make it in such a way that every time bigQuery data updates a sepcic data it will update into Appian. Can I do the same thing with pushing the data too, have the POST Method set up with a process Modeler to push data that has been updated in Appian to BigQuery?

I managed to create a connection to BigQuery's API, however, How would one go about pulling and pushing data between BigQuery and Appian?

We have MS Poller configured for one of our application. We noticed that MS Poller smart service is not able to ingest .MSG files as an attachment, however associated mail is ingested. (Email attachment inside another email).  Kindly assist.

I have managed to get the API to successfully import data from Big Query, However, I am struggling to get the data's to display in the Data Previews. I have created the rule!Pulling_Data().result.body.rows.f along with the: createdictionary( {"ClientID","Client","Project","Developer","Hours"}, fv!item.v ) so that the rows are split into columns, however, although the test is successful with this output. There is no data in the "Data Preview" Is there a way around this, or something I am doing wrong that is now allowing the rows to display?

Does anyone have any experience in using the Azure File Service / Azure Blob Service ?We are currently creating a file within Appian and move it to an on premise server using SFTP. At some point in the future, the on premise server will be replaced and we have the need to move the file to an Azure Server. We've been advised to make use of the above service but are struggling to get this to work.Either the requests we are building are incorrectly formatted or it's not recognizing the document object at all. It would be great to know if anyone else has a solution, the examples i've found, are not Appian specific and so far haven't helped ...

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.