AirMenuAbout this query
Triggers, queries, and actions are the building blocks of Applets. Triggers tell an Applet to start, queries ask a question, and actions are its end result.
Developer info
- Description
- This query will return all the orders of a specific user.
- API endpoint slug
- airmenu.username
- Runtime method
- performQuery("airmenu.username")
Query fields
User name Text input > Other
- Label
- What's the user name?
- Slug
- user_name
- Required
- true
- Can have default value
- true
Ingredients
EmailEmail of the user who placed the order.
- Slug
- user_name
- Filter code
- Airmenu.username.Email
- Type
- String
- Example
- example@gmail.com
User first nameFirst name of the user who placed the order.
- Slug
- user_first_name
- Filter code
- Airmenu.username.UserFirstName
- Type
- String
- Example
- John
User last nameLast name of the user who placed the order.
- Slug
- user_last_name
- Filter code
- Airmenu.username.UserLastName
- Type
- String
- Example
- Reagan
User phonePhone number of the user who placed the order.
- Slug
- user_phone
- Filter code
- Airmenu.username.UserPhone
- Type
- String
- Example
- +35199887766
User addressAddress of the user who placed the order.
- Slug
- user_address
- Filter code
- Airmenu.username.UserAddress
- Type
- String
- Example
- Berwick St, London W1F 0PH, United Kingdom
User cityCity of the user who placed the order.
- Slug
- user_city
- Filter code
- Airmenu.username.UserCity
- Type
- String
- Example
- London
User postal codePostal Code of the user who placed the order.
- Slug
- user_postal_code
- Filter code
- Airmenu.username.UserPostalCode
- Type
- String
- Example
- 4000-999
User countryCountry of the user who placed the order.
- Slug
- user_country
- Filter code
- Airmenu.username.UserCountry
- Type
- String
- Example
- USA
User photoPhoto of the user who placed the order.
- Slug
- user_photo
- Filter code
- Airmenu.username.UserPhoto
- Type
- Image URL
- Example
- https://photo.png
User longitudeLongitude from where the order was placed.
- Slug
- user_longitude
- Filter code
- Airmenu.username.UserLongitude
- Type
- String
- Example
- -5.54634564
User latitudeLatitude from where the order was placed.
- Slug
- user_latitude
- Filter code
- Airmenu.username.UserLatitude
- Type
- String
- Example
- 5.6666
Items plu listList of all the Plus in the order, separated by |
- Slug
- items_plu_list
- Filter code
- Airmenu.username.ItemsPluList
- Type
- String
- Example
- PLU123|PLU456|PLU99999|
Items name listList of all the titles of the items in the order, separated by |.
- Slug
- items_name_list
- Filter code
- Airmenu.username.ItemsNameList
- Type
- String
- Example
- bacon|eggs
Items price listList of all the prices of the items in the order, separated by |.
- Slug
- items_price_list
- Filter code
- Airmenu.username.ItemsPriceList
- Type
- String
- Example
- 12.5|2|4.3
Items qty listList of all the quantities of the items in the order, separated by |.
- Slug
- items_qty_list
- Filter code
- Airmenu.username.ItemsQtyList
- Type
- String
- Example
- 1|3|4
Order IDIdentification of the order.
- Slug
- order_id
- Filter code
- Airmenu.username.OrderId
- Type
- String
- Example
- 112
Order counterIdentification of the order
- Slug
- order_counter
- Filter code
- Airmenu.username.OrderCounter
- Type
- String
- Example
- 12
Order timeOrder time, Unix timestamp in milliseconds.
- Slug
- order_time
- Filter code
- Airmenu.username.OrderTime
- Type
- String
- Example
- 1650383483
Payment methodPayment method of the order.
- Slug
- payment_method
- Filter code
- Airmenu.username.PaymentMethod
- Type
- String
- Example
- Visa Card
Value paidTotal price of the order.
- Slug
- value_paid
- Filter code
- Airmenu.username.ValuePaid
- Type
- String
- Example
- 12.5
Division IDDivision where the order was created.
- Slug
- division_id
- Filter code
- Airmenu.username.DivisionId
- Type
- String
- Example
- London city
Division nameDivision title where the order was created.
- Slug
- division_name
- Filter code
- Airmenu.username.DivisionName
- Type
- String
- Example
- Table 25
Created atDate and the time when the order was created.
- Slug
- created_at
- Filter code
- Airmenu.username.CreatedAt
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00
Operator emailEmail of the operator who placed the order.
- Slug
- operator_email
- Filter code
- Airmenu.username.OperatorEmail
- Type
- String
- Example
- operator@gmail.com
Executor emailEmail of the person who executed the order.
- Slug
- executor_email
- Filter code
- Airmenu.username.ExecutorEmail
- Type
- String
- Example
- executor@gmail.com
Booking timeBooking time, Unix timestamps in milliseconds.
- Slug
- booking_time
- Filter code
- Airmenu.username.BookingTime
- Type
- String
- Example
- 7658765678578
Booking time iso8601Booking time of the order in ISO8601
- Slug
- booking_time_iso8601
- Filter code
- Airmenu.username.BookingTimeIso8601
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00
Booking time end iso8601Booking time end of the order in ISO8601
- Slug
- booking_time_end_iso8601
- Filter code
- Airmenu.username.BookingTimeEndIso8601
- Type
- Date with time (ISO8601)
- Example
- 2020-07-08T04:17:06.000+05:00