SendOwl
Log SendOwl orders from Typeform to Google Sheets
This query returns the details of a SendOwl order given its order number.
Developer info
- API endpoint slug
- sendowl.look_up_an_order
- Runtime method
- performQuery("sendowl.look_up_an_order"}
Query fields
Order number Text input > Regular expression
- Label
- Order number
- Helper text
- The SendOwl order number, e.g. the OrderNumber ingredient from a SendOwl trigger.
- Slug
- order_number
- Required
- true
- Can have default value
- true
Ingredients
Order number The SendOwl order number.
- Slug
- order_number
- Filter code
- Sendowl.lookUpAnOrder.OrderNumber
- Type
- String
- Example
- 12345
Buyer name The name of the buyer who placed the order.
- Slug
- buyer_name
- Filter code
- Sendowl.lookUpAnOrder.BuyerName
- Type
- String
- Example
- Jane Doe
Buyer email The email address of the buyer.
- Slug
- buyer_email
- Filter code
- Sendowl.lookUpAnOrder.BuyerEmail
- Type
- String
- Example
- jane@example.com
Products The product or products in the order, comma-separated. Falls back to the product id if a name can't be resolved.
- Slug
- products
- Filter code
- Sendowl.lookUpAnOrder.Products
- Type
- String
- Example
- My Ebook, Starter Pack
Amount The gross amount paid, as a numeric value in string form.
- Slug
- amount
- Filter code
- Sendowl.lookUpAnOrder.Amount
- Type
- String
- Example
- 19.00
Currency The ISO 4217 currency code the order settled in.
- Slug
- currency
- Filter code
- Sendowl.lookUpAnOrder.Currency
- Type
- String
- Example
- USD
Order state The order's status, such as complete, free, or imported.
- Slug
- order_state
- Filter code
- Sendowl.lookUpAnOrder.OrderState
- Type
- String
- Example
- complete
Created at When the order was created.
- Slug
- created_at
- Filter code
- Sendowl.lookUpAnOrder.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06+05:00
