Integrations

Hi All,   Anyone can pls answer the below questions 1.difference between QueryProcessAnalytics and queryEntities in Appian2.Explain about foreach function and Which case use in foreach?3.What is the difference between the Instance Process and Delete Process in Data management? 4.When we go for Delete Process in Data Management? 5.There are 100 members in Array,how to find 55 member and also want to replace 55 member to 65 member? 6.What are the functions to trigger the flow in the interface itself? 7.Explain about the Queries function and Which case used in the Queries ?8.What is the difference between Query Process Analytic and query Entities? Thanks in Advance!

I have requirement where the web-api needs to be exposed which convert the appian document into base64 based on local id of document received in the request. Appian version :20.4(on premise)

I am trying to connect to a web service by providing WSDL URL from a process model smart shape. The WSDL is accessible smoothly over browser but when tried from Appian it throws below error and also the service endpoints are not listed. The endpoint WSHttpBinding_ISETUP contains a reference to an ExactlyOne policy operator which does not contain a supported policy alternative. That endpoint is not available for selection. The unsupported policies are [[alternative 1 : UsingAddressing]]. (APNX-2-4041-007) Please help on this regard.

hi there,we have an issue with the node "call web service". We are sending some information to "System A" by using the web service. But if "System A" is not available the web service node just stops with an error.  Though the flag "Pause Node on HTTP Error" is set to false.     I would like to handle the error in the process afterwards but this is not possible in this case. Is an easy solution available to handle this problem ? Otherwise I need think about a workaround. thanks Yusuf

Hi All, I am trying to build a new process model which imports the Data from an excel file. the steps i followed - - Create New Process model  - Add the Import Excel to Database Under the Integration service/ excel tools. - On the Configuration window for the  Import Excel to Database what should I enter on the filed properties to get this working and once Configured how to run the process model  Any step by step configuration would be much appreciated Thanks

Hi all, I'm trying to integrate with Microsoft's Graph API and I'm having a bit of trouble. When attempting to get the bearer token, I'm being returned a html page.  Graph API returning HTML and not json (microsoft.com) <- This source suggests that setting the outgoing content type would resolve this, however I'm not sure where on the integration to put this. I'm quite new to using the Graph API at all and so I'll admit the set up I've gone for may be wrong. Could anyone advise on the authorization/access/token process to get the bearer token in Appian? Thanks in advance.

I'm trying to connect to Microsoft Graph, specifically at the moment to retrieve an access token. Please see https://docs.microsoft.com/en-us/graph/auth-v2-service#4-get-an-access-token for more details. First, I've got this to work without using a Connected System (Just a HTTP Integration). The problem I would like to overcome is that of the security of the client secret. As per https://docs.appian.com/suite/help/20.4/Integration_Object.html#encrypted-values I only have three options which is to hard code it in plain text in the integration object, to put it into an expression rule or use a connected system. The expression rule is out as it would expose the client secret as plain text and it doesn't appear as though I can utilize the Third-Party Credentials store through the a!scsField() function. As per the Microsoft Graph documentation (first link above) I need to construct the Request Body as follows (This is the example from the documentat

Hi, I'm configuring Appian with Azure AD. While testing this SAML identity provider i've got the following message: Can anyone tell me what am i doing wrong?

So far, I have only been working on training cases or debugging existing projects, so please bear with me if this is a newbie issue. I have a training data set of various documents (as JPG and PDF) of different kinds, and by certain features (like prevailing color, repetitive layout) I intend to classify them (e.g. invoice type 1, invoice type 2, not an invoice). In a 2nd step, I would like to OCR certain predefined areas of each document and extract e.g. the address of the company sending the invoice and the date. The architecture I am envisioning is the following: In Appian, I have a UI where I can upload new files, which are saved by Appian locally in a directory with filenames like “document_12345689.pdf”. Meta info like upload timestamp, user, original file name should be persisted in a (Appian) database The file should is then submitted to google cloud which should do the classification step, and deliver back the label to Appian to be saved in the database. The page

Hi All, I want to learn how to upload document using WEB API. I am using the link https://docs.appian.com/suite/help/20.4/passing-a-web-api-document-into-a-process-model.html but could not configure each node in the Process model as it was not given in detail. Could someone help me in detail in configuring the nodes? Thanks Faisal

We need to drop a file from Appian to a remote SFTP server. A private key has been provided and verified; no user/pwd authentication is available. Please advise whether this is possible. Searching community found instructions for user authentication or for transfers TO Appian.  Thank you for your time. David Kessler

Hi All, 1. Could someone provide Free POST and GET Urls for Integrations object and WEB API object which may accept documents as well? 2. How to give permission to third party via WB API to expose Appian data ( how to authenticate them or how to set up authentication for third party)? 3. What are the inputs required by third party to use APPIAN data (such as URL and credentials etc)? 4. Where the documents received in APPIAN via integrations saved in Appian?

I built an integration using Microsoft Graph so I'm limited in retrieving 100 records per request. I know I need use the @odata.nextLink in the next GET call. In Power Automate I just loop through the calls using the @odata.nextLink and append each set of results in a array variable. How do I do this in Appian? Thank you, Americo

Do you know if this is possible, and if so what's involved? Is there an Appian Node module available?

We would like to migrate data from various applications (eg java , Oracle etc) into APPIAN using an ETL tool. Please let us know which tool would be a best fit in this case. Is Informatica Power Center compatible with Appiian .If not ,do suggest other tools.

We have a script task that calls a rule within which we make a few calls to some integrations and then process the returned data and save into a PV and then the flow continue further.now the problem is the API catering us with the data is not a stable one and fails sometimes causing the script task to fail. I want to implement a loop around in the process model where I should be able to loop back to the script task and retry executing. how do we approach this problem. I want to reduce human intervention here as much as possible.

Hi All, Could someone help me the below questions? 1. I am not able to understand the meaning of "Send credentials preemptively instead of waiting for a 401 authentication challenge" while creating Integration using HTTP from Scratch. Could you please make me understand in simple terms. 2. I need few free URLs for GET and POST to create Integration for Learning and Free WSDL Url to integrate inside of a Process Model.

Hi, I need to do an integration with GET method, sending a body. Is there any way to do this with a GET method? Thanks.

Hello, I'm trying to deploy a HTTP Connected System in an other environment, but when deploying, the Deployer plugins throws this error :"An error occurred while creating connectedSystem: The creation of the connected system failed because a value must be supplied for baseUrl in an import customization file" (in the base URL field : I have entered the url without any constant) Could you list me the different steps to deploy my connectedSystem please ? Regards

Hi all, we would like to introduce you our approach to implement integration based on Appian, SAP and Salesforce SAP, Appian, Salesforce - SAP Cloud Platform - event-based integration with Microsoft Azure (EN) SAP, Appian, Salesforce - SAP Cloud Platform - event-based integration with Microsoft Azure (DE) What is your experience?

We need to make use of JSON Web Encryption for a 3rd API integration. We are just doing a quick check to see if anyone else has implemented this on Appian.

Can anyone please guide on how to use service account in Appian. Why do we need to use  it and how it is used for testing . Thank you

Hi All,    Can anyone help me with details on hoe to connect to sharepoint (Online / 2016) from Appian, any plugins or other ways to connect.     the main idea is to read a file from SharePoint and place a file to SharePoint     Thanks in advance Warm Regards Vineeth

Hi I am wondering if it is possible to use the readexcelsheet() function on a rule input file (ri!Submission.submissionfile) which is uploaded in the same interface. a!textField( label: "Rules", labelPosition: "ABOVE", value: readExcelSheet( excelDocument: ri!Submission.submissionfile, sheetNumber: 1, startRow: 9, numberOfColumns: 4 ).result.values[1,4], saveInto: ri!rules, refreshAfter: "UNFOCUS", readOnly: true, validations: {} ) Should this be possible or does the function only work within a process model? In the interface I am getting the following error: 'Interface Definition: Expression evaluation error at function 'readExcelSheet'' while in the process model it works (with process variables) Thanks in advance! Chris

hello all, We have multiple documents sending to user via DocuSign and once it is approved we get back the document via WEB-API .... which is working fine  but when one of the document is signed the web api is called and the process moves ahead...which shouldn't happen  now we need something that keeps the web api on hold until all the documents are signed