Linnworks Connector Reference

25 metrics119 dimensions

Fields

The Linnworks connector exposes 144 fields (25 metrics, 119 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Linnworks Fields

Linnworks processed_order_details fields

The processed_order_details report of the Linnworks connector includes 15 fields.

Linnworks processed_orders fields

The processed_orders report of the Linnworks connector includes 62 fields.

Linnworks processed_orders fields (processed_orders__accountname to processed_orders__itemweight)

ID	Type	Name	Description
processed_orders__accountname	TEXT	processed_orders.AccountName	processed_orders.AccountName
processed_orders__address1	TEXT	processed_orders.Address1	processed_orders.Address1
processed_orders__address2	TEXT	processed_orders.Address2	processed_orders.Address2
processed_orders__address3	TEXT	processed_orders.Address3	processed_orders.Address3
processed_orders__billingaddress1	TEXT	processed_orders.BillingAddress1	processed_orders.BillingAddress1
processed_orders__billingaddress2	TEXT	processed_orders.BillingAddress2	processed_orders.BillingAddress2
processed_orders__billingaddress3	TEXT	processed_orders.BillingAddress3	processed_orders.BillingAddress3
processed_orders__billingcompany	TEXT	processed_orders.BillingCompany	processed_orders.BillingCompany
processed_orders__billingcountryname	TEXT	processed_orders.BillingCountryName	processed_orders.BillingCountryName
processed_orders__billingemailaddress	TEXT	processed_orders.BillingEmailAddress	processed_orders.BillingEmailAddress
processed_orders__billingname	TEXT	processed_orders.BillingName	processed_orders.BillingName
processed_orders__billingphonenumber	TEXT	processed_orders.BillingPhoneNumber	processed_orders.BillingPhoneNumber
processed_orders__billingpostcode	TEXT	processed_orders.BillingPostCode	processed_orders.BillingPostCode
processed_orders__billingregion	TEXT	processed_orders.BillingRegion	processed_orders.BillingRegion
processed_orders__billingtown	TEXT	processed_orders.BillingTown	processed_orders.BillingTown
processed_orders__buyerphonenumber	TEXT	processed_orders.BuyerPhoneNumber	processed_orders.BuyerPhoneNumber
processed_orders__cbillingaddress	TEXT	processed_orders.cBillingAddress	processed_orders.cBillingAddress
processed_orders__ccountry	TEXT	processed_orders.cCountry	processed_orders.cCountry
processed_orders__ccurrency	TEXT	processed_orders.cCurrency	processed_orders.cCurrency
processed_orders__cemailaddress	TEXT	processed_orders.cEmailAddress	processed_orders.cEmailAddress
processed_orders__cfullname	TEXT	processed_orders.cFullName	processed_orders.cFullName
processed_orders__channelbuyername	TEXT	processed_orders.ChannelBuyerName	processed_orders.ChannelBuyerName
processed_orders__company	TEXT	processed_orders.Company	processed_orders.Company
processed_orders__countrytaxrate	NUMERIC	processed_orders.CountryTaxRate	processed_orders.CountryTaxRate
processed_orders__cpostcode	TEXT	processed_orders.cPostCode	processed_orders.cPostCode
processed_orders__cshippingaddress	TEXT	processed_orders.cShippingAddress	processed_orders.cShippingAddress
processed_orders__dcancelledon	TEXT	processed_orders.dCancelledOn	processed_orders.dCancelledOn
processed_orders__dpaidon	TEXT	processed_orders.dPaidOn	processed_orders.dPaidOn
processed_orders__dprocessedon	TEXT	processed_orders.dProcessedOn	processed_orders.dProcessedOn
processed_orders__dreceiveddate	DATE	processed_orders.dReceivedDate	processed_orders.dReceivedDate
processed_orders__externalreference	TEXT	processed_orders.ExternalReference	processed_orders.ExternalReference
processed_orders__foldercollection	TEXT	processed_orders.FolderCollection	processed_orders.FolderCollection
processed_orders__fpostagecost	NUMERIC	processed_orders.fPostageCost	processed_orders.fPostageCost
processed_orders__ftax	NUMERIC	processed_orders.fTax	processed_orders.fTax
processed_orders__ftotalcharge	NUMERIC	processed_orders.fTotalCharge	processed_orders.fTotalCharge
processed_orders__fulfilmentlocationname	TEXT	processed_orders.FulfilmentLocationName	processed_orders.FulfilmentLocationName
processed_orders__holdorcancel	BOOLEAN	processed_orders.HoldOrCancel	processed_orders.HoldOrCancel
processed_orders__isexchange	BOOLEAN	processed_orders.IsExchange	processed_orders.IsExchange
processed_orders__isresend	BOOLEAN	processed_orders.IsResend	processed_orders.IsResend
processed_orders__itemweight	NUMERIC	processed_orders.ItemWeight	processed_orders.ItemWeight

Linnworks processed_orders fields (processed_orders__norderid to processed_orders__vendor)

ID	Type	Name	Description
processed_orders__norderid	NUMERIC	processed_orders.nOrderId	processed_orders.nOrderId
processed_orders__nstatus	NUMERIC	processed_orders.nStatus	processed_orders.nStatus
processed_orders__packagecategory	TEXT	processed_orders.PackageCategory	processed_orders.PackageCategory
processed_orders__packagetitle	TEXT	processed_orders.PackageTitle	processed_orders.PackageTitle
processed_orders__pkorderid	TEXT	processed_orders.pkOrderID	processed_orders.pkOrderID
processed_orders__postagecostextax	NUMERIC	processed_orders.PostageCostExTax	processed_orders.PostageCostExTax
processed_orders__postalservicecode	TEXT	processed_orders.PostalServiceCode	processed_orders.PostalServiceCode
processed_orders__postalservicename	TEXT	processed_orders.PostalServiceName	processed_orders.PostalServiceName
processed_orders__postaltrackingnumber	TEXT	processed_orders.PostalTrackingNumber	processed_orders.PostalTrackingNumber
processed_orders__profitmargin	NUMERIC	processed_orders.ProfitMargin	processed_orders.ProfitMargin
processed_orders__referencenum	TEXT	processed_orders.ReferenceNum	processed_orders.ReferenceNum
processed_orders__region	TEXT	processed_orders.Region	processed_orders.Region
processed_orders__secondaryreference	TEXT	processed_orders.SecondaryReference	processed_orders.SecondaryReference
processed_orders__source	TEXT	processed_orders.Source	processed_orders.Source
processed_orders__subsource	TEXT	processed_orders.SubSource	processed_orders.SubSource
processed_orders__subtotal	NUMERIC	processed_orders.Subtotal	processed_orders.Subtotal
processed_orders__taxid	TEXT	processed_orders.TaxId	processed_orders.TaxId
processed_orders__timediff	NUMERIC	processed_orders.timeDiff	processed_orders.timeDiff
processed_orders__totaldiscount	NUMERIC	processed_orders.TotalDiscount	processed_orders.TotalDiscount
processed_orders__totalweight	NUMERIC	processed_orders.TotalWeight	processed_orders.TotalWeight
processed_orders__town	TEXT	processed_orders.Town	processed_orders.Town
processed_orders__vendor	TEXT	processed_orders.Vendor	processed_orders.Vendor

Linnworks stock_items fields

The stock_items report of the Linnworks connector includes 31 fields.

ID	Type	Name	Description
stock_items__barcodenumber	TEXT	stock_items.BarcodeNumber	stock_items.BarcodeNumber
stock_items__batchnumberscanrequired	BOOLEAN	stock_items.BatchNumberScanRequired	stock_items.BatchNumberScanRequired
stock_items__categoryid	TEXT	stock_items.CategoryId	stock_items.CategoryId
stock_items__categoryname	TEXT	stock_items.CategoryName	stock_items.CategoryName
stock_items__creationdate	DATE	stock_items.CreationDate	stock_items.CreationDate
stock_items__depth	NUMERIC	stock_items.Depth	stock_items.Depth
stock_items__height	NUMERIC	stock_items.Height	stock_items.Height
stock_items__images	OBJECT	stock_items.Images	stock_items.Images
stock_items__inventorytrackingtype	NUMERIC	stock_items.InventoryTrackingType	stock_items.InventoryTrackingType
stock_items__isbatchedstocktype	BOOLEAN	stock_items.isBatchedStockType	stock_items.isBatchedStockType
stock_items__itemchanneldescriptions	OBJECT	stock_items.ItemChannelDescriptions	stock_items.ItemChannelDescriptions
stock_items__itemchannelprices	OBJECT	stock_items.ItemChannelPrices	stock_items.ItemChannelPrices
stock_items__itemchanneltitles	OBJECT	stock_items.ItemChannelTitles	stock_items.ItemChannelTitles
stock_items__itemextendedproperties	OBJECT	stock_items.ItemExtendedProperties	stock_items.ItemExtendedProperties
stock_items__itemnumber	TEXT	stock_items.ItemNumber	stock_items.ItemNumber
stock_items__itemtitle	TEXT	stock_items.ItemTitle	stock_items.ItemTitle
stock_items__metadata	TEXT	stock_items.MetaData	stock_items.MetaData
stock_items__packagegroupid	TEXT	stock_items.PackageGroupId	stock_items.PackageGroupId
stock_items__packagegroupname	TEXT	stock_items.PackageGroupName	stock_items.PackageGroupName
stock_items__postalserviceid	TEXT	stock_items.PostalServiceId	stock_items.PostalServiceId
stock_items__postalservicename	TEXT	stock_items.PostalServiceName	stock_items.PostalServiceName
stock_items__purchaseprice	NUMERIC	stock_items.PurchasePrice	stock_items.PurchasePrice
stock_items__retailprice	NUMERIC	stock_items.RetailPrice	stock_items.RetailPrice
stock_items__serialnumberscanrequired	BOOLEAN	stock_items.SerialNumberScanRequired	stock_items.SerialNumberScanRequired
stock_items__stockitemid	TEXT	stock_items.StockItemId	stock_items.StockItemId
stock_items__stockitemintid	NUMERIC	stock_items.StockItemIntId	stock_items.StockItemIntId
stock_items__stocklevels	OBJECT	stock_items.StockLevels	stock_items.StockLevels
stock_items__suppliers	OBJECT	stock_items.Suppliers	stock_items.Suppliers
stock_items__taxrate	NUMERIC	stock_items.TaxRate	stock_items.TaxRate
stock_items__weight	NUMERIC	stock_items.Weight	stock_items.Weight
stock_items__width	NUMERIC	stock_items.Width	stock_items.Width

Linnworks stock_location_details fields

The stock_location_details report of the Linnworks connector includes 15 fields.

Linnworks stock_locations fields

The stock_locations report of the Linnworks connector includes 16 fields.

ID	Type	Name	Description
stock_locations__address1	TEXT	stock_locations.Address1	stock_locations.Address1
stock_locations__address2	TEXT	stock_locations.Address2	stock_locations.Address2
stock_locations__binrack	TEXT	stock_locations.BinRack	stock_locations.BinRack
stock_locations__city	TEXT	stock_locations.City	stock_locations.City
stock_locations__countinorderuntilacknowledgement	BOOLEAN	stock_locations.CountInOrderUntilAcknowledgement	stock_locations.CountInOrderUntilAcknowledgement
stock_locations__country	TEXT	stock_locations.Country	stock_locations.Country
stock_locations__county	TEXT	stock_locations.County	stock_locations.County
stock_locations__fulfilmentcenterdeductstockwhenprocessed	BOOLEAN	stock_locations.FulfilmentCenterDeductStockWhenProcessed	stock_locations.FulfilmentCenterDeductStockWhenProcessed
stock_locations__isfulfillmentcenter	BOOLEAN	stock_locations.IsFulfillmentCenter	stock_locations.IsFulfillmentCenter
stock_locations__isnottrackable	BOOLEAN	stock_locations.IsNotTrackable	stock_locations.IsNotTrackable
stock_locations__iswarehousemanaged	BOOLEAN	stock_locations.IsWarehouseManaged	stock_locations.IsWarehouseManaged
stock_locations__locationname	TEXT	stock_locations.LocationName	stock_locations.LocationName
stock_locations__locationtag	TEXT	stock_locations.LocationTag	stock_locations.LocationTag
stock_locations__stocklocationid	TEXT	stock_locations.StockLocationId	stock_locations.StockLocationId
stock_locations__stocklocationintid	NUMERIC	stock_locations.StockLocationIntId	stock_locations.StockLocationIntId
stock_locations__zipcode	TEXT	stock_locations.ZipCode	stock_locations.ZipCode

Linnworks other fields

The Linnworks connector has 5 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date

ID	Type	Name	Description
processed_order_details__customerinfo	OBJECT	processed_order_details.CustomerInfo	processed_order_details.CustomerInfo
processed_order_details__extendedproperties	OBJECT	processed_order_details.ExtendedProperties	processed_order_details.ExtendedProperties
processed_order_details__foldername	OBJECT	processed_order_details.FolderName	processed_order_details.FolderName
processed_order_details__fulfilmentlocationid	TEXT	processed_order_details.FulfilmentLocationId	processed_order_details.FulfilmentLocationId
processed_order_details__generalinfo	OBJECT	processed_order_details.GeneralInfo	processed_order_details.GeneralInfo
processed_order_details__items	OBJECT	processed_order_details.Items	processed_order_details.Items
processed_order_details__notes	OBJECT	processed_order_details.Notes	processed_order_details.Notes
processed_order_details__numorderid	NUMERIC	processed_order_details.NumOrderId	processed_order_details.NumOrderId
processed_order_details__orderid	TEXT	processed_order_details.OrderId	processed_order_details.OrderId
processed_order_details__paiddatetime	DATE	processed_order_details.PaidDateTime	processed_order_details.PaidDateTime
processed_order_details__processed	BOOLEAN	processed_order_details.Processed	processed_order_details.Processed
processed_order_details__processeddatetime	DATE	processed_order_details.ProcessedDateTime	processed_order_details.ProcessedDateTime
processed_order_details__shippinginfo	OBJECT	processed_order_details.ShippingInfo	processed_order_details.ShippingInfo
processed_order_details__taxid	TEXT	processed_order_details.TaxId	processed_order_details.TaxId
processed_order_details__totalsinfo	OBJECT	processed_order_details.TotalsInfo	processed_order_details.TotalsInfo

ID	Type	Name	Description
stock_location_details__address1	TEXT	stock_location_details.Address1	stock_location_details.Address1
stock_location_details__address2	TEXT	stock_location_details.Address2	stock_location_details.Address2
stock_location_details__city	TEXT	stock_location_details.City	stock_location_details.City
stock_location_details__countinorderuntilacknowledgement	BOOLEAN	stock_location_details.CountInOrderUntilAcknowledgement	stock_location_details.CountInOrderUntilAcknowledgement
stock_location_details__country	TEXT	stock_location_details.Country	stock_location_details.Country
stock_location_details__county	TEXT	stock_location_details.County	stock_location_details.County
stock_location_details__fulfilmentcenterdeductstockwhenprocessed	BOOLEAN	stock_location_details.FulfilmentCenterDeductStockWhenProcessed	stock_location_details.FulfilmentCenterDeductStockWhenProcessed
stock_location_details__isfulfillmentcenter	BOOLEAN	stock_location_details.IsFulfillmentCenter	stock_location_details.IsFulfillmentCenter
stock_location_details__isnottrackable	BOOLEAN	stock_location_details.IsNotTrackable	stock_location_details.IsNotTrackable
stock_location_details__iswarehousemanaged	BOOLEAN	stock_location_details.IsWarehouseManaged	stock_location_details.IsWarehouseManaged
stock_location_details__locationname	TEXT	stock_location_details.LocationName	stock_location_details.LocationName
stock_location_details__locationtag	TEXT	stock_location_details.LocationTag	stock_location_details.LocationTag
stock_location_details__stocklocationid	TEXT	stock_location_details.StockLocationId	stock_location_details.StockLocationId
stock_location_details__stocklocationintid	NUMERIC	stock_location_details.StockLocationIntId	stock_location_details.StockLocationIntId
stock_location_details__zipcode	TEXT	stock_location_details.ZipCode	stock_location_details.ZipCode

API Connectors