Integrations

I have tried with Web Content Component it will embed page with provided source url but it will ask for logon and password again.

Hi, While getting data from DB using in WebAPI, getting Z appended only in the datetime field as below. WebAPI: a!localVariables( local!Details: rule!XXX_DetailsView( batchSize: http!request.queryParameters.batchSize, startIndex: http!request.queryParameters.startIndex ), a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson(value: local!Details) )) It's a simple GET API. NOTE: rule!XXX_DetailsView - This is queryEntity used to get data from View. Anyone can advise, what could be the reason, and how can we remove this extra 'Z'.

Hi, I am trying to integrate a web api in Appian enviornment but getting error that The connection is not secure even the web api is secured by SSL certificates.  Apart from this, I am able to access web api in postman without any errors. Please suggest me what should I do to fix this.

I am trying to set up an OpenAPI integration based on the JSON provided in the link below, but it is giving me an error message "The selected OpenAPI document could not be parsed" when I upload the document. Does anyone have insight here? I am not seeing anything in Appian's documentation that would assist troubleshooting.https://docspring.com/api-docs/v1/openapi.jsonSource: https://docspring.com/docs/api/openapi.html

DocuSign integration I have seen another project where when they create an envelope, they send a draft envelope to DocuSign. When the envelope is created, they call an integration object to retrieve a url like below: Apologies for the blurry images, but this is the setup to this integration object: In the Response Body in the first image, there is an http url. They are able to take that url and provide it as a link in an Appian interface, so that a user can click on that link and immediately see the DocuSign draft envelope configuration screen, where they are able to configure signer and recipient information before sending the envelope off to be signed. We want to replicate that in our project, however, we're using Appian's OOB DocuSign objects. Our connected system is below: We're not able to generate a similar URL. When we create and send envelopes, this is the only thing we see: If we try to get envelope definition (operation Get Envelope Definition), this is all we

Hi All, I want to retrive my credentials stored in third party credentials in Admin Console or in Settings page. I have tried a!scsfield() and a!httpAuthenticationBasic() but no luck. Can anyone suggest how can we retrieve the data stored in secure credential store to integration object. Thanks In Advance.

Hello, We've successfully implemented the web API document upload template in Appian, fetching documents and metadata from an external system. However, we've encountered an issue where the file name is consistently labeled as "Untitled Document" in the process. Any assistance in resolving this matter would be greatly appreciated. Thanks

How to detect/fetch all base64 values using Gmail API response in Appian? Currently, I am using this End point/URL "">gmail.googleapis.com/.../messageId".

Can Appian whitelist by URL instead of IP address?

Hi all,We need to send a document from appian to an external system which receives document as a part of json with document converted into base64 string. For example:{ "name":"Document_name", "document":"base64 string encoded document"} The request json will look something like this. How to convert document into base64 string in appian? Do we have any plugins for that??

I've created an WebAPI to save data by a!writeRecords(by WebAPI creation wizard) it worked fine when I test it by "TEST REQUEST" button, but when I call it by an Integrations, got error of {"message":"Write request has failed","error":"The input \"Records\" refers to an invalid record type. The record type does not exist, has been deleted, or the user does not have sufficient privileges to access the data."} I have create a Service Account, add SA to the security config with Administrator permission, to all objects, include WebAPI, RecordType Also add the API Key(Appian-API-Key) to Connected System. Can anyone help me?

Hello, I am getting this error while integrating. Can anyone please suggest? I have checked all the parameters and headers and they are good. Please suggest. The external system did not understand the request error-result-guidance The request was missing required details or was improperly formatted HTTP/1.1 400 Bad Request Next Steps Make sure that you are providing all required headers and parameters and that those values are valid Check the request and response for more details Review the external system''s documentation for information on what may have caused the problem

Hello, I'm creating a Web API for the first time, and I'm facing issues, perhaps due to not knowing how to test it. I have the Web API set up, and when I click the button to test it, it returns the value correctly: However, when trying to do it from an integration or using Postman, it doesn't return the response, but rather the following: What am I doing wrong? Thank you very much.

Hi Community members, I have requirement where i need to send the status to process model, if My integrations fails. Can someone help me. I have configured it this way,  Have created a PV of Error and its of type IntegrationError, but still if integration fails am getting blank value in Error (PV).

I am trying to get the data from Integration , there is multiple field which is more than 4K characters , is appian having restrictions to receive the no of characters and show the data in GUI ? when i test the integrations  , I am seeing the data truncated  , any Input is greatly appreciated ,? if 4K is max limit , whether we need to sub divide them into multiple fields and show them , Please advise

We are trying to fetch access token in order to integrte with gmail. To get the access token, we need JWT, which comprises of header, claim set and signature. The header and claim set part are clear. Can anyone help to understand how to compute this signature in appian? Is there any plugin available in the market?

I have created a webapi - Get method, I have created a basic user and added that user in a Group and attached that Group in that WebAPI. Now I used that basic method and called that using PostMan , it works fine. Now I deleted that basic user from that group & created a API Key and attached that Service Account in that group.  Used the API Key & Value in PostMan, I am getting an error  Pls let me know, what is the mistake I am making here. Thanks in advance.

I have two applications with API Integrations configured. Each application connects to the same gateway - Request Reply Bus (RRBUS) using the same client certificate.  Because the host is the same, how can we configure the applications to use separate client certificates? According to this post: https://community.appian.com/discussions/f/integrations/21467/adp-ssl-certificate-usage-in-integrations "This is done automatically by matching the url in the certificate to the server you call." Any input is appreciated.  Thanks!

Hi, I have a question, im creating a web api to return data from a query and i have to remove a column from the response. For example: I have an expression rule to bring me all the centers we have and it returns  "id" : null, "address" : "null", "officeName" : "null", "countryId" : null, "isAvailable" : true How can i remove the column "countryId"?

i have requirement where i need to pass start date ,end date and some mail address to external system (api) . how to send this data using integration and which method i need to use (get/post)Upon startdate api call should happend  and upon end date it revert the api call

i want to create address auto suggestion interface. i found a method called google places api. can you plase explain me how to do that

I have a Write Record WebAPI that needs to start a process. The purpose of the process is to notify a user group that a new speaker request has been added to the system.  I keep getting an error when trying to kick off the process, "PMSO Volunteer Request can only be indexed into using square brackets or the index function" I created a blank process (start node and end node) called "PMSO New Speaker Request".  There is one process variable created "entryId" that is set to be a parameter. The Web API a!localVariables( local!value: cast( 'recordType!{ca4c278b-1034-49bc-af7d-e4c16cf132b6}PMSO Volunteer Request', a!fromJson(http!request.body) ), a!writeRecords( records: local!value, /* * Construct an HTTP response to return to the caller */ onSuccess: {a!httpResponse( statusCode: 200, /* * Set an HTTP header that tells the client that the body of the response will be in JSON format */ h

How to integrate the Gmail API with the help of Appian's Integration Object?

Hello, I am trying to set up a data source / connected system in my Community Edition Site. I am running a MySQL Server instance on localhost:3306, but my connection test fails. Am I even doing this right? The username and password are correct, and My SQL says the server is running: Do I have to host the server online to be able to connect? No technical background here, but I'm trying to get it. I would appreciate your help!

Hello All, I have a scenario where we are receiving file in one of the path of Appian On-premises Server (Linux). e.g path : /temp/data/file.xlsx or /temp/data/file.txtWe want to read that file from Appian instance (UI) installed on same server. Can any one suggest how I can achieve same. Regards, Vijay