DataService not returning expected records for Invoice and InvoiceItem tables about infusionsoft.net

[mfairch]

Is it possible that you have more than 1000 Invoices from 2014-05? I think its likely since you are asking for the InvoiceItem table.

[piranout]

No, there are under 300 invoices in this period. Under 350 invoice items as well. There are no "Get" methods on the Invoice service, so I can't use that as a working reference to compare the raw RPC calls. I did compare the Invoice & InvoiceItem calls against a Company and Contact RPC calls that work as expected, and I don't see any significant structural differences in the XML.

[jhallam3]

Hi there.

Your code is fine... Numbering starts at 0.

try page = 0.

my code is and works..
var queryData = new XmlRpcStruct() { { "DateCreated", "2015%" } };
var invoiceItems = client.DataService.Query(
table: "InvoiceItem",
limit: 1000,
page: 0,
queryData: queryData,
selectedFields: new[]
{
"Id" //, "InvoiceAmt", "DateCreated", "Description", "Discount", "OrderItemId"//, "CustomFields"
})
.ToList();