Integrations

Due to security reasons my Organization does not allow to do CRUD operations on Oracle Database directly. Iam allowed to do via API Call. Iam not sure how do i perform CRUD operation via API to the Database. Request you to suggest your thoughts or please share me the links by any chance if you have. Thanks in advance.

Hi, I have an Appian WebAPI that performs a DB write using standard Appian smart service. During regression testing it was observed that sometimes the API fails with a http status 500 for a request that otherwise works perfectly. On further investigation I noticed the below error in tomcatStd.log [Appian AppianServerThreadPoolProvider 4577208] ERROR com.appiancorp.connectedsystems.http.execution.AppianHttpRequestExecutor - ConnectorRuntimeException [title=You are not permitted to perform the requested operation, The external system understood the request but refused to authorize it] The API is authenticated by oAuth 2.0 clientId and the service account does have access to all the necessary objects required for execution. Does anyone know how to drill down this error to find the component that is denying access? Thanks!

Greetings All, I am interested in creating a POC during my trial (time running out) that includes the use of Twilio Integration.  I have used Twilio for years in other companies and with other integration technologies. For some reason, I just cannot find Twilio in the Process Modeler so I see no way to include it in the process. Thanks in advance for any pointers on how to do this. Paul

when I try to call a related action I am getting the following error: The Requested Record Type Is Not Available Expression evaluation error [evaluation ID = ad9b8:6311a] at function a!recordList: An error occurred while retrieving the data for "UMS DOL AAPP". Details: Unexpected error executing query (type: [VAAPPDetailsDT5451], query: [Report on Record Type], order by: [[Sort[aapp asc]]], filters:[null]) (APNX-1-4198-000) And the error is not constantly showing up, sometimes it shows and other times it doesn’t. I have created the CDT via Appian so all the values are the same as the table. Any Input will be greatly appreciated if you can point me to the right place to see why this error is happening, will be great

Hi everyone, We have exposed a service which is accesed by HTTPS (SOAP) but it's defined by HTTP on a WSDL service. We can't change the WSDL definition because it's automatically generated. If we send a message to the HTTP endpoint it throws the following error.  Details: Transport error: 302 Error: HTTP/1.0 302 Moved Temporarily (APNX-1-4045-000) This error is thrown because the SOAP server has a redirection from HTTP to HTTPS. In fact the end server does not listen to HTTP requests. How we can connect to another endpoint that it's not defined in the WSDL service?

Dear all, we have a scenario to capture the use activity when they are accessing Appian to track the user activity.  decided to capture the data and store into database for generating report out of it. Could you suggest any approach to write the data into database without button click. Thanks in advance

Hello everyone, Please share your inputs/thoughts on below use case On click button/link from Appian, external web page should open with some form fields. few of them suppose to filled by data from Appian and there on users continue to work on their page can save data to their external system. (i.e. Something similar in Angular post data to web form using form inputs) Is there way we can achieve this from Appian?   

Hello, I need to sent a xml file to a endpoint (https:// ) different than the endpoint publised in the exposed wsdl file  ( which is http://  for firewall reasons). How can we do it? Enclosed the implementation and the message error. Thanks in advance Jesus Salazar

I want to use one get API endpoint which has dql query in the endpoint. but its failing in Appian integration and getting result from postman. 1. When I execute Get API endpoint in postman am getting result. but if i do the same in appian Integration am getting error. what might be the reason? Do integration doesnt support dql query?

Google Maps Display or Directions configured in Interface not working in Site but working in Mobile App Configured Google Maps Connected System, Working Fine, Integration Working Fine, WebContent Working fine with the Key. Google Maps Directions and Display field is not updating on either Interface or Site, but is working fine when I log in through Appian Mobile App on App Home Page. Is there any specific configuration to be done to display those fields on Site Home Page on Laptop as compared to Mobile. fyi, I have not configured the home page as per mobile.

Dear, we have created an integration with Sharepoint  (using Authortaion Code as Authoritation Type) to add document in a specific folder months ago. Integration worked, but yesterday I have received the following error (with the same test): Clicking on the link, integration worked, but how can we solve this problem without a manual operation? Thanks in advance for any suggestion 

Hi! I am trying to retrieve the metadata of a document already uploaded to sharepoint and I have this error ... The data is apparently fine. Could someone who has worked with this help me?Thanks and regards

Hello We have the need in the project to create a service (not a process model) with a wsdl passed to us by the customer. So that we then pass the end-point and invoke us.Is it possible from Appian to generate an end-point from a wsdl? Thank youAlex ACG

We need to integrate Appian on cloud  with an authentication web page, which works as a reverse proxy. The authentication will be done in that page and a  header interchange mechanishm will work after the authentication to pass through the HTTP traffic to Appian. Which is the best way to integrate with this authentication method and how?

For our project we currently have SAML set up to create users based on a single AD group. We want any users belonging to a handful of AD groups to be added to various Appian business groups. I decided to make a pm to add or remove group members, but don't have a way to query AD. We cant seem to find a way to query AD aside from using LDAP(my understanding is SAML cant be used with LDAP).  Is there  way to query AD with LDAP without fully committing to using LDAP in the Appian Admin console? Something like an integration/webapi to query AD with LDAP without fully commiting to using LDAP from the admin console.

Hello, I am upgrading a web API that was created sometime ago, it has all the process nodes in one very big process. I have managed to split it up to smaller sub-processes successfully, but the thing is that after splitting it to multiple process I started to add more functionalities (as this was the main goal in the first place), but once all the new functionalities were integrated the web API started "act out" or become unstable, where the web API sends a response back before the whole process reaches an end and before the "response body" variable is filled so I keep getting an error saying that function toJson() can't convert null data, I should mention that I have all of my nodes in all of the processes and sub-processes chained. my question is: is there a resource limit or time limit (keep in mind the API requires about 1-3 seconds to complete) and if so how can I modify this. ------------------------------------------------------ helpful screenshot

Hi Appian team, Web API that connects to process model -I need to pass input parameter different and get a different output parameter can anyone help me out with this , now whatever am passing as input parameter to processparameter same am getting as output parameter as process info.Please edit below code accordingly below is the currently used web API code snippet: a!startProcess( processModel: cons!xxxxxxxxx processParameters: {xxxxxxxxxx : 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" } ) ))

I pulled the data from Big Query's data source using the HTTP Get Method it works I was able to translate the data to Appian's formatData is displaying Now with the Expression editor, would this be the Data side of things, Will I be able to set the variables for the data in there and make it in such a way that every time bigQuery data updates a sepcic data it will update into Appian. Can I do the same thing with pushing the data too, have the POST Method set up with a process Modeler to push data that has been updated in Appian to BigQuery?

I managed to create a connection to BigQuery's API, however, How would one go about pulling and pushing data between BigQuery and Appian?

I have managed to get the API to successfully import data from Big Query, However, I am struggling to get the data's to display in the Data Previews. I have created the rule!Pulling_Data().result.body.rows.f along with the: createdictionary( {"ClientID","Client","Project","Developer","Hours"}, fv!item.v ) so that the rows are split into columns, however, although the test is successful with this output. There is no data in the "Data Preview" Is there a way around this, or something I am doing wrong that is now allowing the rows to display?

Does anyone have any experience in using the Azure File Service / Azure Blob Service ?We are currently creating a file within Appian and move it to an on premise server using SFTP. At some point in the future, the on premise server will be replaced and we have the need to move the file to an Azure Server. We've been advised to make use of the above service but are struggling to get this to work.Either the requests we are building are incorrectly formatted or it's not recognizing the document object at all. It would be great to know if anyone else has a solution, the examples i've found, are not Appian specific and so far haven't helped ...

Hello, I want to call a rest API that use NTLM. Integration cannot be used in this case. I do not found anything else. How can achieve ? Regards

Hello, We have a requirement to call some integration rules from UI. I am able to call a single Integration rule and able to receive the response. But, in our requirement, we have 3 separate integration rules one of the response parameters from the first integration rule is the request parameter for the second integration rule and the second integration rule response is the request parameter for 3rd rule.  So, In the UI Interface, the user should be able to click a button that should call these three integration rules subsequently and we have to show the response of the 3rd integration rule on the UI. Please guide us to achieve this requirement. Thanks in advance. 

Hi Guys, I am quite new to Appian. I have tried using this HTTP link bigquery.googleapis.com/.../data which the link to access my project,however, everytime I put that in and test the data it throws an error. I do have the account I am getting it from Authenticated. I am lost from here. Has anyone run into this issue and found the resolution to it?

We have created a service call using 2-Way SSL. The request message has been hard-coded with the required fields, but when we try to run the service, the following error message is provided:  Caused by: org.apache.axiom.om.DeferredParsingException: javax.xml.stream.XMLStreamException: ParseError at [row,col]:[1,1] Message: Premature end of file. Is there a way for us to see our request body or further details? The error message is unfamiliar and we are not sure how to debug.