dotConnect for Magento

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Cloud Applications
Post Reply
kwasek83
Posts: 2
Joined: Tue 30 Aug 2016 13:55

dotConnect for Magento

Post by kwasek83 » Thu 09 Feb 2017 14:26

Hello,
I need to extract Shipping Arrival Date? This is crucial point of ordering this addin

thank you

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dotConnect for Magento

Post by Pinturiccio » Mon 13 Feb 2017 13:26

Magento API does not allow getting such data. There is a SalesOrderShipments entity in Magento. You can only get the creation date of a shipment via the following query:

Code: Select all

SELECT sh.created_at as "Shipping Create Date", o.*  FROM "SalesOrderShipments" AS sh inner join SalesOrders o ON sh.order_id = o.order_id

Post Reply