Developers Forum

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. 

Hallo,I want to conduct a condition of comparing a given sting to match a patter:<exact 4 random digits></><exact 2 random digits> using a regex string:\d{4}\/\d{2}.F.i. string 2024/01 should be OK, but 202/01 or 2024/014 or 20243x/01 wouldn’t.Using FIND action or REGEX tools doesn’t work as expected, any clues? 

Hey everyone,   Is there a way to create a ccustom error handler? like: would be great to create a custom one like "Login error” or whatever. i`be searched in AA360 latest SDK and unfortunately didn't find:    

I was searching for outlook email to be send in encrypt format for users due to confidential information provided in email body. But there is no way by automation to send in encrypted format rather than encrypting file.Can we get us an idea how to send outlook email in encrypted format..?

Hi All,  I'm facing the below error while trying to install Automation360 (on-premise) . Any help/ thoughts would be really helpful Note: I have already installed the MS SQL 2019 express edition and configured TCP/ IP with port 1433.  Error logged as below 1: ElasticsearchCertStore: Returned error "C:\Program Files\Automation Anywhere\Automation360\jdk11\bin\java.exe", -Dext.properties.dir=.\config -Djavax.net.ssl.trustStore=.\pki\trust\store.ks -Dlog4j.configurationFile=.\config\log4j2.xml -cp kernel.jar com.automationanywhere.elasticsearch.util.ESInstallerUtil -store "C:\Program Files\Automation Anywhere\Automation360" ********** localhost, Return Result (-1)  CustomAction ElasticSearchCertProcess returned actual error code 1602 (note this may not be 100% accurate if translation happened inside sandbox)   Thanks in advance, AK

I am getting this error after running existing bot-  None of the user(s) provided have a default device or all sessions on the default device(s) of unattended user(s) have been allocated to user(s) with bot creator, attended, or citizen developer licenses This bot ran successfully one month ago but now now.Please help me in resolving this error as I am new developer.

We are looking to add a customer sign off on requested actions after UAT and prior to production roll out. I am interested in how others handle this and how it is documented. Initial thoughts are to use a Microsoft form to gather data to verify the bot results match expectation. If something comes up that is out of scope or not meeting their needs, we can regroup. If something comes up later or there is a conflict, we can use this to verify the results were approved.

Excel takes long time to update after sql database query in automation anywhere a360.Also if tried to open it shows that read-only mode. Locked by other user.

Hi, Can someone tell me what is framework  and how we will create it in AA360?

Hello,When I write from data table into excel worksheet the numbers are stored as text.  I need them to be numbers so I can put in formulas and have the calculations work properly.  I have tried several things.Changed format of all cells to ‘number’ (didn’t work). Made sure I was using .xlsx and not .csv file. Changed column type on data table to ‘numbers’ and then did write from data table (didn’t work). Turned off the error checking in Excel Options (didn’t work).What am I doing wrong??  How do I fix?

Hello everyone!I have a question about XML navigation, hope you can help!That’s basically the XML I have: For every XML doc I have the infNFe and from 1 to 999 “det” nodes and inside each det nItem node, I have the other nodes.The question here is how I can navigate from det node to det node if their name is the same and what differences them is the “nItem” attribute.For the first “det” node I can already reach the inside nodes with:NFe/infNFe/det/prod/NCMBut I don’t know how I can navigate throught them and get the NCM node from every “det” node. I hope I could make myself clear on my question.Thank you! 

Hi,I want to update an excel using update command where I set some values using where condition. Is there any alternative to this? Can I use an excel command for doing this? I don’t want to use database. I cannot see any command for this in automation anywhere

Does anyone know how to detect if an SAP Session has been initiated or not? Like in an IF statement. I don’t mean SAP itself, just if the SAP Connect action has resulted in an active session for use in AA.I’ve placed the SAP Disconnect action in the catch of my error trapping to disconnect if there are errors. But I only want it to execute if there’s an active session. I’m thinking of moving the Disconnect action to a Finally section of error handling, but I think I may still experience issues if there’s not an active session.

Has anyone else noticed that the "CSV/TXT: Read" action ignores the last column in a CSV if that column is null, despite the column having a header? For example, if you open the following CSV and read it:key val1 val2 val3 val4 1001   “StringData” “StringData”   1002 “StringData”   “StringData”    Your data table will only have 4 columns, “key”, “val1”, “val2”, and “val3”; “val4” will be omitted. This seems like an oversight to me and I think it should be fixed in future releases. I think we should at least have the option to toggle “headers” on and off to tell the “read” action how to interpret our files. EDIT:The “read” action appears to read the final column, but you can’t reference it. For example, I have a CSV with 14 columns, and the last is blank. When read into a DataTable, the table column count is 14, but when I reference index “13” (which is the 14th index position), I get an error that the index is out of bounds. Very odd to me.

How does some one drop a list of tables and verify first ifd the y exit or not if they dont the BOT runs as it should but if they exist drop them  

Hi,  It appears that after resetting the password for a bot operating within a Virtual Machine (VM), I updated the corresponding credentials in the Automation Anywhere (AA) Control Room. However, while the bot runs manually correctly(I believe so) in the Control Room, it fails to execute within the VM. Additionally, there is an absence of log generation in this context. Could you provide guidance on resolving this issue? thanks

I am getting an above error while try to extract data to excel from pdf, Just wondering if I am missing any action here

I want to loop through this format of a string and only execute a function if system date is more than this column, how can i compare the string to a system date. I have tried using datetime assign but the format is not getting accepted. The format I enter in custom format is MMM dd, yyyy HH:mm but its not getting converted to string for me to compare and execute next function. Please helpTimestamp Jan 5, 2024 09:03 Jan 5, 2024 08:22 Jan 5, 2024 08:20 Jan 5, 2024 08:18 Jan 5, 2024 08:09 Jan 5, 2024 07:46 Jan 5, 2024 07:46 Jan 5, 2024 09:39

I want to loop through this format of a string and only execute a fucntion if system date is more than this column, how can i compare the string to a system date. I have tried using datetime assign but the format is not getting accepted. The format I enter in custom format is MMM dd, yyyy HH:mm but its not getting converted to string for me to compare and execute next function. Please helpTimestamp Jan 5, 2024 09:03 Jan 5, 2024 08:22 Jan 5, 2024 08:20 Jan 5, 2024 08:18 Jan 5, 2024 08:09 Jan 5, 2024 07:46 Jan 5, 2024 07:46 Jan 5, 2024 09:39

An unusual error is occurring when I am trying to run my bot. I checked all log files, searched for error but no solution. I have installed A360 on my D drive.I have re-installed both bot agent and A360 but error is still there. I have also downloaded SSL certificate of control room and imported it in .cert file as directed in below link.error image is attached.I have checked for dependencies error, but no error found.there is plenty of storage.I have no proxy installedwhat is the fix?  

I want to capture the green highlighted domxpath in a list from an application however this needs to be dynamic, so every time the bot can click on the element.If you see they is a pattern in the domxpath list however when it captures the blue highlighted domxpath and move to the next element which is the green highlighted domxpath it has a seven and not a six .When I do an html inspect in chrome it shows they is a hidden element between div[5] and div[7].How do I dynamically capture the element?//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[1]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[2]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[3]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[4]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[5]/div[1]/div[1]/p[1]/label[1]//form[@name='form']/div[5]/div[2]/div[1]/div[2]/div[7]/div[1]/div[1]/p[1]/label[1]/

In the loop excel basic  set cell commnad is not working where as excel advance is working. Can someon tell me why is that happening.

Hi,I’m developing in Automation Anywhere360 and using SOAP Web Service action. but the SOAP service that I need to connect requires a WSSE Authorization Header that needs to contain the User, Password and Timestamp. Can someone provide me with an example of how to setup that in the SOAP Web Service Action? 

Hey, I’m working on a process for our accounting team and I’ve managed to build out a process that when they hit run in AARI it will show a form to upload a csv file which will be used in the task bot process to format the data in the excel and once completed I was wondering if I there is a way to show a different form with hyperlink to download the file within one process? perhaps if there would be a way to output variables from task bot to form that might work? I’m aware that I can drop the file “somewhere” using task bot or send them back in attached email, but it would be cool to have it all in one process run.  Thanks,J

We need to access SharePoint location through Automation Anywhere and for that have to configurea.       Client IDb.       Client Secretc.       Tenant ID  To config these in SharePoint IT has requested ·      1.Reply URL ·      2.Sign in URLPlease help us to find what are those URLs to connect AA + SharePoint