Hi,
We are trying to get below datapoints via GraphQL API call.
Purchaser Order Status
Purchase Order Line Item Status
Warehouse Note
I see Fulfillment status with in Purchase order and PO Line Items object and both have the same values and doesn’t match with PO line Item status. Can you please let me know if its possible to fetch the above mentioned data and what those data points are?
Thanks!
Thanks for reaching out and Welcome to our Developer Community!
I see what you mean when you said the purchase order status and the purchase order line item status have the same value, but that doesn’t match with what the PO line item status value should be.
What field are you talking about when you mention warehouse_note?
Also, we have a PO Update Webhook that might be useful to you. It has numerous fields related to a PO whenever it is updated, such as the line item quantity, quantity received, and overall PO status. If this interests you, you can read more about it here.
Please let me know if you have any questions or concerns!
Hi @Rayanp,
Thanks for your response. I am specifically looking to get PO level status, PO LineItem level status which I highlighted in the below screenshot.
I think your first point regarding the PO level status might not be working as intended through the api. I’m looking into this to confirm the expected behavior.
I can confirm that the warehouse note you see in that column is the packing_note under the purchase_order(s) query in the Public API.
An example query that returns the warehouse note as well as units and units received would look something similar to this:
Hi @Rayanp,
I was hoping to use the existing PO GraphQL api to fetch the purchase order which was updated on a certain day/days for ex- the previous day. I understand we could use the webhook but thats not something we can use right now.
I believe right now we can use created from - to, po created from -to, closed from - to dates to filter. For our use case we want updated from - to. Is that a possibility?
Please let me know if there is any additional information I can provide here. Any guidance here is appreciated.
Thanks!
I’ve gone ahead and escalated the PO line item and PO level status having the same value issue as a bug. I’ll let you know when a fix has been rolled out here.
I have passed along your feedback regarding using “updated” as a filter for the PO queries, but I don’t have anything to report at the moment.
Please let me know if you have any questions or concerns.
I have no updates to share at this moment regarding the addition of the addition of the “updated” filter for the PO Query.
The second issue that I thought was a bug, has since been passed along as feedback to add the ability to return the line item status through the PO Query as well.
Please let me know if you have any questions or concerns.
Do we have any update on adding the the updated filter for the purchase order query? And also looks like the fulfillment status issue we discussed still exists. Because of these items we are facing issues in the report we generate. Any update or timeline of when these will be fixed is greatly appreciated.
Unfortunately, I have no update for both instances of feedback. I’m unable to disclose most details regarding this process, but I can ensure you that I’ve passed along your concerns and sense of urgency.
Please let me know if there’s anything I can do to assist in the meantime.