Discussion Categories

when I run the functon a!fromJson(). It gives the error Error:== The JsonText parameter does must not be null or empty what should i do

We need to dump ~30 MB Excel data into DB and we are using Import Excel to Database (Plugin to extract data from file to DB) with batch size=5000(parameter in plugin) While doing this process, heap size is reaching threshold (4 GB) and causing the environment down. Is there any way to dump this data into DB via Appian without increasing the Heap size. We need to do via Appian as User has to upload the excel via Common User interface.

 How to Download data to an Excel where a view has more than 150 columns?

We have purchased the Full Calendar with Event Scheduling plug in from the Appmarket but are unfamiliar with how to get it installed on our cloud instances.  We reached out to Appian support and they informed us that: It's possible that the functionality offered by Vuram includes some additional installations or scripting, but in terms of what would be expected from Appian Support in order to install a plug-in on the server I see the offering (Assuming it is this: community.appian.com/.../full-calendar-with-event-scheduling or this: community.appian.com/.../full-calendar-with-event-scheduling-12-week-view) is a component plug-in, so we would expect a file named something like "full-calendar-with-event-scheduling-2.0.2.zip-signed" Has anyone installed this or similar plugin that might be able to provide some guidance.  The zip file from the plugin web site contains several folders that contain java script files. Thank you

i am getting data from external system which is being displayed on UI(example: 2342;34324;3441), i want to export this data by clicking on button in the form of CSV. please suggest the right steps. Thanks in advance.

Hi Team, i created a process Report for a user that displays processes initiated by him. now i want to display some charts using that reports. but the chart fields are accepting record types.is there any method that we can us the process report data into charts to visualize them graphically Thank you  J Vinay 

We have configured a service backed record with full sync configured. We also have a use case of syncing the changed records after the put call of that service is successful. In the put call process model, we have used Sync Record smart service and have passed the identifier into the node. Our sync expression uses token as an authentication to the service. This configuration works smoothly in dev environment. After deploying the code to QA environment using a Deployment Admin account , our sync record smart service is failing. The error is of failed authentication. (To cross verify, we passed the same identifier to sync expression manually and it returns the row) The Deployment Admin does not have a valid token to successfully call the integration. To resolve that we have configured the smart service node to run as whoever started the process. Even then the sync is giving error of authentication. We checked in System logs and even there we didnt find any additional information apa

Hi All, I tried to use a!queryrecordtype to query a process backed record and am getting result. When i tried to put ".data", am getting below error. Any idea on this error? Thanks in advance

https://docs.appian.com/suite/help/21.2/configure-record-data-source.html#use-a-web-service-with-sync-enabled Above information says we can change but not able to understand the place where should i make the change?I am using Other Web Service as Record Data Source and using integration to pull data.I tried Limit in Query Parameters it didn't work.Any Suggestions?

Hi everyone, i've created a series of post and get api web into my dev environment application and they're still working. When i've exported the application and inported in the test environment the api key and the same associate service account are still present, but when i change the url in the prompt request to activate the api web it doesn't work, give me the error "autentification fail, check out the credential and try it", but the credential are the same. In the dev environment there's no problem. Why is this happen?  Thank you all

I've configured User Input Task in a process where I've used an Interface in which I'm using StartProcess smart service to invoke a process, Please find the code snippet below: a!buttonWidget( label: "Approve1", saveInto: { a!startProcess( processModel: cons!PA_ProcessConstant(), processParameters: { currentWorkstep: local!currentWorkstep, temp: "Test Param", workCount: local!workstepCount, worksteps: local!worksteps }, onSuccess: a!save( local!outPut, "Process started successfully" ), onError: a!save(local!outPut, "Process failed to start") ) }, submit: true, style: "PRIMARY", showWhen: { if(ri!workstepcount = 0, false, true) } ) The above code is resulting in the error as shown below:  If I will comment the saveInto parameter of buttonWidget from the above code snippet the interface works fine. Please let me know If there is any issue in the code.

Hi Champs, I have a Use case where user need to be authenticated with a onetime password provided to their mobile number. How can I achieve this? Regards, Ghanashyam

Hi everyone, I would like to use the "write to record type" activity in a process model to be able to update the fields of a record. I set up the process as follows with the following variables and settings for the write node, but it always gives me the same error (attached in the figure). How to configure this node correctly? Additional question: If you write to the record like this, do you also update the underlying data model table that the record is based on? Thanks all in advance.

Hi, I'm facing an issue when using Rich Text Editor Component plugin, sometimes it works fine, but sometimes it will not work and check the Network, there is 403 response for below request. But after I clear chrome cache, the issue will be fixed. Is there anyone have the experience about this? appiancloud-dynamic.com/suite/rest/a/content/latest/webcontent/richTextField/index.html?locale=en-US&accent=%231d659c

How do you change the dimensions of multiple dropdown field?

Hi, I have a summary screen which has list of columns that I generated using a Record Type list and not through an interface. How do I put a checkbox using a grid column? I found this link which talks about the delete functionality but not sure where do I enter this code as I am not able to access the expression editor to the entire summary screen instead I only see individual grid column expression editor. docs.appian.com/.../recipe-delete-rows-in-a-grid.html Basically I want to implement delete functionality by selecting each row using checkbox and delete them.  Appreciate any help and advance thanks!! Suneetha.

Hi all, Does someone has any clue why the "Show Objects" button, located on the bottom right corner, isn't working in some specific page? We've a lot of different interfaces/pages and, on some of them, the button doesn't show the highlighted objects in pink color.

I have a gridField where one of the gridColumn is displaying an icon for its value (icon is displayed as a richTextIcon in a richTextDisplayField). In this column, it can either have the icon or not (null). How would I go about configuring the sortField for these values since they're not necessarily field values. I would like to sort so all rows with the icon are at top (or bottom). Thanks

Hi,  Is there any way to prevent column widths from shrinking to fit the page? I am looking to force a horizontal scroll. Specifically, without using a grid. I need to display cards within each column that have multiple components within them. I've tried prevent wrapping, no luck with that. I can't leave any more comments for at least 2 hours. Are there any layout components that support horizontal scrolling?

Load CSV file to database gives error "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=' at line 1" I am using same CSV file that was exported using export db to CSV have gone through all the discussions so far on the community we are using on-premise mysql DB so using this smart service rather than import CSV to DB which was also giving error anyway. will attach excel file I am trying to import: date is in proper format:'yyyy-MM-dd hh:mm:ss' since that was earlier error Anyone faced similar issue or knows the cause please help

Hi All,When I run the process, I am getting the error in "Send Email" node. Error Details - "index (Data Inputs)".Assignment of the node, it is set as run whoever started the process.Please suggest if anyone had an idea about this.Thankyou in advance!

Hi Guys, I want to identify for each status ( "Not Active", "Active", "Completed", "Cancelled", "Paused", "Paused by Exception" and "Processes with Errors"). I got only one paused by exception status Id is 8. The same way need all the status id. Please share your details. Thanks, Pradeep Sridharan

I have an interface with a grid, in which first columns is an ID, and you can click on one of the ids to go to another interface with specific details for that ID. Right now that link works with a process, but I need to change it so it does not trigger any process, I want it to open the interface with the details for the selected ID without going through a PM.How can I do that? Thanks you!

Hi, I am trying to implement a Box integration using JWT Authentication. I have set up the entire integration however while trying to generate the access token it is giving an error. Can anyone help how to fix the issue? Thanks in advance!

HI I am fetching data from appian report. I have applied filter also so it won't fetch all the data everytime. but for the very first time it has to fetch everything  from the reocrd and then store in database. Now just to be on safer side I want to fetch the data in batches and then want to consume it.I am doing it with the following way a!localVariables( local!latestDate: cast( typeof(now()), index( rule!MO_GetLatestAuditDetails().data , "endTime" , now()-60) ), local!processModelUuids: rule!MO_GetAllProcessModels().processModelUuid, local!totalCount: index( rule!NEW_MO_ExtractProcessMetricsFromPortalReport( batchSize: 1, startIndex: 1, date: local!latestDate, processModelUuids: local!processModelUuids ), "totalCount", 0 ), local!numberOfIterations: = fn!ceiling(local!totalCount / ri!batchSize), local!listOfIntegers: = enumerate(local!numberOfIterations), a!forEach( items: local!listOfIntegers, expression: rule!NEW_MO_ExtractProcessMetricsFromPortal