# Purchase Order Data - GraphQL API
**URL:** https://community.shiphero.com/t/purchase-order-data-graphql-api/2429
**Category:** GraphQL API
**Created:** [April 11, 2023, 4:21am UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429 "2023-04-11T04:21:05Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [April 11, 2023, 4:21am UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/1 "2023-04-11T04:21:05Z")
Hi,
We are trying to get below datapoints via GraphQL API call.
1. Purchaser Order Status
2. Purchase Order Line Item Status
3. 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!
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [April 11, 2023, 11:55am UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/2 "2023-04-11T11:55:21Z")
Hey @kavitha,
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](https://developer.shiphero.com/webhooks#po-update-webhook).
Please let me know if you have any questions or concerns!
Best,
RayanP
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [April 11, 2023, 1:13pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/3 "2023-04-11T13:13:35Z")
Hi @sh-agent,
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 believe the api value for Warehouse Note which you can see in the below screenshot is packing\_note. Can you please confirm if I am correct?
Is there a way to get # of Units and # of Units Recieved from PO graphql endpoint?
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [April 11, 2023, 1:41pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/4 "2023-04-11T13:41:01Z")
Hey Team,
Thanks for hanging in there!
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:
```auto
{
purchase_orders(warehouse_id: "string") {
request_id
complexity
data(first: 5) {
edges {
node {
id
legacy_id
fulfillment_status
po_note
packing_note
line_items {
edges {
node {
id
quantity
quantity_received
quantity_rejected
fulfillment_status
}
}
}
}
}
}
}
}
```
Please let me know if you have any questions or concerns.
Best,
RayanP
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [April 12, 2023, 3:27am UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/5 "2023-04-12T03:27:42Z")
Hi @sh-agent,
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!
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [April 12, 2023, 11:38am UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/6 "2023-04-12T11:38:33Z")
Hey Team,
Thanks for hanging in there!
I’ll go ahead and pass along your feedback regarding this issue, as using updated\_from and updated\_to are not current filters for this webhook.
Please let me know if you have any questions or concerns.
Best,
RayanP
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [April 19, 2023, 6:46pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/7 "2023-04-19T18:46:03Z")
@sh-agent Do you have any updates on below items?
1. Adding updating to the purchase order filters
2. PO level and PO line item level status which you mentioned might not be working as intended in your earlier comments.
Thanks
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [April 19, 2023, 7:02pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/8 "2023-04-19T19:02:55Z")
Hey @kavitha,
Thanks for hanging in there!
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.
Best,
RayanP
---
### Author:  [@TBaxter](https://community.shiphero.com/u/TBaxter)
#### Post date: [April 26, 2023, 5:48pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/9 "2023-04-26T17:48:15Z")
Hi, any update on this bug? Thanks
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [May 3, 2023, 5:59pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/10 "2023-05-03T17:59:10Z")
Hi @sh-agent,
Do we have any update on the above items?
Thanks
Kavitha
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [May 3, 2023, 6:38pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/11 "2023-05-03T18:38:50Z")
Hey Team,
Thanks for hanging in there!
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.
Best,
RayanP
---
### Author:  [@TBaxter](https://community.shiphero.com/u/TBaxter)
#### Post date: [May 9, 2023, 2:41am UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/12 "2023-05-09T02:41:40Z")
Hi, any update on the bug?
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [May 17, 2023, 6:38pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/13 "2023-05-17T18:38:30Z")
Hi @sh-agent,
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.
Thanks
Kavitha
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [May 18, 2023, 12:02pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/14 "2023-05-18T12:02:56Z")
Hey Team,
Thanks for hanging In there!
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.
Best,
RayanP
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [June 12, 2023, 3:03pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/15 "2023-06-12T15:03:59Z")
Hi @sh-agent,
Happy Monday! Just checking in to see if there is any update here?
Thanks
Kavitha
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [June 12, 2023, 5:12pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/16 "2023-06-12T17:12:25Z")
Hey Team,
Thanks for hanging in there!
Regarding the updated to and updated from filters, there is no update.
In regards to the second part, the issue of having the line items return statuses such as “received” or “under received” this will not be done. That is a calculation that is done on our front end. Therefore, no table exists in our database with that information to pull. You can discern that value through the API by comparing the expected and received quantity.
Please let me know if you have any questions or concerns.
Best,
RayanP
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [June 13, 2023, 1:39pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/17 "2023-06-13T13:39:52Z")
Hi @sh-agent,
Could you please let us know what all PO Line Items statuses we can expect and what will the comparison btw expected and received quantity will be for each status?
For ex -
Recieved \> Ordered - Over Received
Recieved = Ordered - Received
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [June 14, 2023, 7:29pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/18 "2023-06-14T19:29:45Z")
Hey @kavitha,
Thanks for hanging in there!
I believe all the PO Line Item statuses you will receive are “pending” and “complete” in relation to the Purchase Order.
By comparing the expected and received quantity you can discern the “received” status that the UI shows:
if the quantity expected is 50 but you’ve received 40, it’s under received.
if the quantity expected is 50 but you’ve received 50, it’s received.
if the quantity expected is 50 but you’ve received 60, it’s over received.
Please let me know if you have any questions or concerns.
Best,
RayanP
---
### Author:  [@kavitha](https://community.shiphero.com/u/kavitha)
#### Post date: [June 23, 2023, 6:45pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/19 "2023-06-23T18:45:48Z")
Hi @sh-agent,
The PO line item statuses we receive via api is not always pending and complete as you mentioned. I have highlighted in the below image.
And the status show in the shiphero application doesn’t match with the api data which I have shown in the below screen shots. Its bit confusing with theses statuses. Could you please provide clarification on these mismathes and what all status we can expect for PO status and PO line items status?
---
### Author:  [@sh-agent](https://community.shiphero.com/u/sh-agent)
#### Post date: [June 26, 2023, 5:37pm UTC](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429/20 "2023-06-26T17:37:40Z")
Hey @kavitha,
Thanks for bringing this to my attention.
I’ll sync with the team again and get back to you on this.
Best,
RayanP
[Next page](https://community.shiphero.com/t/purchase-order-data-graphql-api/2429.md?page=2)