I have created a View in Zoho Analytics that is a summary of "Previous Month" support Hours by "Account Name" - I want to ingest this data into Zoho Books and produce a single invoice for each "Account Name" with each unique TicketID (ROW) as an item [Generic Item Name - Ticket info is Description]. This would stage my invoices in "Draft" so I can verify/send on a monthly basis.

Any ideas here?

I have created the SQL to pull the information from zDesk via my Analytics connection.

SELECT  "Tickets"."Request Id", "Accounts"."Account Name" as "Account Name",CONCAT('Tkt# ', "Tickets"."Request Id", ': ', "Tickets"."Subject") as "Ticket Details", "Tickets"."Status" as "Status",

DATE("Tickets"."Created Time") as "Ticket Created Dt", MAX(DATE("Time Entry"."Created Time")) as "Last Time Entry Dt", sum(round("Time Entry"."Seconds Spent"/60/60,2)) as "Hours Entered"

from "Time Entry"

JOIN "Tickets" ON "Tickets"."ID" = "Time Entry"."Request"

            JOIN "Agent" ON "Time Entry"."Agent" = "Agent"."ID"

            JOIN "Contacts"ON "Tickets"."Contact ID" = "Contacts"."ID"

            JOIN "Accounts" ON "Contacts"."Account ID" = "Accounts"."ID"

            where

DATE("Time Entry"."Created Time")

BETWEEN start_day(month,previous_nmonth(current_date(),1)) AND end_day(month,previous_nmonth(current_date(),1))

GROUP BY "Tickets"."Request Id", "Ticket Details", DATE("Tickets"."Created Time"), "Accounts"."Account Name","Tickets"."Status"

ORDER BY "Tickets"."Request Id" ASC