API Call to retrieve all relevant addresses

Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:


Request

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

Request body

Name Type Required Description
AddrKey integer false

pixi* Address Key

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

RowCount integer false

Number of rows returned maximum

Type: int

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateTo string false

Create Date to (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateTo string false

Update Date To (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateDateFrom string false

Create Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

UpdateDateFrom string false

Update Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateTo string false

Create or Update Date to (excluding)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)

CreateAndUpdateDateFrom string false

Create or Update Date from (including)

Type: datetime

Default value: NULL

Example:

Available from: LOU Official - Update 46 (6.9.46.27927)


Response

1. Result set

Name Type Description
BIC string

BIC

Type: varchar

Available from: / (25.8.0.59841)

Fax string

Fax

Type: varchar

Available from: / (25.8.0.59841)

ZIP string

ZIP

Type: varchar

Available from: / (25.8.0.59841)

ABLZ string

ABLZ

Type: varchar

Available from: / (25.8.0.59841)

City string

City

Type: varchar

Available from: / (25.8.0.59841)

Fax2 string

Fax2

Type: varchar

Available from: / (25.8.0.59841)

IBAN string

IBAN

Type: varchar

Available from: / (25.8.0.59841)

Name string

Name

Type: varchar

Available from: / (25.8.0.59841)

Note string

Note

Type: datetime

Available from: / (25.8.0.59841)

CCCVC string

CCCVC

Type: varchar

Available from: / (25.8.0.59841)

Name2 string

Name2

Type: varchar

Available from: / (25.8.0.59841)

Phone string

Phone

Type: varchar

Available from: / (25.8.0.59841)

State string

State

Type: varchar

Available from: / (25.8.0.59841)

ZIPMB string

ZIPMB

Type: varchar

Available from: / (25.8.0.59841)

eMail string

eMail

Type: varchar

Available from: / (25.8.0.59841)

AGosF1 string

AGosF1

Type: varchar

Available from: / (25.8.0.59841)

AGosF2 string

AGosF2

Type: varchar

Available from: / (25.8.0.59841)

AddrNr string

AddrNr

Type: varchar

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)

Phone2 string

Phone2

Type: varchar

Available from: / (25.8.0.59841)

Street string

Street

Type: varchar

Available from: / (25.8.0.59841)

UsStId string

UsStId

Type: varchar

Available from: / (25.8.0.59841)

active string

active

Type: varchar

Available from: / (25.8.0.59841)

eMail2 string

eMail2

Type: varchar

Available from: / (25.8.0.59841)

ACardNr string

ACardNr

Type: varchar

Available from: / (25.8.0.59841)

AddrKey integer

AddrKey

Type: int

Available from: / (25.8.0.59841)

Address string

Address

Type: varchar

Available from: / (25.8.0.59841)

CAnrede string

CAnrede

Type: varchar

Available from: / (25.8.0.59841)

Contact string

Contact

Type: varchar

Available from: / (25.8.0.59841)

Country string

Country

Type: varchar

Available from: / (25.8.0.59841)

HouseNr string

HouseNr

Type: varchar

Available from: / (25.8.0.59841)

Mailbox string

Mailbox

Type: varchar

Available from: / (25.8.0.59841)

rowguid integer

rowguid

Type: int

Available from: / (25.8.0.59841)

AAccName string

AAccName

Type: varchar

Available from: / (25.8.0.59841)

AAccount string

AAccount

Type: varchar

Available from: / (25.8.0.59841)

ACardExp string

ACardExp

Type: varchar

Available from: / (25.8.0.59841)

AHisNote string

AHisNote

Type: varchar

Available from: / (25.8.0.59841)

AIssueNr string

AIssueNr

Type: varchar

Available from: / (25.8.0.59841)

APayment string

APayment

Type: varchar

Available from: / (25.8.0.59841)

ASlocked string

ASlocked

Type: varchar

Available from: / (25.8.0.59841)

AddrType string

AddrType

Type: varchar

Available from: / (25.8.0.59841)

LastName string

LastName

Type: varchar

Available from: / (25.8.0.59841)

ABankName string

ABankName

Type: varchar

Available from: / (25.8.0.59841)

ACardName string

ACardName

Type: varchar

Available from: / (25.8.0.59841)

ACardType string

ACardType

Type: varchar

Available from: / (25.8.0.59841)

AReplFlag string

AReplFlag

Type: varchar

Available from: / (25.8.0.59841)

AWaitDays integer

AWaitDays

Type: int

Available from: / (25.8.0.59841)

Ansprache string

Ansprache

Type: varchar

Available from: / (25.8.0.59841)

BirthDate string

BirthDate

Type: datetime

Available from: / (25.8.0.59841)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.8.0.59841)

FirstName string

FirstName

Type: varchar

Available from: / (25.8.0.59841)

SearchKey string

SearchKey

Type: varchar

Available from: / (25.8.0.59841)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.8.0.59841)

AShipImmed string

AShipImmed

Type: varchar

Available from: / (25.8.0.59841)

AddrShopID string

AddrShopID

Type: varchar

Available from: / (25.8.0.59841)

AdrCustRef integer

AdrCustRef

Type: int

Available from: / (25.8.0.59841)

Billing_Id integer

Billing_Id

Type: int

Available from: / (25.8.0.59841)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.8.0.59841)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.8.0.59841)

CompanyType integer

CompanyType

Type: int

Available from: / (25.8.0.59841)

CompanySince string

CompanySince

Type: datetime

Available from: / (25.8.0.59841)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: / (25.8.0.59841)

PersonContact_Id integer

PersonContact_Id

Type: int

Available from: / (25.8.0.59841)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: / (25.8.0.59841)