Integrations

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

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