...
Here is an example with the tracking number: https://mysekoapi.sekologistics.io/tracking-service/track/NR1865881
Try to find the Shipment Data
exec sp_executesql N'SELECT TOP 1 * FROM dbo.OrdOrder WHERE Number = @trackingNumber',N'@trackingNumber nvarchar(8)',@trackingNumber=N'21720895'Source Code Repository: https://bitbucket.org/sekologistics/myseko-track-api/src/develop/
Source SQL Query (Subject to change. See Source Code for current query details)
| Code Block | ||
|---|---|---|
| ||
USE HarmonyStore
DECLARE @TypeOrderIdDomestic uniqueidentifier = 'fe2ba03d-1c5e-4475-9280-cf89b282baf3'
DECLARE @TypeOrderIdInternational uniqueidentifier = '60b8d5a0-b1fb-4817-ae38-c5b254c6b26f'
SELECT TOP 1 * FROM dbo.OrdOrder WHERE Number = @trackingNumber AND TypeOrderID IN (@TypeOrderIdDomestic, @TypeOrderIdInternational) |