Extensibility

Good Afternoon, We are using the query DOMO Dataset API to perform a SELECT query statement to retrieve some data for our Appian interface.  Documentation: https://developer.domo.com/portal/52fd0777839f4-query-a-data-set We only intend to use SELECT statements to get data however we still have to use a POST method for this API. Because the Appian Integration is using the POST method to perform the query we are not allowed to use it in the Appian Interface's on page load. It will only work when used through a SaveInto parameters for buttons or links. I tried to make a middle layer Appian Web API to perform the POST Query Statement but referencing the POST integration inside of the Web API code that is using GET method was not allowed. I am going to try to use the Web API to launch a process model. That will have an Integration node to call the POST method query statement and the end of a successful process execution will be the response. I still need to carryout the i

Hello team, is it please somehow possible to use site page as a hyperlink to external page? It means when user click on HELP (as one of site pages) it will redirect him to a SharePoint page with useful docs. I tried it as Interface with safelink but it does not work. Maybe with process model it can work? Thanks

So here’s the thing, I fixed an issue with an Appian plugin. I downloaded its code, was able to get it running with all dependencies and build.gradle stuff, found the faulty code and upgraded it, I also upgraded and cleaned the code since lots of functions and/or variables were either deprecated or not used (seems like nobody tried to edit this plugin for ages now and is considered a black box) Uploaded it to our demos environment for a spin and it works like butter now. The thing is, this is a vital plugin for a certain demographic, I believe an update such as what I was able to accomplish in days should’ve been done by Appian a long time ago (this shouldn’t have passed testing stage let alone be published for thousands of developers and millions of users and be dismissed for a few years now) So my question is has anyone ever faced a similar situation ? How did you deal with it ? And how do I / should I get in contact with Appian regarding this? I noticed the “

Could anybody help me? I need a example to call this function getmodelswithgiventimertrigger Thanks

I can upload the documents from external application to the Appian. When try to open the received documents with file extensions .docx,.pdf,.pptx, the files are throwing error and after I select "Repair" option, then the files are opened. But the files with extension .xlsx,.zip,.png,.bmp are not opening and its throwing "file format or file extension is not valid" error and unable to open the files. Step 1: By using, "Document Upload" Web API can receive document from external application to Appian.               a!startProcess( processModel: cons!DSC_UPLOAD_CWR_DOCS, processParameters: { transcript: http!request.body, cwrId: http!request.queryParameters.cwrId, documentType:http!request.queryParameters.documentType, }, onSuccess: a!httpResponse( statusCode: 200, headers: {}, body: concat( "Upload Successful: ", document(h

Hi , As pe the  Function Plug-ins - Appian 22.2 , We can inject the service ( ContentService ) as a argument to the custom functions. When I try to inject as  below public String dowork(@Parameter String para, ContentService cs) { } I am getting below error. : Unable to find a required instance of ContentService. Is there any other annotation or setting ? Thanks & Regards, Chaminda

Hi, I'm generating a word docx using docx from dynamic template and converting the docx to pdf using PDF from DOCX smart service. I'm able to generate the docx properly but while converting to PDF the text is getting overlapped in single line.  can anyone help me on how to convert DOCX (generated using docx from dynamic template) into pdf with proper format. Thanks in Advance.

Hello All , I have noticed this error in the process model where we are calling an integration , And i have no clue what does it means can somebody help me here please ? com.appian.komodo.api.exceptions.ConnectionClosedException: The connection to content was closed, aborting CONTENT.getVersion Thanks, Udhaya

Hi All, I have setup the integration object using https://docs.appian.com/suite/help/21.2/sharepoint-connected-system.html All the methods I can use and its all working fine but I have a requirement that I must be able to move a document from one folder to another or delete a specific document from one folder.  I got one method to use Execute Write Request but can someone help in what data we need to pass in that to fulfil the requirement? Thanks 

Hi Team, I am having an issue with reading the log file (login-audit.csv). It contains multiple rows, but the function is only returning the header and not the rows. However, when I try with other log files, it works fine. Currently Our Appian version is 24.1 and we are using this plugin firsttime.   Expression -    readcsvlogpaging(   csvPath: "login-audit.csv",   startIndex :1,   batchSize:20 )   Output     'type!{com.appiancorp.logreader}CsvContents'('logName': "/usr/local/appian/ae/logs/login-audit.csv", 'totalCount': -1, 'headers': {"2024-05-14 00:00:05", "Appian", "Succeeded", "3.106.112.168", "Web API", "Appian", "cd05a5a0-b1e5-4ffb-8dd6-0f7007e505ce", ""})

I am trying to call an integration that needs to pass a file from appian through its body.  However, it's not being acceptable, cause As you can see, the connection endpoint is expecting the file parameter to be of type File.  An information: with the url that I am retrieving in appian, I am being able to download the file just by clicking on the link. However apparently the File type on this connection expects another type of string: MultipartFile, Is it by any chance possible that conversion? Thanks

I have an integration which returns the document in binary format and I can convert that to Appian document using the option to Convert Binary response to Appian document. But this API returns JSON body as below while returning error. I want to extract this error details and present it to the users but the integration object is returning null response body when I select the option "Convert Binary response to Appian document" even though API is returning below body. Is there any way to extract this body when API returns error and convert the binary to Appian document in case of successful response ? API Response as JSON body: {"type":"about:blank","title":"Bad Request","status":400,"detail":"Failed to read request","instance":"/api/v1/"} Integration Response:

Hi Team, Import excel to database plugin not writing in database table and not getting error in output parameter and in tomcat logs. The issue i am facing in my Prod environment and even not facing frequently. Could you please help me on this to move further. The same process i tried individual with only node of import excel to database, its working. The issue not occurring repeatedly and same file is working for some time. Thanks, Pradeep Sridharan 

Hi All, I have a file uploaded to sharepoint with encrypted file name ex: 1234.pdf . I have the original name of the file stored in table and while providing a safelink for download , I need to replace 1234.pdf with original name from table.  Currently safelink downloads the file with default/encrypted name of 1234.pdf . What approach can be taken to have the file downloaded in original name. Please suggest. Appreciate the help . Note: if we download to Appian KC temporary and then rename the file, it will become a 2 step process. I would like to avoid that. Thanks Raj

This is the result of 1st integration , i want to store client guid (of result body)  in some process variable and then pass this value as input to 2nd integration .How Can I achieve this ,can someone please advise

hi i have a query that i am using to fetch the data from post grace sql to appian  but while i am making a manual query  in that query i have empty values  as some contion  in the above condition we have empty values  whic is not considerding by plugin and displaying the below error  please give me any solution on this 

it is  posible to  change a sharepoint    folder name using the  update folder metadata integration

I am struggling with parsing the HTTP response.  I thought fv!result in the rule that called the integration would allow me to access the body of the response.  However, I am getting errors.  The three values I am trying to access are highlighted below.  Screenshots of the function where I call the integration and the response from the call are shown below.  I would like the three values stored in local variables so I can display the text messages to the user.  Thank you in advance! rule!CreatePatientResource( givenName:local!firstName, familyName:local!surName, gender:local!gender, dateOfBirth: local!dateOfBirth, onSuccess: { a!save(local!registrationErrorMessage,null), a!save(local!registrationComplete,t

From appian i Need to send the below data using integration{ "Guid": "String","TypeId":  1 "Comment": "string", "addColleague": { "email": "string",  "Name": "string", "Flag": true, "deletedFlag": true, "ID": 2, "idFromsender": "string", "addDeleteUpdate": 1 } }How to send the data in the above format from integration .Can I use CDT's I have one CDT  were GUid,comment, email,name and idfromsender are present Can someone please guide

Hi, I'm trying to import a CSV file into a PostgreSQL DB. Customer requires all data from appian must rely on that DB which is connected as datasource. I'm using the plug in Excel tool and the Smart Service Import CSV to Database.  I got the following error from stdOut log:  ERROR ImportCsvToDatabase8 Error executing SQL org.postgresql.util.PSQLException: ERROR: syntax error at or near "," Position: 17 From database, i turned statements log on and i found out the following statement:  2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:ERROR: syntax error at or near "," at character 17 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:STATEMENT: select `field1`, `field2` from `table` where 1=0 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:LOG: execute S_1: ROLLBACK I'm running the same statement on my client in Postgres and i got the same error of course. What I found out is that backtick is cau

I am using the LDAP tools application and reieveing the following error [Appian Work Item - 323 - WorkID 69 - execution02 - process 2098658 - model 65 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.plugins.directory.syncwithusernames.service.SynchronizationService - Error while conducting name search:  javax.naming.PartialResultException [Root exception is javax.naming.CommunicationException: DomainDnsZones.eg.Albaraka.local:389 [Root exception is java.net.SocketTimeoutException: connect timed out]]

Hi Everyone, We have a requirement where we use OAUTH2.0: Authorization code grant and once we click on Authorize, A new browser tab opens and an after logging into the external system, an URL comes in the search bar of the newly opened browser tab. Is there an way in appian to read the URL and fetch it into any variables,once authorization is successful. Thanks Rupa

Hello, Need an input if there is way to connect Appian and AWS cloud search. Thanks in Advance

Hi All, I have an in integration object which its currently returning successfully a file.gz , can anyone guide me if possible on a way into actually downloading this document?any suggestion helps thanks in advance

Hi All, we are currently working on the integration where we are sending a document and payload using multi-part form data to another system and we are retrieving the document back on request basis into Appian via Integration object using REST API Calls as we cannot keep the documents in APPIAN.  Document can be any MIME-Type, In this case, we are taking example of .msg file format. when we retrieve the document back from other system, they are attaching boundary data & MIME Type details as shown in the below screenshot. Because of this, .msg file is unable to open after we retrieve the document into Appian and downloaded. Only way is to remove those line items from the document as marked and resaved it. can someone suggest here anyway to ignore the line items in the response and able to open the file. Here is the response Here is the way that I setup my Integration object