Read from CSV/Input to webform

Hello all,
Just a heads up, I had this whole macro previously automated in UIPath, but due to licensing issues (too expensive) I’m transferring over to UIVision. So far, I really like the client. There are a few differences, but overall it seems fairly straight forward.
I’ll also note that I’m definitely not an expert. So please excuse any simple issues.
Now, for my code: I’m trying to create a webform macro where I read an Excel CSV with rounding areas, and input it into my company’s ticketing suite. COL1 is my building, COL2 is the department, and COL3 is my tech’s name. I’ve already built the routine, but I can’t seem to get the macro to read from my CSV. I keep getting error logs:
[Line 11] Internal variable “!COL1” not supported, etc, so my best guess is that i’ve not stored the CSV in a datatable or variable properly.

So thats issue 1, issue 2 is getting the macro to repeat ForEachRow of the CSV.
See my code below. Thanks again for any help!

{
  "Name": "TicketSub",
  "CreationDate": "2022-3-24",
  "Commands": [
    {
      "Command": "csvRead",
      "Target": "Rounding List Ryan.csv",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "linkText=Create New",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[2]/div/div/div/div[2]/div[4]/div/ul/li[3]/a/span[2]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div/div/div/div/div/div/div/div/div[3]/input",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div/div/div/div/div/div/div/div/div[3]/input",
      "Value": "Frank Mauro",
      "Description": ""
    },
    {
      "Command": "pause",
      "Target": "3000",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "XClickRelative",
      "Target": "rhslfo_dpi_96.png",
      "Value": "",
      "Description": "Select Customer Name"
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div/div/div[2]/div/div/div/div/div/div/button",
      "Value": "",
      "Description": "Browse All Templates"
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/div[2]/div[2]/div/input",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "pause",
      "Target": "10000",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "xpath=/html/body/div[4]/div/div/div/div[2]/div[2]/div/input",
      "Value": "${!COL1}",
      "Description": "Rounding Location"
    },
    {
      "Command": "pause",
      "Target": "3000",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/div[3]/div/button",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "name=summary",
      "Value": "${!COL2}",
      "Description": "Department name"
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div[4]/div/div/div/div/div/div[2]/label/span[2]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[2]/div[5]/label/div/input",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[2]/div[5]/label/div/input",
      "Value": "${!COL3}",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[3]/div/div/div[2]/div/div[3]/span[2]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[3]/div[3]/div/div[2]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/div/div/button",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div[4]/div[3]/div/div/div/div/div[2]/label/span[2]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[2]/div[5]/label/div/input",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[2]/div[5]/label/div/input",
      "Value": "frank mauro",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[3]/div/div/div[2]/div/div/div",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[3]/div[2]/div/div[2]",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=/html/body/div[4]/div/div/div/div/div/button",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"main\"]/div/div[2]/div/button",
      "Value": "",
      "Description": ""
    },
    {
      "Command": "pause",
      "Target": "3000",
      "Value": "",
      "Description": ""
    }
  ]
}

I am not sure if spaces in file names are supported. => Maybe the CSV reading fails. That would explain why in line11 gives the “!COL1” not supported" error you mentioned.

to repeat ForEachRow of the CSV.

3 options:

(1) Use the Loop button

(2) Use WHILE (see DemoCsvReadWithWhile that comes with the RPA software)

(3) Instead of csvRead use csvReadArray and read the complete CSV file at once, see also How to mark a row in a CSV line as processed?

Thank you for the reply. I was able to successfully read the CSV and I see my columns in the variables tab with my original CSV file, however I just removed the spaces anyway (because why not). I can see those variables when I go to run the ${!COL} type command, however the command fails and those variables seemingly disappear from the tab.