Hi! I am creating a customer service application. Since customer support usually have a customer on the line, i would like to use the fastest method to get Invoice list containing the customer name. I would like something similar to the list that is in Zuora Invoices. To get the list I am using a query "queryString": "Select accountid, amount, AmountWithoutTax, Balance, CreatedDate, DueDate, Id, IncludesOneTime, IncludesRecurring, InvoiceDate, InvoiceDate, InvoiceNumber, LastEmailSentDate, PaymentAmount, RefundAmount, Status, TargetDate from Invoice" It would have been brilliant if I could use Account.Name in it, but it seems that is not possible as its a ZOQL and not export. So far the only options I have found is either get the account names in a seperate api call or to use an ZOQL Export. Neither of this methods seems like they are efficient. So I am wondering if there is a easier way to get the name of the account on a invoice?
... View more