Extensibility

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

Hi, We are using Import Excel to Database plugin to import data to Oracle DB. We are facing issue related to the primary key auto generation. We have sequence to autogenerate the primary key. But while using the plugin, we are facing the below error "???ORA-01400: cannot insert NULL into (Table_Name.Primary_Key)???". When we are trying to have a column of primary key with value, its working fine but auto generation of primary key is not happening. Is there any limitation to the plug-in? 

Hi team, can any one please suggest me the steps or any link  to download the  plug-ins of  time line chart and  google chart component in my application and how to show Gantt chart data in interface  i am not understanding from where to start

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     

Hi all, I have a requirement to retrieve the list of applications and display for each user the applications that he can view them. Any ideas ?

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"

Hi  My dataset has multiple entries of working and non-working days in excel. I want to update the working and non-working days in a calendar. I am reading excel file using readexcelsheet paging function and generating calendar process variable by using read calendar method . While iterating the rows in excel as an output it just updates the first row only. How to read all the rows in excel.

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?

We have a requirement to embed excel on the Appian UI and this Online Office Integration Plugin seems to be useful for us. However, we are getting below error   I know this might be a silly question , from where we get WOPI Client URL. If anybody has already implemented this can you please help us here. We are trying to do a short POC so that we can show it , we are using our own office 365 account for testing purpose.

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.

Upon reading or uploading an excel file receiving the following log error 2022-01-20 21:09:00,529 [ajp-nio-0.0.0.0-8009-exec-6] ERROR com.appiancorp.ps.exceltools.expression.ReadExcelFileFunction - Failed to read zip entry sourcejava.io.IOException: Failed to read zip entry source I am uploading a .xlsx file but it is saying failed to read zip entry source. 

Hi All, I am trying to use "Receive a file from RDBMS BLOB" smart service and it is appending zero every time in the file name. Can anyone please help me on this. Any reply is appreciated. Thanks in Advance, Neha Raghuvanshi

Hello, I am using Send File Over SFTP smart service and I'm supposed to place a file in docfiles folder of F drive in the destination remote VM. So I've given the remote file path as "F:/docfiles/sample.pdf"  However File is not being transferred to remote file path and I am receiving No Such File error in Appian though I have sample.pdf available in Appian repository. Any thoughts pls ? Error transferring file to SFTP server2: No such file

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.

I would like to know if we have any replacement or equally functioning Deprecated Export CDT to Excel. I am aware we have Export DSE to Excel but my requirement is to export the local data into Excel and we are not storing data in the table.

Hi, Mail server to database smart service is not working for 21.4 appian update. Its working fine with same configuration for 21.3.  Getting error [Cipher suits are not appropriate] may be the security needs to be updates in java.securities file.