Integrations

Hello All, We have Appian setup on premises and want to expose & reuse processes to new Appian mobile app. Is there any way to embed on-premises processes/interfaces in Appian mobile app?  Thanks, Bhushan

Hi, in our system,  we have a functionality to create a document from an url of Reporting Service. We use the following smart service: In Input Body, we use the function httpgetbinary() (from plugin Web And XML Extensions), where endpoint is the url of Reporting Service that generate the document. However, the plugin doesn't exist anymore and Appian suggests to use Integration Object to substitute it. However, when we try to use it, we receive the following error:   So, we find Microsoft SSRS Document Integration Plugin, but there isn't no documentation about this plugin and we don't know the value of input Device Info. Could you help me to understand what kind of value it's necessary to insert? Or Is there another way to get a document from Reporting Service with NTLM Authentication? Thanks in advacne. Regards, Juri Monti

I'm trying to  connect to a system that  requires oauth 2.0  but  i want client credential in order to just connect with one global account for all the user to retrieve  the information. the site that I'm trying to access doesn't allow "oauth 2.0: client credential grant", right now only   the   "oauth 2.0: authorization  code grant "   is available. The way that quickbooks works is:   Step 1: the  site  can give me an access token and a  refresh token for  like a hundred  days  that's  why i'm trying to figure out  a  way to pass this tokens through the integration is there any way to do it ?.  

Want to know the best approach for E-sign functionality (Like username and passwords should be in each and every task before submit button ).  

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.