Madden Analytics API

Get Latest Transaction

GET /v1/transactions/latest

Bearer

Retrieves the latest transaction in Madden.

Query parameters

sort string

Parameter to sort by to get latest transaction

Values are date or externalid.
type string

Filter on specific purchase type

Values are purchase or return.
channel string

Filter by channel

Values are d2c or b2b. Default value is all.

Responses

• 200

OK
Hide response attributes Show response attributes object
- cancelledDate string(date-time)
  
  Date that the transaction was cancelled
- channel number Required
  
  Channel of the transaction (1: D2C, 2: B2B)
- completedDate string(date-time)
  
  Date that the transaction was completed
- createdDate string(date-time) Required
  
  Date that the transaction was created
- currencyCode string Required
  
  Currency Code of transaction (ISO 4217)
- customerName string
  
  Name of the Customer (Only used on B2B transactions)
- deliveryDate string
  
  The estimated Delivery Date of the transaction
- externalCostCenterID string
  
  External ID of an assosciated cost center. Will be added as a suffix to externalStoreID
- externalCustomerID string
  
  External Customer ID of the B2B customer
- externalInfo string
  
  JSON body that can be used for integration purposes
- externalParentID string
  
  Reference externalTransactionID of initial transaction when adding returns
- externalRowID string
  
  Additional ExternalID of transaction
- externalStoreID string Required
  
  External ID of the store (Store must exist in Madden)
- externalTransactionID string Required
  
  The ID of the transaction in the source platform (used to query single transacitons)
- id integer
  
  Maddens ID of the transaction (Used as reference on replace)
- items array[object]
  
  The items/product rows of the transaction
  
  Hide items attributes Show items attributes object
  
  ageGroup string
  
  AgeGroup assosciated with the variant
  
  brandName string Required
  
  Brand Name of the variant
  
  category string Required
  
  Category of the variant
  
  collection string
  
  Collection that the variant belongs to
  
  color string
  
  Color of the variant
  
  costPrice number(float)
  
  Cost Price of the items on transaction row
  
  costPriceCurrency string
  
  Currency Code of Cost Price (ISO 4217)
  
  customFields string
  
  Any JSON object holding additional filter attributes
  
  deliveryWindow string
  
  Name of Delivery Window assosciated with the variant
  
  ean string
  
  Ean of the variant
  
  externalID string
  
  Id of variant in external platform
  
  externalItemID string Required
  
  ExternalItemID the external id of the transaction item
  
  fulfillmentType number
  
  Method of fulfillment for transaction item (0: Warehouse, 1: DropShip)
  
  Default value is 0.
  
  gender string
  
  Gender assosciated with the variant
  
  key string Required
  
  Key used between products, transaction & stock tables. Usually SKU or EAN but needs to be same on all occurrences of the variant
  
  moneyDiscount number
  
  Any discounts given on transaction row
  
  moneyItemTotalNet number(float) Required
  
  Total of the items on transaction row ex. VAT
  
  moneyItemTotalVat number(float) Required
  
  Total VAT of the items on the transaction row
  
  primaryWarehouseExternalID string
  
  External ID of the warehouse where items WILL be allocated
  
  productGroupID string
  
  ProductGroupID of the variant (used to group variants together)
  
  productName string Required
  
  Name of the Product
  
  productType number
  
  Type of Product (1: Normal/standard, 2: Commission, 3: Local
  
  Default value is 1.
  
  quantity integer Required
  
  Quantity of the variant purchased
  
  season string
  
  Season that the variant belong to
  
  shipments array[object]
  
  Shipments assosciated with the transaction row
  
  Hide shipments attributes Show shipments attributes object
  
  externalWarehouseID string
  
  External ID of the warehouse where items were allocated
  
  quantity integer
  
  Quantity shipped
  
  shipmentDate string(date-time)
  
  Date the shipment was created
  
  shipmentID string
  
  External ID of the shipment
  
  size string
  
  Size of the variant
  
  sku string
  
  SKU of the variant
  
  supplier string
  
  Name of the supplier of the variant
  
  variantGroupID string
  
  VariantGroupID of the variant (used to group skus/sizes together)
  
  variantName string Required
  
  Name of the Variant
  
  vatValue integer Required
  
  VAT Percentage on the item
  
  vendorSKU string
  
  Vendors SKU if using own sku structure
  
  year string
  
  Start of the variants life-cycle
- market string Required
  
  Market that the transaction was destined for. (Ex. Delivery Country)
- orderType string
  
  OrderType of the transaction
- statements array[object]
  
  Any fees/discounts applied to the whole transaction that are not directly tied to a transaction item
  
  Hide statements attributes Show statements attributes object
  
  customFields string
  
  Custom Fields
  
  name string
  
  Name of the Statement
  
  priceNet number
  
  Statement Price (ex VAT)
  
  priceVat number
  
  VAT of statement
  
  type number
  
  Type of the statement (1: Fee, 2: Voucher, 3: Shipping, 4: Service, 5: Giftcard, 6: CartDiscount)
- type number Required
  
  Type of the transaction (1: Sale, 2: Return)
• default

All errors will return the same object with a describing code & message
Hide response attributes Show response attributes object
- error string
- message string
- statusCode integer

GET /v1/transactions/latest

curl \
 -X GET https://ma-api.maddenanalytics.com/v1/transactions/latest \
 -H "Authorization: $API_KEY"

Response examples (200)

{
  "cancelledDate": "null",
  "channel": 1,
  "completedDate": "2022-08-17T17:00:00+02:00",
  "createdDate": "2022-08-17T10:53:53+02:00",
  "currencyCode": "SEK",
  "customerName": "B2B Company Inc",
  "deliveryDate": "2021-11-15T10:15:30Z",
  "externalCostCenterID": "OL",
  "externalCustomerID": "1234-567",
  "externalInfo": "{}",
  "externalParentID": "string",
  "externalRowID": "string",
  "externalStoreID": "store101",
  "externalTransactionID": "779644",
  "id": 42,
  "items": [
    {
      "ageGroup": "Senior",
      "brandName": "ACME",
      "category": "Sneakers",
      "collection": "SS21",
      "color": "Black",
      "costPrice": 45.5,
      "costPriceCurrency": "USD",
      "customFields": "{}",
      "deliveryWindow": "IMMEDIATE",
      "ean": "7340192703345",
      "externalID": "99887766",
      "externalItemID": "779644-1000",
      "fulfillmentType": 0,
      "gender": "gender",
      "key": "7340192703345",
      "moneyDiscount": 380,
      "moneyItemTotalNet": 3040,
      "moneyItemTotalVat": 760,
      "primaryWarehouseExternalID": "central-ws",
      "productGroupID": "123456",
      "productName": "Petter",
      "productType": 1,
      "quantity": 1,
      "season": "Spring/Summer",
      "shipments": [
        {
          "externalWarehouseID": "central-ws",
          "quantity": 1,
          "shipmentDate": "2022-08-17T16:50:50+02:00",
          "shipmentID": "779644-1"
        }
      ],
      "size": "43",
      "sku": "123456-001-43",
      "supplier": "Acme Enterprises AB",
      "variantGroupID": "123456-001",
      "variantName": "Petter Black",
      "vatValue": 25,
      "vendorSKU": "9876543-001-43",
      "year": "2021"
    }
  ],
  "market": "Sweden",
  "orderType": "Standard",
  "statements": [
    {
      "customFields": "{}",
      "name": "Cart Discount",
      "priceNet": 159.2,
      "priceVat": 39.8,
      "type": 6
    }
  ],
  "type": 1
}

Response examples (default)

{
  "error": "Error Type (if any)",
  "message": "Message describing the error",
  "statusCode": 400
}