Upsert a list of orders to Northbeam (V1, deprecated)
Headers
Body
Orders listMinimum array length:1Items must be unique.
| Field | Type | Description | Example |
|---|---|---|---|
order_id required | string | This must be a universal id that must be unique across all of your existing orders. It should exactly match the ID that you send using firePurchaseEvent if that is a part of your workflow. For documentation on firePurchaseEvent please review our Northbeam Pixel API. This must not be the customer ID.Minimum string length: 1 | ”abc-123” |
customer_id required | string | This must be a universal id that must be unique across all of your existing customers. The internal customer ID. This must not be the order ID. This should not be an email. Minimum string length: 1 | ”def-456” |
time_of_purchase required | string (date-time) | The time the order was placed by the customer. ISO-8601 timestamp. | ”2022-03-08T01:23:45-08:00” |
customer_email | string (email) | The email associated with the customer. Cannot be provided if hashed_customer_email is present. | ”example@gmail.com” |
customer_phone_number | string | The phone number associated with the customer. Cannot be provided if hashed_customer_phone_number is present. | ”1112223333” |
hashed_customer_email | string | Pre-hashed (SHA-256) email associated with the customer. Cannot be provided if customer_email is present. Important: Email must be normalized before hashing. See the Hashing Customer Data guide for normalization rules and implementation examples. | ”5d41402abc4b2a76b9719d911017c592ae5f7d09d5c8d0e9e3e5f4a8e5c5c5c5” |
hashed_customer_phone_number | string | Pre-hashed (SHA-256) phone number associated with the customer. Cannot be provided if customer_phone_number is present. Important: Phone number must be normalized to E.164 format before hashing. See the Hashing Customer Data guide for normalization rules and implementation examples. | ”8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92” |
customer_name | string | The name associated with the customer. | ”Jane Doe” |
customer_ip_address | string (ip) | The IP address associated with the customer. | ”127.0.0.1” |
discount_codes | string[] | A list of discount codes used in the order. Items must be unique. | ”Discount” |
discount_amount | number | The amount of money discounted due to discount codes in the currency of the order. Required range: x <= 100000000000000 | 10 |
order_tags | string[] | A list of internal tags describing the order. Items must be unique. | ”Special order” |
tax required | number | The tax amount in the currency of the order. Required range: x <= 100000000000000 | 1 |
is_recurring_order | boolean | Whether or not this order is part of a recurring purchase. | false |
currency required | string | The currency of the order. Note, all subsequent fields will assume that the currency is the one passed in this field. Please use standard ISO-4217 currency codes. Minimum string length: 1Pattern: ^AED|AFN|ALL|AMD|ANG|AOA|ARS|AUD|AWG|AZN|BAM|BBD|BDT|BGN|BHD|BIF|BMD|BND|BOB|BRL|BSD|BTN|BWP|BYR|BZD|CAD|CDF|CHF|CLP|CNY|COP|CRC|CUC|CUP|CVE|CZK|DJF|DKK|DOP|DZD|EGP|ERN|ETB|EUR|FJD|FKP|GBP|GEL|GGP|GHS|GIP|GMD|GNF|GTQ|GYD|HKD|HNL|HRK|HTG|HUF|IDR|ILS|IMP|INR|IQD|IRR|ISK|JEP|JMD|JOD|JPY|KES|KGS|KHR|KMF|KPW|KRW|KWD|KYD|KZT|LAK|LBP|LKR|LRD|LSL|LYD|MAD|MDL|MGA|MKD|MMK|MNT|MOP|MRO|MUR|MVR|MWK|MXN|MYR|MZN|NAD|NGN|NIO|NOK|NPR|NZD|OMR|PAB|PEN|PGK|PHP|PKR|PLN|PYG|QAR|RON|RSD|RUB|RWF|SAR|SBD|SCR|SDG|SEK|SGD|SHP|SLL|SOS|SPL|SRD|STD|SVC|SYP|SZL|THB|TJS|TMT|TND|TOP|TRY|TTD|TVD|TWD|TZS|UAH|UGX|USD|UYU|UZS|VEF|VND|VUV|WST|XAF|XCD|XDR|XOF|XPF|YER|ZAR|ZMW|ZWD$ | “USD” |
purchase_total required | number | The amount of money collected from the customer (including taxes, shipping, and other fees) in the currency of the order. Required range: x <= 100000000000000 | 10000 |
products required | object[] | A list of objects describing the products in the order. Minimum array length: 1 | |
Field Type Description Example id requiredstring A unique identifier describing the product in the order. Minimum string length: 1”prod-1”name requiredstring The name of the product. Minimum string length: 1”Our product”quantity requirednumber How many of this product was sold in the order Required range: x <= 1000000000000001price requirednumber The (per unit) price of the product in the currency of the order. Required range: x <= 10000000000000010011 | |||
refunds | object[] | A list of objects describing the refunded products. Items must be unique. | |
Field Type Description product_id requiredstring A unique identifier describing the product in the refund (should also be included in the products list). Minimum string length: 1quantity requirednumber The number of products refunded (should be less than or equal to the corresponding quantity in the products list). Required range: x <= 100000000000000refund_amount requirednumber The total amount refunded to the customer in the currency of the order. Required range: x <= 100000000000000refund_cost requirednumber The estimated total cost of the refund, including the refund amount to the customer and any other overhead costs (i.e. shipping, fees). Required range: x <= 100000000000000refund_made_at requiredstring (date-time) The time the refund was fulfilled by your brand. ISO-8601 timestamp. | |||
customer_shipping_address | object | ||
Field Type Description Example address1string The street address of the customer’s shipping address. Minimum string length: 1”123 Main St.”address2string An optional additional field for the street address. ”Apt. 1A”citystring The city or locality of the customer’s shipping address. Minimum string length: 1”Small town”statestring The state or region of the customer’s shipping address. ”CO”zip requiredstring The postal code (e.g. zip, postcode) of the customer’s shipping address. ”11111”country_code requiredstring The three-letter ISO 3166 country code of the customer’s shipping address. Minimum string length: 3Pattern: ^A(BW|FG|GO|IA|L[AB]|ND|R[EGM]|SM|T[AFG]|U[ST]|ZE)|B(DI|E[LNS]|FA|G[DR]|H[RS]|IH|L[MRZ]|MU|OL|R[ABN]|TN|VT|WA)|C(A[FN]|CK|H[ELN]|IV|MR|O[DGKLM]|PV|RI|U[BW]|XR|Y[MP]|ZE)|D(EU|JI|MA|NK|OM|ZA)|E(CU|GY|RI|S[HPT]|TH)|F(IN|JI|LK|R[AO]|SM)|G(AB|BR|EO|GY|HA|I[BN]|LP|MB|N[BQ]|R[CDL]|TM|U[FMY])|H(KG|MD|ND|RV|TI|UN)|I(DN|MN|ND|OT|R[LNQ]|S[LR]|TA)|J(AM|EY|OR|PN)|K(AZ|EN|GZ|HM|IR|NA|OR|WT)|L(AO|B[NRY]|CA|IE|KA|SO|TU|UX|VA)|M(A[CFR]|CO|D[AGV]|EX|HL|KD|L[IT]|MR|N[EGP]|OZ|RT|SR|TQ|US|WI|Y[ST])|N(AM|CL|ER|FK|GA|I[CU]|LD|OR|PL|RU|ZL)|OMN|P(A[KN]|CN|ER|HL|LW|NG|OL|R[IKTY]|SE|YF)|QAT|R(EU|OU|US|WA)|S(AU|DN|EN|G[PS]|HN|JM|L[BEV]|MR|OM|PM|RB|SD|TP|UR|V[KN]|W[EZ]|XM|Y[CR])|T(C[AD]|GO|HA|JK|K[LM]|LS|ON|TO|U[NRV]|WN|ZA)|U(GA|KR|MI|RY|SA|ZB)|V(AT|CT|EN|GB|IR|NM|UT)|W(LF|SM)|YEM|Z(AF|MB|WE)$“USA” | |||
Responses
Body
Orders list
1This must be a universal id that must be unique across all of your existing orders. It should exactly match the ID that you send using firePurchaseEvent if that is a part of your workflow. For documentation on firePurchaseEvent please review our Northbeam Pixel API. This must not be the customer ID.
1"abc-123"
This must be a universal id that must be unique across all of your existing customers. The internal customer ID. This must not be the order ID. This should not be an email.
1"def-456"
The time the order was placed by the customer. ISO-8601 timestamp.
"2022-03-08T01:23:45-08:00"
The tax amount in the currency of the order.
x <= 1000000000000001
The currency of the order. Note, all subsequent fields will assume that the currency is the one passed in this field. Please use standard ISO-4217 currency codes.
1^AED|AFN|ALL|AMD|ANG|AOA|ARS|AUD|AWG|AZN|BAM|BBD|BDT|BGN|BHD|BIF|BMD|BND|BOB|BRL|BSD|BTN|BWP|BYR|BZD|CAD|CDF|CHF|CLP|CNY|COP|CRC|CUC|CUP|CVE|CZK|DJF|DKK|DOP|DZD|EGP|ERN|ETB|EUR|FJD|FKP|GBP|GEL|GGP|GHS|GIP|GMD|GNF|GTQ|GYD|HKD|HNL|HRK|HTG|HUF|IDR|ILS|IMP|INR|IQD|IRR|ISK|JEP|JMD|JOD|JPY|KES|KGS|KHR|KMF|KPW|KRW|KWD|KYD|KZT|LAK|LBP|LKR|LRD|LSL|LYD|MAD|MDL|MGA|MKD|MMK|MNT|MOP|MRO|MUR|MVR|MWK|MXN|MYR|MZN|NAD|NGN|NIO|NOK|NPR|NZD|OMR|PAB|PEN|PGK|PHP|PKR|PLN|PYG|QAR|RON|RSD|RUB|RWF|SAR|SBD|SCR|SDG|SEK|SGD|SHP|SLL|SOS|SPL|SRD|STD|SVC|SYP|SZL|THB|TJS|TMT|TND|TOP|TRY|TTD|TVD|TWD|TZS|UAH|UGX|USD|UYU|UZS|VEF|VND|VUV|WST|XAF|XCD|XDR|XOF|XPF|YER|ZAR|ZMW|ZWD$"USD"
The amount of money collected from the customer (including taxes, shipping, and other fees) in the currency of the order.
x <= 10000000000000010000
A list of objects describing the products in the order.
1The email associated with the customer. Cannot be provided if hashed_customer_email is present.
"example@gmail.com"
The phone number associated with the customer. Cannot be provided if hashed_customer_phone_number is present.
"1112223333"
Pre-hashed (SHA-256) email associated with the customer. Cannot be provided if customer_email is present.
Important: Email must be normalized before hashing. See the Hashing Customer Data guide for normalization rules and implementation examples.
"5d41402abc4b2a76b9719d911017c592ae5f7d09d5c8d0e9e3e5f4a8e5c5c5c5"
Pre-hashed (SHA-256) phone number associated with the customer. Cannot be provided if customer_phone_number is present.
Important: Phone number must be normalized to E.164 format before hashing. See the Hashing Customer Data guide for normalization rules and implementation examples.
"8d969eef6ecad3c29a3a629280e686cf0c3f5d5a86aff3ca12020c923adc6c92"
The name associated with the customer.
"Jane Doe"
The IP address associated with the customer.
"127.0.0.1"
A list of discount codes used in the order.
"Discount"
The amount of money discounted due to discount codes in the currency of the order.
x <= 10000000000000010
A list of internal tags describing the order.
"Special order"
Whether or not this order is part of a recurring purchase.
false
A list of objects describing the refunded products.
Response
Orders succesfully upserted