Process Automation

I want to upload an image with the POST request and retrieve it from database. How can I do that? 1. To which datatype can we assign the document? 2. How can we convert to image into base64? 3. How can we encode and decode? 

Hello, is it possible to have a conditional sort on multiple columns in a query rule? I need to sort the data by modified date and created date columns. Modified date might be null for some rows. Below order by expression gives just what i want when i use it with the SQL query. Is there a way of creating same logic in a query rule? order by case when MODIFIED_DATE is null then CREATED_DATE else MODIFIED_DATE end DESC I tried below code but it didn't help. pagingInfo: a!pagingInfo( startIndex: 1, batchSize: -1, sort: {a!sortInfo(field: "createdDate", ascending: false), a!sortInfo(field: "modifiedDate", ascending: false)} )

hi, for ex, if i enter some date from that date till today how many days? how to count no of days 

Dear Practitioners, Does anyone know the licensing model for using Appian RPA? I could not find any information in the documentation or maybe I missed it. Any help is appreciated! Thanks, Sunil Zacharia

any() 

Hi there, I am new to Google Cloud Document OCR Connected System in Appian. I have created the connected system. just want to use it in the integration. but I dont know what should be put in the two circled fields in attached pic. Do I need to go to google to create a "Google Storage"? or Appian provide these storage? if I need to create myself, anyone can provide information how to do it? and the credential use to create google storage need to match the credential used to create the connected system? regards, L  

I have a situation where I need to hold a task for a certain time period. The condition is as follow: 1) If the task is activated before 8.30 AM on a particular day, it should wait till 8.30 AM to be completed. If not , it should take the exception path post 8.30 AM. 2) If the task is activated after 8.30 AM on a particular day, it should wait till 8.30 AM of the next day to be completed. If not , it should take the exception path post 8.30 AM on next day. Can anyone please help us on the above logic?

Hi,  I'm stumped on the attribute capture step of the Create Robotic Processes with Appian - Part 2 course. I created process variables and started the task recorder to get the status attribute as per the given instructions. I'm able to capture attribute value but save into does not list any created process variable & it's the same issue with new variable creation. The drop-down doesn't populate with value upon searching. Here are the specifics of my system environment: RPA Version -  8.1.0 Appian Version - 22.1 Chrome Version - 101.0.4951.67 ChromeDriver Version - 101.0.4951.41

Hi, I am validating just uploaded document size  with below code: if( rule!APN_isBlank(ri!documentId), { fullName: null(), name: null(), ext: null(), size: tointeger(null()) }, a!localVariables( local!value: a!fileUploadField(value: todocument(ri!documentId), target:cons!RMO_FOLDER_ALL_DOCUMENTS, fileNames: fv!file), local!fileDetails: tostring(local!value.contents.value.filename), local!fileName: extract(local!fileDetails, "[name=", ", extension" )[1], local!fileExt: extract(local!fileDetails, "extension=", ", size")[1], local!fileSize: tointeger(extract(local!fileDetails, "size=", "]")[1]), { fullName: local!fileName & if(rule!APN_isBlank(local!fileExt), "", "." & local!fileExt), name: local!fileName, ext: local!fileExt, size: local!fileSize } )) Issue: After clicking on submitting button, document name storing as [name=Document Name, extension=docx, size=3752844] instead of only d

Hi there,  I'm in the process of automating use case of opening an emails and read the content and take decisions accordingly. Can someone shed some light of doing it via Appian RPA? The documentation seems to be little elusive particularly in the case of adding the jars and workflow libraries for the outlook module in the Appian RPA console. 

"APPIAN" (TEXT TYPE)  --- Should return in "NAIPPA"

Hi Everyone, I am trying to automate outlook application. But I am getting the below error continuously.  Caused by: com.novayre.jidoka.outlook.api.exception.JidokaMsOutlookException: Invoke of: RetentionPolicyNameSource: Microsoft OutlookDescription: The operation failed. Has anyone faced similar scenario . Please guide me if you had overcome this scenario. Thanks

Hi,  I am a beginner in RPA, Trying the tutorial- Excel data provider. The tutorial says, I have to use the template Please Help.

Hi, We are using webservicequery() function for calling an SOAP API which is taking more than 90 seconds to retrieve the data, Which is causing Appian to error out due to default 60 seconds socket timeout. So we increased the socket timeout to 180 seconds, After this change Appian doesn’t error out and also doesn’t show response data.  I'm not sure but I think the default auto retry at every 60 sec of Appian error handling is causing problems https://docs.appian.com/suite/help/22.1/Automatic_Error_Handling.html#external-error-handling. Does anyone know the root cause of this issue  ? Thanks in Advance

Goal: name1, name2, name3 (show and hide comas in between and names if they are selected)  Default is N/A if no names are selected What I have tried: if(isnull({pv!process.name1,pv!process.name2,pv!process.name3}), "N/A","") & if(isnull(pv!process.name1), "",", "& pv!process.name1) & if(isnull(pv!process.name2), "", ", "&pv!process.name2) & if(isnull(pv!process.name3), "", ", "&pv!process.name3))

Hi Team, I have a rich text editor in my interface and its value is saved as "text" in DB with all the tags (that includes bullets, colors, background color, highlight etc ). I want to extract only the text part of the data. How can I do this? Like if the value is saved as "<div>Assigned to <em style="color: rgb(0, 71, 178);">XYZ</em></div>" , I only want "Assigned to XYZ". striphtml() function throws error. Appian version 21.1

Goal: John Joe(12/2) Breakdown: Name: John.Joe (User picker) Birthday: (date&time)If no name is selected then present "N/A"What I have tried:  =if(isnull(pv!processvariable.name), "N/A", user(pv!processvariable.name,"firstName")& " " & user(pv!processVriable.name,"lastName") & "(" pv!processVariable.birthday &" )" )Problem: Issue with If statement 

"Activity Chaining in Process Model" I have 3 User Input tasks which are assigned to different Groups/users. For instance, I enable activity chaining between them . What will happen in that case. 

how can we get today date with time instead of now() function.

Hi, i have a picker field when i select some particular users names it has to show validation message else no  i have written like this but it is showing for all users whoever i select in picker field 

Hi,I have downloaded the latest jre version and installed it but anytime I run a bot it gives me this error of "[ERROR] 2022-05-10 18:54:49 - - java.lang.reflect.InvocationTargetException    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)" and more lines of error? Any clue on how this can be managed?

Could someone explain why the following code work without compiler errors? if( isnull(ri!user), "", isusernametaken(ri!user), user(ri!user, "firstName") & " " & user(ri!user, "lastName"), joinarray(split(ri!user, "."), " ") ) I expect some kind of evaluation error, but it works just as the three lines starting on "isusernametaken" were an embedded if. I saw that in one of the Appian courses and I'm wondering if it is some undocumented feature of the if function. Thank you

Hi, I have a!queryEntity where I have to apply few filters for querying data. I have to apply 3 filters with an "AND" along with these filters I have to apply additional 2 filters with "OR".  Is this possible. Any advices please.

Hi,I'm trying to setup the configurator ( maven) for Appian RPA and i'm unable to add the URL needed to the appian repository.Can anyone guide me on what exactly needs to be mentioned and where can get the required URL for the configurator to get set up.

Hello, I am using Appian RPA using Google Chrome to login to a client web site for downloading PDF documents. The URLs for downloading the PDFs are obtained from the web site, but on navigating to these URLs the documents are getting directly opened in browser. Is there a way by which I can download them ? I would also like to whether there is a way by which I can directly upload these documents to Appian without downloading them to the local machine ? Regards, Deepak Devarajan