Discussion Categories

I have a WEB API that starts a process with a start form and writes data to the record using the 'Write Records' smart service. When i test the WEB API, I get the following error. The Write Record configuration looks like this.

Can I import CSV files with Appian without using any sort of plugin?I know that there are plugins that allow for this, but I'm in an Appian cloud environment and plugins are not always capable/available. What I need to do is allow the end user to import any one of six different CSV files all with different headers and data.Based on the data in the files I need to do different calculations.I have no problems running queries against the data after it's been imported.  If this is possible without a plugin, can you point me in the direction of documentation/tutorials to help me out with this? Thanks,pete

I have a doubt that, If two CDT's are created for the same table(TCDT without new column and  previous cdt  with new column) and how can we  write to the db that CDT which is new cdt data and moved from existing table and taking primary key as a output  and writing it to db? I am doing this Bcoz having a issue with the new column added to the table which is required. Thanks in Advance.

Hi Everyone ,  I need to convert Appian document to base64 . How can i achieve this .  thanks in Advance

Hi All, I need to call record type summary interface(configured in views and headers in record) from button widget. How to achieve this? thanks!

Hi, I'm using the WebField element to display videos uploaded to Appian. This works, but there's a problem: it's impossible to move from one point of the video to the other. In other words, clicking on the progress bar of the video does absolutely nothing. Tried using the Advanced Video Player, and the same problem occurs. While testing the example of the documentation, this functionality works, so I don't know if there's something I'm not getting right. https://docs.appian.com/suite/help/22.2/Video_Component.html Maybe this functionality doesn't exist when the videos are from within Appian? My code is: a!videoField( label: "Vídeo", labelPosition: "ABOVE", videos: { a!webVideo( source: document(ri!document, "url") ) } )

Hi,  I have folder Name... i want to know, In that name there is a folder exists or not... please Suggest.. Thank You. 

Hi, I tried to log in to the Appian designer page but got below the attached page.

Hi all, need some help with the user's configuration. Is it possible enable by defaultthe user's accessibility option? I mean before to create it. Thanks for reading

I am trying to upload an excel file to my application and then use this file as a data source for Tableau Dashboard. Problem I am facing here is that Tableau cannot access the file which I have uploaded on Appian folders. I am open to all kinds of suggestions for this, I just need to use the data from this uploaded excel file in Tableau as the datasource. further I will be displaying this Tableau Dashboard in my Interface using Web Content Component.

HI , In my usecase, i have to open the interface form and upload a excel file to load data in editable grid. Then on pressing submit button the flow goes to Process model where doing some business logic inserting that data to db tbl. I am able to display data in form after uploading and reading it from excel the problem is updating rule input cdt which is having blank values as not able to set the values read from excel to ruleinput. . Flow as of now PM--> Interface form--> PM  --> Same Interface form (User to view and edit data if needed the submit)-

Hi everyone, apologise if this question has been asked before as I couldn't find the it anywhere :) I want to update date time value of 2 columns (createdDateTime and updatedDateTime)  in my data table by using Write To Data Store Entity.  I already have a CDT that has primary key matching with my data table. For configuring Write to Data Store smart service node, I want to config this node to update the 2 columns (createdDateTime = pv!createdDateTime  and updatedDateTime = pv!updatedDateTime) where Id (primary key column) = pv!id. How do I achieve that? Thank you! P/s:  I tried Execute Store Procedure smart service but not sure why it updated only 1 column with my input date time, but the other column was not updated, and I couldn't find the reason for that. That's why I tried to change to Write To Data Store Entity to see if this works

Hi, everyone I am trying to build Maven project with Eclipse. However, I am getting an error. Eclipse says that downloading org.apache.maven.plugins:maven-deploy-plugin:2.7 is failedbecause it is impossible to access www.novayre.es/.../1.0-SNAPSHOT According to what I found, the URL has been gone or its domain has been changed. Could you tell me how to solve it? Finally, I share log message Eclipse output.--------------------------------------------------[[1;34mINFO[m] Scanning for projects...[[1;34mINFO[m] [[1;34mINFO[m] [1m-----------< [0;36mcom.novayre.jidoka.tutorial:robot-development[0;1m >------------[m[[1;34mINFO[m] [1mBuilding robot-development-Dversion=0.0.1 Jidoka Robot 1.0-SNAPSHOT[m[[1;34mINFO[m] [1m--------------------------------[ jar ]---------------------------------[m[[1;34mINFO[m] [[1;34mINFO[m] [1m--- [0;32mmaven-clean-plugin:2.5:clean[m [1m(default-clean)[m @ [36mrobot-development[0;1m ---[m[[1;34mINFO[m] Deleting C:\AppianRPA\AppianRPARbot-CustomJavaCode\robo

Hi, We have installed SAP JCo (Java Connector) on Appian Cloud Server, to call SAP BAPI using Sap Invoke functions provided by Appian. We are consistently facing cache issues in our environment where the BAPI configurations and credentials used with SapInvoke function does not get refreshed. Due to which we are not able to fetch updated data in proper structure. This generally happens when an existing BAPI configuration gets changed or modified at SAP end. As per our understanding of SAP JCo, it caches metadata to improve the throughput of the application. However, please note that if any changes are made to the BAPI structure in SAP, the old version will still be cached until the cache is refreshed via a server restart. We were able to find a Knowledge Base Article - KB1232 to clear the cache, but our understanding is that it is targeted for on-premise servers. I would like to know if there any other effective method that we can take to handle this cache issue, other th

Is there anyway can we show all the currently logged in users in the interface

Hi, I have a read-only grid and loading the data using a recordType. I am trying to implement "delete" functionality to delete each row of data/db record by having "Delete" in each row. I am trying to implement by using a Related Actions. But, when I click on "DELETE" it is opening a popup (DIALOG BOX) and closing automatically. Is there a way I can avoid popup window which is not useful in this scenario.  Thanks

Below is the code in which when we want to select option "Four" then we have to press "F" twice. a!localVariables( local!options : {"One","Two","Three","Four","Five"}, local!selectedValue, { a!dropdownField( label: "Dropdown", labelPosition: "ABOVE", placeholder: "--- Select a Value ---", choiceLabels: local!options, choiceValues: local!options, value:local!selectedValue, saveInto: local!selectedValue, searchDisplay: "OFF", validations: {} ) } ) When we press "F" first time the options opens. And when we press "F" second time only then the value "Four" is selected. However, it was not the same behavior in previous versions. Can you help me achieve the same functionality/behavior with version 22.4 ?

I researched and checked theres known issues for a!update so I was hoping that someone may have solutions for this particular scenario.The output for the following code just returns a 4 instead of 4 Current a!update( remove( {1,2,3,4,5,6,7}, remove( enumerate(0,1,2,3), 1 ) ), 1, ri!application.projectYears & " Current" )

I am setting up Maven.As part of that, I excute Maven commands "mvn package -Pjidoka-repo". However,I am getting an error below.-------------------------------------Non-resolvable parent POM for com.novayre.jidoka.tutorial:robot-developmentguide-first-robot:4.0.0: com.novayre.jidoka.robot:jidoka-robot-parent:pom:4.0.0 was not found in mnvk.appian.community/.../repo during a previous attempt. This failure was cached in the local repository and resolution is not reattempted until the update interval of SERVER_ID has elapsed or updates are forced and 'parent.relativePath' points at wrong local POM @ line 10, column 10 ->------------------------------------ Could you tell me how to solve it?

can we save xls file which we are getting from fileupload interface component to our local PC drive? can we do it without any process model ? if process model is required then how we can do it?

Hi, I have a "DELETE" button in an interface where I have a readonly grid and the grid is loading the data using a RecordType. Now, when the user selects multiple rows of data, I am calling "deleteFromDataStoreEntitites" and passing required parameters and in the background data is getting deleted. But, the issue, the deleted row data is still showing in the readonly grid. Is there any way, I can do page reload or grid load to call after "Delete" button click.

I have my own data or CDT called "Clients" and i have a relationship with other CDT called "Vendor" I have this editable grid created with the CDT called "Clients" (red square image bellow) this works great. Now i want add the related data or relationship of the CDT called "Vendor" (blue square image bellow) into the editable grid  Its possible? How do I call that data?, what expression should I use? Here is my relationships between my data 

Is there a way to sort a record dataset after it's been queried? I have a list of records I got from a queryRecordType stored in a local variable that I am using in multiple places on an interface. I only want the record dataset to be sorted in a particular way for only one instance on the interface, but I want to leave it alone in all other instances, so I don't want to sort the data set within the initial queryRecordType call in the local variable. The only solution I've thought of is query the record again but this time sort it the way I want and store it in a new local variable or write my own expression rule to be able to sort records. I am not allowed to install plug-ins on my environment by the way. Thanks!

Team, We have  HTML output and we want to convert that output to pdf for showing the same in UI via document viewer component. Any idea how to ? Please Note: i have html output not html document.

Hi, I am trying to populate the data in a read only grid using Record Type. I have enabled Search, Refresh and export to excel options. Not, I am try to implement DELETE record List Action where user will select multiple check boxes on the grid and click on "DELETE". Is there any option to move and align the "DELETE" beside to Filter or refresh icons.