Explore Plans
Mobile menu Close menu
AirMenuAirMenu

Get all the orders from user

This query will return all the orders of a specific user.

Developer info

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