Extensibility

Can Appian whitelist by URL instead of IP address?

Hi all,We need to send a document from appian to an external system which receives document as a part of json with document converted into base64 string. For example:{ "name":"Document_name", "document":"base64 string encoded document"} The request json will look something like this. How to convert document into base64 string in appian? Do we have any plugins for that??

Hi! I have task to generate excel file, I am using Text Doc from Template. Almost all parameters I am passing like ###parameter###  but I  also have checkbox in template in which I should pass true/false and I am not sure how to do that.

I've created an WebAPI to save data by a!writeRecords(by WebAPI creation wizard) it worked fine when I test it by "TEST REQUEST" button, but when I call it by an Integrations, got error of {"message":"Write request has failed","error":"The input \"Records\" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data."} I have create a Service Account, add SA to the security config with Administrator permission, to all objects, include WebAPI, RecordType Also add the API Key(Appian-API-Key) to Connected System. Can anyone help me?

Hello, I am getting this error while integrating. Can anyone please suggest? I have checked all the parameters and headers and they are good. Please suggest. The external system did not understand the request error-result-guidance The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request Next Steps Make sure that you are providing all required headers and parameters and that those values are valid Check the request and response for more details Review the external system''s documentation for information on what may have caused the problem

Hello, I'm creating a Web API for the first time, and I'm facing issues, perhaps due to not knowing how to test it. I have the Web API set up, and when I click the button to test it, it returns the value correctly: However, when trying to do it from an integration or using Postman, it doesn't return the response, but rather the following: What am I doing wrong? Thank you very much.

Hi Community members, I have requirement where i need to send the status to process model, if My integrations fails. Can someone help me. I have configured it this way,  Have created a PV of Error and its of type IntegrationError, but still if integration fails am getting blank value in Error (PV).

I am trying to get the data from Integration , there is multiple field which is more than 4K characters , is appian having restrictions to receive the no of characters and show the data in GUI ? when i test the integrations  , I am seeing the data truncated  , any Input is greatly appreciated ,? if 4K is max limit , whether we need to sub divide them into multiple fields and show them , Please advise

We are trying to fetch access token in order to integrte with gmail. To get the access token, we need JWT, which comprises of header, claim set and signature. The header and claim set part are clear. Can anyone help to understand how to compute this signature in appian? Is there any plugin available in the market?

Hi Everyone, I m using the SFTP Plug-in to send a file but I ma getting the following error. This plug-in [sftp] is not registered to access secured values for the given external system key [ExternalSystem]. Check the external systems plug-ins list in the Administration Console. (APNX-1-4229-003) Here I have added the external system in third-party credentials and added this plugin in the list also but still same error. Which is causing this error?  thanks in advance.

Hello everyone, I am using plugin HTML to PDF. I have used two nodes in process model "HTML DOC from template" and "HTML to PDF". In first node("HTML DOC from template") I am passing process variable for  ###name###  (pv!customer.name) and so on for others. Successfully converted HTML to PDF file but I am having issue with multiple entries. Like: I have total 10 records but in pdf all records shown up in one line with comma separator. Note: Created a rule for this where I get all records but getting issues passing this rule in process model node ("HTML DOC from template"). for example: <table> <tr> <td> <h3> Name </h3> </td> <td> <h3> Address</h3> </td> <td> <h3> Unit </h3> </td> </tr> <tr> <td> ###name### </td> <td> ###address### </td> <td> ###unit### </td> </tr> </table

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?