Currently I keep employee information in Creator but what I am trying to do is pull it from Reports.

What I have currently is the following:

for each var in Harvesters  [Team = input.Team]

{

    insert into Harvesters_Daily

    [

        Added_User = zoho.loginuser

        EEID = var.EEID

        Harvester_ID = var.Harvester_ID

        Id1 = input.ID

        Name = var.Name

        Team = var.Team

        Team_Position = var.Team_Position

    ]

}

^This creates a new record for each harvester for the specified team

What I would like to do is create a new record for each harvester (row)  from my Reports table so something like:

ticketDetails = getUrl(("https://accounts.zoho.com/login?servicename=ZohoReports&FROM_AGENT=true&LOGIN_ID=<USERNAME>&PASSWORD=<PASSOWRD>"));

ticket = (ticketDetails.toString()).subString(((ticketDetails).indexOf("TICKET=")  +  7),((ticketDetails).indexOf("RESULT")  -  1));

query = "select Gang, member_number, h01_emp_num from member_list";

url = getUrl("https://reportsapi.zoho.com/api/jpiajr/Harvester_Wage/member_list?ZOHO_ACTION=EXPORT&ZOHO_OUTPUT_FORMAT=HTML&ZOHO_ERROR_FORMAT=XML&ZOHO_API_KEY=<API KEY>&ticket=" + ticket + "&ZOHO_API_VERSION=1.0&ZOHO_SQLQUERY=" + query);

response = getUrl(url);

result = response.executeXPath("/root/response/result/rows/text()");

listvar = result.toList("");

for each var in listvar

{

    insert into Harvesters_Daily

    [

        Added_User = zoho.loginuser

        Id1 = input.ID

        Harvester_ID = var.h01_emp_num

        EEID = var.member_number

        Team = var.Gang

    ]

}

But I receive an error "Variable 'var' is not decalred"

Is there anyway to iterate records based on the data recieved from reports?

OR

Can I update my employee table (view) in Creator based to my employee table in Reports and have this done on a daily or weekly schedule?