Extensibility

I have an integration which returns the document in binary format and I can convert that to Appian document using the option to Convert Binary response to Appian document. But this API returns JSON body as below while returning error. I want to extract this error details and present it to the users but the integration object is returning null response body when I select the option "Convert Binary response to Appian document" even though API is returning below body. Is there any way to extract this body when API returns error and convert the binary to Appian document in case of successful response ? API Response as JSON body: {"type":"about:blank","title":"Bad Request","status":400,"detail":"Failed to read request","instance":"/api/v1/"} Integration Response:

Hi Team, Import excel to database plugin not writing in database table and not getting error in output parameter and in tomcat logs. The issue i am facing in my Prod environment and even not facing frequently. Could you please help me on this to move further. The same process i tried individual with only node of import excel to database, its working. The issue not occurring repeatedly and same file is working for some time. Thanks, Pradeep Sridharan 

Hi All, I have a file uploaded to sharepoint with encrypted file name ex: 1234.pdf . I have the original name of the file stored in table and while providing a safelink for download , I need to replace 1234.pdf with original name from table.  Currently safelink downloads the file with default/encrypted name of 1234.pdf . What approach can be taken to have the file downloaded in original name. Please suggest. Appreciate the help . Note: if we download to Appian KC temporary and then rename the file, it will become a 2 step process. I would like to avoid that. Thanks Raj

This is the result of 1st integration , i want to store client guid (of result body)  in some process variable and then pass this value as input to 2nd integration .How Can I achieve this ,can someone please advise

hi i have a query that i am using to fetch the data from post grace sql to appian  but while i am making a manual query  in that query i have empty values  as some contion  in the above condition we have empty values  whic is not considerding by plugin and displaying the below error  please give me any solution on this 

it is  posible to  change a sharepoint    folder name using the  update folder metadata integration

I am struggling with parsing the HTTP response.  I thought fv!result in the rule that called the integration would allow me to access the body of the response.  However, I am getting errors.  The three values I am trying to access are highlighted below.  Screenshots of the function where I call the integration and the response from the call are shown below.  I would like the three values stored in local variables so I can display the text messages to the user.  Thank you in advance! rule!CreatePatientResource( givenName:local!firstName, familyName:local!surName, gender:local!gender, dateOfBirth: local!dateOfBirth, onSuccess: { a!save(local!registrationErrorMessage,null), a!save(local!registrationComplete,t

From appian i Need to send the below data using integration{ "Guid": "String","TypeId":  1 "Comment": "string", "addColleague": { "email": "string",  "Name": "string", "Flag": true, "deletedFlag": true, "ID": 2, "idFromsender": "string", "addDeleteUpdate": 1 } }How to send the data in the above format from integration .Can I use CDT's I have one CDT  were GUid,comment, email,name and idfromsender are present Can someone please guide

Hi, I'm trying to import a CSV file into a PostgreSQL DB. Customer requires all data from appian must rely on that DB which is connected as datasource. I'm using the plug in Excel tool and the Smart Service Import CSV to Database.  I got the following error from stdOut log:  ERROR ImportCsvToDatabase8 Error executing SQL org.postgresql.util.PSQLException: ERROR: syntax error at or near "," Position: 17 From database, i turned statements log on and i found out the following statement:  2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:ERROR: syntax error at or near "," at character 17 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:STATEMENT: select `field1`, `field2` from `table` where 1=0 2024-03-29 17:32:08 UTC:10.245.48.249(51148):appian@postgres:[3319]:LOG: execute S_1: ROLLBACK I'm running the same statement on my client in Postgres and i got the same error of course. What I found out is that backtick is cau

I am using the LDAP tools application and reieveing the following error [Appian Work Item - 323 - WorkID 69 - execution02 - process 2098658 - model 65 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.plugins.directory.syncwithusernames.service.SynchronizationService - Error while conducting name search:  javax.naming.PartialResultException [Root exception is javax.naming.CommunicationException: DomainDnsZones.eg.Albaraka.local:389 [Root exception is java.net.SocketTimeoutException: connect timed out]]

Hi Everyone, We have a requirement where we use OAUTH2.0: Authorization code grant and once we click on Authorize, A new browser tab opens and an after logging into the external system, an URL comes in the search bar of the newly opened browser tab. Is there an way in appian to read the URL and fetch it into any variables,once authorization is successful. Thanks Rupa

Hello, Need an input if there is way to connect Appian and AWS cloud search. Thanks in Advance

Hi All, I have an in integration object which its currently returning successfully a file.gz , can anyone guide me if possible on a way into actually downloading this document?any suggestion helps thanks in advance

Hi All, we are currently working on the integration where we are sending a document and payload using multi-part form data to another system and we are retrieving the document back on request basis into Appian via Integration object using REST API Calls as we cannot keep the documents in APPIAN.  Document can be any MIME-Type, In this case, we are taking example of .msg file format. when we retrieve the document back from other system, they are attaching boundary data & MIME Type details as shown in the below screenshot. Because of this, .msg file is unable to open after we retrieve the document into Appian and downloaded. Only way is to remove those line items from the document as marked and resaved it. can someone suggest here anyway to ignore the line items in the response and able to open the file. Here is the response Here is the way that I setup my Integration object

Hello Everyone i need small help regarding to the  "audioPlayerField()", i want to play the mp3 audio in interface so that i am using the  audioPlayerField() but i am unable to play the song can any one help for this 

Hello - I am trying to test creating a FHIR compliant JSON payload to send to hapi.fhir.org/Patient.  Here is what I done so far. created an expression to create the JSON payload: concat( "{","""resourceType""",":","""Patient""",",","""name""",":[{","""use""",":","""official""",",","""text""",":","""Brian Doe""",",","""family""",":","""Doe""",",","""given""",":","[","""",tostring(ri!firstName),"""","]","}","]",",","""gender""",":","""male""",",",""&qu

Hi all,  I have seen that the decodeJWT function of JWT Tools plug-in returns the decoded token but only if the signature is valid, otherwise it returns null. This function needs jwks url to retrieve the proper public key and validate the given token.  Does anyone know if there is a way to decode a JWT without validating the signature? It is possible to decode a JWT with a private key stored in scs? Is there any other plug-in to create and validate JWTs? Thanks in advance. 

Hi, I'm calling MsGraph API from Appian in a two steps methop, I have to send the content-length from the previous integration as a header information in another call. How can I capture or insert into a variable an http request from an integration? Or are some way to calculate the content-lenght? Regards

We have a requirement to call web API which uses Bearer Token authentication type and it requires client id and secret in the Header. Before calling this API we need to get the access token using oAuth endpoint, this endpoint has authentication type as Basic Auth and it requires same client id and secret in the Header. 1. For OAuth endpoint, we have created a connected system (A) with the Basic Authentication using username and password. - Works fine. 2. For the primary API, we have created another connected system (B) with the following information. a. Base URL: <Base URL>. b. Authentication: None 3. Created an Integration object which uses connected system B and has following parameters in the Headers. a. Authorization: <Token received in step #1, passed as rule input> b. X-IBM-Client-Id: <client id, passed as constant > c. X-IBM-Client-Secret: <client secret, passed as constant> The above setup works fine however as per our secur

Hi, I wanted to ask what is the maximum number of records that can be loaded into the DB using the Load Csv File to Database plug-in?

Hi All - I've created an integration with Docusign and have configured the Web API to receive a response from Docsign when the document is signed. Docusign responds and successfully kicks off the process, but I can't figure out how to pull the envelopeid and documentid from the message response.  I've got the sample code that converts the http!request.body from json to a processparameter. But I can't figure out how to get the data from there? I've tried converting to process variables and various settings within the Start Trigger panel, but haven't been able to see the message body/data anywhere. Any guidance would be appreciated.

I am attempting to set up an Oauth2.0 client credentials grant authentication for our application web APIs. I believe I have done the configuration correctly but I'm clearly missing something because when I attempt to get an authorization token using postman I am a failed client authentication. Here is the sequence of configurations I have performed in order. 1. I created an Oauth2.0 Client in the Admin console creating a new service account in the process. 2. I copied the client_id, client_secret, and access token url. 3. I created a Web API object. For connectivity testing I'm just using the GET Hello World configuration. I added a path value to the web api and copies the URL. 4. I then added the service account to the admin group which secured the new Web API object. 5. In postman I created a new request. I gave it the copied url. 6. Under authorization I selected Oauth2.0 and under configure new token I included the grant_type, client_id, and client_secret (see below image

Hello, to perform a POST type integration in which I want to add a content type multipart/form-data to the body, I have to add the boundary field to the integration header, which I have seen that appian generates in the HTTP Request . That value that is generated in the HTTP Request is --TnQmfygKfP801A_kE1bGL-7YAFk_k6gl9--, and after testing in different environments and files, I have seen that it is always the same. POST /api/myit-sb/content HTTP/1.1 Content-Type: multipart/form-data; boundary=TnQmfygKfP801A_kE1bGL-7YAFk_k6gl9 X-Requested-By: XMLHttpRequest Cache-Control: no-cache Content-Disposition: form-data; name="file"; filename="OP_ATP_DocPrueba.docx" Content-Length: 12354 Host: aena-dev-restapi.onbmc.com Connection: Keep-Alive User-Agent: Appian Accept-Encoding: gzip,deflate --TnQmfygKfP801A_kE1bGL-7YAFk_k6gl9 Content-Disposition: form-data; name="file"; filename="OP_Test_DocPrueba.docx" Content-Type: application/vnd.openxmlformats-officedocument.wordprocessingml.document Con

HI TEAM, I am trying to save the signed documents post DocuSign by creating a web API to start a process model to save the documents but I couldn't get the response from APi. What are configurations need to be done in DocuSign admin application for making it success. If anyone had experience in realtime implementation of DocuSign please help me in resolving. Thank you 

Good morning,  I can upload documents and list with the system logged in, but I am having trouble seeing if I can modify the metadata of a document, as I get the following error: The construction of the request is done by Appian and I can't change the one it uses (Path) to the one it tells me (Url). Does anyone know how I can do it or what I am doing wrong? Thank you very much for your help