Hi Team,
We are unable to use the Vendor Order API query to pull up closed (Archived) purchase orders.
For our needs, we want to do a refresh of the purchase order values in a target system, and we're using the vendor order search to pull that information however once the purchase order is archived, it is no longer retrievable via the search.
E.g. If I perform a GET request such as api/v1.0/companies/3/vendorOrders/?Stage=Archived it always returns nothing (empty array, []).
I've tried this in both our customer's build and the sandbox environment and it seems to return the same in both, however I wondered if anyone else had encountered this issue or knew of a solution.
Thanks in advance for your help,
Andy
Unable to search archived purchase orders
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.
Re: Unable to search archived purchase orders
Hi Andy,
Thank you for your message, we can confirm that's a bug, we will patch it in the next release.
cheers,
Rick
Thank you for your message, we can confirm that's a bug, we will patch it in the next release.
cheers,
Rick
Rick Lan
API Developer | simPRO Software Group
API Developer | simPRO Software Group
Re: Unable to search archived purchase orders
Hi,
Is there any update on this bug, given its been more than 5 years? I see it is still affecting.
Is there any update on this bug, given its been more than 5 years? I see it is still affecting.
-
SimproAPITeam
- Posts: 831
- Joined: Wed May 01, 2024 2:31 am
Re: Unable to search archived purchase orders
Hi Ashishs,
It works for me, Are you able to give more examples?
It works for me, Are you able to give more examples?
Simpro API Team | Simpro Software Group
Re: Unable to search archived purchase orders
Sorry, Stage=Archived is working.
But "/api/v1.0/companies/0/vendorOrders/" is not returning Archived records. Is that by design?
But "/api/v1.0/companies/0/vendorOrders/" is not returning Archived records. Is that by design?
-
SimproAPITeam
- Posts: 831
- Joined: Wed May 01, 2024 2:31 am
Re: Unable to search archived purchase orders
Hi,
Archived is returned for individual records like this:
The basic columns returned on list view are limited but you can assign the columns you need like this:
This can all be found in our documentation here:
https://developer.simprogroup.com/apido ... 3f69eb796f
Archived is returned for individual records like this:
Code: Select all
/vendorOrders/{id}Code: Select all
vendorOrders/?columns=ID,Archivedhttps://developer.simprogroup.com/apido ... 3f69eb796f
Simpro API Team | Simpro Software Group
DEVELOPER CENTER