Integrations

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?

Hi Champs, I have a Use case where user need to be authenticated with a onetime password provided to their mobile number. How can I achieve this? Regards, Ghanashyam

Hi, I am trying to implement a Box integration using JWT Authentication. I have set up the entire integration however while trying to generate the access token it is giving an error. Can anyone help how to fix the issue? Thanks in advance!

Hi Team, I have an integration with Drupal. We send the outcomes from Appian to Drupal. I wanted to retrieve the request body (we are sending a json body) which is sent to Drupal. Is there any way to extract the same? There is some issue with the json that is being sent over to Drupal which we cannot figure out. Any help would be appreciated. Kindly revert back if you need any more information.  Thank you! 

We have requirement where schedule activity has to save the excel document into folder or sharepoint from where User can refer any time in future. This is big file and need to run Quarterly so doesn't want to be into Appian forever. While following the steps mentioned in https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azureacs#setting-up-an-app-only-principal-with-tenant-permissions to generate clinet id etc. I am getting a message that Tenant Admin has to approve the permission. Now while going thru share point offering in our organisation, seeing below- "Apps requested from the sharepoint are not supported. The interface allows requesting the Apps from share point store and send approval to share point admins, since it is not supported feature, request  will not be consideredor approved" Does that mean we can't do Appian + Sharepoint integration in our organisation? We use SPOL(Sharepoint Online)