Purchases & Reservations Schema Reference

Exported Object: Purchases
Exported Object represents: Your upcoming and past purchases gathered from Google Services.
Object is exported in these formats: JSON
Exported object has the following fields:
* The preceding fields represent key data fields for the purposes of parsing and ingesting the relevant data exports. Data fields produced in an export vary by service and user action and some services or actions don't produce each data field described.
Data Field *Field DefinitionData Field Type
customer.emailEmail of the customer.

Examples:
abc@gmail.com		string
merchantOrderIdOrder ID in merchant's system.

Examples:
123456		string
creationTimeTime of purchase.

Examples:
{ "usecSinceEpochUtc": "1674534345995000", "granularity": "MICROSECOND" }		json
orderStatusStatus of the purchase.

Examples:
{ "status": "FULFILLED", "label": "Your order has been fulfilled." }		json
transactionMerchant.nameName of the merchant.

Examples:
Merchant X		string
lineItemList of items in the purchase order.

Examples:
{ "provider": { "name": "Restaurant A" }, "priceline": [{ "type": "TOTAL", "amount": { "amountMicros": "1500000", "currencyCode": { "code": "USD" } }, "taxIncluded": false, "state": "ESTIMATE" }], "purchase": { "status": "DELIVERED", "quantity": 1, "fulfillment": { "type": "PICK_UP", "location": { }, "recipient": { "displayName": "John Doe", "email": "johndoe@gmail.com ", "firstName": "John", "lastName": "Doe", "phoneNumberDetails": [{ }] }, "timeWindow": { "startTime": { "usecSinceEpochUtc": "1674534345995000", "granularity": "MICROSECOND", "utcTimezoneOffsetMinutes": 0 } } }, "itemOption": [{ "name": "Coke", "quantity": 1, "priceline": [{ "type": "TOTAL", "amount": { "amountMicros": "0", "currencyCode": { "code": "USD" } }, "taxIncluded": false, "state": "UNSPECIFIED" }] }], "productInfo": { "name": "Soda - Drinks" }, "userVisibleStatusLabel": "Your order has been fulfilled." }, "statusLabel": "Your order has been fulfilled.", "name": "Soda - Drinks" } 		repeated json
pricelineAdditional line items in the purchase order like tax or gratuity.

Examples:
[{ "type": "TAX", "name": "Tax", "amount": { "amountMicros": "1760000", "currencyCode": { "code": "USD" } }, "taxIncluded": false, "state": "ESTIMATE" }, { "type": "FEE", "name": "Support Local Fee", "amount": { "amountMicros": "950000", "currencyCode": { "code": "USD" } }, "taxIncluded": false, "state": "ESTIMATE" }] 		repeated json
paymentInfo.displayNamePayment used to place the purchase order.

Examples:
Visa •••• 1234		string
orderUpdatesList of order updates.

Examples:
[{ "orderStatus": { "status": "FULFILLED", "label": "Your order has been fulfilled." }, "updateTime": { "usecSinceEpochUtc": "1674546170000000", "granularity": "MICROSECOND" } }, { "orderStatus": { "status": "CONFIRMED", "label": "Your order has been confirmed" }, "updateTime": { "usecSinceEpochUtc": "1674538362000000", "granularity": "MICROSECOND" } }] 		repeated json
Exported Object: Reservations
Exported Object represents: Your upcoming and past reservations gathered from Google Services.
Object is exported in these formats: JSON
Exported object has the following fields:
* The preceding fields represent key data fields for the purposes of parsing and ingesting the relevant data exports. Data fields produced in an export vary by service and user action and some services or actions don't produce each data field described.
Data Field *Field DefinitionData Field Type
unique_idA unique identifier for this item.

Examples:
6789806736475647144
A789806736475647144		string
last_modified_timeThe last time this item was modified.

Examples:
2023-11-09T16:32:36.035236Z		string in ISO 8601 format
nameA name for this item. It may not be unique.

Examples:
Dining Reservation
Balayage		string
merchant_nameThe business offering this reservation or waitlist.

Examples:
City Diner
Nails by Mei		string
start_timeThe start of the reserved time slot.

Examples:
2023-12-29T01:30:00Z		string in ISO 8601 format
end_timeThe end of the reserved time slot.

Examples:
2023-12-29T03:30:00Z		string in ISO 8601 format
created_timeWhen the waitlist entry was created.

Examples:
2023-11-09T16:29:36.768543Z		string in ISO 8601 format
party_sizeHow many people were included in the request.

Examples:
2		numeric string
serviceThe name of the service.

Examples:
Haircut
Outside table		string
special_requestAny special request that was attached to the reservation.

Examples:
Table by the window.		string
addressThe address of the business offering the service.

Examples:
1600 Amphitheatre Pkwy, Mountain View, US		string
canceledWhether the reservation or waitlist was canceled through Google. Note that Google may not be notified of cancellations made directly with the business.

Examples:
true		boolean string
A table representing Resource Groups and the objects that are exported with it.
Resource GroupOAuth Scope NameDescriptionExported Objects
order_reserve.purchases_reservationshttps://www.googleapis.com/auth/dataportability.order_reserve.purchases_reservationsThis resource group contains data for Order with Google and Reserve with Google.
Purchases
Reservations