Integrations

We are trying to connect to a hive DB via a Rest API hosted in Openshift cluster, the .pem for the hosted environment have been imported to Appian environment via Client certificate and trusted certificate Still we are unable to establish the connectivity to the Hive DB due to SSL connectivity error. We have created certs for the Rest API hosted environment and imported the same to Appian , but still Appian is unable to establish the connectivity via Rest API call. Appian version used : 21.4 When trying to connect to the given host ip via openssl s_client -showcerts -connect <ipaddress> following was observed CONNECTED(00000003)write:errno=104---no peer certificate available---No client certificate CA names sent---SSL handshake has read 0 bytes and written 0 bytes--- Can we know why Appian is unable to connect to Rest api and what certs are needed for Appian to trust the cluster in which this Rest API is hosted?

Hello, is it possible to listen to an email address? Maybe something like, whenever there is an email with a certain subject then do something.

Hi All,Getting the below error while calling integration.Thank You.

Hi everyone,I am new into appian I am trying to use Integration object. I am using this url https://icanhazdadjoke.com/ for generating random jokes but it is giving me this error cn you please help me to resolve it

Hello , I am trying to use the uipath connector to connect to my onpremise uipath orchestrator. When I enter the data I get this error and I do not know the reason. Can someone help me ?

Hello, I am trying to use the Call Web Service smart service in a process, but I have the problem that the WSDL URL is too long and I am unable to insert it in the field completly. I am trying to use the dynamic WSDL URL but it retrieves an error. Any idea? Thank you

Hello,Looking for some help in configuring MQ in Appian 20.4.Here are the details that we configure in apache-tomcat server's suite.xml file. <Resource name="jms/MyQCF" auth="Container" type="com.ibm.mq.jms.MQQueueConnectionFactory" factory="com.ibm.mq.connector.outbound.ManagedConnectionFactoryImpl" description="JMS Queue Connection Factory for sending messages" HOST="myMQserver" PORT="1414" CHAN="myChannel" SCPHS="mySSLcertName" TRAN="CLIENT"/> <Resource name="jms/WriteQueue" auth="Container" type="com.ibm.mq.jms.MQQueue" factory="com.ibm.mq.connector.outbound.MQQueueProxy" description="JMS Queue for receiving messages from Dialog" QU="myQueueName"/> <Resource name="jms/ReadQueue" auth="Container" type="com.ibm.mq.jms.MQQueue" factory="com.ibm.mq.connector.outbound.MQQ

Hello guys, I have a page html and I want call web api appian, but retrivied this error: can you help me? thanks

How to retrieve the sign document back to the appian

I have created a Connected System that uses OpenAPI.  I then created an Integration that uses the OpenAPI CS to call a User Authentication API that returns a service token.  That token is then used to authenticate  other APIs that are available for the application.  Every API must have the token referenced in the header in order to authenticate.  I am trying to create an Expression Rule that can be used as a wrapper to call the User Authentication API and return the token.  I would like to use this rule as the Header value when creating additional integrations for the other APIs so that the authentication can occur every time the integration is called.  When I test the expression rule, I get an error that reads: "The jsonText parameter must not be null or empty." Here is a screen shot of the Integration, which works when I manually insert a valid bearer token: Here is the expression rule that fails: It seems like the API is

Hi all,What is the best way to reduce Intergration's execution time.  Time 4,153 ms Prepare: < 1 ms - Execute: 4,152 ms (Send|Wait|Receive: 3,925 ms) - Transform: 1 ms Thanks

Good day,I have some APIs that do operations over the resource 'User', and the following ones are needed: GET users - To retrieve them POST users - To create them PATCH users - To update them PATCH users/disable - To disable them PATCH users/enable - To enable them The problem is that I can only have one combination of endpoint vs method, so when I try to declare the second PATCH user API to specify the path to "disable" or "enable" I receive and error.My question is: what's the Appian way for doing those APIs declarations using the Restful pattern?Create only one web API object switching between each different path?Let the endpoint be empty, and put all the URI in the path field?Other options...Thanks for the help in advance

Hello Team, We have a WebAPI that needs to be accessed from external system with Oauth 2.0 authorization. For this we setup Web API Authentication in Admin Console and got the Service account, Client ID, Client Secret, and Token request end point.  When setting up in Postman to test this out, not sure about what to use for the Callback URL and Auth URL - see attached.  [View:/cfs-file/__key/communityserver-discussions-components-files/18/PostmanSetup.pdf:320:240] Any pointers how this can be setup properly to test the WebAPI call from Postman? Appreciate in advance. Mahesh 

hi I was able to make the connection between google sheets and appian, using the google sheets connected system (vuram)... i want to store the data of my appian cloud database to a  google sheets, is it possible? this is the integration that i have creates, connection successfully

I have created an integration s shown below: I am able to run this integration when values are null however, it is giving the below error when I give any values: sample request body with values: { "range": "Sheet1!A2:B2", "majorDimension": "ROWS", "values": { {"ABC"} }} Error:  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

Hello, We need to get message from Blue Prism integration after integration call is successful.  When we call integration directly in integration object we get response in raw response like this: "<soap:Envelope xmlns:soap='schemas.xmlsoap.org/.../' xmlns:xsi='www.w3.org/.../XMLSchema-instance' xmlns:xs='www.w3.org/.../XMLSchema' xmlns:soapenc='schemas.xmlsoap.org/.../'><soap:Body><Message xsi:type='xs:string'>Successfully completed process</Message></soap:Body></soap:Envelope>"   But, when we call integration using call integration smart service in process model and try to save response we get empty result: [] saved in process variable.  Is there a way to get the raw http body while calling the integration smart service so I can parse it manually?

How to get the signed document sent using send document for e-signature docu sign back to appian.

Hello Everyone, I am creating a Web API (GET method) and am using a!queryprocessAnalytics to get some values from a report. One of the column in the report is Asignee and the type/Formatting for this column is 'User or Group Name'. When i test the request i am getting a valid result but with either Group Id or username. I want to first know if the value is User or Group then convert it into First Name, Last name for User or Group name for Group. I tried using find("[",cast(3,value),0) to know if the value is user or group but after knowing i am not able to convert the value to First Name, Last name for User or Group name for Group. Please help me to find a solution for this. Thank you

Hi, I am trying to create an Integration object in Appian. How can I make these parameters dynamic based on the environment. I would like to pass different parameters based on the environments like DEV, UAT and PROD. All these environments will have different urls. How can I achieve this.

I am having difficulty utilizing the "Connected System" and connecting to the Appian DB. I have verified we have a Maria DB and that the database name is Appian.  I think I have the server name correct, but not 100% sure. Would the server name be the same as the appian website.... companytest.appiancloud.com:3306? I know it is already available as a Data Type "Topcat" but I am trying to execute a stored procedure on the DB. Thank you

Hi,I've been assigned on creating a dashboard which includes showing all the Logs that are executed in the integration..As we can see.. once put check on the integration object the "Enable HTTP request/response logging for this integration object" and we clicked on test request in the integration, it is saved is the system logs>perflogs> http-request-and-responses As for my task, I need to get details from it and save it in appian DB. For POST method:I've managed to get a workaround on this by going to the PM's that were used to execute post integration and just added "write to datastore" in the flow for storing it in the DB. For GET method:I can't seem to find a way on when get integration is executed. I've used smart service also like a!startprocess etc. added in the handler of the get method and it just won't work since we cant run smart service on get method.Do you guys have any suggested workaround for getting the Integ

Any integration function there to over come this challenge 

Hi I want to filter my data by the field: "provienceID" (image bellow)  in my integration I create a rule input (number integer) The idea is, when I change the test values in the expression, I test with 1 and the result will be all my data with the "province ID" with value 1. I use this expression in query parameter section, but it doesn't filter by the values that I want, it gives me all the values For example for "province ID" with value 1 must show me just 15 fields a!query( filter: a!queryFilter( field: "provienceID", operator: "=", value: ri!provinceID ), pagingInfo: a!pagingInfo(1,-1) )

Trying to read the emails from Gmail account using "IMAP", but found no solution.

Hello everyone We use the Appian(on premise version) and want to connect with MYSQL.I think we can use user id and PW to make it work ,but it means we need to store this sensitive info in our service(GCP) and someone can get by check the detailin < configure.bat >..file. So I want to know whether we can use the service account for database security authentication to connect with the DB or not ?