Hi...we are in the middle of converting to Acumatica and I am just beginning to get into the API for integrating with our other internal systems.
I have figured out how to use ODatav4 to read stock items. I even figured out how to use a “Navigation Property” (by trial & error) to pull in the item class description. Below is the current request broken down for readability.
But now I also want to pull all of the Cross-References (customer item numbers) for a given inventory item. The Cross-References show as another DAC - INItemXRef - but there doesn’t seem to be any navigation property from the InventoryItem DAC to it. Can I pull in this related information with an $expand clause? Or do I just need to query the INItemXRef separately and combine them manually?
Thanks!
https://<company>.acumatica.com/ODatav4/<tenant>/PX_Objects_IN_InventoryItem?
$select=InventoryCD,Descr,ItemStatus,BaseUnit
&$filter=ItemStatus eq 'AC'
&$expand=INItemClassByItemClassID($select=ItemClassCD)