Discussion Categories

Hi All ,  I have values stored in database in a particular field i.e. say previousValues, like below  "{"name":"xyz","regDate":"2012-07-01","regStatus":"Completed"}"  --   (Text) Now my requirement is to fetch regStatus value from this format .  How can I achieve this

We have a n export scheduled to ran daily for billing , when Microsoft has outages and task fail we do not get any alert for the failed export job and we cannot even see event logs. How can we create alert for any failed export or job not received in the billing export container We haven't tried anything as yet , since MIcrosoft Engineers couldn't help us .

Hello Community, Does anyone knows how to read data from a docx file in the same way we can do for PDF files? I read that is possible to convert docx files to pdf and maybe accomplish this, but not sure. Please let me know if you have some ideas how to accomplish this. Thank you

I'm facing two issues:1. Warning is coming in process instance - Some referenced items could not be found. Please check the model and correct any problems.2. Action Complete banner flashes out..

Hi, can anyone help me how to generate web API for API Key authentication? And also how to generate the key and value needed for the API key

I'm trying to connect the UIpath orchestrator in Appian connected system. Eventhough my credentials are correct, its showing invalid credetial URL I tried- platform.uipath.com/[organization name]/[[Logical name]/orchestrator_ https://cloud.uipath.com/[organization name]/[[Logical name]/orchestrator_ https://platform.uipath.com/ https://cloud.uipath.com/ I got the below error for all the URL's i tried

I was trying out this plugin called "Timer Component". It basically provides us with a stopwatch functionality. We can also stop it automatically at some given time interval. I just tried to create a functionality where this plugin can be used to refresh a variable automatically in custom time intervals ( also less than 30 sec). Is it a good way to do it? a!localVariables( local!total: 50, local!bool: false, local!refreshAfter: 5, { stopWatchField( /*label: "Stopwatch Timer",*/ labelPosition: "ABOVE", validations: {}, height: "AUTO", action: "START", size: null, align: null, expiredMessage: null, color: "#FFF", style: null, timerDirection: null, enableReverseTimer: null, reverseTimerColor: null, secondsValue: local!total, secondsSaveInto: { a!save( local!bool, not(local!bool) ), a!save( local!total, local!total-l

Hi, I am getting below cast invalid error for below rule. Please help in resolving this. The same code is working fine in one of our environments but not in another environment. "Expression evaluation error at function a!queryEntity_22r2: Could not cast from Boolean to Data Store Entity. Details: CastInvalidCould not cast from Boolean to Data Store Entity. Details: CastInvalid" a!queryEntity_22r2( entity: cons!RGRACSLBL_ENTITY_NEW_PROJECTS_EVENTS_VIEW, query: a!query( logicalExpression: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: "processId_int", operator: "not null" ), a!queryFilter( field: "isExistingCountry_bool", operator: "=", value: ri!isExistingCountry_bool ) } ), pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1 ) ), fetchTotalCount:true() ).data

Hi, I had a question regarding calling the webApi outside Appian. Is that possible and how can it be done?

Hi All, I came across a question where the environment should get upgraded to latest version. Should we start upgrading the higher environments first and go down to lower environment upgrade or vice-versa, and what will be the impact in both cases. Can someone help in knowing this impact?

Hi, I am trying to use a!writeRecord function in an interface button save into block. Below is my code. Id is a Primary Key and is set as AUTO_INCREMENT in the database table. When I set the id as 0, it doesn't seem to accept the identifier and hence fails. What should I do in order to write a new entry into the table using this function? PS : I am able to update the record and the corresponding row in the DB with an existing identifier.

Hi, I would like to send error details to an email DL when there is an issue with process model functionality. The below option is allowing me to create a reference to an Appian group and specify at this place. But, I would like to provide an email DL so that all the people who are the part of the email DL should receive the email with error details.

Hi, I have a big user interface form where I am using multiple controls. Now when I try to submit a form data by clicking "Submit" button it is taking few seconds to complete the submission and it between it is allowing use to click on different form elements and it is creating an issue. So, when the user clicks on the "Submit" button, I would like to show a rotate/progress bar so that user can't click on any other elements of the form. Is this possible in Appian 22.4? Can someone advise please. Thanks in advance.

I need get a document from the external cloud source and need to do data extraction using IDP process model and convert the data into the CSV file and source the file in another external cloud folder can it be done in IDP  or RPA ? if yes how to do that. 

Hi Experts, I have a requirement where I need to store 100 phone numbers in a given field, i.e Targets for now. And then to filter the data on all the columns considering if user searches with 555 then 2nd record should be returned Currently I was using a single table with structure as shown below TargetID (num) OrderID (num) Targets(varchar) 1 1 +91-9999999999+91-9999999999+91-8888888888 2 1 +91-9999999999+91-9999999999+91-8888888888+91-5555555555 Now, due to some performance issues, we need to get that targets column to be moved to a separate table and store all the phone numbers as a separate row, as shown in below tables TargetID OrderID 1 1 2 1 id TargetID Targets 1 1 +91-9999999999 2 1 +91-9999999999 3 1 +91-8888888888 4 2 +91-9999999999 5 2 +91-9999999999 6 2 +91-8888888888 7 2 +91-5555555555 Kindly suggest as how this can be implement, do we need to use nested CDT or if there is any other way possible. Thanks, Gaurav Singh

Hi, is it possible to receive multiple messages on one Receive Message Event? I need to use Receive Message Event to stop the process flow until all the fields of multiple entities are populated, so I have a Send Message Event on each asynch subprocess that sends a message to my main one that the fields have been populated. There is also an Expression Condition on Receive Message Event that checks if all entities have populated values. If it's possible to receive multiple messages, does the condition get validated each time it receives a message? Thanks!

Hello,As the title says, I'm trying to extract data from a table using Appian RPA, and then apply some transformation to that data, and save it to a variable also in the RPA.The data is being fetched correclty, and the transformation "tested independently" is also working, but when trying to combine them, it doesn't work, as no data is being written to the final variable.Can anyone help me please?Thank you in advance!

Hello,I'm trying to create an RPA that fetches data from a table from a system and then do operations on that data.I'm able to fetch the table data, and I have a section with a expression rule that does the correct parsing on that data, but I'm not able to use them in junction.I'm trying to pass the data like this (the value is not empty), but the value being passed is always empty, according to logs.Anyone can help me with what I'm doing wrong?

Hi, I have text field in an interface and I need to trim the Leading and trailing spaces for the value if there any. So I have used trim() as in below code. I tested by giving some sample text with leading and trailing spaces, trim() has removed all the trailing and leading spaces in the interface. But when I checked the CDT to see how it stored, the spaces are still there and it is carrying forward the same value to next screens also. Can anyone please help me in resolving this.    a!textField( label: "Bundled Submission Description", labelPosition: "ADJACENT", value: trim(ri!bundle.submissionDesc_txt), saveInto: ri!bundle.submissionDesc_txt, required: true, validations: rule!RGRACSLBL_FN_getTextLengthValidationMessage( input_txt: index( ri!bundle, "submissionDesc_txt", {

Hi, We have a requirement to generate a document which contains some information of a user that needs to be encoded by the guidelines provided. We need to format the value in such a way that it's length remains fixed always which is provided to us. So any value which has less digits than the required number of digits should be formatted like for eg: If the input is 1250000 and the max limit is 20, then it should be encoded as 00000000000001250000. How can we do that, thanks in advance.

We have integrated the automated rule testing to our CI/CD pipeline. We are using a!startRuleTestsApplications to start the test. We notice on an average the entire test takes under 15 mins to complete, but on occasions the test takes a long time and we ultimately have to kill the build.  Want to know how I can debug this. Unable to find anything in the tomcat logs. Is there any debug log I can enable to check where the test execution is stuck?

Hi I am just looking for the horizontal scrolling in Appian. Is there any kind of components to achieve this kind of scrolling just like the Trello boards  horizontal scrolling, Or may be in feature we can solve this type of scrolling use cases.

Appian documentation at - https://docs.appian.com/suite/help/22.4/records-data-sync.html#smart-services-that-automatically-sync-data mentions following Data sync will automatically sync any data changed by select smart services. I have the following database record type with the sync enabled. I am writing new record to DB using write to DSE smart-service. The record gets created into DB table, however the record list does not get refreshed. I have to do full-sync manually to retrieve the newly added record. Am I missing something?

Hi All, If you are going to create a New Record type and select 'I want to start from scratch' then there is only the option to proceed with the Maria Database, is this correct and your experience too, or do we miss anything?

Should the conf.data.search-server.restclient.apiKey be the same on all nodes/servers in a distributed installation?