Integrations

I am unable to call a WEB API that uses POST (trying to write to a datastore). I made sure the service account has all the right permission. I am getting the following error: 500 - Internal Server Error Edit: Turns out the service account simply did not have access to one of the objects called. Thank you.

Hi  We have a requirement to switch the API end points(i.e the integration calls(among different environments) based on user selection from UI) We can dynamically generate the URLS and authenticate via Basic Auth and store the Username and passwords on a constant  but the problem is that people with designer access can view the constant values  If we provide credentials for a single environment, by default they are encrypted and environment specific but if we configure them using expression the credentials are visible to designers which is a security concern. I am looking for the way to secure them and retrieve them back in Appian using a!scsField() -(There used to be a plug-in called HTTP Request with Secure Credentials Store  but that is archived unfortunately) We are using Azure cloud services so I am not sure if there is any connected system to integrate directly with Azure key vault to store and retrieve credentials or any plug-in to integrate with SCS from App

Is it possible to deploy only Db Scripts through Deployment API ?

I am new to appian.I have no idea. How to register data from user interface to integration object andhow to display the registered value on the user interface. Thank a lot.

Hello All, Is there any possibility to integrate  MS teams with Appian for real-time chat enablement.

Hi All, I have to make an REST API call with an integer value 17002732024, it cannot be passed as string as the receiver wont accept it. Do we have any way to achieve this. I am able to call this API as expected from Postman but when tried from Integration object, the value is converted to the max limit value(2147483647) which is not a valid value for request. Any help is appreciated. Thanks in advance!

The client wants us to log information about everything that goes in and out of the app through APIs and integrations. Appian logs a lot of stuff by default. So far I've found:  api_key.csv - saves information about any api keys used for our APIs, including identifying information for the key itself, what endpoint it was used to access, and the ip address of the client that accessed itoauth_callback.csv - saves all oauth calls that made to other systems. includes the user that made the request, the connected system it was made too and whether it was successful or notoauth_client_credentials_grant_for_web_apis.csv - saves oauth requests made to our APIs. Includes the service account that was accessed, the endpoint that was accessed, and client ip addresses Integration_summary.csv - I am not quite sure what this is. It seems to be a summary log taken every 5 minutes of the amount of time spent on all integrations in that 5 minutes. (is there some way to reduce the frequency? Ev

How can I call a 3rd party Web API in Appian which returns data in JSON format or XML format? Can anyone please inform me about the steps and prerequisites to integrate the 3rd party Web API in Appian?

Hi, all.We're attempting to establish a connection to an external system from Appian using a WSDL/SOAP endpoint with basic authentication. We are following the process outlined here:https://docs.appian.com/suite/help/22.1/Choosing_the_Right_Type_of_Integration.html#appian-initiates-the-interactions-with-another-systemOur first attempt via the process model and the Call Web Service Smart Service was partially successful. We were able to put our endpoint in and choose from the available services, so some limited contact was made; however, once the service was selected and the appropriate variables automatically created, running the process model caused the process to hang on the Call Web Service node, producing no error messages or feedback of any kind and populating no local variables.Our second attempt via an expression rule and webservicequery() produced similar results, but upon testing it timed out after the service and parameters had been specified.  If we put in an inco

Hi, We have a requirement to upload files coming form an external system to Appian. I am following this tutorial:   https://docs.appian.com/suite/help/22.1/passing-a-web-api-document-into-a-process-model.html I created all the objects required (process model, cdt, etc.). How can I test this in the test Inputs section? The "Body" field says Select a document. Is this asking for a full path of the file to be uploaded? What is the syntax for setting the Body field?  

Hi   Created one web api where we are starting a process  with one CDT as an input . When sending data like {["employeeName":"test",}]in the appian body and test request its working fine. But triggering the same from post man we are getting a 500 error. Web api authentication is happened properly . a!startProcess( processModel: cons!employee_processweb, processParameters: {employeedetails: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" } ) )) Postman: Configured header with Content-Type:application/json sending API Key bearer token. Body format as JSON.

Has anyone configured Appian to connect with AWS SNS?

Hi, We are using Appian on-prem version and implemented SAML authentication for single sign. We have a requirement that our on-prem server will be accessible to multiple development team and we want to implement application security. What i understood from Appian documentation that Groups are used to implement role based security from Appian application. my questions are 1. Is there any other way to implement Application security other than Groups? 2. Can we create groups automatically by integrating with Azure AD, and during user login group will be created and users will be mapped? Thanks, Bipindra Singh

I am calling an OpenAPI Integration that needs a session authentication token to run successfully.  I can call a different OpenAPI to retrieve the bearer token, but I cannot find a way to pass it into the Call Integration step. I created the Integration with a Header and Query Parameters. The integration test is successful, with the header and query parameters included in the request. When I add the Call Integration step to the Process Modeler, there is a message that reads "Map rule inputs/outputs using the Data tab": When I go to the Data Inputs tab, neither the Header nor Query Parameters that are defined in the Integration are listed: The Outputs tab does include the information from the response. Any idea why the inputs tab does not include the Header or Query Parameter values from the integration?  Any idea how to pass values through the Call Integration step of a Process Model? Thanks!

For suppose we have two drop down fields F1 and F2 in an editable grid. And we have two integrations namely A and B.   A contains data of F1 and F2 fields we need to fetch data from integration A and displays the data in each row as soon as interface loads. And by clicking add new row link in grid .the field F1 as it is drop down we need to fetch the dropdown values from integration B Let me know is it possible if yes any helpful tips to solve this.

Hello All I am new into Appian I am fetching data from integration object where i get all nearby vaccination centers name, type of vaccine, available slot and it is free or paid. But when I fecth the details i get all the details in one row only. So how can i show center name row wise please help me I am new into appian and facing problem in these See Here I am getting center name in one row only. How to show in different row. I am sharing the code also please tell me where and what should i do the changes a!localVariables( local!result: rule!CVMS_vaccinationCenter_INT(district_id: ri!district_id,date: ri!date), a!formLayout( label: "Form", contents: { a!textField( label: "Enter Your District Id", labelPosition: "ABOVE", value: ri!district_id, saveInto: ri!district_id, refreshAfter: "UNFOCUS", required: true, validations: {} ), a!textField( label: "Enter The Date for which want to check availability", labelPosition: "ABOVE&quot

Hello Everyone I am new into appian. I have used an integration object which shows me different vaccination centers available near by me and type of vaccination and availability and all the other things. I want to show this result to user in proper way in interface that this are the vaccination center name and type of vaccine in a proper way. But I dont know how to show integration object in interface and how to show the result in proper way like all vaccine center name then type of vaccine in that hospital. Please help me 

Hi, I have a requirement of Appian integration with outlook. We are sending / triggering an email notification to user(s) with Approve & Reject links. When the users try to click on the Approve or Reject links, is it possible to update the status in Appian without really login into Appian. Is there any service in Appian related to Outlook integration to achieve this functionality.

I am new to appian. I want to know how to refer integration object to user in interface. In my case user will give his district id and date and he will get all the vaccination center near by him and available slot and type of vaccine. I want to show this integartion object result in Interface to user in a proper way how can I do that?

I'm trying to figure out how to link an Appian Cloud database to Tableau.

Hi, In our Use case we have a requirement of conversion of base64 to doc. We were able to find this smart service in the 22.1 cloud version. Can anyone confirm if this smart service is available in OnPrem(22.1) version as well? this smart service is not present in OnPrem version of 20.4. Regards, Chetana

Hi All, I have configured the appianseleniumapi with example projects given.  AppianSeleniumapi 22.1.1  jar file's Basefixture/sitefixture/tempofixture not contains readlines() function. Common.io.utils jar contains readlines(). I have installed common.io 2.11.0. I am getting the below error. Exception in thread "main" java.lang.NoSuchMethodError: 'java.util.List org.apache.commons.io.IOUtils.readLines(java.io.InputStream, java.nio.charset.Charset)' at com.appiancorp.ps.automatedtest.common.PropertiesUtilities.loadProperties(PropertiesUtilities.java:28) at com.appiancorp.ps.automatedtest.fixture.BaseFixture.<init>(BaseFixture.java:66) at com.appiancorp.ps.automatedtest.fixture.TempoFixture.<init>(TempoFixture.java:104) at com.appiancorp.ps.automatedtest.fixture.SitesFixture.<init>(SitesFixture.java:11) at com.appiancorp.example.HelloAppian.main(HelloAppian.java:22). Kindly help to resolve.

Hi All, I am trying Automation with Appianseleniumapi. I have downloaded AppianSeleniumApi from appmarket and  have followed the steps provided in the document https://community.appian.com/w/the-appian-playbook/2304/automated-testing-with-appian-selenium-api. when running the project in eclipse , i am getting this below error kindly help.

We are looking at using the Parse Excel to CDT to parse excel data into a table.  Does anyone know if this process has protection to prevent SQL Injection? Thank you

New to Appian, have been through the developer training but have not taken the test yet. I have a request to be able to upload a Excel file and then parse the data and insert into a table. I have been looking at the Parse Excel to CDT to do this since this is the option our Appian has. Trying to wrap my head around this and have been trying to find examples. Does anyone by chance use this and is there documentation some place for this? Does anyone have a sample process model showing the steps on how it was done? Also trying to figure out the configuration on the plugin as well. Basically the user will upload the excel file, then parse data from excel into CDT then use the CDT to write to the database. Thank you for any help.