Integrations

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

Hi! When I use an integration in a process model, I get the following error:The integration execution time exceeded the configured timeout.However, the service I invoke through the integration works fine, only the Appian integration gets the error even if it worked as expected. How can I fix this? Is there a way to give it more time so it doesn't get error by timeout?

Hii Everyone, I am working on Deployment API - Inspect Package, i have created a connected system in which i have entered the base url as https://<domain>/suite/deployment-management/v2, where <domain> is replaced with my site domain, and use API key for authentication. Then i have created integration using this connected system with relative path as /inspections and in request body selected content type as multipart form data and created four parts adminConsoleSettingsFileName, packageFileName, customizationFileName and zipFile, for all this parts i have created rule inputs named same as the part names and kept type as text typeexcept zipFile which is of document type. I have passed the names of document in text type rule inputs and in zipFile i have passed exported applications zip file but now its showing error as shown in below image, can anyone help me with this?

We have a third party system which sends a notification to one of our endpoints in Appian at random times and wont wait for any response from us. Our concern is that we will miss some of these notifications if Appian is down for an upgrade / maintenance as all nodes will become unavailable even if we are on HA config and there is no queueing OOB for Appian to capture these API calls (which does make sense as APIs typically needs to send a response back when ever called) I cant go to the third party system to create a queueing system and retry them after some time once Appian is available. I am looking for some ideas to handle this in Appian. 

I have created an integration to do the patch inspection using Appian Inspect api. I am expecting the ouput as uuid of the patch but I am not getting the proper output. I am gettting the below  shown response. The status code is 200 but I am not abole to convert the response into appian value. 

Hi Team, I have a requirement wherein in Appian interface after clicking on a link directly it will redirect to the Tableau dashboard on same tab or different one. Please let me know how we can achieve this. Thanks, Amita

HI ,I am using "Google Sheet Connected System"  to write data in google sheet . I am trying to write data in the different columns for example column is I & J so range and values are- Ranges:- " Sheetname&"!I2:J" "  values:- { "Text10@Text4", "Text2@Text5", "Text3@Text6"} but If i want to update the column T also and giving range :- Sheetname&"!I2:T" values : _ {"Text10@Text4@Text9","Text2@Text5@Text8","Text3@Text6@Text7"} In this case ,T column is not updating or writing anything.So Can anyone tell me that what will be the correct way to update or write in the google sheet.Thanks in advance

I am trying to create an email that will go to an non Appian user.  I am putting 2 links/buttons in the email for them to click and in turn would like it to start a process.  First, is this even possible?  Second, in my HTLM code, do I set mode to cors or no-cors?  Third, where do I put the authorization in the HTML code?  I set up a service account in the admin console and added it to the user group.

Hello everyone. I would like to know if it's possible to use Appian as a consumer for a specific Kafka topic. In our very specific case, let's suppose a user updates an address and the message is replicated to multiple systems, through Kafka. Our idea was to enable Appian to consume from this topic and these messages. I tried to configure the Kafka Tools plugin available in the AppMarket, but I can't seem to configure the nodes correctly. I have a demo instance in Confluent Cloud and I was able to do some producer/consumer tests locally and also via Python Client, but I'm not able to consume anything when it concerns Appian. Do we have a better way of integrating with a Kafka topic? Kind regards

Hi Community,    I need to create a record type based on an external Airtable table. AirTable provides a REST API for querying the data, so I decided to create a Web Service based record type.  I already created a connected system and confirm that is returning data.    The issue here is the paging (due to the expected number of records) - Airtable does not accept a page number as (query) parameter, only the page Size.  In each response, beside the record list, there is an attribute called "offset" that should be used in next request (send as a query parameter) to get the next page (and so on).  When we get the last page, the offset attribute will be empty. Additionally, there is no way to know (in advance) the number of records in the Airtable.    As the Appian paging is based on batch number, I do not have any idea how to proceed.   Hope that somebody knows a way how to handle this type of paging.  Thanks in advance

Hello! Our integration with DocuSign just stopped working on August 29th at around 2:30 eastern.  We spent the morning with DocuSign techs and were not able to resolve the issue.   DocSign came back with "This would indicate that the mechanism relaying your auth token is either not properly relaying it or the token itself is being cut off. The messaging would indicate that it's not being included at all, and that the CORS related error I was seeing was a red herring related to attempting to send envelopes without a registered IntegratorKey.  We have put in a support ticket, but is anyone facing this issue?  And if so were you able to resolve it?

Some integrations (i.e. CRM Dynamics 365) have scopes tied to the environment. For some reason, this is the only parameter that we cannot put in an Import Customization file and it gets overwritten on each full deploy of the application.

I am trying to get data from Salesforce. The connected application is functional on Salesforce (tested on Postman) but, I get this error in Appian Unable to retrieve access token The following error occurred: invalid_grant authentication failure whenever I test the connection of the connected system. Can someone please help me out with this error?