Filtered Job API Issue

[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

[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

[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

[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

[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