Invoices endpoint not returning all invoices

Posts about the simPRO API. Help/support/how-to etc.
Forum rules
  • Check the documentation first. Before posting questions, please check the documentation to ensure it doesn't already cover what you need.
  • No spam. All automated messages, advertisements, and links to competitor websites will be deleted immediately.
  • Post in relevant sub-forums only. Messages posted in the wrong topic area will be removed and placed in the correct sub-forum by moderators.
  • Respect other users. No flaming or abusing fellow forum members. Users who continue to post inflammatory, abusive comments will be deleted from the forum after two warnings are issued by moderators.
  • Harassment. No threats or harassment of other users will be tolerated. Any instance of threatening or harassing behavior is grounds for deletion from the forums.
  • Adult content. No profanity or pornography is allowed. Posts containing adult material will be deleted.
  • Bandwidth. All images and signatures must be 500 x 500 pixels or smaller. Posts containing over-sized images and signatures will be removed.
  • Illegal content. No re-posting of copyrighted materials or other illegal content is allowed. Any posts containing illegal content or copyrighted materials will be deleted.
Post Reply
MarkIBI
Posts: 6
Joined: Thu Dec 10, 2020 9:21 pm

Invoices endpoint not returning all invoices

Post by MarkIBI » Thu Jul 07, 2022 1:47 pm

Hi

When querying the Invoices EndPoint not all the Invoices are being returned.
/api/v1.0/companies/0/invoices/?orderby=-ID&columns=ID

ID's 765 and 763 are missing from the list of ID's below
Screenshot 2022-07-07 144137.png
Screenshot 2022-07-07 144137.png (3.96 KiB) Viewed 10998 times
However, when specifying the invoice ID in the query the details are returned
/api/v1.0/companies/0/invoices/765
Screenshot 2022-07-07 144556.png
Screenshot 2022-07-07 144556.png (2.37 KiB) Viewed 10998 times
Are some invoices excluded from the Invoices endpoint?

Thanks
robbertcha
Posts: 416
Joined: Thu Apr 15, 2021 10:07 pm

Re: Invoices endpoint not returning all invoices

Post by robbertcha » Thu Jul 07, 2022 10:22 pm

Hi,

Do you mind to share us your build details via private message? we can check it for you, thank you
Robbert
API Developer | simPRO Software Group
robbertcha
Posts: 416
Joined: Thu Apr 15, 2021 10:07 pm

Re: Invoices endpoint not returning all invoices

Post by robbertcha » Tue Jul 12, 2022 1:13 am

Hi,

765 & 763 are credit notes, so they won't show on invoices endpoint, but showing the credit note details on invoice endpoint e.g.: api/v1.0/companies/0/invoices/765 is an issue, thank you for your information and we will send you an update when this issue is fixed and released, or please keep an eye on API release update, thank you.

API release update
viewforum.php?f=3
Robbert
API Developer | simPRO Software Group
AvidTheProgrammer
Posts: 1
Joined: Tue Jul 19, 2022 4:15 am

Re: Invoices endpoint not returning all invoices

Post by AvidTheProgrammer » Tue Jul 26, 2022 2:17 am

I am not sure if this is the same issue but my company is also not getting invoices back. When searching with CustomerInvoiceSearch the past few weeks we've only gotten "{\"result\":[],\"error\":null,\"id\":1}\n" and the like back, even when we know there are invoices in the time period. This code has been working for a year until recently.
Sindre
Posts: 493
Joined: Wed Apr 20, 2022 4:51 am
Location: Brisbane

Re: Invoices endpoint not returning all invoices

Post by Sindre » Wed Jul 27, 2022 12:35 am

Hi AvidTheProgrammer,

The endpoint for customer invoices in deprecated so it's no longer updated but there are no changes so it should still work fine. I did a test on our local build.

To help you please send me a private message with some screenshots and information of what endpoints you are using and if there are any special search parameters you are using.

Also send me your local build details so I can troubleshoot in your environment.

Regards
Sindre
API Developer | Simpro Software Group
Post Reply