Settlement Transactions

Retrieve transactions included in a settlement

Example

Request

GET /reports/settlements/{{settlementId}}/transactions?page=1&perPage=1&includeProductCode=false HTTP/1.1
Host: api.uat.walleydev.com // (Please note! Different hostname in production)
Authorization: Bearer bXlVc2VybmFtZTpmN2E1ODA4MGQzZTk0M2VmNWYyMTZlMDE...

Response

{
  "data": [
    {
      "customerNumber": "",
      "firstName": "Test",
      "lastName": "Test",
      "amount": 1000.0,
      "purchaseDate": "2022-01-01",
      "transactionDate": "2020-01-01",
      "orderNumber": "TEST_230116_011045",
      "invoiceNumber": "11111111",
      "type": "Purchase",
      "totalVatAmountPerRate": [
        {
          "vatRate": 25.0,
          "amount": 180
        },
        {
          "vatRate": 6.0,
          "amount": 5.66
        }
      ],
      "currency": "SEK",
      "settlementDate": null,
      "payoutReference": null,
      "actionReference": null,
      "orderId": "4f35934d-dcf7-4929-b1ec-179155a6db58",
      "productCode": "DI001"
    }
  ],
  "links": {
    "self": {
      "method": "GET",
      "href": "/settlements?page=1&perPage=1",
      "query": "page=1&perPage=1"
    },
    "next": {
      "method": "GET",
      "href": "/settlements?page=2&perPage=1",
      "query": "page=2&perPage=1"
    }
  },
  "metaData": {
    "totalNumberOfRecords": 100,
    "numberOfPages": 100,
    "currentPage": 1,
    "range": {
      "from": 1,
      "to": 1
    }
  }
}

Request

Request path

Path	Required	Explanation
settlementId	Yes	The id for the requested settlement transactions

Request headers

Header	Required	Explanation
Authorization	Yes	Instructions on how to generate the Bearer token value can be found here
Accept	No	Default response format is json, to return transactions in csv format set Accept header to text/csv

Please Note

When using the Accept text/csv the format will follow the same format as the example files on the Settlements page

Request querystrings

Header	Required	Explanation
page	No	Page of items that should be returned in request
perPage	No	Number of items to be returned in each request. Largest allowed value is 5000
includeProductCode	No	Specify whether you want productCode values in response. Defaults to false

Response

Possible responses

Http status code	Description
200	Successful request
401	Unauthorized, token verification needed. See: Authentication for more information
403	Permissions needed e.g. trying to fetch content for a store you don't have permission to
404	Transactions not found
422	Query with incorrect format

Response body from 200 OK

response.data object is an array of the following structure:

{
  "customerNumber": "",
  "firstName": "Test",
  "lastName": "Test",
  "amount": 1000.0,
  "purchaseDate": "2022-01-01",
  "transactionDate": "2020-01-01",
  "invoiceNumber": "11111111",
  "orderNumber": "TEST_230116_011045",
  "type": "Purchase",
  "totalVatAmountPerRate": [
    {
      "vatRate": 25.0,
      "amount": 180
    },
    {
      "vatRate": 6.0,
      "amount": 5.66
    }
  ],
  "currency": "SEK",
  "settlementDate": null,
  "payoutReference": null,
  "actionReference": null,
  "orderId": "4f35934d-dcf7-4929-b1ec-179155a6db58",
  "productCode": "DI001"
}

Property	Explanation	Comment
customerNumber	Custom value that can be provided at purchase
firstName	B2C customers first name, B2B company name
lastName	B2C customers last name, B2B empty
amount	Transaction amount
purchaseDate	The date when the purchase was captured
transactionDate	Custom date value provided at purchase	In SOAP OrderDate
invoiceNumber	The purchase invoice number
orderNumber	Custom value that can be provided at purchase	In checkout reference
type	Settlement types
totalVatAmountPerRate	The amount of VAT paid for each VAT rate
currency	The purchase currency
settlementDate	The date the settlement is created,	Only available when extended csv is configured
payoutReference	The reference used for the bank payout	Only available when extended csv is configured
actionReference	Custom value that can be provided when purchase is captured or refunded	Only available when extended csv is configured
orderId	The id of the order associated with the transaction	Available on type Purchase, Return and PurchaseAmountAdjustment
productCode	The product code associated with the transaction	Possibly empty. Included if includeProductCode query param is true