[Patched] Error with job / customer invoices endpoint

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
gavynj
Posts: 13
Joined: Fri May 01, 2020 1:34 am

[Patched] Error with job / customer invoices endpoint

Post by gavynj » Sun Dec 06, 2020 8:05 pm

Hi there,

This query has been working fine up until around 2am (NZDT) this morning:

/api/v1.0/companies/{companyID}/jobs/{jobID}/invoices/{invoiceID}?columns=ID,Type,IsCredit,IsVoided,Retention

If I remove Retention from the columns parameter it works, but obviously doesn't return the Retention object.

A 500 error is now returned:

Code: Select all

{
    "error": "Could not process your request. Please contact support."
}
What has changed? Our 1am import ran fine, but not since.

I will likely just remove the columns parameter so that everything is returned but would be good to know what's going on.

Cheers,
Gavyn
gavynj
Posts: 13
Joined: Fri May 01, 2020 1:34 am

Re: Error with job / customer invoices endpoint

Post by gavynj » Sun Dec 06, 2020 10:12 pm

Further to this, it looks like all Retention data is currently showing as 0 via the API, even though the website shows the correct value:

Code: Select all

"Retention": {
        "ExTax": 0,
        "IncTax": 0
}
Previously imported data for the invoice I'm testing with:

Code: Select all

"Retention": {
        "ExTax": 432.76,
        "IncTax": 497.67
}
rick.lan
Posts: 274
Joined: Wed May 30, 2018 6:14 am

Re: Error with job / customer invoices endpoint

Post by rick.lan » Sun Dec 06, 2020 11:30 pm

Hi Gavyn,

Thank you for your message, this is caused by the latest changes we had in our core system, we are investigating the issue now and will release a patch ASAP.

cheers,
Rick Lan
API Developer | simPRO Software Group
vaughan
Posts: 43
Joined: Wed May 30, 2018 6:14 am

Re: Error with job / customer invoices endpoint

Post by vaughan » Mon Dec 07, 2020 6:05 am

This issue should now be fixed.

Please let us know if you encounter any further issues.
gavynj
Posts: 13
Joined: Fri May 01, 2020 1:34 am

Re: Error with job / customer invoices endpoint

Post by gavynj » Mon Dec 07, 2020 6:52 am

Thanks, the query no longer returns an error, but all the retention values still seem to be $0.

Let me know if you want an examples.
Muqeet
Posts: 772
Joined: Mon Dec 03, 2018 3:24 am

Re: Error with job / customer invoices endpoint

Post by Muqeet » Mon Dec 07, 2020 7:23 am

Hello Gavyn,

We are investigating the issue on our end, we will let you know with any updates soon.
Muqeet
API Developer | simPRO Software Group
csjohnst
Posts: 1
Joined: Fri Oct 15, 2021 8:39 am

Re: [Patched] Error with job / customer invoices endpoint

Post by csjohnst » Fri Oct 15, 2021 8:41 am

Was there ever a resolution to this?

We've just come across the same
Attachments
Retention.png
Retention.png (31.6 KiB) Viewed 12283 times
robbertcha
Posts: 416
Joined: Thu Apr 15, 2021 10:07 pm

Re: [Patched] Error with job / customer invoices endpoint

Post by robbertcha » Sun Oct 17, 2021 11:24 pm

Hi csjohnst,

The problem has been fixed, but do you mind to provide us your build details and the invoice ID you looking at via private message? because it seems working fine on our end.

Image


By the way, 'customerInvoices' endpoint is deprecated (we are still support it if any mistakes), please use another new endpoint for invoice.

Except credits are not yet included in the new endpoints, we have support for regular invoices like, tax invoice, progress claims etc. In addition to that we also have full support of retention claims.

New Invoice Endpoint
https://developer.simprogroup.com/apido ... 3103f46fd3
Robbert
API Developer | simPRO Software Group
robbertcha
Posts: 416
Joined: Thu Apr 15, 2021 10:07 pm

Re: [Patched] Error with job / customer invoices endpoint

Post by robbertcha » Tue Oct 19, 2021 11:20 pm

Hi all,

We are investigating the issue on our end now, and patch it on next release, thanks for your waiting.


API release updates
viewtopic.php?f=3&t=1568
Robbert
API Developer | simPRO Software Group
Post Reply