[Patched] /tasks endpoint returns 404 "Quote not found"

[gavinhodge]

Hi there,

I'm trying to fetch tasks using the API. The first few pages worked fine, but when reaching a certain page we get a 404 with this message:

Code: Select all

{"errors":[{"path":null,"message":"Quote not found.","value":null}]}

The URL in question is

Code: Select all

/api/v1.0/companies/{companyId}/tasks/?orderby=DateModified&pageSize=100&page=8&columns=ID%2CSubject%2CAssignedTo%2CAssignees%2CAssignedToCustomer%2CCompletedBy%2CAssociated%2CIsBillable%2CShowOnWorkOrder%2CDescription%2CStartDate%2CDueDate%2CCompletedDate%2CNotes%2CStatus%2CPriority%2CCategory%2CEstimated%2CActual%2CParentTask%2CSubTasks%2CCustomFields%2CPercentComplete%2CDateModified&display=all

Any clues?

Gavin.

[Muqeet]

Hi Gavin,

I have looked into the issue, it caused by a non-existent quote referenced to a task. We will patch this issue by not loading the associations when not exist anymore.

Thanks.

[gavinhodge]

Thanks Muqeet, much appreciated.

[johann]

Hi Muqeet,

Will this patch be in the next release, and when is the next release due? (actually is there a list of expected release dates anywhere?)

Thanks!
Johann

[Muqeet]

Hi Johann,

The patch will be in next simPRO release 20.3.2 which is due to be released in two weeks (26th july approx.). simPRO builds are updated in stages, so you may be updated to the latest version up to a week after the initial release.

You can get more details about simPRO releases from link below.

https://helpguide.simprogroup.com/Conte ... -Notes.htm

[gavinhodge]

Still getting similar but different errors after the update.

Usual error returned:

Code: Select all

{"errors":[{"path":null,"message":"Job not found.","value":null}]}

This one has also been seen for one customer:

Code: Select all

{"errors":[{"path":null,"message":"API column \"mdl.date_modified\" is not defined in builder \"SimPRO\\RestAPI\\Builder\\Tasks\\Tasks\".","value":null}]}

Sample URL of API request:

Code: Select all

/api/v1.0/companies/{companyId}/tasks/?orderby=DateModified&pageSize=100&page=1&columns=ID%2CSubject%2CAssignedTo%2CAssignees%2CAssignedToCustomer%2CCompletedBy%2CAssociated%2CIsBillable%2CShowOnWorkOrder%2CDescription%2CStartDate%2CDueDate%2CCompletedDate%2CNotes%2CStatus%2CPriority%2CCategory%2CEstimated%2CActual%2CParentTask%2CSubTasks%2CCustomFields%2CPercentComplete%2CDateModified&display=all

DM me if you need the subdomain / company id.

Gavin.

[Muqeet]

Please check your private message.

[Muqeet]

Patch for this bug did not release with 20.3.2, apologies for that. It has now been scheduled to get released with 20.3.3

[johann]

Hi Muqeet,

We've tried to run this again after the latest patch and while "Quote not found" seems to be fixed we're still getting "Job not found" errors.

The error:

Code: Select all

{"errors":[{"path":null,"message":"Job not found.","value":null}]}

Sample of the url:

Code: Select all

/api/v1.0/companies/{companyId}/tasks/?orderby=DateModified&pageSize=100&page=1&columns=ID%2CSubject%2CAssignedTo%2CAssignees%2CAssignedToCustomer%2CCompletedBy%2CAssociated%2CIsBillable%2CShowOnWorkOrder%2CDescription%2CStartDate%2CDueDate%2CCompletedDate%2CNotes%2CStatus%2CPriority%2CCategory%2CEstimated%2CActual%2CParentTask%2CSubTasks%2CCustomFields%2CPercentComplete%2CDateModified&display=all

Can provide the company and domain via DM if needed - but I suspect it will be a very similar issue to the Quotes one.

Thanks,
Johann

[Muqeet]

Please send me the DM anyway with details, thanks.