Hello,
I have a design question. I am trying to download/sync all of our invoice/invoice line item data to our front end eCommerce application so customers can view their invoices.
At the moment, I have it working using the Rest API endpoint but its very slow and I keep hitting our license limits. I have been porting all my RestAPI calls to using oData on top of a GI. This is MUCH faster and has relieved the pressure on the API calls. The invoice sync is the last one I need to do.
I am struggling to figure out how to “find” that data. I do have all the invoices downloaded via these entities.
I can’t figure out how to get the invoice line items. What entities should I query?
For my sales order sync, I download all the sales orders, and then download all the line items. My sync process joins the data together in my eCommerce app DB. Its very fast. I am looking to do a similar approach here.
I am open to tapping into the oData4 endpoint if that is a better option.
Any help would be greatly appreciated!
Best answer by Naveen Boga
View original