Process Automation

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18}Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

I need to setup an intergration between UiPath and Appian, and have learned that by using the "Appian Activities" utility and "UiPath Connector" plug-in, the connection between the two could be done. Meanwhile, I also notice that when searching related information through Appian Document, UiPath seem to be associated with RWM to some extent. I would like to confirm that whether I need a RWM in order to finish the setup. Does anyone have any idea about how RWM function within the process indicated as the picture above.

I'm currently trying to implement RPA to get the title, URL, etc. of each news from the news list on the news site.My RPA was able to get the information I wanted and store it in an array.However, the information cannot be saved in Appian's DB in table format. I would like to store the contents of the array that holds the acquired information in the pre-created CTD. Since the Appian document states that it is not possible to directly store data from RPA to the DB, I will implement RPA which creates a list of data saved by CDT etc. and returned this list to the process model. If you have better idea, could you tell me about it?

Given a dictionary D , and a list of nodes N, I need to replace all existing nodes in the dictionary which are single value to list of values containing the single one. For example:   D= {foo:"bar",bar:"baz"}, N={"foo"} => {foo:{"bar"} /*converted*/,bar:"baz"/*no change*/}    D={bar:"baz",foo:{"multi","items"},nested:{foo:"bar"}}, N={"foo","bar"} => {bar:{"baz"} /*converted*/,foo:{"multi","items"}/*no change*/ ,nested:{foo:{"bar"} /*converted*/} The use case is to support conversion from XML where certain nodes should be arrays, however when converting from XML to JSON and there is  a single item under those nodes, we need it to be array and not a single object. 

Hello All,  I am seeing below error when I am querying data from database. in the database nonInvoicePayments is defined as Tinyint(4) and in the rule input for this variable is defined as Boolean.   Please suggest me the solution. Error message: expression evaluation error at function a!queryEntity [line 3]: Cannot apply operator [EQUALS] to field [nonInvoicePayments] when comparing to value [TypedValue[it=26,v=1]]. Thanks in advance.

Can we have regexmatch code for this scenario : I have   4 digits in text format but last  2 digits should be fixed EX:"XX30" here "30" is fixed "XX" can be any numbers in text format

Hi, Any idea how to find the third largest value using a!queryentity?

I am facing an issue with my RPA code. I have automated a process for data entry into an internal database, but it seems that the bots are not able to handle exceptions or errors that may occur during the process. This is causing the automation to fail and manual intervention is required, defeating the purpose of using RPA in the first place. I read this article to get more understanding and tried debugging the code, but I am not able to identify the root cause of the issue. Here's a sample of the code that's causing the problem: bot.click("submit_button") result = bot.get_text("status_message") if result == "Success": bot.click("continue_button") else: # What should I do here to handle exceptions or errors? ```"

how can i sort an Array?

Hi Team, I am trying to convert html code in my email template to dynamic so i can loop some values using expression rule but i facing some issue in syntax , Looking for the help below is the html code <!DOCTYPE html><html><body><head> <link rel="stylesheet" href="styles.css"></head> <h2>###bodytext###</h2> <br><br><h2>Please click on any below link to submit you response</h2> <a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Complete</a><br></br><a href="mailto:processmodeluuid0002e98e-199e-8000-273d-7f0000014e7a@cscswdev.appiancloud.com?subject=###resultId###&body=Please don't edit subject and To-email Address, Please add your comments below">Cancel</a> <br><br&g

Hi  I have scenario to create a chat bot in my application can any one help me how to do this?

Hi ,   I want to know what the relevant links or the paths and the topics which are priority for the preparation of RPA +IDP Badge. Also want to know the percentage that need to be achieved in order to get the Badge.

Hi All, I have this cast function  cast( 'type!{urn:com:appian:types:TLT}TLT_VEHICLEDETAIL?list', ri!data ) and I'd like to change TLT_VEHICLEDETAIL with a dynamic input using ri!inType. I thought to fix this problem with concat function ex.  but it doesn't work. and my result was this one    who can help me?

Hi team, I was following the document  https://academy.appian.com/#/online-courses/fc14c3d1-0eb3-4d9d-8ae2-fc0149ae7585 asking me to select Template from the toolbar and then select 'Import Template' but I do not find the import template icon on my community edition.  I can just see the default ones.. When I see the Appian documentation at https://docs.appian.com/suite/help/22.3/rpa-8.5/templates/rpa-templates.html I can see the import template icon on the top right in the doc. Can someone pls help is it just me or do I need to update something somewhere to get the import template icon ?? for now while I wait I have raised this to support team as well thanks jaideep

Background: Using integrations I have called several endpoints and pulled the data into a map with nested maps.  I now need to move values from the nested map to the parent, as they are all 1:1 relations. a!localVariables( local!CDT: a!map(id: 1, name: "Walt Disney", demographics: a!map(age: 73, gender: "M")), local!CDT) This returns:  Map id1(Number (Integer)) name"Walt Disney"(Text) demographicsMap age73(Number (Integer)) gender"M"(Text) what I am in the need of is: a!map(id: 1, name: "Walt Disney", Age: 73, gender: "M")

Hello good evening, I need help, well, it turns out that I have a problem, for example, when I want to omit certain special characters, I use substitute, all fine for example if I only want to omit the symbol "&", but when I put another symbol, for example "%", instead of replacing it, I get a blank space, I have already used substitute, stripwith, a regex, and I can not find a solution, I attach my code. a!localVariables( local!subs:substitute(ri!name," & "," "), local!formatB: cleanwith( local!subs, cons!GT_CONS_Clean /*1234567890qwertyuiopñáéÃ%ADóúÃ%81ÉÃ%8DÓÚQWERTYUIOPasdfghjklASDFGHJKLzxcvbnm-ZXCVBNMÑ_ */ ), if( length( local!formatB ) = 0, "attach", local!formatB ) ) I have already tried these functions and I can't get that.  regexreplaceall("\s\W", local!sub, "_") stripwith(ri!name," &#$%&/|¡? ") For example, when I try to test this string, instead

Hi Experts, I have a requirement where we have to get the input from user for the time fields, User want the time to be entered in HH:MM:SS in 24hrs format where SS is optional. Below are the input with expected stored output Input1: 23:55:55      Output: 23:55:55 Input2: 10:32           Output: 10:32:00 Input3: 23                Output  23:00:00 Input4: 231000        Output: 23:10:00 Input5: 2359            Output: 23:59:00 Input6: 23               Output: 23:00:00 Kindly suggest for the feasibility of such expression as how can we achieve this.

Hi there, could anyone let me know what's the problem here, in the following expression rule, if the condition is meeting, it will return the records which meet the condition, if there are no records meet the condition, I just want to return 0 item, but here it returns 2 "0 items". replacing "{}" with null does not work either. what I should do? regards Lin

Hi All, I have a table with studentid|subjectid 1     | 10 1     | 11 2     | 12 Students who belong to 10 and 11 should get 1|Science, 2|Maths. How can I get the output like this.        

Getting "RecordFormatException" while updating the record in excel file. Used apache poi with the version 4.0.0 for reading and writing to the excel file. Can any one help on this issue?

Hi all, {1,2,3,8,9,9,9,9,9,80,90,70}, {56,76,54,32}, {20,23,45,54,32,54}, {1,2,3,4,5,6,7}, {11,12,13,14,15,16,17,18} Please suggest how do this using foreach function get output like this, length of array 1 is 12length of array 2 is 4length of array 3 is 6length of array 4 is 7length of array 5 is 8 Thank You In Advance

Hi All, I have been trying the image recognition RPA functionality, getting the below error & I have used the given templates & ran the process in the available resource.  Kindly let me know where can we insert the image for Image recognition, How to configure this?

Dear david.catalan    Could you help me to resolve this issue? I am following the course and trying to record the searching bank name and certificate number action in chrome browser but could not get the list of applications Please refer to the screenshots below: I have chrome in the start menu Could not see any applications in the dropdown list,

My teammate found a bug when using proper() to display a label; a word preceded by a non-alphabetic character will not be converted to proper case. If the 11th floor is home to the HR department. Floor.id = 11 Floor.department.name = "human resources" We would expect: Floor 11 (Human Resources) but instead get: Floor 11 (human Resources) To reproduce the issue, I used this expression to check capitalization: proper( "I am reporting that ""proper() coNverts each [alphabetic] cHaRacter into ProPeR caSe " & "(unless a non-alphabetic character precedes it)""" ), Where I would expect: I Am Reporting That "Proper() Converts Each [Alphabetic] Character Into Proper Case (Unless A Non-alphabetic Character Precedes It) It's returning: I Am Reporting That "proper() Converts Each [alphabetic] Character Into Proper Case (unless A Non-alphabetic Character Precedes It) Is proper() working as designed? Side note: 22.4 documentation reads, "Converts each character i

for example my input is 0323 and i need output march-2023 (or) 03-2023