Integrations

Hi, everyone I would like to integrate Appain'DB to MS Access'DB.In order to do it, I am tyring to create RPA Robot that excutes JDBC to read or write to Access'DB by costum Java code. If you have better idea or know how to create RPA Robot that excutes JDBC to read or write to Access'DB, could you tell me about it? Thank you.

Hi, I want to send sms to mobile number for authentication. Can anyone know best possible way?

Hi, In my application I am sending emails with task/record links. The user can click on the link and the link takes him to the task/record or Appian login page, based on whether the user is logged in. I got a new requirement to count the number of clicks from email to Appian, without using any other technology outside Appian. For this, I came up with two Web API endpoints, first GET with link to itself in the email sent. GET returns HTML website with automatic POST page that utilizes second WebAPI, which runs a counting smart service and returns the original task/record link. This solution works only if user is already logged in into Appian, otherwise an ugly error is returned to the user, see below. My question is, is there some way to force the Appian Log in page in case no valid session is found when trying to use the GET API and then redirect him back to it - with the GET API being linked from an email. Thanks  error:  "error":"APNX-1-4187-000&qu

I have a requirement to access the database in Appian Community Edition from the Appian Cloud Edition. Can you list out the steps that I need to follow for this?

Hi All, I am trying to upload appian file to CMIS. I'm using CmiCopyDocumentFromAppian as AppianDocs suggests. =load( local!appianDocument, local!cmisFolderId, local!cmiCopyDocumentFromAppianWriter: bind( null, a!cmiCopyDocumentFromAppian( scsExternalSystemKey: cons!CMIS_SCS_KEY, usePerUserCredentials: true, atomPubUrl: cons!CMIS_URL, repositoryId: cons!CMIS_REPO_ID, objectId: local!cmisFolderId, properties: {name: "Example Document"}, appianDocument: _ ) ), { a!textField( label: "Folder Id", instructions: "The object id of the CMIS folder into which the Appian document will be copied", value: local!cmisFolderId, saveInto: local!cmisFolderId ), a!pickerFieldDocuments( label: "Select an Appian Document", instructions: "The selected document will be copied to the target CMIS site", maxSelections: 1, value: local!appianDocument, saveInto: local!appianDocument ), a!buttonArrayLayout( buttons: { a!buttonWidget( label: "Copy Documen

We're trying to implement an eTag to reduce query time to a remote API.  They've provided support on their end and are generating an ETag,  a subsequent GET by us, with an ETag header doesn't seem to generate the response I'd hoped, and  before I go back to the vendor, I wondered if there was something tricky in the way the quotes need to be created around the ETag string?

Hi friends I have to Integrate payment gateway for Ecommerce Application how I can do that? how we will get Payment gateway

Hi I want to test an integration which should create a new record in an external system. This is the code that creates a 'job', with its name, the department, an array for the offices ids and a template_job ida!tojson({ "job_name": "AppianFlow3"& " "&"Related data"&ri!record['recordType!NJW NewJoiner.relationships.njwGhOfficePicklist.fields.officegh']&ri!record['recordType!{1fc618ce-6255-402a-81f8-007ca9ca5de4}NJW NewJoiner.relationships.{925eac6a-be91-4fe5-b4a3-1009d480994a}njwGhOfficePicklist.fields.id']& "NJWRecordType"&ri!record['recordType!NJW NewJoiner.fields.division']&" "& ri!record['recordType!NJW NewJoiner.fields.businessmanagerapprover']&ri!record['recordType!NJW NewJoiner.fields.id'], "department_id":"4076573002", "office_ids":{"4036737002"} , "template_job_id":"5468426002" } ) I want to test the integration by getting one record by id of the record type NJWNewJoiner and parse in the json request some fields from the NJWNewJoiner Record type as well as

I have created an apian web post API. api is working in appian and when i try to test it in postman its gives error 501. how can i test it in post man. need help. i already created outh credentials and also added the service user to the application groups.   a!localVariables( local!value: cast( 'type!{urn:com:appian:types:TFA}TFA_TESTING_RT', a!fromJson(http!request.body) ), a!writeToDataStoreEntity( dataStoreEntity: cons!TFA_data_store_constant, valueToStore: local!value, onSuccess: a!httpResponse( statusCode: 200, headers: { a!httpHeader(name: "Content-Type", value: "application/json") }, body: a!toJson( fv!storedValues ) ), 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" } ) ) ) )

Hello Appian People, I have integration GET(Queries Data). Basically this integration search address. And I call this integration in the interface. In my interface I have a texbox and search button, whenever the search button is clicked if there is corresponding search result returned in the integration or if the integration search result is onSuccess the result value will print. So my problem is, how to check if  the result of the integration in the interface  fails/failure and gets the corresponding message of the integration error?

How to invoke Appian WebAPI with OAuth2.0 clients from postman? And Do I need to add any query parameters as "Authorization" in Appian Web API for setting OAuth 2.0 clients?

Dear Appian Community,i want to call a pretty common webApi with a regular JSON request.Usually no issue. CDT/Map tojson() go for it.Just faced that a key is mandatory at the receiving end which has a "space" in it.But CDT field names and Map paramters are just working without space.To show what i mean:the API expects a JSON parameter like "Creation Date: "my CDT has "CreationDate" (so space missing) Any ideas to solve it?Still amazed that i never faced that so for.kind regards,Richard

Integration returns: HTTP/1.1 302 Date: Wed, 04 Jan 2023 16:05:55 GMTServer: Apache/2.4.41 (Win64) OpenSSL/1.1.1cX-Content-Type-Options: nosniffX-XSS-Protection: 1; mode=blockLocation: /MyWeb/CreateNoteContent-Length: 0Set-Cookie: MYSESSIONID=ABCXYZ123456; Path=/MyWeb; HttpOnlyVia: 1.1 myserver.dev.comKeep-Alive: timeout=5, max=100Connection: Keep-Alive I want to cal this integration via a link or a button from an appian interface.

what is the difference between HTTP connected system and open API connected system

what are the steps to follow in schedule a teams meet link in outlook and also how to cancel the schedule event and how to reschedule the existing schedule Meeting ? 

if anyone know let me know

a!richTextItem( text: "You must authorize your account before using this functionality." & char(10), style: "STRONG" ), a!richTextItem( text: "CONNECT", link: a!authorizationLink( connectedSystem: cons!ITS_CONS_INNERVUE_CONNECTED_SYSTEM, label: "Confirm connection" ) ), a!richTextItem( text: " " & "to your account to access your calculations first, then click" & " " ), a!richTextItem( text: upper("HERE"), link: a!safeLink(uri: "", openLinkIn: "SAME_TAB") ), a!richTextItem(text: " " & "to proceed.") } Below this code I will be having a UI in read only mode and once the user got authorized the above error message will disappear and the UI will come in editable mode. sometimes it is working fine but sometimes it is not navigating to the editable UI and going back to the initial pa

Hi, I'm using an Integration component to call a REST API that allows to return a PDF file (the input is a document ID). In the Integration Response Body Parsing selection, I've chosen the "Convert binary to Appian object" option to store automatically the document in Appian. All works fine, the document PDF is retrieved then stored in Appian KC. The issue I meet is to deal with the error case:When the API is called with an incorrect Document ID, the Integration error output result is stored in Appian as a Json file. But I don't want this Json file to be store in the Appian KC. If I want to choose the "Return raw response body" to manually deal with the raw body response, could you tell me how may I manually convert and upload the binary content to a PDF file in Appian please ? Regards

An error occurred while evaluating expression: expiredContracts:rule!TCT_ContractDashboard_Status_Expired( waitingOnCustomerAndApprovar: pv!waitingOnApprovaAndWaitingOnCustomer) (Expression evaluation error in rule 'tct_contractdashboard_status_expired' at function a!forEach [line 3]: Error in a!forEach() expression during iteration 10: Expression evaluation error in rule 'tct_docusign_getenvelopedefinition': com.appiancorp.connectedsystems.templateframework.functions.pipeline.proxyDecoratorPipeline.TemplateInvocationException: Contact the developer of this template to resolve the following issue. java.util.concurrent.TimeoutException: null)

Hi, We are going to use OAuth2 for a customer and reading the Appian doc, I can see this : - "OAuth 2.0: Client Credentials Grant" : is used when access is being requested on behalf of an application,  - "OAuth 2.0: Authorization Code Grant" : is used when access is being requested on behalf of a user, - "OAuth 2.0: SAML Assertion flow" :  used with SAML... Could you explain me the main differences between each of them please ?  (with possibly examples [emoticon:0f36700dfeb3494fa10d47dd9e1f90a1]) Regards

Hello everyone, I need to integrate my appian app with DocuSign. So I created connected system using DocuSign type. Then I created integration to this connected system using "Create and Send Envelope" operation to create a draft envelope with recipients with defined order. It works fine - but subsequently I need to implement multi-factor recipient authentication -> require phone authentication for my signers. Checking DocuSign documentation I can see that I need to add "identityVerification" part in envelope definition that is sent in POST method. The "identityVerification" part requires workflowId parameter. The question is: How to get this workflowId parameter using Appian?The docusign documentation says that to obtain my workflow ID I need to make a request to the identity_verification endpoint on the Accounts resource of the eSignature REST API using your {API_ACCOUNT_ID} to retrieve the workflow ID. The response

Hi, When you call a REST API and have such a reply below. How would the best pratice to cast the response to a CDT please ?Do you consider this ER must always return a generic CDT reply (solution A),or do you consider this ER must return 2 different CDTs according the reply, but in this case, we would have to handle a condition (Solution B) Response Ok from API : body: {  "id" : 1212  "url" : "https...."} Error Response from API : body: {  "developerMessage": "file already used",  "errorCode":102 } Solution A : type!response(  OK: {  /* Filled if OK */    id : 1212    url : "https...."  },  ERROR {  /* Filled when Error */    developerMessage: "file already used",   errorCode: 102 } Solution B : 2 different CDTs type!errorResponse(  developerMessage: "file already used",  errorCode: 102) type!

Hello Everyone, I am new to Appian I am trying to use Integration object where I have used QR Code Generator API I want to use that body ID 4424 but when I am calling that in Expression rule it is giving reaction tree so can you please help me how can I get that body ID.

Hi, I've created an Integration component and I have a PDF to send to a remote REST API (by POST method). So I've created an Appian document, and I've upload a PDF file (Test1.pdf) as it. When I call the remote API, I get an error in the response : "developerMessage : Extension non authorized - filename: "Test1.pdf.zip"  " Do you know why this component is adding ".zip" extension to the PDF file ? Of course, I've tested it before in Postman and all works fine. In my request body (in Appian), I've set my param like this : Name : "document"   Content Type : Document (auto-detect) Value : (RI is uploaded with Test1.pdf) I've tried another way : Content Type = Custom (with  application/pdf) but I obtain another error : "Internal error: Required request part 'document' is not present" Any idea ?

We are attempting to create an SSIS package for our on-premise MSSQL Database to create a connection to the Appian Cloud Maria DB. Is it possible to create an ODBC connection to facilitate this integration? Unfortunately, we cannot utilize the built in Connected System for integrating MSSQL due to our VPN being outbound only.  Thanks!