I need the system to open links in a spreadsheet, complete task, and move to the next row and repeat process until all links have been accessed. I cannot get the system to move past the first row. It continues to open the first link. Please help. {
“Name”: “Convert April 24”,
“CreationDate”: “2024-4-24”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “success to abx hyperlinks.csv”,
“Value”: “”,
“Description”: “Read CSV file row by row”
},
{
“Command”: “while_v2”,
“Target”: “${!csvReadStatus} == ‘OK’”,
“Value”: “”,
“Description”: “Loop until CSV rows are exhausted”
},
{
“Command”: “open”,
“Target”: “${!COL1}”,
“Value”: “”,
“Description”: “Open the URL from the first column of the CSV”
},
{
“Command”: “waitForPageToLoad”,
“Target”: “60000”,
“Value”: “”,
“Description”: “Wait for the page to load with a 60-second timeout”
},
{
“Command”: “click”,
“Target”: “xpath=//button[@name=‘Convert’]”,
“Value”: “”,
“Description”: “Click the Convert button”
},
{
“Command”: “pause”,
“Target”: “5000”,
“Value”: “”,
“Description”: “Wait for 5 seconds for any dynamic content to load”
},
{
“Command”: “click”,
“Target”: “xpath=//*[@id="opptyCheckBox"]/lightning-primitive-input-checkbox/div/span/label/span”,
“Value”: “”,
“Description”: “Click the checkbox using its xpath”
},
{
“Command”: “click”,
“Target”: “xpath=/html/body/div[5]/div[2]/div/div[2]/div/div[3]/span/button”,
“Value”: “”,
“Description”: “Click the final confirmation button”
},
{
“Command”: “endWhile”,
“Target”: “”,
“Value”: “”,
“Description”: “End the loop when no more CSV rows are available”
}
]
}