Process Automation

expression evaluation error at  "readexcelsheet" readexcelsheet( excelDocument:ri!Spreadsheet, sheetNumber: 1, startRow: 2, ) ruleinput is document

In this rule i had merged two query rule to one new rule, now i want set query filters on this new rule to filter data. Thank You

Hi, I want to execute a SQL query, is there any function like executestoredprocedure that is used to execute an sp? I am trying to run a SQL query through the process model and trying to see the result of that query, so is there a way how to get the result of that select statement? Can anyone please help?

Hello everyone,   How to display the table format in appian using expression rules?  If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this and data is coming from database.

i have written the expression rule to show the data in table. but how to remove these semicolons from the table a!localVariables( local!contractData: rule!generatecontracttable( cif_int: ri!cif_int ), local!rowItemsdata: { " " & index( local!contractData.value_txt, wherecontains( 1, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 5, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 6, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & index( local!contractData.value_txt, wherecontains( 7, tointeger( local!contractData.extensionRefId_int ) ), {} ), " " & inde

I'm working on a integration project where data is coming out of appian, here I have a situation Where I need to specify if data is missing In a particular field let's say "name" under "personal details" section then "error type" should be "personal details" and "error details" should be "name". Likewise I have many fields under section "personal details" - for this i have created a record. Can anyone please help me to achieve this situation

Hello everyone,   How to display the table format in appian using expression rules?  If anyone has the idea how to generate the table using html please help me . Thanks in advance. The finally format in pdf should be like this

Hello everyone, I can't find a single mention in the docs for this, so here I am - does anyone know what 'Orphaned' means for the result of an Appian RPA process? The process was a longer running one (looping over several pages to pull data out) In the Robotic Processes tab of the Appian RPA dashboard, the Result shows as Aborted and Orphaned. It shows pretty much the same thing in the Monitoring -> Events tab. There's no error in the process indicating why it would have broke, so any insight is appreciated!

Hi all, I am trying to configure the RPA resource. The final Maven setting does not work and results in error. I have tried to give the credentials and all the URL info but still pops up with same message. The same works fine when I initiate from my personal PC but when I try to work on the same logic with my official Pc there is an error thrown. Is there something am I missing to configure or set up I specified my URL as : https://<mysite>/rpa-repo/ I gave my credentials too 

Hello Everyone,  is there a guide how to configure a resource for APPIAN RPA in AWS ? 

here for the fist two filters i want to use it as "AND" operator filters and last two I want use as "OR" operator. Is there any way to do it inside the a!queryrecordtype function?

Hi, I have a string in DB which is: "<key>PROJECT_CODE</key><style>BOLD</style><color>#EF0010</color>" and I want your help to split this into different variables, like after splitting the above string  var1 will have value = PROJECT_CODE, var2 will have value = BOLD, var3 will have value = #EF0010 Thanks in advance!

Hi All, My scenario is to filter the below view column in appian expression rule using the two rule inputs of "date" dataype(startDate,EndDate), We can see in screenshot, the  column is of text and its in concatenated way, is it possible to filter this from appian? Could you please help me on this. Thanks in Advance.

if( isnull(ri!type), {}, a!forEach( items: a!queryEntity( entity: cons!POINTER_TO_DSE, query: a!query( filter: a!queryFilter( field: "type", operator: "=", value: ri!type ), pagingInfo: if( isnull(ri!pagingInfo), a!pagingInfo(1, - 1), ri!pagingInfo ) ), fetchTotalCount: true ), expression: if( ri!type = "Text", updatedictionary(fv!item, { textField: true }), if( ri!type = "Decimal", updatedictionary(fv!item, { decimal: true }), if( ri!type = "Date/time", updatedictionary(fv!item, { dateTimeField: true }), if( ri!type = "Integer", updatedictionary(fv!item, { integer: true }), if( ri!type = "Date", updatedictionary(fv!item, { date: true }), if( ri!type = "Boolean", updatedicti

Hi, How can I print the numbers between two numbers. Eg: Number 1 = 1, Number 2 = 5. Expected output 2,3,4 Kindly help. Thanks in Advance

RPA process cant scan Drop down components from appian and ends the process when it comes to drop down, it takes id as a random number when i gave recorder by interacting with dropdown, So what i was trying to do is create rpa process to automatically login into my appian designer and create an interface, so when i try to press new which is a drop down the interaction is not being performed

a!localVariables( local!metadataJSON: if( a!isNotNullOrEmpty(ri!metadataJSON), a!fromJson(ri!metadataJSON), null ), local!result: a!forEach( items: local!metadataJSON, expression: a!localVariables( local!section: fv!item, a!forEach( items: local!section.questions, expression: a!localVariables( local!questionrow: fv!item.questionrow, a!forEach( items: local!questionrow, expression: if( fv!item.questiontitle = ri!targetField, updatedictionary(fv!item, { "responsetext": ri!value }), null ) ) ) ) ) ), local!metadataJSON ) I have a nested json. I need to update its field "responestext" if its questiontitle is equal to the parameter. Then return the new json. But the original variable metadataJSON is not updated. Is there an

i tried but i did not get exact output, any one try this .. a!localVariables( local!expression: "x+y-x*y", local!result: a!forEach( items: enumerate(len(local!expression)) + 1, expression: local!expression[fv!index] ), local!arryIndex: { x: wherecontains(touniformstring({ "x" }), local!result), y: wherecontains(touniformstring({ "y" }), local!result), }, local!etdata: a!update( data: local!result, index: { local!arryIndex.x, local!arryIndex.y }, value: { 10, 20 } ),local!etdata)

Hello, I am learning query entities and I am getting the warning message (missing domain prefix).  cons!UA_DSE_STUDENTSINFO is mapped to UA_Students DB. I believe it is configured properly because I use the same constant to write values to DB. I am getting the same warning message when I try to use sorting. 

hi, I am trying to create a BOT that will read records from Appian DB, hit a website, extract information (get attributes) and update few other columns of the DB. The table is The BOT reads restaurantname (in a loop), get attributes (status and date) and update the DB back this is what I have Loop is: foreach pv!restaurant.restaurantName Update value in search is "interact with element" with value as fv!item Get Date is 'get attribute' with target as restaurant.inspectionDate where restaurant is a variable of type CDT that has when i run this BOT (through a process model) I see the restaurant names are picked up fine by the loop (one after another), however the status and date values that gets updated is for the last entry in the table (in this case: Gallery Market & Cafe)  so when I see the process variable in BOT after it has run it is  Value [{"restaurantID":1,"restaurantName":"True Food Kitchen","restaurantStatus":"Status: Permitt

I need an expression which finds corresponding value based on ranges: Input:x{v1,v2,...,vn+1}{r1,r2,...,rn} Result:if (x<=r1) then v1else if (x<=r2) then v2....else if (x<=rn) then vnelse vn+1 Thanks

Hi, we are facing issue with executing “Open Browser(Edge)” action stage in Appian RPA for “https://xxxxx.xxxxxxxx.local/Reports/Pages/Folder.aspx” URL. Getting below error while executing it. Kindly give your suggestion.

Hi folks, I have a requirement like display the number of resignation cases per quarter and the data in grid format. Facing issues to fetch data by quarterly. Please help me on this, Thank you. 

Hi, I have created a BOT (as suggested by the Appian RPA tutorial) to update a single DB row and it works just fine..Here are the steps in brief My Appian DB: BOT is 1. opening the browser: https://inspections.myhealthdepartment.com/va-arlington 2. updating value in search: pv!restaurant.restaurantName (comes from the process model which retrieves the data from the DB) 3. click on search button 4. Getting status (from UI - CSS selector) and updating restaurant.status 5. Getting date (from UI - CSS selector) and updating restaurant.date This is my CDT and the process model My process variables: Get Restaurants to Search Node: Execute the RPA and saving the values in restaurant variables Writing to the restaurant variables:   Updating DB This works just fine. The status and date field on my DB gets updated with the value it extracts from the https://inspections.myhealthdepartment.com/va-arlington Problem: Now I am trying to do this for mult

Hi, We have a requirement in Appian RPA where robot needs to open a website which is having 'http' and NOT 'https'. When I'm using 'Open Browser' action it is showing to provide a valid URL. Could anyone tell a solution on this?