Integrations

Hi, we need to make an integration with SharePoint Online, in form of single system login, with Appian 21.4 The customer after done the configuration on SharePont, gave us a PFX certificate and no client secret. But as I read on Appian documentation the "certificate authentication" is an alternative to Client Secret authentication which is needed by Sharepoint Connected System on Appian. So we need the customer to configure following "Granting access using SharePoint App-Only" (https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs) and not "Granting access via Azure AD App-Only". Is what I say correct? Is there a way to configure a SPO integration on Appian by using the certifcate authentication? Thanks

Hi, I have a web API, and inside that am calling few expression rules and storing it in Local variable. Is there a way that i can see what value is getting stored in that local Variable.(just like we have an option in interface, expression rules.) Eg: From local!getDelta am getting Delta value local!abc: rule!xyz( getDelta:local!getDelta, processid:index(http!request.querryParameters,"processId",{}) ) I need to check what is the value in local!abc in Web API object.

Hi All, In our application,  there are slowness integration. Pls need solution

Hi, We have a requirement to integrate a component that is based on a javascript library. The instructions given tell us to include into the consumer application page, an HTML script tag and a div tag with some specific attributes to setup the behaviour of the component.  As far as I know, there are no other way to get this kind of integration that build a plugin, ¿is that correct? I'm trying to establish the alternatives we have, I would like ti be sure I'm not forgetting some easy way behind. Thank you all

Hi all,I have the requirement to replicate certain services, with functionality and endpoint already defined. The problem is that when creating a web api it does not allow to use the character "/" to compose the URL, which makes it impossible for me to replicate certain URLs. For example: /add/vehicleI know I could use the "add-vehicle" variant, but it is imperative to keep the same structure for the other systems.Is there any possibility to do this in Appian? Thanks in advanced!

Hello everyone, trying to configure code grant integration. Client did set it up in a way where I need to pass the token not only in header but also in body, AFAIK there is no way to access the the headers of to get the token generated by CS ( very unfortunate ) any advice how to get code grant token into body of request easily ?

HttpResponse statusLine: "HTTP/1.1 200 OK" statusCode: 200 headers: Dictionary Date: "Thu, 07 Sep 2023 12:24:23 GMT" Content-Type: "application/json" Content-Length: "317" Connection: "keep-alive" Server: "Apache" Access-Control-Allow-Origin: "*" Access-Control-Allow-Headers: "origin, x-requested-with, accept, content-type, Authorization" Access-Control-Max-Age: "3628800" Access-Control-Allow-Methods: "GET, PUT, POST, DELETE, OPTIONS" contentType: "application/json" body: "{ "Apttus__APTS_Agreement__c" : { "success" : "false", "errors" : { "message" : "Upsert Agreement Failure:\n\nError Status Code: INVALID_FIELD;\nError Message: OBJ: Apttus__APTS_Agreement__c - Foreign key external ID: CO-UK-977-6935 not found for field Name in entity Protocol__c\n" } } }" Hello All,  We are getting this above error while sending data to third party system using POST MENTHOD. What mi

I want to execute store procedure as soon as i called the rule and in this store procedure i am trying to update some of the field on the basis of conditions. At the very first time it is working perfectly fine but after 4-5 minutes something wired is happening. It is updating all the rows data and not considering the condition which we have written in the procedure. Example: SQL query which we are executing: "update projectProject set isEditMode = 1, isEditCurrentUser = @currentUser, isEditTimeStamp = GETDATE() where IDprojectProject = @projectId " 2nd time it is not considering the where condition and updating all the project. I know it is already been written that executeStoredProcedureForQuery function could run more than once, do not use it with stored procedures that modify data to avoid unintentional changes but i am not able to find any other solution. Below is the code which i am using in rule. a!localVariables( local!data: a!executeStoredProcedureFo

We have requirement where we need to pull data from one of the table(Not Relational Database and it is Big Data environment)  to our schema or application. Data will be off appx 90 columns and 15+ column may have defined length of 4000 Char. And At a time it will provide 250+ rows.  We need to pull this data via Appian without doing Databasse to database integration though We just need to dump this data into our schema and landing table. I am thinking it may have impact on performance of the enviroment or Time out with API call but want to understand if any solution can be done via web API or any other way.

We have created a Webapi , that will be invoked by external system every 10mins to get data from our application. is there any way to check how much resources it is consuming and see whether it is impacting any performance.

HI All, I am posting this question out of curiosity. As we know Appian is coded in Java.  I am just thinking is there a way to fetch the Appian Reports in my Java Application ? Like if there is any Java Class/package that appian provides or something ? I have found something here: https://docs.appian.com/suite/help/22.4/api/com/appiancorp/suiteapi/process/analytics2/ReportData.html But just want to check is this something feasible ? Thanks

Hello, I have a Web API in Appian which returns ~4K records of custom data type (each data type has 14 fields). I am calling it using integration object and then using it as a webservice source in record type.  Issue - - The Web API returns ~4K records successfully whereas the integration object response shows only ~500 records.  - Is there a size limitation for integration object response? - What is the workaround? Regards, Abhay

Can use Integration in records? how to use integration to manage records and whether it's possible to integrate records?

I have a requirement where we need to send data from tables to PUB/SUB API in JSON formate . for this i tried fetching data from tables using queryentity then converting data to json .While sending we also converting that data to encodebase64string  and touniformstring . here the issue is we are unable to send large amount of data because encodebase64string has limit on characters . Is there any alternate way  to send data . Thanks,

Hi, We have a particular business requirement, in which large number of documents will be generated on daily basis, and these need to be stored for a relative longer period of time, around 7 years. Which tool can we use to integrate with Appian for storing the generated documents. Please suggest. Regards, Chetana

Hello, As shown in the screenshot below, I am able to get a ASP.NET_SessionId in HTTP Response instead of getting it in Result. In such a case how do I save it in a global variable and use it as a header input for another integration to fetch data from the other system API.

Hi fellow Appian practitioners, I am working on an integration with an external SAP system and have run into a potential Appian shortcoming, and would like to confirm this. I first do a get request to an external system authenticating endpoint to retrieve a token. That endpoint also returns three cookies in separate headers all with identical "Set-Cookie" name. I can view them when looking at the "HTTP Response" tab in the integration object after calling the API via "Test Request": Now, when moving over to the Result, the HttpResponse data type includes ONLY one "Set-Cookie" parameter, the last one, specifically. I do currently need all three cookies that will be passed into the next API call, but I have no way of accessing those in the HttpResponse headers in a process model. The integration works via Postman, as the cookies are automatically passed on to the subsequent API call. I have tried both CS with Basic Authentication as well as just

Hi , I am using 23.2 version which is upgraded recently and Once connected systme which was using Basic auth stopped working . when I test integration, I get following error , can aby one please let me know if this is deprecated and when ?

Hi Team, I want to know the configuration to be done on the process model in my case. I have created a WebAPI object to start the process model (my process model is empty for now), this external application is doing POST. But where can I see the JOSN body of the data the external system is sending to the Process model? many thanks

Hi, I am trying to integrate Grafana and Appian.I created a Web API object for POST so that it can write into the database table. Now whenever the alert is triggered from Grafana it is creating a new row in the DB but the row is empty. How do I find what all details or JSON is being sent to that Web API whenever Grafana triggers? Many thanks, Khaiser

Hi. Can anyone tell me how to go about this: I have to integrate and automate MS Teams Attendance Report in Appian. For example, need to get the meeting attendance data (time when one individual joins the meeting, leaves the meeting, their total duration)

I need to connect to a 3rd party system using Appian to pull in data from it.  It would need me to first create a token bearer , access that token for Bearer Authorization which will help to connect to a session and finally get data based on the api path URL Would highly appreciate if someone can help me with the steps I need to follow to achieve it. Thanks.

Hi Team  Here i am looking for different ways to integrate Appian with Microsoft teams without using paid plug in if you have any suggestions how can i implement that would be helpful . Thanks

How to drilldown into integration body  to index upto specific field

https://docs.appian.com/suite/help/21.2/configure-record-data-source.html#use-a-web-service-with-sync-enabled Above information says we can change but not able to understand the place where should i make the change?I am using Other Web Service as Record Data Source and using integration to pull data.I tried Limit in Query Parameters it didn't work.Any Suggestions?