Integrations

Hi, I have a set of Integration object that uses a Connection System (OAuth2: Client Credential Grant).I am testing direct on the Integration object with blank attributes:1. If it use connected system and the API returns 404 (i.e. user not found), the API will always fired twice (not expected). Below are the debug logs:2. If it use connected system and the API returns 200, the API will only fired once (expected). 3. if I remove the connected system and the API returns 404, then it will only fired once (expected).  2023-10-26 07:26:14,981 - { "origin" : "local", "type" : "request", "correlation" : "d782eed85047a462", "protocol" : "HTTP/1.1", "remote" : "localhost", "method" : "POST", "uri" : "https://example.com/path/to/service/07?test=001", "host" : "example.com", "path" : "/path/to/service/07", "scheme" : "https", "port" : null, "headers" : { "Authorization" : [ "XXX" ], "Content-Type" : [ "text/plain; charset=UTF-8" ] },

I am a graduate student using the community edition as part of my Appian learning journey. I plan on doing a grad project on integrating Appian with AWS.  Is it possible to explore this connectivity in the community edition? Any help would be appreciated.

Hi All, If somebody has worked on Jira integration, Let me know if we can get the data based on list of project ids.(if i pass single project id it is returning the data).Solution i Have :- i can use a!foreach in order get whole data

Using integrations, I am retrieving outlook emails, but only receiving 255 characters rather than the whole body. Is there any way to get the whole email body?

Hello, I have been struggling with an issue for almost 2 days so far. I have an integration in a process that is triggered by a web API. I am repeating this integration up to 5 times the response was not successful. In the case where the response of the integration is successful in the first time, I am getting back the required response that is a json format that I am indexing from a process variable. In the case where the integration is repeated twice or more, the response I am getting back is empty as if the process variable was returned as a null value. The response i am indexing is the variable where I am saving the httpresponse from the integration. So again, if integration goes through from the first time, the response is filled, if it goes through on the second time or more, the response is empty as if the web API only considered the first value saved in the variable where i am saving the httpresponse and it's not updating it; and when i check the process variable

Hi My requirement is convert base64 data to appian value received from external system.I tried making it by referring to the URL below.docs.appian.com/.../Integration_Object.html The problem is that many pdf files were created.Has anyone had the same problem? How to solve it .Need advice and help!!! below is my source code image When i click refresh button the PDF file increases.↓

Hi I'm trying to implement an Appian Web API (POST method) that is exposed to an external system.This API capture data like passing a document inside a json structure to an appian.My question is how to impletement passing a document inside a JSON structure to an appian web API?Is it possible to implement it in appian web API?If not is there any other way I can implement it? Please share any relevant documentation or sample code reference. Thank you

Hi,  Im engaged with a client who has adopted in their enterprise standards that all exposed microservices within their organization be consumed using gRPC (https://grpc.io/).   Some  of those services will need to be consumed by the Appian solutions we are planning.    My current understanding of gRPC & supported authentication mechanism is the out of the box  Appian connected system, HTTP & Open API authentication types will not work.   As such we are considering if building custom connected systems and support for integration objects might work.  Has anyone in the community run across a requirement like this and done any successful custom connected system development to support the gRPC framework or solved the integration needs  in some other fashion?Also with Appian Integration SDK when developing custom Connected systems is it a requirement to use one of the Authentication Types supported by Appian (https://docs.appian

Hi  What path should I use for web api document download? image is uploaded to appian's image folder and How should I specify that image folder?  

I have set up an integration with Salesforce to bring in Salesforce Opportunities and create records in Appian.  I have created record types for the Opportunity, Content Document Link, and Content Document tables.  What I need to do is upload any documents in Salesforce to the corresponding record in Appian.  I.E. User creates Opportunity in Salesforce and uploads a document.  That Opportunity syncs to Appian and creates a record in Appian.  I also want to bring the attached document over from Salesforce and attach it to the record in Appian. Through Content Document Link and Content Document, I can see the attached document, I just can't download and attach.  Has anyone done this before or can give me pointers on how to do this?

Hello All, Could you please help us to redirect the URL using Appian webapi.  Below is the sample code I used . Now the URL is displayed in the body because i mentioned in the body. I tried to mentioned in headers  but nothing happened. Also i didn't see any keywords apart from body,statuscode,headers in a!httpResponse. Requirement is to download the documents using URL .(documents URL's are dynamic so we are trying to use redirect here). a!httpResponse( status Code: 302, body: {rule!example(fileName:concat( "537","Customer " "454", ".pdf" ))}, headers: {},),

Hi,I have an webapi which accepts xml as body request, So in order to test that webapi, I'm passing below xml:<UserInformation><id>TestUser1</id><isAppianUser>true</isAppianUser><firstName>Test</firstName><lastName>User1</lastName><name>Test User 1</name><systemRole>{'Initiator','Manager'}</systemRole><market>Hong Kong</market></UserInformation>But I'm getting below error when I test: can anyone help me how to test webapi in this case.

Hi, I have a Web API (Method GET) that sporadically fails and responds with http status 500. When I test it manually, with the same request, it works perfectly. Checking web api logs (web_api_req_resp_activity.log) I see: "body" : "500 - Internal Server Error" Checking tomcat-stdOut.log I see:[Appian AppianServerThreadPoolProvider 1680924] ERROR com.appiancorp.connectedsystems.http.execution.AppianHttpRequestExecutor - ConnectorRuntimeException [title=Connection timed out, The integration execution time exceeded the configured timeout] Checking design_errors.csv I see:All_Digital_Channels,AWS_GetPage (getpage),Web API,API Web Services,APNX-1-4198-000,Expression evaluation error [evaluation ID = a6e0f:1d079] in rule 'aws_aaabbb': Invalid index: Cannot index property 'body' of type Text into type Text,a6e0f454abd9e91cd6945ab8487579a8:1d079c3d00638e7f,aeccefc3-09ab-4951-9e47-80ff276293b2,,,,,,,, This error doesn't seem to make sense to me because w

Hi  I need to download multiple files in one zip file from a web API, I have multiple Document IDs so I need to download them all at one in a Zip format.

Does anyone know if the advanced call web service app market plugin supports SSL Client Authentication?    The documentation indicates is supports ability to call secure HTTPS services that use a self-signed certificate but unclear if that is the same thing as SSL Client Authentication.    Thanks Bob

Hello All, We are having a requirement to split the document uploaded by the user into smaller documents if the size of the document uploaded by the user is more than 5MB. The file type can be any like Excel, txt, pdf etc. We need to create a solution that will pick the file and divide that in small size files and save in Appian document folder. Thanks in advance for your response. Regards

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.