Developers Forum

I want to get the table from an Excel and paste it in the same format in the email body.

If there is only one column of data in Excel, when we try to assign it to a Record variable using a loop action, an error will occur and it will stop working. Why?

HiI've followed this doc Add Control Room certificate to Java Credential Store (automationanywhere.com) and added On-premise Control Room SSL certificate on my Computer.But I'm still getting the error below:"Unable to connect to the Control Room and it may be due to not being able validate the SSL certificate presented by the Control Room."​This may be due to multiple reasons. To continue, please​1. Check to see if the SSL certificate has been added to the Java Key Store that is bundled with the bot agent.​The

Hello,I wanted to change the value in the credential - I had edit option and when I removed the credentials from the locker I received errors: ‘You no longer have access to manage the credential’ and “Results Error reading credential values: Access is denied” and the credential has disappeared from the list of credentials and is not visible for other users neither. When I wanted to create new credentials with the same name it didn’t allow me with message that credential with this name already exists ...how I can put this credential back to the list of credentials please? thank you!

It just started recently and not sure if this is related to a control room update going on. I have been copying bots a lot in the past and never had a problem.Here is the simplest way that I can reproduce this all done in my private folder on A360 :1. Create a bot with only one action (i use message box)2. Copy the bot3. Open the copied bot (this fails) looks at following screen. I turned on login on the AA extension which shows a 403 error (not sure if it is related)   

HI guys, I use loop to get file name of each file that is present in the folder. Bot works good and is able to get correct file names, but sometimes it retrieves the file name with extension e.g.’ Downloads\FORECAST.020950.csv.csv' - for that I put if statement and extract name w/o extension if it is presentand sometimes it retrieves totally different name: ‘Downloads\886e099b-53f7-44c0-8383-0f7ed2b34472.csv' - but I am  not sure how to handle this and bot fails if incorrect file name is being retrieved.Can anyone help here, please? Thanks a lotEva 

Hi team, I want to put file to azure blob container via SFTP connection. I use ftp/sftp command but I am getting error: ‘use valid connection parameters and try again.’ Does anyone have experience please? I saw that it uses SSH2 and I also saw a note that aa360 does not support SSH1. Do you think it is feasible to put file to blob container via SFTP? Thanks a lotEva 

Hallo,affected: AAe 360 v.29 on-premiseToday i’ve encountered an issue after upgrading a Chrome from revision 120.0.6099.225 to the recent 121 revision.Some usages of the recorder action started to failing, both on Bot Creator and Bot Runner hosts.Recorder action ver. 2.15.2-20231004-180246,Bot Agent: ver. 21.250Chrome extension, ver. 3.1.0.0I’ve dealed with it by downgrading the Chrome back to revision 120.0.6099.225 and reinstalling Bot Agents,but I wonder what could be the reason for such behaviour?Any clues? 

I am looking for a way on how to get output values from a bot as a JSON Response by triggering it as an Endpoint using Control Room APIs.I am currently using V3 Bot Deploy API endpoint that returns the Deployment ID whose response is asynchronous.Please help me on how can that be done. Or Is there a different way altogether 

Hi I am trying to process the documents from learning instance and getting error “Unexpected token 'j', "java.lang."... is not valid JSON” Please help me out if anyone has face this issue  

Is it possible to lock a folder/bot in public directory?  I have a business requirement where the task bot access needs to be limited, even when checked in the public folder.

I can't login SAP using action sap connect (I'm a beginner and just learning how to do it). I'd like to ask for instructions or a VDO to recommend usage. Thank you in advance.

How can we lock the excel file from excel advance commands at share point

I am having a problem while trying to open an excel.Basically when i used excel advanced : open, the excel got opened but there is a slight loading cursor and the bot agent pick it as “unable to open excel” the loading cursor took like 1-2 seconds only and it doesn’t matter even if i used a try catch as the open is deemed failed the session is not establish, meaning i couldn’t perform any excel advanced command in the excel

Is there a way to delete or overwrite the file which is uploaded to the AARI Form?

Identified a bug while running AARI process where one of the field in a form is not marked as required but we have an error on that field and unable to submit the form.I guess the issue is due to the new version of Control Room installed on the environment. Do someone have the same error and what could be the solution for it?

Hi Team, I am having a requirement to create a html table with data given in excel in local language. example Chinese. So when it is creating table there is question mark in content. Is there feature to convert Any local language to English.   

I am trying to insert column into a data table, but I am not sure why it is not working. Please let me know what needs to be done. trying to read excel into data table trying to insert column into the table 

Hello, I am trying to connect to an Azure SQL DB with the following connections string:jdbc:sqlserver:{{server}};database={{db}};user={{username}};password={{password}};encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;authentication=ActiveDirectoryPasswordThe issue is that when I run the code, I get the following error:Exception occurred in command execution. 'Could not Connect to Database. Failed to load MSAL4J Java library for performing ActiveDirectoryPassword authentication.' Do you know what is to be done? I have searched and found nothing about this. Thank you

Hi All, Need some help regarding a task.I have one excel and in that there is one of the columns named “Action to Perform” .I want to filter on column “Actions to Perform” and create five excels based on 5 different values that are there. It is a 20000 plus row excel.Can you help / advise on how to achieve that ? Also, i would like to copy only specific corresponsing columns based on values in “Actions to Perform” columun.

Hi everyone,I would need to set up a bot insight dashboard for tracking the processing of purchase orders.The problem that I’m facing is, that I would need to track two different levels of detail.PO level (e.g. PO#, customer #, PO date, was it processed correctly or not) PO Item level (e.g. item number, delivery date, status, PO# to which it is related)When using “Analyze: Open/Close” actions with different transaction names I can at least save the data independently but when using the variable “PurchaseOrderNumber” in both transaction it will cause problems in the analysis, cause I would have a record with the PO# for every line item.I know that I could use different variables for each transaction (e.g. PoNumber on PO_Level transaction and PoNumberOnItemLevel on PO_Item_Level transaction) but I’m not sure if this is  the best approach. Anyone in this community, who had a similar problem with a proper solu

Hi Team, I need to open file from SharePoint using by SharePoint packages, but I’m unable to do the authentication.There are asking client, tenant, and secret ids.Please kindly help me. Thanks,Sunil

Has anyone managed to send user submitted data from Salesforce via the connected apps?Specifically using a button trigger within salesforce, that will prompt for an input. During testing, all SF case data is being sent, but the user submitted field does not. The API name was set and used, and we also tried submitting the variable as the actual AA variable name, but to no avail. There seems to be very little documentation in regards to this.

I have a bot that I can run with Admin Privs if I manually start the automation OR set it up on a schedule. However, I am unable to run that same bot with Admin Privs if I set it up to run from a trigger event such as “file modified”.Is there a way to implement this ask or does Automation Anywhere have something in place to address this inconsistency? 

I am trying to get the Access token by using the REST API activities, i get the response but when I try to parse JSON node value, using activities I get an issue the activity removes the double quote. My Co-worker tried the same approach on his AA360 but didn’t get the double quotes removed.