Integrations

I searched Appian documentation to see if Appian has any capabilities with directly reading .MPP (Microsoft Project) files (local files) but didn't see any OOTB options. Has anyone had a use case/solution leveraging (ingesting) data from Microsoft Project? If not, I assume we would need to extract the Microsoft Project data (multiple files at a given interview)  to excel (or another file format) in order to ingest the data. Thanks in advance for any help/insights!!

Good morning, For customer needs, we need to remove the Appian login and that is from the client itself where this access to the site is controlled. Is it possible?What would be the steps? Thank you very muchAlex

Hello All, We have implemented OKTA. As a part of which we have created a connected system, that handles the user token authorization and allows user to perform operations based on valid tokens. We don't have any controls overs the token recieved as those are stored with appian and it gets expired after every 24 hours. Hence, we have to provide some way for users to regenerate their access token. To achieve this we are making a call to a specific table at the start of process model and if it gives 401 or 403 as a status code in response, We are showing a link in the interface saying "Your access token is expired" and giving them a link which they can click and regenerate the token. We have used a!authorizationLink() function for the same. Now the problem is that this function doesn't have any saveinto parameters inside it. Due to that its not possible for us to get to know whether user has refreshed their token or not. This information is necessary because we wa

I'm having this issue When i try to call a process model from a record view but when i open the process model i have no issues and when i open the interface everything normal i just have the issue when i call it through the record view  i try to get into the monitoring view but   the process model does not  appear   as excecuted  Screenshots below     

Hello there, I am doing a Timestamp app for employees to clock in & Out. but I want also the app to get the actual location of the employee. I have the api for it , but I do not why I am getting only the Appian server location. How I can get the actual location of the employee? 

I am trying to use this plugin but I am getting the folowing error: javax.xml.ws.WebServiceException: java.lang.ClassCastException: com.sun.xml.ws.message.saaj.SAAJHeader cannot be cast to com.sun.xml.ws.security.opt.impl.outgoing.SecurityHeader Any idea why this would be? Thanks for any insight.

I have button click in appian UI which i need to use for consuming API from APIGEE layer. This is the two APIs we need to integrate https://it.api-dev.honeywell.com/v1/premiumFreight/appian/validateRequest for authorization and access token link is https://it.api-dev.honeywell.com/v2/oauth/accesstoken And input json i have added in the insert code I have and API url and access token to pass it to the headers of the api .Can anyone help us to know how to do this integration?{"row":{ "orderDelNumber":"8105050724", "orderDelItemNumber":"", "PO_SO_STO_INDEL_OUTDEL":"OD", "Source_System":"BID" } } Thanks Sunu Sam

Hi All,  I'm trying to pass JSON object in the startprocess but some how I'm not able to send all the attributes at one go  Here is the sample JSON I'm passing  {"CompanyName": "Company","Category": "Information Technology","SubCategory": "COnsulting","Definition": "On Call","ShipToState": "AK","invoiceDetails": [{"InvoiceNumber": "3425638769","InvoiceDate": "1/28/2022","InvoiceValue": "400.00$","InvoiceDueDate": "2/22/2022","InvoiceBalance": "300.00$" },"InvoiceNumber": "3425638769","InvoiceDate": "1/28/2022","InvoiceValue": "400.00$","InvoiceDueDate": "2/22/2022","InvoiceBalance": "300.00$" ]} In the above JSON I was able to get all the individual attributes into the process model except the  Invoice details Any help is much appreciated  Thanks  

I am recieving the following error trying to connect to OpenText "Failed to connect to the external system [key=opentext]. The site-wide credentials may be incorrect. Please ask an administrator to update the credentials in the Third-Party Credentials page in the Administration Console. Connection failure details: Unexpected document! Received: HTML document"

Hello Appian Community, We are facing an issue where Appian is generating a JSON message to an external system and the external system is sending Appian back a large JSON file that has XML in an element of the JSON returned. This XML doc can exceed 5MB because of Base64 string docs stored within the XML. Appian will need to parse the XML out of the JSON response and send that on to a separate system. The issue we are seeing is the response exceeds 5MB so we cannot have the "Return raw response body" set as the Response Body Parsing. We cannot use "Convert binary to Appian document" in the Response Body Parsing because we have to parse the response to get the XML from the JSON. We are attempting to use "Convert JSON to Appian value", but when indexing into fv!Response.body.fieldName we see an error thrown "com.appiancorp.suiteapi.content.exceptions.InvalidContentException: Invalid Content ID".  We have tried different extensions for the

How to track and display in the google map 

I am trying to get the location & weather of the user, but I am only getting the location weather  of the Appian Server en Germany, I am using https://api.weatherapi.com/v1/current.json?key&q=auto:ip.  , please any help?

I've created a HTTP connected system by passing all the required parameters(sample values) as shown in Fig. But when I export this object and download the customization file, it does not specify SCOPE attribute at all.  Anyone has any idea, why Appian is not adding this attribute to customization file ?    Then how can we maintain this in all environments ( Each environment SCOPE attribute is different) without manual update.

Hi Folks. I want to retain the same file name while fetching details from integration. Please note contentBytes stores the document fetched. But I'm getting below error: Request your suggestion on how can I achieve this in keeping the same file name as passed.

Hi Everyone, I'm trying to invoke MS Graph REST API to fetch email with attachment and that the attachment in response body location is fetched correctly but When specifying fv!result.body.value.name in 'Name', we get error as shown above. Does it accept only static names?  As our requirement is to retain the same name of the attatchment as fetched. Need your suggestions on the above query.

Hi Everyone, Is there a way where appian can fetch the password of the loggedInUser. If possible, please suggest an approach

Hello All, We have Appian setup on premises and want to expose & reuse processes to new Appian mobile app. Is there any way to embed on-premises processes/interfaces in Appian mobile app?  Thanks, Bhushan

Hi, in our system,  we have a functionality to create a document from an url of Reporting Service. We use the following smart service: In Input Body, we use the function httpgetbinary() (from plugin Web And XML Extensions), where endpoint is the url of Reporting Service that generate the document. However, the plugin doesn't exist anymore and Appian suggests to use Integration Object to substitute it. However, when we try to use it, we receive the following error:   So, we find Microsoft SSRS Document Integration Plugin, but there isn't no documentation about this plugin and we don't know the value of input Device Info. Could you help me to understand what kind of value it's necessary to insert? Or Is there another way to get a document from Reporting Service with NTLM Authentication? Thanks in advacne. Regards, Juri Monti

I'm trying to  connect to a system that  requires oauth 2.0  but  i want client credential in order to just connect with one global account for all the user to retrieve  the information. the site that I'm trying to access doesn't allow "oauth 2.0: client credential grant", right now only   the   "oauth 2.0: authorization  code grant "   is available. The way that quickbooks works is:   Step 1: the  site  can give me an access token and a  refresh token for  like a hundred  days  that's  why i'm trying to figure out  a  way to pass this tokens through the integration is there any way to do it ?.  

Want to know the best approach for E-sign functionality (Like username and passwords should be in each and every task before submit button ).  

let me explain myself  i want to  use an oauth authentication token  globally for all the users that log into my  appian site and let them post and edit   information  using just that one  token 

I've got a sort of weird problem that I can't figure out. I have a webAPI built that kicks off a process model for creating new users. When I test it within Appian, I get a JSON response with all the info about the process model. { "pp" : { "id" : 268442112, "name" : "Create User Bob Newman", "priority" : 1, "initiator" : { "id" : "******" }, "startTime" : "2022-01-06T18:04:14.980Z", "timeZone" : "US/Eastern", "starred" : false, "parentName" : "", "execId" : 1, "status" : 0 }, "pm" : { "id" : 5238, "uuid" : "0005e780-67c2-8000-2559-7f0000014e7a", "name" : "PP Web API User Generation", "description" : "Create a new user with a web API", "version" : "16.0", "creator" : { "id" : "*****"

An API I was building required a query of a datastore and to avoid getting a 500 error, I needed to add the service account as a viewer to the datastore. While I don't particularly care about access to the entity that is getting queried, there are other entities within the datastore that I would rather not have potential external access. My question is, is there a danger of accessing other entities within a datastore through that service account somehow? Would it be safer to create a separate datastore for the service account that only contains the entity that it needs to access? Or would it not make a difference either way and I'm just being paranoid? 

Hi Team, We started to create a new Database schema using the Connected systems concept introduced in 21.3 However we have to use the Execute Store Procedures we need to provide the Data source Name : For example like jdbc/Appian Like this i am unable to find out the Data source/JNDI Name for the Seperate schema which is created. Could someone help me out with the datasource name of my schema created. For Example the Data source Name / Schema name created in the DB is SchemaOne.

Hello Appian practitioners,  Following the notes from this discussion, I tried creating a WEB-API to load a locally available WSDL within the 'Call Web Service' smart service. My web-api returns the following httpResponse a!httpResponse( /* * Set an HTTP header that tells the client that the body of the response * will be a CSV attachment. */ headers: { a!httpHeader( name: "Content-Disposition", value: "attachment; filename=" & char(34) & local!username & ".xml" & char(34) ) }, /* * Create a CSV value of 'local!user' and place it in the response body. */ body: rule!TS_test_ProfileXML() /* XML Contents */ ) However, the call web-service is still not able to detect the WSDL.  Appreciate all your help!