Hey All,
I’ve been attempting to fetch the contents of this Generic Inquiry (screenshot 1) to no avail.
I have the columns I require in the Generic Inquiry but not in the Webservice Endpoint.
I modified the Generic Inquiry to left join SOOrder to SOShipline (screenshot 2) and was able to successfully request the two additional columns (LotSerialNbr, ExpiryDate) via the “View Inquiry” button. (screenshot 1)
Attempting to retrieve the content via the Webservice endpoint has yielded no answer however. Here is my raw get request and here is the modifications i’ve made via the Webservice endpoint GUI (screenshot 3) :
/SalesOrder?$expand=Shipments&$select=Shipments/InvoiceType,Shipments/InvoiceNbr,Shipments/ShippedQty,Shipments/ExpiryDate,Shipments/LotSerialNumber
The moment I modify the select statement to include Shipments/LotSerialNbr and Shipments/ExpiryDate, the shipment section returns the default state
"OrderNbr": {
"value": "015263"
},
"Shipments": [
{
"id": "afe97e3d-0289-46ec-85ca-7ab877bf0002",
"rowNumber": 1,
"note": null,
"LotSerialNbr": {},
"custom": {}
}
],
"custom": {}
How do i access this information from inside of a /SalesOrder route,
Thanks for your time,
Chris
Best answer by rosenjon
View original