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

Fax string

Fax

Type: varchar

Available from: / (25.7.0.59144)

ZIP string

ZIP

Type: varchar

Available from: / (25.7.0.59144)

ABLZ string

ABLZ

Type: varchar

Available from: / (25.7.0.59144)

City string

City

Type: varchar

Available from: / (25.7.0.59144)

Fax2 string

Fax2

Type: varchar

Available from: / (25.7.0.59144)

IBAN string

IBAN

Type: varchar

Available from: / (25.7.0.59144)

Name string

Name

Type: varchar

Available from: / (25.7.0.59144)

Note string

Note

Type: datetime

Available from: / (25.7.0.59144)

CCCVC string

CCCVC

Type: varchar

Available from: / (25.7.0.59144)

Name2 string

Name2

Type: varchar

Available from: / (25.7.0.59144)

Phone string

Phone

Type: varchar

Available from: / (25.7.0.59144)

State string

State

Type: varchar

Available from: / (25.7.0.59144)

ZIPMB string

ZIPMB

Type: varchar

Available from: / (25.7.0.59144)

eMail string

eMail

Type: varchar

Available from: / (25.7.0.59144)

AGosF1 string

AGosF1

Type: varchar

Available from: / (25.7.0.59144)

AGosF2 string

AGosF2

Type: varchar

Available from: / (25.7.0.59144)

AddrNr string

AddrNr

Type: varchar

Available from: / (25.7.0.59144)

Anrede string

Anrede

Type: varchar

Available from: / (25.7.0.59144)

CareOf string

CareOf

Type: varchar

Available from: / (25.7.0.59144)

Phone2 string

Phone2

Type: varchar

Available from: / (25.7.0.59144)

Street string

Street

Type: varchar

Available from: / (25.7.0.59144)

UsStId string

UsStId

Type: varchar

Available from: / (25.7.0.59144)

active string

active

Type: varchar

Available from: / (25.7.0.59144)

eMail2 string

eMail2

Type: varchar

Available from: / (25.7.0.59144)

ACardNr string

ACardNr

Type: varchar

Available from: / (25.7.0.59144)

AddrKey integer

AddrKey

Type: int

Available from: / (25.7.0.59144)

Address string

Address

Type: varchar

Available from: / (25.7.0.59144)

CAnrede string

CAnrede

Type: varchar

Available from: / (25.7.0.59144)

Contact string

Contact

Type: varchar

Available from: / (25.7.0.59144)

Country string

Country

Type: varchar

Available from: / (25.7.0.59144)

HouseNr string

HouseNr

Type: varchar

Available from: / (25.7.0.59144)

Mailbox string

Mailbox

Type: varchar

Available from: / (25.7.0.59144)

rowguid integer

rowguid

Type: int

Available from: / (25.7.0.59144)

AAccName string

AAccName

Type: varchar

Available from: / (25.7.0.59144)

AAccount string

AAccount

Type: varchar

Available from: / (25.7.0.59144)

ACardExp string

ACardExp

Type: varchar

Available from: / (25.7.0.59144)

AHisNote string

AHisNote

Type: varchar

Available from: / (25.7.0.59144)

AIssueNr string

AIssueNr

Type: varchar

Available from: / (25.7.0.59144)

APayment string

APayment

Type: varchar

Available from: / (25.7.0.59144)

ASlocked string

ASlocked

Type: varchar

Available from: / (25.7.0.59144)

AddrType string

AddrType

Type: varchar

Available from: / (25.7.0.59144)

LastName string

LastName

Type: varchar

Available from: / (25.7.0.59144)

ABankName string

ABankName

Type: varchar

Available from: / (25.7.0.59144)

ACardName string

ACardName

Type: varchar

Available from: / (25.7.0.59144)

ACardType string

ACardType

Type: varchar

Available from: / (25.7.0.59144)

AReplFlag string

AReplFlag

Type: varchar

Available from: / (25.7.0.59144)

AWaitDays integer

AWaitDays

Type: int

Available from: / (25.7.0.59144)

Ansprache string

Ansprache

Type: varchar

Available from: / (25.7.0.59144)

BirthDate string

BirthDate

Type: datetime

Available from: / (25.7.0.59144)

CreateEmp string

CreateEmp

Type: varchar

Available from: / (25.7.0.59144)

FirstName string

FirstName

Type: varchar

Available from: / (25.7.0.59144)

SearchKey string

SearchKey

Type: varchar

Available from: / (25.7.0.59144)

UpdateEmp string

UpdateEmp

Type: varchar

Available from: / (25.7.0.59144)

AShipImmed string

AShipImmed

Type: varchar

Available from: / (25.7.0.59144)

AddrShopID string

AddrShopID

Type: varchar

Available from: / (25.7.0.59144)

AdrCustRef integer

AdrCustRef

Type: int

Available from: / (25.7.0.59144)

Billing_Id integer

Billing_Id

Type: int

Available from: / (25.7.0.59144)

CreateDate string

CreateDate

Type: datetime

Available from: / (25.7.0.59144)

UpdateDate string

UpdateDate

Type: datetime

Available from: / (25.7.0.59144)

CompanyType integer

CompanyType

Type: int

Available from: / (25.7.0.59144)

CompanySince string

CompanySince

Type: datetime

Available from: / (25.7.0.59144)

AddrNoChargeVAT boolean

AddrNoChargeVAT

Type: bit

Available from: / (25.7.0.59144)

PersonContact_Id integer

PersonContact_Id

Type: int

Available from: / (25.7.0.59144)

CustomerNrExternal string

CustomerNrExternal

Type: varchar

Available from: / (25.7.0.59144)