Page 1 of 1

Filtered Job API Issue

Posted: Wed Jan 29, 2025 2:42 am
by Jourdan
Hi Simpro team,

Could I please have a Simpro tech look into the below as this API and similar ones were working previously and now arn't.

I'm having an issue with jobs API routes using specific filters for custom fields, technicians and stage.
The Sandbox version of this API route works perfectly, however not in our company build which is causing me to think there is an issue with our build.

Routes below are tested using Postman.

Sandbox API route:
enterprise-sandbox-au.simprosuite.com/api/v1.0/companies/{CompanyID}/jobs/?columns=Customer&CustomFields.CustomField.ID={ID}&CustomFields.Value=Yes&Technicians.ID={ID}&Stage=in(Pending,Complete,Progress)

Company API route:
{companySubDomain}.simprosuite.com/api/v1.0/companies/{CompanyID}/jobs/?columns=Customer&CustomFields.CustomField.ID={ID}&CustomFields.Value=Yes&Technicians.ID={ID}&Stage=in(Pending,Complete,Progress)

If I remove the custom field part of the filter from the route it works, however the custom field ID and custom field value are 100% correct after checking mutliple times, also again this was an API that once worked.

Thank you for the help,
Kind Regards,
Jourdan

Re: Filtered Job API Issue

Posted: Wed Jan 29, 2025 9:58 pm
by AndyRees
Hi team,

We are seeing the same issue and it's heavily impacting a client service, so we'd appreciate an urgent look into the issue

We've raised a similar issue before that was eventually fixed, but may be related to this new issue:
viewtopic.php?f=2&t=2654&p=7153#p7153

Let us know when it's resolved as we now have to query every job and filter on custom field value manually within the service, which is very inefficient and requires a lot more calls to the Jobs API each service run

Thanks,
Andy

Re: Filtered Job API Issue

Posted: Mon Feb 10, 2025 2:09 am
by Jourdan
Hi Simpro Team,

I'm hoping this can be looked at as a high priority.
This issue is stopping a key workflow for our job management.

Again this API works in sandbox but not in our build.
API request returns 200 OK with no returned data.

Cheers,
Jourdan

Re: Filtered Job API Issue

Posted: Fri Feb 14, 2025 12:29 am
by SimproAPITeam
Hi Jourdan,
This has been reported by other user and is being investigated.

Please also report issues when they arise to our helpdesk so they can verify and we can get an overview of the scope.
https://helpdesk.simprogroup.com/

If you submit an issue please include your build name and examples of the endpoint affected and relevant payloads or parameters used. This will help them recreate the issue.

Regards

Re: Filtered Job API Issue

Posted: Thu Feb 20, 2025 12:11 am
by Jourdan
Hi Team,

Thank you for the reply, I have just submitted a case through the help desk.
Hoping to have this resolved sooner than later as it is an integral part of our workflow.

Kind Regards,
Jourdan