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.8.0.59841)

ZIP string

ZIP

Type: varchar

Available from: / (25.8.0.59841)

City string

City

Type: varchar

Available from: / (25.8.0.59841)

Email string

Email

Type: varchar

Available from: / (25.8.0.59841)

Phone string

Phone

Type: varchar

Available from: / (25.8.0.59841)

Price integer

Price

Type: int

Available from: / (25.8.0.59841)

Anrede string

Anrede

Type: varchar

Available from: / (25.8.0.59841)

CareOf string

CareOf

Type: varchar

Available from: / (25.8.0.59841)

EANUPC string

EANUPC

Type: varchar

Available from: / (25.8.0.59841)

Status string

Status

Type: varchar

Available from: / (25.8.0.59841)

Street string

Street

Type: varchar

Available from: / (25.8.0.59841)

ArtName string

ArtName

Type: varchar

Available from: / (25.8.0.59841)

Country string

Country

Type: varchar

Available from: / (25.8.0.59841)

DF_Type string

DF_Type

Type: varchar

Available from: / (25.8.0.59841)

HouseNr string

HouseNr

Type: varchar

Available from: / (25.8.0.59841)

ordernr integer

ordernr

Type: int

Available from: / (25.8.0.59841)

APayment string

APayment

Type: varchar

Available from: / (25.8.0.59841)

LastName string

LastName

Type: varchar

Available from: / (25.8.0.59841)

ShipCost string

ShipCost

Type: varchar

Available from: / (25.8.0.59841)

Shipdate string

Shipdate

Type: datetime

Available from: / (25.8.0.59841)

discount string

discount

Type: varchar

Available from: / (25.8.0.59841)

FirstName string

FirstName

Type: varchar

Available from: / (25.8.0.59841)

OrderDate string

OrderDate

Type: datetime

Available from: / (25.8.0.59841)

SupplInfo string

SupplInfo

Type: varchar

Available from: / (25.8.0.59841)

AddrShopID string

AddrShopID

Type: varchar

Available from: / (25.8.0.59841)

AddressLock string

AddressLock

Type: varchar

Available from: / (25.8.0.59841)

ItemNrSuppl string

ItemNrSuppl

Type: varchar

Available from: / (25.8.0.59841)

CustomerLock string

CustomerLock

Type: varchar

Available from: / (25.8.0.59841)

OrderHistKey integer

OrderHistKey

Type: int

Available from: / (25.8.0.59841)

OrderLineRef integer

OrderLineRef

Type: int

Available from: / (25.8.0.59841)

ShipInstruct string

ShipInstruct

Type: varchar

Available from: / (25.8.0.59841)

ShipVendorCode string

ShipVendorCode

Type: varchar

Available from: / (25.8.0.59841)

itemNrExternal string

itemNrExternal

Type: varchar

Available from: / (25.8.0.59841)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: / (25.8.0.59841)

Address_remarks string

Address_remarks

Type: varchar

Available from: / (25.8.0.59841)

OrderNrExternal string

OrderNrExternal

Type: varchar

Available from: / (25.8.0.59841)

StatusChangeDate string

StatusChangeDate

Type: datetime

Available from: / (25.8.0.59841)

oItemSpecialNote string

oItemSpecialNote

Type: varchar

Available from: / (25.8.0.59841)

InvoiceNrExternal string

InvoiceNrExternal

Type: varchar

Available from: / (25.8.0.59841)

OrderCurrencyCode string

OrderCurrencyCode

Type: varchar

Available from: / (25.8.0.59841)