Integrations

let me explain myself  i want to  use an oauth authentication token  globally for all the users that log into my  appian site and let them post and edit   information  using just that one  token 

I've got a sort of weird problem that I can't figure out. I have a webAPI built that kicks off a process model for creating new users. When I test it within Appian, I get a JSON response with all the info about the process model. { "pp" : { "id" : 268442112, "name" : "Create User Bob Newman", "priority" : 1, "initiator" : { "id" : "******" }, "startTime" : "2022-01-06T18:04:14.980Z", "timeZone" : "US/Eastern", "starred" : false, "parentName" : "", "execId" : 1, "status" : 0 }, "pm" : { "id" : 5238, "uuid" : "0005e780-67c2-8000-2559-7f0000014e7a", "name" : "PP Web API User Generation", "description" : "Create a new user with a web API", "version" : "16.0", "creator" : { "id" : "*****"

An API I was building required a query of a datastore and to avoid getting a 500 error, I needed to add the service account as a viewer to the datastore. While I don't particularly care about access to the entity that is getting queried, there are other entities within the datastore that I would rather not have potential external access. My question is, is there a danger of accessing other entities within a datastore through that service account somehow? Would it be safer to create a separate datastore for the service account that only contains the entity that it needs to access? Or would it not make a difference either way and I'm just being paranoid? 

Hi Team, We started to create a new Database schema using the Connected systems concept introduced in 21.3 However we have to use the Execute Store Procedures we need to provide the Data source Name : For example like jdbc/Appian Like this i am unable to find out the Data source/JNDI Name for the Seperate schema which is created. Could someone help me out with the datasource name of my schema created. For Example the Data source Name / Schema name created in the DB is SchemaOne.

Hello Appian practitioners,  Following the notes from this discussion, I tried creating a WEB-API to load a locally available WSDL within the 'Call Web Service' smart service. My web-api returns the following httpResponse a!httpResponse( /* * Set an HTTP header that tells the client that the body of the response * will be a CSV attachment. */ headers: { a!httpHeader( name: "Content-Disposition", value: "attachment; filename=" & char(34) & local!username & ".xml" & char(34) ) }, /* * Create a CSV value of 'local!user' and place it in the response body. */ body: rule!TS_test_ProfileXML() /* XML Contents */ ) However, the call web-service is still not able to detect the WSDL.  Appreciate all your help!

I have a GET web API which is consumed by third party, my GET API calls other POST API and there I am triggering a process and generating a user task, in my GET API i am also generating a process report to get task id using process id i get from POST API and than generating a url for  the task and redirecting url as response of GET API.  But sometime i am getting 500 error message and after initial analysis I get to know process report is slow and by the time web api triggers process and query report, entry is not added in report and so task id is return as null because of this, third party getting 500 server error. Any suggestion how can I resolve this error ?

I've made an API in Appian, but am having the hardest time understanding how exactly one connects to it externally.  According to the documentation: https://docs.appian.com/suite/help/21.4/Web_API_Authentication.html I should be able to connect to it this way: example.appian.com/.../endpoint -H "Appian-API-Key: ${API_KEY}" I put in my endpoint and API key, but every time I get an authentication error, so clearly I must be doing something wrong.  Could someone walk me through the exact steps to get this to work? 

Hi All, I am creating Document Download WebAPI which will be called by external system to download Appian Document . I want to capture few parameters such as data, time , document , user  whenever the document is downloaded (for an audit purpose) .I am trying to use a!startprocess or a!writetodatastoreentity() in the same webAPI but it doesn't work . Can I call a smart service a!startProcess or a!writeToDataStoreEntity in web API's of the method GET? What should be approach in this case ? Any help would be appreciated. Thanks in advance!

Hi, I have been using DocuSign developer account (using Basic Authentication) for testing purpose and its working like charm, but when migrated from developer to production account I am not able to authenticate using Basic Authentication. The error message says "The specified Integrator Key was not found or is disabled".  Please hep me with it.

We're using Azure B2C SAML based application with Identity provider-initiated flow. Please refer: https://docs.microsoft.com/en-us/azure/active-directory-b2c/saml-service-provider-options?pivots=b2c-custom-policy We'll embed this identity provider-initiated flow URL to our client websites, when customers click this identity provider-initiated flow URL that will take them to the Azure B2C SSO login page. We'd would like to know if there is any way to identify the requesting URL where the identity provider-initiated flow URL is triggered from, please? For example. when www.client1.com and www.client2.com calling this identity provider-initiated flow URL. Within Azure B2C portal OR Custom login page if there any possibilities to identify this Azure Idp initiated URL is triggered by www.client1.com OR www.client2.com. For example, on successful sign-up, call the Appian Web API to pass the client / customer-id and sign-up email-id paramete

I'm getting this kind of  numbers when i get data from an integration i want to  convert it into   numbers  to make an excel file and be able of edit the numbers  when i try converting todecimal() or round(val,2)   any  of this  conversion methods work what can i do  in this case ?

There is an requirement to send existing or uploaded docs to external system with metadata , with SFTP protocol I think we cant send metadata , What would be the better apprach

I have requirement to integrate Twilio with Appian to send SMS. How could I reach Twilio features in Appian? Can you guide me how to integrate and implement this task?  Thanks.

Problem statement: I have a requirement wherein we receive file in Appian from a third party system. For security reasons we want to restrict only few file extension.  I have created a WEB API using a ' Document Upload' Template , so that external systems can push documents to Appian.  I want to return error code in response when some hits this WEB API and upload files with extension other than .xlsx.  I have used  document(http!request.body, "extension"), however this does not restrict document to be added to target folder.  Is it possible that , WEB API returning error code and  not even allowing files with specific extension to be added to target folder.

we have requriment in our project , where we need read many documnets and search for partcular text in these docs, we need know what is the limit of number docs we can pass if we loop the getpdftext() in PM asychronusly , is ther any threshold for document size for getdpftext() function has the limit and is there any performacne issue can occur while processing of mutiple pdf docs here.

Hi All, i am using path segments to extract data from the request and i'm testing the API through postman everything worked fine in dev environment but when it goes to the higher environment its not working for example abc/bcd/cde http!request.pathsegments[3] returns cde in lower environments but in higher environment it returns bcd endpoint is almost same in all environments. path segment index is changing on the environments is there any server side setting for this anyone can help me please ? Thanks in advance

Hi, I have used "urlforrecord" in the email template to provide a link/url to the users. But, then email has been generated and clicked on the url, it is trying to open the record in "tempo" instead of "site" =urlforrecord(cons!AT_EMPLOYEERECORDTYPE,pv!employee2.employeeId) How can I provide link to the "site" instead of "tempo". Thanks

Hi everyone, which is the best way to send a binary doc via a SOAP serice? To be clear, using soapUI the documents are uploaded into attachments tab Thank you!

Good morning, We have the need to use the Tivoli tool to monitor different parts of the Appian software stack. Is it possible or are there any limitations?We see that in the list of tools it does not appear. community.appian.com/.../server-monitoring Thank you very muchAlex

does anybody know what does this error mean? Test Output Expression evaluation error in rule 'ums_qr_getvaappdetails' at function a!queryEntity [line 3]: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [VAAPPDetailsDT5506], query: [queryentity expression], order by: [[Sort[processIndicator asc]]], filters:[(aapp = TypedValue[it=1,v=100165])])

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?