Sumamry: I have a scenario in which need to Read google sheet and then filter rows based on the project status =Completed and group by customer id and raise invoice if for same customer id there is 2 services status is completed then I need both the items to be mentioned in same invoice. google sheet contains all data along with service, cost for each service and everything. currently in grouping and generating properly but in Zoho invoice I’m not able to access other fields using array . In Google sheet I have all other details like template id, tax rate, discount, everything because in array aggregator I have used target structure type to Zoho line items.
One more option I tried was I used custom and aggregated all fields in in array aggregator and during Zoho invoice like items I mapped the whole array of output of array aggregator but got error stating missing item id, rate, quantity.
