Skip to main content

Developers Forum

The place for Developers to share and learn.

  • 4,118 Topics
  • 10,855 Replies
4118 Topics
T
tayyabimtiaz1Navigator | Tier 3
asked in Developers Forum
How to copy the excel table and paste in email body

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

14537
Zaid Chougle
Navigator | Tier 3
11 months ago
G
GuruLokesh92Cadet | Tier 2
asked in Developers Forum
Capturing Objects in PowerBi

Hi Team,I am not able to capture objects in the Power bi Web Version using the recorder.Please suggest me any other options to capture. Thanks,Lokesh

804
C
11 months ago
Y
YKare2023Cadet | Tier 2
asked in Developers Forum
About single-column record variables

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?

14411
Zaid Chougle
Navigator | Tier 3
11 months ago
C
chienchienlingGround Control | Tier 1
asked in Developers Forum
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.

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.​Then, try again.If you continue to see this message, please contact your system administrator.Code: registration.error​Can anyone help provide solution?Thanks!

21622
D
11 months ago
E
EvaGNavigator | Tier 3
asked in Developers Forum
Credentials has disappeared from the list after I received some errors

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!

531
S
11 months ago
R
rmorinCadet | Tier 2
asked in Developers Forum
problem opening newly copied bot in A360

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)   

502
R
11 months ago
E
EvaGNavigator | Tier 3
posted in Developers Forum
Sometimes bot retrieves incorrect file name

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 

1919
E
11 months ago
E
EvaGNavigator | Tier 3
posted in Developers Forum
Azure Blob Storage via SFTP

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 

2354
E
11 months ago
M
MichalTurekNavigator | Tier 3
asked in Developers Forum
Auutomation Failing after Chrome Browser upgrade to 121 version

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? 

13505
M
11 months ago
V
ViralSharmaGround Control | Tier 1
asked in Developers Forum
How to get bot output in a JSON response

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 

750
V
11 months ago
H
hetalnCadet | Tier 2
asked in Developers Forum
Issue is coming in document Automation

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  

942
H
11 months ago
N
namanpathak08Ground Control | Tier 1
asked in Developers Forum
hide a task bot in Public folder

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.

301
Tamil Arasu10
Most Valuable Pathfinder
11 months ago
M
mewkyNavigator | Tier 3
asked in Developers Forum
I can't login SAP

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.

320
M
11 months ago
D
Daisy.K2Cadet | Tier 2
posted in Developers Forum
How can we lock the excel file from excel advance commands at share point

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

110
D
11 months ago
D
David JansenNavigator | Tier 3
asked in Developers Forum
Unable to open excel even though the excel is opened

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

410
D
1 year ago
M
mhazemCadet | Tier 2
asked in Developers Forum
AARI File

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

726
C
Most Valuable Pathfinder
1 year ago
J
Jay 8374Cadet | Tier 2
asked in Developers Forum
AARI Bug

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?

965
J
1 year ago
D
Daisy.K2Cadet | Tier 2
posted in Developers Forum
Convert non English language to English and create html table

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.   

230
D
1 year ago
L
lathabCadet | Tier 2
asked in Developers Forum
unable to insert column in Data table

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 

3456
Raul Jaimes
1 year ago
O
ovdptrCadet | Tier 2
asked in Developers Forum
Connect to Azure SQL DB via Active Directory Password

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

6065
E
1 year ago
N
Nishant.DCadet | Tier 2
asked in Developers Forum
Excel Task : Copy data from one excel and create other excels

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.

1753
Raul Jaimes
1 year ago
P
patrick.lorenz_jitGround Control | Tier 1
asked in Developers Forum
Bot Insight - track data with different level of detail

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 solution for it?

350
P
1 year ago
S
sunil.kumarGround Control | Tier 1
asked in Developers Forum
Required assistance in SharePoint command

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

1151
Tamil Arasu10
Most Valuable Pathfinder
1 year ago
B
b.goodsellGround Control | Tier 1
asked in Developers Forum
Passing User submitted inputs as variables during a bot trigger from Salesforce

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.

170
B
1 year ago
B
ben.zumwaltCadet | Tier 2
asked in Developers Forum
Are Triggers not able to run with Administrator Privilege's?

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? 

410
B
1 year ago
Terms & ConditionsCookie settings