[Released]List all job work orders query issue

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
brendonv
Posts: 4
Joined: Tue May 16, 2023 5:58 am

[Released]List all job work orders query issue

Post by brendonv » Mon Jul 03, 2023 1:46 pm

Hi,

I have an application that retrieves job work orders for a specific job. The endpoint has recently (within the last 2 weeks) stopped working and now responds with a Request failed with status code 500

The endpoint I am accessing is a get request to:

Code: Select all

/api/v1.0/companies/{companyID}/jobWorkOrders/?Project.ID={jobID}
I can retrieve a specific work order using just the ID indicating query parameters still work on the jobWorkOrders endpoint

Code: Select all

/api/v1.0/companies/{companyID}/jobWorkOrders/?ID={jobWorkOrderID}
Is there a reason the nested Project.ID query filter has stopped working?
According to the example docs nested queries are valid:

https://developer.simprogroup.com/apido ... -resources
Search in nested columns by specifying Column1.Column2:

Code: Select all

GET /api/v1.0/companies/?Address.Line2=%25NSW%25
Top
Sindre
Posts: 493
Joined: Wed Apr 20, 2022 4:51 am
Location: Brisbane

Re: List all job work orders query issue

Post by Sindre » Mon Jul 03, 2023 11:27 pm

Hi brendonv,
Thank you for reporting this.

We will investigate to see what has been changed on this endpoint and why your query is no longer working.

Regards
Sindre
API Developer | Simpro Software Group
Top
brendonv
Posts: 4
Joined: Tue May 16, 2023 5:58 am

Re: List all job work orders query issue

Post by brendonv » Mon Jul 10, 2023 7:56 am

Hi,

Any updates for this please?
Top
Sindre
Posts: 493
Joined: Wed Apr 20, 2022 4:51 am
Location: Brisbane

Re: List all job work orders query issue

Post by Sindre » Mon Jul 10, 2023 11:27 pm

Hi brendonv,
Yes, we have done some updates for this issue. Please follow our upcoming release notes for details.

Regards
Sindre
API Developer | Simpro Software Group
Top
Post Reply

Return to “General Discussion”