Developers Forum

Today I faced one issue.While convert System.Date to To String with “YYYY” format. it is returning result “2025” and if you use “yyyy” then it is returning “2024”.This is happen on 30th of Dec 2024.  Please let me know the permanent solution. Thanks   

Is there any prebuilt function where we can get the cell Address/reference value from the Google Sheet? For Example: If we are using  “Excel Advanced package : Get Cell Address” function. The output of this call will be like A1,B1..etc(depending upon the Active cell/specific cell). So, is there any similar Function with Google Sheets to retrieve in the same way? or how can we achieve this?

Hi all,I’m Darshan Hiranandani, trying to use the "Run Javascript" action in Automation Anywhere with manual input, but I need to reference an RPA variable within the JavaScript code.For example, I have a variable $variableInRPA$ (which holds a value like 50), and I want to add 10 to it in the JavaScript code, then return the result. Here's what I’ve been attempting:(function(){    var variableInManualInput = $variableInRPA$;    var result = variableInManualInput + 10;    return result;}());Is there a way to pass the RPA variable into the JavaScript code correctly? I’m unsure how to reference it properly for this use case.Has anyone encountered this before and figured out a solution? Any tips or suggestions would be greatly appreciated!

Hello All, I have been trying to automate the Azure blob Storage to upload files using Rest APis. However, I'm able to retrieve the values from file in blob storage container. But when trying to upload a file its not working as expected (Authorization used : SAS Token). Could anyone give me an idea if any automation has been done on blob storage. Also if the API automation not possible. Can anyone suggest me if anyother methods that has been followed to automate this.

Trying to click by object capturing the hierarchy element in web page , i have attached the example for reference. There username would be a dynamic one . Needs to navigate and click the username which have the word TEAM 3rd highlighted point in below image.Tried to change the domx path and html href but Its selecting the 1st user name highlighted below. 

Hi everyone,I’m Darshan Hiranandani, facing an issue with an infinite pending execution in Automation Anywhere. I’ve already attempted several fixes, including restarting the service via services.msc, but the problem persists. Additionally, I’m unable to delete the device. I’ve also tried reinstalling the bot agent and clearing everything in the Automation Anywhere folder, but this results in a new issue where an additional device gets registered.Has anyone encountered a similar problem and found a solution? I’d really appreciate any suggestions or advice on how to resolve this issue.Thanks in advance!Darshan Hiranandani

Hi all,I’m Darshan Hiranandani, trying to use the "Run Javascript" action in Automation Anywhere with manual input, but I need to reference an RPA variable within the JavaScript code.For example, I have a variable $variableInRPA$ (which holds a value like 50), and I want to add 10 to it in the JavaScript code, then return the result. Here's what I’ve been attempting:(function(){    var variableInManualInput = $variableInRPA$;    var result = variableInManualInput + 10;    return result;}());Is there a way to pass the RPA variable into the JavaScript code correctly? I’m unsure how to reference it properly for this use case.Has anyone encountered this before and figured out a solution? Any tips or suggestions would be grea

Hello everyone,I’m Darshan Hiranandani, and I’m working on a project where I need to extract data from scanned Arabic documents using Document Automation (DA). While I know that DA can handle Arabic text extraction, I’m now looking into whether it can also identify visual elements like departmental stamps and signatures.Specifically, I need to:Confirm whether the document contains a departmental stamp. Verify if the document is signed by the appropriate authority.While DA is great for text extraction, I’m wondering if it also has the capability to visually detect stamps and signatures, or if this would require additional tools or a different approach.Has anyone tackled a similar problem? Any suggestions on how to handle this, or what tools to use in conjunction with DA for stamp and signature recognition, would be really helpful!Thanks in advance for your insights!Best regards,Darshan

Is there a way to use the Debugging tool like the “Run from here...” command, but through mid point of code? I would like to use the ‘Step over’ function but always have to run my code from beginning.My current way around it is; to copy my line of code (e.g. say middle part) to the beginning of the bot to then use the debugging tool to see that part run.

Hi Friends,Can any body please tell, How to  get/display/retrive  linkedhashmap values ?In other word, Can we cast linkedhasmapvalues in String format ?

If a bot deployment fails, I want to be notified via email immediately - I do not always have my control room up. I have just now turned on all CR notification settings and I turned on the Email Reports setting. I have read in the Notification articles that some Automation events will instantly notify me, but it is not clear if the email itself will send instantly. Will EMAILS be sent instantly after a deployment failure, or are the notifications only instant if you are logged into the control room?

The recent document automation bootcamp series provides this link https://apeople.automationanywhere.com/s/?language=en_US as a place to download the document classifier packages, but I do not see the downloads anywhere, not even in the “downloads” link.Can anybody point me in the right direction for downloading this package to my control room?Thank you.

This may be due to the following reason: class com.automationanywhere.botcommand.data.impl.StringValue cannot be cast to class com.automationanywhere.botcommand.data.impl.WindowValue (com.automationanywhere.botcommand.data.impl.StringValue and com.automationanywhere.botcommand.data.impl.WindowValue are in unnamed module of loader java.net.URLClassLoader @65c2ef49)To continue, edit the bot and fix the error. Then, try again. If you continue to see this message, please contact your system administrator.Code: bot.execution.error

Hi All,I am working on a use-case where I need to process an application form and extract the following information : 1. Hand-written information in respective fields2. Snips of stamps and signatures - can be randomly placed anywhere in the document The output can be stored in database to be processed further. Need help to understand if anyone has worked on such a use-case. If yes,1. What is the kind of accuracy achieved?2. Which components did you use to accomplish this data extraction? Thank you!

I need another set of eyes on this; hoping it is just something stupid simple I am not thinking of. I have to pull data from a 3rd party source through their API. This is a multi-step process following the path below:Obtain Access Token Obtain Location URL Obtain requested dataFirst, I obtain the access token, pretty standard.I then have to send a request for the specific patient info (medical procedure). The parameters are things like patient.FirstName, patient.LastName, startDate, endDate, DOB.The return headers from this second call includes a Location field formatted in a URL with a session ID. It looks similar to this:  https://api.company.com/company/v2/service-reviews?sessionId=1234567890987654321That Location is the source of the third call, and returns the require

Hi Team, Right now I am having an issue with the extract data bot, when it is trying to extract the data from a PDF file I am getting this error 

Artificial Intelligence has revolutionized various business processes by automating tasks, providing deep insights, and enhancing decision-making capabilities. What would be the imapct of AI on the existing ERP system when integrated .How  seamlessly it work with existing systems to enhance functionality without disruption.

Microsoft Outlook 365 - Save attachments displays the following error 50% of the time.“Field 'folderPath' must not be null” The “Save attachments to folder” is a variable, which is a valid location. Line just before does a log to file command and displays the correct location. When it does work the attachments are same correctly. I am using the same emails for each test.Anyone seen this behavior before???

Hi,I am trying to export all the data from xls file to Data table using DataBase package. Query used in the export to data table command is Select * from [Sheet1$]. When looked into number of columns in the Data table, it is not matching with what is in xls file. Tried to use select query with all columns, Select column1,column2,...column20 from [Sheet1$], this is throwing error “No value given for one or more required parameters”, but when any one column is removed it works as expected. 

Hi everyone, I hope you’re doing well.I am automating an Excel file using Automation Anywhere (AA). During the process, the bot is configured to apply a custom cell format dd/mm/yyyy. For example, if the date entered is 10/30/2024, it is correctly formatted in the cell.However, after the bot execution is complete and I open the file manually, an issue arises: the leading zero disappears in some dates. For instance, the date that should be formatted as 10/03/2024 appears in the cell as 1/3/224.It’s important to note that this issue only occurs in one specific worksheet. The other four worksheets in the file retain the correct format and data entered.Could anyone help me identify the cause of this issue and how to resolve it? I’d really appreciate any guidance or suggestions.Thank you very much in advance for your help!

Hi everyone, I have created a bot that retrieves e-mails with the Microsoft Graph API. However, the result must be properly encoded using unicode. For example the letter “è” is U+00E8 and if I don’t correct it, the word “règlement” appears as “ru00e8glement“I have used the javascript component, to run this function : function decodeUnicode(str) {    return str.replace(/\\u[\dA-F]{4}/gi, function(match) {        return String.fromCharCode(parseInt(match.replace(/\\u/g, ''), 16));    });} However, it is particularly slow.If I run this script on a batch of 100 e-mails, it takes roughly two minutes. In my opinion, it is not an acceptable duration. Is there a way to optimize that ?

i have a customer who is using the AA On premise license, As some reason they reduce some license , then from the configurations it shows the problem like attached picture, What should they do to remove the redudent license,  

Team,I need to restrict access to my Cloud Control Room URL in the public environment. If I configure our company's ANF and NAT IPs under network settings, it will limit access to public usage as intended. However, in the event of an issue with our company IPs or a change in IPs, I might be unable to access the URL to log in and update the IP settings.What steps should I take to address this scenario?

I have Given all the access in MSSQL and as well as firewall still i am getting this error Kindly help me to solve it 

how to Migrate one DB to another DB I need to migrate table record from one database to another databse throught AA in same server when i try.  it enter the record in same table  I need to enter the data in another table it is in another db kindly help me in this