Forum Discussion

Mike_James's avatar
Mike_James
Ultimate Cover User
2 months ago
Solved

Sale/Invoice/Item GET request returns 2 invoices short

In a GET request today, the control count was 404, but only 402 invoice records were received. Repeated with same result.

 

URL: https://arl2.api.myob.com/accountright/<fileID>/Sale/Invoice/Item?$top=400&$filter=Date ge datetime'2025-04-01'

Has anyone had the same experience?

Can MYOB offer an explanation? It's hard to provide accurate sales reports when this happens.

  • Thanks Doreen_P​ . I've already done that. I posted here to see if any other developers have had this experience, and get their responses. 

    I also exported all the item invoices to a file, extracted the invoice numbers and compared them with a list of invoice numbers taken from the JSON files included in the API response. Since there were 403 in each set, I concluded that no other invoice is missing from the response.

3 Replies

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 months ago

    Partial answer. Since I knew one of the missing invoices, I edited it, added a full-stop in the comment field and voila! the invoice appeared in the next JSON response. But the other one??

  • Mike_James's avatar
    Mike_James
    Ultimate Cover User
    2 months ago

    Thanks Doreen_P​ . I've already done that. I posted here to see if any other developers have had this experience, and get their responses. 

    I also exported all the item invoices to a file, extracted the invoice numbers and compared them with a list of invoice numbers taken from the JSON files included in the API response. Since there were 403 in each set, I concluded that no other invoice is missing from the response.