API call for retrieving the DF Changes.

Since pixi version: LOU Official (6.3.0.4452) Additional notes:


Request

POST https://apigateway.descartes.com/tms/pixi/pixiDFGetChanges

Request body

Name Type Required Description
Secret string false

Secret parameter to check if data are save to be returned.

Type: varchar(20)

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)

SupplNr string false

Supplier number.

Type: varchar(4)

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)

ExcludeStatuses string false

Exclude statuses from resultset.

Type: varchar(200)

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)

LockedCustomers boolean false

Show also locked customers.

Type: bit

Default value: 0

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

OrderNRExternal string false

Order number external -filter only changes for one particular order.

Type: varchar(50)

Default value: NULL

Example:

Available from: LOU Official (6.3.0.4452)


Response

1. Result set

Name Type Description
Qty integer

Qty

Type: int

Available from: / (25.11.0.62283)

ZIP string

ZIP

Type: varchar

Available from: / (25.11.0.62283)

City string

City

Type: varchar

Available from: / (25.11.0.62283)

Email string

Email

Type: varchar

Available from: / (25.11.0.62283)

Phone string

Phone

Type: varchar

Available from: / (25.11.0.62283)

Price integer

Price

Type: int

Available from: / (25.11.0.62283)

Anrede string

Anrede

Type: varchar

Available from: / (25.11.0.62283)

CareOf string

CareOf

Type: varchar

Available from: / (25.11.0.62283)

EANUPC string

EANUPC

Type: varchar

Available from: / (25.11.0.62283)

Status string

Status

Type: varchar

Available from: / (25.11.0.62283)

Street string

Street

Type: varchar

Available from: / (25.11.0.62283)

ArtName string

ArtName

Type: varchar

Available from: / (25.11.0.62283)

Country string

Country

Type: varchar

Available from: / (25.11.0.62283)

DF_Type string

DF_Type

Type: varchar

Available from: / (25.11.0.62283)

HouseNr string

HouseNr

Type: varchar

Available from: / (25.11.0.62283)

ordernr integer

ordernr

Type: int

Available from: / (25.11.0.62283)

APayment string

APayment

Type: varchar

Available from: / (25.11.0.62283)

LastName string

LastName

Type: varchar

Available from: / (25.11.0.62283)

ShipCost string

ShipCost

Type: varchar

Available from: / (25.11.0.62283)

Shipdate string

Shipdate

Type: datetime

Available from: / (25.11.0.62283)

discount string

discount

Type: varchar

Available from: / (25.11.0.62283)

FirstName string

FirstName

Type: varchar

Available from: / (25.11.0.62283)

OrderDate string

OrderDate

Type: datetime

Available from: / (25.11.0.62283)

SupplInfo string

SupplInfo

Type: varchar

Available from: / (25.11.0.62283)

AddrShopID string

AddrShopID

Type: varchar

Available from: / (25.11.0.62283)

AddressLock string

AddressLock

Type: varchar

Available from: / (25.11.0.62283)

ItemNrSuppl string

ItemNrSuppl

Type: varchar

Available from: / (25.11.0.62283)

CustomerLock string

CustomerLock

Type: varchar

Available from: / (25.11.0.62283)

OrderHistKey integer

OrderHistKey

Type: int

Available from: / (25.11.0.62283)

OrderLineRef integer

OrderLineRef

Type: int

Available from: / (25.11.0.62283)

ShipInstruct string

ShipInstruct

Type: varchar

Available from: / (25.11.0.62283)

ShipVendorCode string

ShipVendorCode

Type: varchar

Available from: / (25.11.0.62283)

itemNrExternal string

itemNrExternal

Type: varchar

Available from: / (25.11.0.62283)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: / (25.11.0.62283)

Address_remarks string

Address_remarks

Type: varchar

Available from: / (25.11.0.62283)

OrderNrExternal string

OrderNrExternal

Type: varchar

Available from: / (25.11.0.62283)

StatusChangeDate string

StatusChangeDate

Type: datetime

Available from: / (25.11.0.62283)

oItemSpecialNote string

oItemSpecialNote

Type: varchar

Available from: / (25.11.0.62283)

InvoiceNrExternal string

InvoiceNrExternal

Type: varchar

Available from: / (25.11.0.62283)

OrderCurrencyCode string

OrderCurrencyCode

Type: varchar

Available from: / (25.11.0.62283)