Integrations

Hello! I have an API which is returning an array of documents through an integration call with the response looking something like this:  { documents: [ { documentName: "document1.pdf", documentContent: "[BASE64ENCODEDCONTENT]" }, { documentName: "document2.pdf", documentContent: "[BASE64ENCODEDCONTENT]" } ] } The issue I'm having is that here in the integration where you can make appian to automatically convert the binary data to Document type, appian will recognise multiple files (content of them) through the fv! domain, but there is no way to set the document name for each document through the fv! domain.  What I want to be able to do is to set the document names similarly like I do here in the screenshot for the documentContent, which then correctly goes through the response and converts the data to document type.. What is the expected way to do this in appian? 

The US Department of Labor (DOL) has an application called "GPMS" that is built using Appian. The application's url is cmp.dol.gov/.../. My company builds a related web application. There's duplication between the GPMS (Appian) application and our web application. For example, the GPMS application has "case" records and so does our application. We want to make it easy for a user to navigate from a case in our application to the corresponding case in the GPMS (Appian) application. The users have entered the GPMS (Appian) "case IDs" (8 digit numbers) into our system. Is there a way to construct a link using only the numeric case ID that would open the corresponding case record in Appian? For example, let's say there's a case with ID "123456789" in GPMS (Appian). The current url to the page in GPMS is something like the following: cmp.dol.gov/.../{...long encrypted parameter...}/view/summary There's no way for

Hi All, I am getting this error in integration, which is get and sending huge data , because of this the PM is failing as it is returning null value in the PM. The output is too large to display, so the value has been truncated. Switch to the Raw or Expression options to see the entire value any pointer will be helpful on this  Thanks, Pooja

We have a requirement to archive all versions of a document in a separate CMS.  We have an integration that can upload a document, but it only works on the latest version of a document. We are not able to upload previous versions.  I was planning to use a plugin to "unpack" documents to a temporary folder where each version is a new document.  Is anyone aware of an existing, cloud-approved plugin that can handle this?  Are there any other integration or plugin alternatives that would meet this requirement?

I could not find any Appian documentation that describes how to add dynamic variables to Integrations/Web APIs for use with a!urlForRecord() and I was wondering if anyone had any guides or advice I would greatly appreciate it!

I'm trying to configure an Azure OpenAI service in Admin console, however when I try to test connection, I'm ending up with below error and the log shows ' Caused by: org.apache.http.ProtocolException: Target host is not specified' Any thoughts ?

I am trying to integrate with our Sharepoint Online platform in order to take data from it. I followed the configuration steps in the appian document (https://docs.appian.com/suite/help/24.2/Integrating_Sharepoint_with_Appian_CS.html), using the client credential - Azure ACS option but it gives me the following error:Could you help me solve the problem? Thank you very much.

When I called the webAPI, I want to check the parameter that comes from by caller, I checked the check box of the webAPI properties. But I can not find any information in the web_api_req_resp log file. How can I get the api request information?

Faced this issue when tried this tutorial Expression rule and integration for this tutorial are as follows Please provide suggestions to resolve this issue Thanks in advance

Hello, Recently I have been trying to set up the SharePoint connected system using "Client Credentials" as the authentication method. This is so that we can have an App-Only type access to SharePoint. Our client is insistent on setting up their SharePoint application is Azure AD as opposed to Azure ACS. It is my understanding that when setting up in Azure Ad as App-Only, we are not able to generate a client secret and therefore we are not able to use the Appian SharePoint connected system. Is this correct? and if so, is there a work around to this? Our two requirements are for the SharePoint to be registered in Azure AD, and for the access to be App-Only. Thank you.

Hi All, In Web API, when Appian receives file in binary format, we are using Appian-Document-Name field in the header to pass file name. And it is working fine when for English characters but when comes to Swedish file names it gives random some values in the file name.  For Example, Expected file name ÖPPNA.pdf, actual output cames ?PPNA.pdf

Hello there, I am wondering if its possible to get my public ID using an appian function. Please Help!

Provide suggestions to connect Appian with Sonic s3 bucket to upload/download documents without using plugin. 

Hello,  I'm trying to figure out how to integrate an external web site with Appian. I have a JAVA war file that contains JavaScript files. The war was produced by another organization, and I expect to have occasional updates. I have the war hosted and running on its own server. What I would like to do is push a button on an Appian form that launches the web page created in the war. The user then selects different options in the popup and hits submit. The external web site produces an XML string and sends it back to Appian. Appian then displays the processed XML on the form. Later, when the Appian form is completed and submitted, Appian saves the XML to the DB. I've tried using Web Content Field. It displays the button and launches the external web page. I have no idea how to send the XML back to Appian. Web Content Fields don't retrieve data as far as I can tell. I also thought about setting up an Appian Web API for the external site to call and send the data

Hello! I'm getting this error while setting up my integration. I have a couple of integrations in my application that allows users to archive and download documents from a SharePoint and they both use the same connected system that I have in this one. The one I'm showing is for my own testing purposes. I'm using this integration to see if I can retrieve any folder metadata but I keep getting this error. The connected system says it's connected and I'm using Entra ID. My question is am I doing something wrong here or does it look like I have everything set up correctly? Trying to find out if there's something missing on the Appian side of things or if there's something missing on the Azure side.

When we execute the API Endpoint to load the data in DB, we get Generic Error Message " 500 There was an error writing to the data store"  Is there a way to capture the Actual Error message and Return it as a message instead of the above? Example:  Details: javax.persistence.PersistenceException: org.hibernate.PropertyValueException: not-null property references a null or transient value Following is the code :onError: a!httpResponse( statusCode: 500, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( { error: "There was an error writing to the data store" } ) )

Hi,everyone I was using Post Method and when I tested with the expression rule, I was able to get 355 rows of data.When i tested webapi only 300 lines are responded from Webapi response. Can I change the size limit or number of lines for webapi?If so, where can I change it?

Hi,  We need to get access tokens from our id provider and we had thought about using a Connected System with the OAuth 2.0: SAML Bearer authentication method but the documentation says:  "As soon as Appian gets that SAML bearer assertion, it decrypts it if necessary and signs the user in. Then, for each Connected System that uses the OAuth 2.0: SAML Bearer Assertion Flow, Appian will immediately pass the SAML bearer assertion (along with the Client ID, Client Secret, Scope, and any Additional HTTP Headers set in the connected system) to the authorization server at the Token Request Endpoint. Appian will always pass the SAML assertion unencrypted" Our id provider requires that scope, grand type and assertion must be provided into the body and we have some questions:  Where does the SAML assertion travel, header or body? Can we get the SAML assertion in some way? Can we move the scope from the header to the body? Thanks in advance

Hi!Is there a way to check when and by whom an API Key was deleted from the Admin Console Web API Authentication?

hi all  related to the apache avro serialisation of data , wherein i got an error in integration in the result saying 500 status code and integration failed and avro serialization error.

Hello, I have a use case where I need to download multiple documents from SharePoint. Currently, I need to do this in a process model and the only way I have found of doing this is by creating a loop within my process.  Unfortunately, I need to activity chain this process and by having this loop, I risk breaking the 50 node limit. My question is as follows: is there any way to download multiple documents from SharePoint using a single node within a process? Thank you

Hi everyone, I’ve created a GET method Web API that returns a list of countries in the HTTP response. The Web API also includes a query parameter for the username. Now I need to log each Web API call by saving the endpoint name, response body, query parameter, and the current date and time into my Web API Log record. However, the issue I am facing is that Appian doesn't allow the execution of the WriteRecords smart service within a GET method Web API and gives me this error: Smart Services cannot be executed in Web APIs that have a method of "GET." Does anyone have any suggestions on how to handle this case without changing the API method to POST, PUT, or any other? I would appreciate any help. Thank you! For reference, here’s an example of my Web API code: a!localVariables( /* Retrieve all avalaible countries from the corresponding Record Type */ local!countries: a!queryRecordType( recordType: 'recordType!ABC Country', paging

I got 2 of this. one is Intergrate Designer and one is API Web designer. I already configured all the parameter and the endpoint seem the same from 2 of them. I use test request and both of them return success (200) but only Web API designer post data to database while Intergrate Desginer doesn't. Integration Designer :  Web Api Designer: Can anyone know what is the issue and how to resolve this one.

Is there any way to show a loading animation like a loading circle instead of an interface while the integration is running?  For example my main site is built with 8 interfaces where one of the interfaces calls an integration that might sometimes be slower (can take up to 5sec to load). In the current version if I force the backend API to take longer to load and then try to load the main site the integration call blocks the loading of the whole page while the data is loading.  What I would optimally like to have is that all the other interfaces get loaded while the one that calls the api shows a loading symbol until the data is loaded from the API.  If anyone has any suggestions on how to achieve this please let me know.  Thanks, Jan

hello in our application we're using a!sapInvoke to query some data from SAP. the integration were working till last friday but from this week they're failing. here's an example code of one of this expressions: a!sapInvoke( scsExternalSystemKey: cons!LEASE_SAP_SCS_EXTERNAL_SYSTEM_KEY, usePerUserCredentials: cons!LEASE_SAP_USE_PER_USER_CREDENTIALS, hostname: cons!LEASE_SAP_HOSTNAME, clientnumber: cons!LEASE_SAP_CLIENT_NUMBER, systemNumber: cons!LEASE_SAP_SYSTEM_NUMBER, bapi: "BAPI_MATERIAL_AVAILABILITY", importParameters: { MATERIAL: ri!SAPcode, STGE_LOC: cons!LEASE_MATERIAL_STORAGELOCATIONSELECT_LOW, PLANT: cons!LEASE_MATERIAL_PLANTSELECTION_LOW, UNIT: ri!unit }, tableParameters: {}).result which is returning the error: Could not connect,message:Failed to connect to the external system [key=leasesapdev]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Cons