Extensibility

Hello there! I am using Export Data Store Entity to Excel/CSV Smart Service to export the data in Excel sheet. If I check database, there are records, but through the smart service, in Excel sheet, I am getting the message "No data available due to empty data source, applied filter/selection criteria, or fields visibility." Also, I have applied filters for specific data shown in excel sheet on the basis of id.  = a!queryFilter( field: "caseid", operator: "=", value: pv!transactionDetails.caseID_int) Please assist me in this. Thanks

I am looking to read a specific column of Excel in Appian. suppose I have 3 columns in Excel roll no. , name, and email. So, I want to read all the values in the column email as an array of Strings. 

Getting the following message when clicking the download button:  This app is available to download for Appian Customers, Partners, and Employees. Please make sure to self-associate from your profile. Within edit profile, there is no section to update the Member Organization, the minute you select update your able to see the join organization. I'm not here to find bugs in your application!!! Can we resolve this so that i can download the jar file.  I simply wanted to download a plugin!!!

I have created a webapi - Get method, I have created a basic user and added that user in a Group and attached that Group in that WebAPI. Now I used that basic method and called that using PostMan , it works fine. Now I deleted that basic user from that group & created a API Key and attached that Service Account in that group.  Used the API Key & Value in PostMan, I am getting an error  Pls let me know, what is the mistake I am making here. Thanks in advance.

Hi, This is mainly for the Appian team. I just noticed there is a bug in this plug-in. The moment it comes across a blank row, it treats it as the end of file. For eg, if rows 1-100 have data in any of the columns and row 101 is completely blank and 102-1000 rows have data in any column again, it only processes data from  1-100 and ignores the data in 102-1000. This seems to be a bug because previous versions would read from rows 1 to 1000. What can be done to resolve this?

I have two applications with API Integrations configured. Each application connects to the same gateway - Request Reply Bus (RRBUS) using the same client certificate.  Because the host is the same, how can we configure the applications to use separate client certificates? According to this post: https://community.appian.com/discussions/f/integrations/21467/adp-ssl-certificate-usage-in-integrations "This is done automatically by matching the url in the certificate to the server you call." Any input is appreciated.  Thanks!

Hi, I have a question, im creating a web api to return data from a query and i have to remove a column from the response. For example: I have an expression rule to bring me all the centers we have and it returns  "id" : null, "address" : "null", "officeName" : "null", "countryId" : null, "isAvailable" : true How can i remove the column "countryId"?

i have requirement where i need to pass start date ,end date and some mail address to external system (api) . how to send this data using integration and which method i need to use (get/post)Upon startdate api call should happend  and upon end date it revert the api call

i want to create address auto suggestion interface. i found a method called google places api. can you plase explain me how to do that

I have a Write Record WebAPI that needs to start a process. The purpose of the process is to notify a user group that a new speaker request has been added to the system.  I keep getting an error when trying to kick off the process, "PMSO Volunteer Request can only be indexed into using square brackets or the index function" I created a blank process (start node and end node) called "PMSO New Speaker Request".  There is one process variable created "entryId" that is set to be a parameter. The Web API a!localVariables( local!value: cast( 'recordType!{ca4c278b-1034-49bc-af7d-e4c16cf132b6}PMSO Volunteer Request', a!fromJson(http!request.body) ), a!writeRecords( records: local!value, /* * Construct an HTTP response to return to the caller */ onSuccess: {a!httpResponse( statusCode: 200, /* * Set an HTTP header that tells the client that the body of the response will be in JSON format */ h

How to integrate the Gmail API with the help of Appian's Integration Object?

Hello, I am trying to set up a data source / connected system in my Community Edition Site. I am running a MySQL Server instance on localhost:3306, but my connection test fails. Am I even doing this right? The username and password are correct, and My SQL says the server is running: Do I have to host the server online to be able to connect? No technical background here, but I'm trying to get it. I would appreciate your help!

Hello All, I have a scenario where we are receiving file in one of the path of Appian On-premises Server (Linux). e.g path : /temp/data/file.xlsx or /temp/data/file.txtWe want to read that file from Appian instance (UI) installed on same server. Can any one suggest how I can achieve same. Regards, Vijay

Greetings, I am looking to utilize the Log Reader plugin to read the login-audit.csv files in logs. I noticed the function returns the structure CsvContents, but it is treating my first row as a header when there is none. How do I go about making it so that the first row will be part of the rest of the rows and not as a header?

Hi, I have a set of Integration object that uses a Connection System (OAuth2: Client Credential Grant).I am testing direct on the Integration object with blank attributes:1. If it use connected system and the API returns 404 (i.e. user not found), the API will always fired twice (not expected). Below are the debug logs:2. If it use connected system and the API returns 200, the API will only fired once (expected). 3. if I remove the connected system and the API returns 404, then it will only fired once (expected).  2023-10-26 07:26:14,981 - { "origin" : "local", "type" : "request", "correlation" : "d782eed85047a462", "protocol" : "HTTP/1.1", "remote" : "localhost", "method" : "POST", "uri" : "https://example.com/path/to/service/07?test=001", "host" : "example.com", "path" : "/path/to/service/07", "scheme" : "https", "port" : null, "headers" : { "Authorization" : [ "XXX" ], "Content-Type" : [ "text/plain; charset=UTF-8" ] },

I am a graduate student using the community edition as part of my Appian learning journey. I plan on doing a grad project on integrating Appian with AWS.  Is it possible to explore this connectivity in the community edition? Any help would be appreciated.

I am working on Connecting Twilio to Appian, I have Inserted everything correctly and connected system authenticate properly. But the Twilio field is not working. It says invalid parameter for Sid, how can i resolve this.

I need to read and save data from XLS document. I tried using "Export excel to Database" smart service, but it is giving 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 (eg HSSF instead of XSSF)???". I also tried to convert the XLS document to CSV document using the "Convert excel to CSV" smart service and also tried to read XLS file in expression rule using fn!readexcelsheetpaging but still getting same error. Is there any way we can read XLS document? 

Hi, I have a requirement for generating barcode or QR Code. At present I am using Barcode Utilities plugin which is available in App Market. But this is not cloud approved. Can anyone suggest me if any other plugin available or any alternatives for this?

Hi i have polled emails using filter and poll plugin in a process model. The body is saved as a .EML file in a folder.  Is there anyway to extract the body of the EML file in to a table. Or to convert the .EML file into different format so that it can be extracted in to a table. I cannot use ReadEML plugin due to jar file conflict. any suggestions??

Hi All, If somebody has worked on Jira integration, Let me know if we can get the data based on list of project ids.(if i pass single project id it is returning the data).Solution i Have :- i can use a!foreach in order get whole data

Using integrations, I am retrieving outlook emails, but only receiving 255 characters rather than the whole body. Is there any way to get the whole email body?

Hello, I have been struggling with an issue for almost 2 days so far. I have an integration in a process that is triggered by a web API. I am repeating this integration up to 5 times the response was not successful. In the case where the response of the integration is successful in the first time, I am getting back the required response that is a json format that I am indexing from a process variable. In the case where the integration is repeated twice or more, the response I am getting back is empty as if the process variable was returned as a null value. The response i am indexing is the variable where I am saving the httpresponse from the integration. So again, if integration goes through from the first time, the response is filled, if it goes through on the second time or more, the response is empty as if the web API only considered the first value saved in the variable where i am saving the httpresponse and it's not updating it; and when i check the process variable

Hello team, I have a requirement where in the from there is a section where user need to fill order details (item, price, quantity). I need to provide an option to user to fill these details manually (this part is done) or by using an excel template. The tool should be able to read the content of the excel and fill it in the form before submitting the form itself. I know there is an excel plugin to read content but if I understand it correctly it can be read only after submitting the form. Is there a way how i can enable for the user to lead data form excel without levaing the form (staying on the same screen)? Thanks for nay answer

Hi My requirement is convert base64 data to appian value received from external system.I tried making it by referring to the URL below.docs.appian.com/.../Integration_Object.html The problem is that many pdf files were created.Has anyone had the same problem? How to solve it .Need advice and help!!! below is my source code image When i click refresh button the PDF file increases.↓