Extensibility

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.↓

I am new to use this Range slider  , noUiRangeSliderField() I am trying to install the new plug in and use this range slider   My basic query is how do we save the slider value back to any rule input or local variable   , i do not see value or save into parameter  onClick: a!save( ri!value , What parameter we can pass as Value  ? )  onClick: null,onChange: null,onSlide: null noUiRangeSliderField( label: "Temperature", labelPosition: "ABOVE", validations: {}, height: "AUTO", minRange: 0, maxRange: 200, startHandle: 0, endHandle: 200, pips: null, tooltips: null, sliderOptions: null, sliderOrientation: null, verticalHeight: null, step: null, behavior: null, additionalRange: null, shape: null, sliderColor: null, backgroundColor: null, disableSliderTooltip: null, disableSlider: null, readOnly: null, onClick: null, onChange: null, onSlide: null )

Hi, I am tying to run the Mysql to Excel plug-in: with basic SELECT Queries it works: but if I sent something similar to this:   SET @pivot_sql = 'SELECT * FROM report'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt;   it shows MariaDB syntaxis error.   any idea how workaround for this ?

Facing an Issue with basic user, While I was trying to get inactivated user from custom Picker, It is throwing an error like insufficient privileges for basic User Login.But for Administrator user type it is working fine and I have Updated that plugin to its recent version as well.

I want to parse CSV file and load into CDT without DB. Please suggest a plugin which is not deprecated.

Hi I'm trying to implement an Appian Web API (POST method) that is exposed to an external system.This API capture data like passing a document inside a json structure to an appian.My question is how to impletement passing a document inside a JSON structure to an appian web API?Is it possible to implement it in appian web API?If not is there any other way I can implement it? Please share any relevant documentation or sample code reference. Thank you