Page 1 of 1
[Patched] /tasks endpoint returns 404 "Quote not found"
Posted: Thu Jul 09, 2020 6:51 am
by 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.
Re: /tasks endpoint returns 404 "Quote not found"
Posted: Thu Jul 09, 2020 7:17 am
by 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.
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Fri Jul 10, 2020 3:42 am
by gavinhodge
Thanks Muqeet, much appreciated.
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Mon Jul 13, 2020 4:54 am
by 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
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Mon Jul 13, 2020 5:21 am
by 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
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Mon Aug 03, 2020 5:44 am
by 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.
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Mon Aug 03, 2020 11:28 pm
by Muqeet
Please check your private message.
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Tue Aug 04, 2020 6:19 am
by 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
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Thu Aug 27, 2020 1:31 am
by 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
Re: [API-817] /tasks endpoint returns 404 "Quote not found"
Posted: Thu Aug 27, 2020 1:35 am
by Muqeet
Please send me the DM anyway with details, thanks.