Integrations

Dear Team, Am getting the following error message while calling a Endpoint from browser, only in one environment we are facing this issue and rest all working fine. Any advise would be helpful. {"resource":"\/suite\/webapi\/invalidWMUrl","error":"APNX-1-4187-000","message":"Authentication failed. Please check your credentials and try again.","title":"An Error Has Occurred"} Thanks, Sunil

How can i get the data from the api into the interface ? like in my scenario i want the movie details once i enter my movie name , and the thing as i had created the intergration using the link and it's working .now i just want to know how can get the values in my interface once i click the movie and submit button.

We have what is effectively an API broker or proxy tool between our Appian instance and an API we consume.  The broker/proxy requires API Authentication to properly identify our system and allow access to the API's that it brokers.  It does not however leverage it's own API keys to the services it represents.  As a result, we have to pass a second API key through as a header.However, I have security concerns about the storage and security of this second key. Has anyone had experience and advice to secure this secondary key?  It appears as clear text in the request headers,  must be available in the integration or connected system (unlike the primary API key - which is masked and unreadable in the Connected System), and I cannot use the secure credential store to secure it.  Even if I store it in a constant,  I'm concerned about the potential security. Advice greatly appreciated.

Hi Everyone , i want to extract pdf file data into database. if any smart service or plug-in is available in appian  ?  like: ( we have importfromXL to XL files ) please suggest the best way to achieve this. Thank you

redirect an link of tempo record to site 

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