pixi Developer & Integration Documentation

pixiReadCustomerAccountMatch

Description

API call returns customer account match records


Request Parameters

#

Name

Type

Required

Example

Description

1

CustomerAccountMatchKey

integer

0

123

Customer account match id. If @RowCount is NULL then it returns only this row, otherwise next @RowCount records.

2

CreateDateFrom

string

0

YYYY-MM-DD hh:mm:ss

Create Date from (including)

3

CreateDateTo

string

0

YYYY-MM-DD hh:mm:ss

Create Date to (excluding)

4

UpdateDateFrom

string

0

YYYY-MM-DD hh:mm:ss

Update Date from (including)

5

UpdateDateTo

string

0

YYYY-MM-DD hh:mm:ss

Update Date To (excluding)

6

CreateAndUpdateDateFrom

string

0

YYYY-MM-DD hh:mm:ss

Create or Update Date from (including)

7

CreateAndUpdateDateTo

string

0

YYYY-MM-DD hh:mm:ss

Create or Update Date to (excluding)

8

RowCount

integer

0

123

Maximum number of records returned

9

CustRef

integer

0

12345

Customer reference (CustKey). Additional AND filter that narrows results to match records where either CAref1 or CAref2 belongs to a customer account of this customer. Can be combined with any main filter.

10

CustomerAccountKey

integer

0

67890

Customer account key. Additional AND filter that narrows results to match records where CAref1 or CAref2 equals this value. Can be combined with any main filter.


Request body

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:dem="https://api.pixi.eu/soap/demosandbox/">
   <soapenv:Header/>
   <soapenv:Body>
      <dem:pixiReadCustomerAccountMatch>
         <dem:CustomerAccountMatchKey>123</dem:CustomerAccountMatchKey>
         <dem:CreateDateFrom>YYYY-MM-DD hh:mm:ss</dem:CreateDateFrom>
         <dem:CreateDateTo>YYYY-MM-DD hh:mm:ss</dem:CreateDateTo>
         <dem:UpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:UpdateDateFrom>
         <dem:UpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:UpdateDateTo>
         <dem:CreateAndUpdateDateFrom>YYYY-MM-DD hh:mm:ss</dem:CreateAndUpdateDateFrom>
         <dem:CreateAndUpdateDateTo>YYYY-MM-DD hh:mm:ss</dem:CreateAndUpdateDateTo>
         <dem:RowCount>123</dem:RowCount>
         <dem:CustRef>12345</dem:CustRef>
         <dem:CustomerAccountKey>67890</dem:CustomerAccountKey>
      </dem:pixiReadCustomerAccountMatch>
   </soapenv:Body>
</soapenv:Envelope>


Response


Body 1: Customer account match information

#

Name

Type

Description

1

CustomerAccountMatchKey

integer

Customer account match ID

2

CAref1

integer

Customer account refference ID

3

CAref2

integer

Customer account refference ID

4

AbsoluteMatchAmount

number

Absolute match amount

5

CreateEmp

string

Creator of the recodr (pixi* user)

6

CreateDate

string

Create date

7

UpdateEmp

string

User who last updated the record

8

UpdateDate

string

Last update date of the record


Additional Notes