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 Definition	Data Field Type
customer.email	Email of the customer. Examples: [e-mail]	string
merchantOrderId	Order ID in merchant's system. Examples: 123456	string
creationTime	Time of purchase. Examples: { "usecSinceEpochUtc": "1674534345995000", "granularity": "MICROSECOND" }	json
orderStatus	Status of the purchase. Examples: { "status": "FULFILLED", "label": "Your order has been fulfilled." }	json
transactionMerchant.name	Name of the merchant. Examples: Merchant X	string
lineItem	List 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": "[e-mail] ", "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
priceline	Additional 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.displayName	Payment used to place the purchase order. Examples: Visa •••• 1234	string
orderUpdates	List 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 Definition	Data Field Type
uniqueId	A unique identifier for this item. Examples: 6789806736475647144 A789806736475647144	string
lastModifiedTime	The last time this item was modified. Examples: 2023-11-09T16:32:36.035236Z	string in ISO 8601 format
name	A name for this item. It may not be unique. Examples: Dining Reservation Balayage	string
merchantName	The business offering this reservation or waitlist. Examples: City Diner Nails by Mei	string
startTime	The start of the reserved time slot. Examples: 2023-12-29T01:30:00Z	string in ISO 8601 format
endTime	The end of the reserved time slot. Examples: 2023-12-29T03:30:00Z	string in ISO 8601 format
createdTime	When the waitlist entry was created. Examples: 2023-11-09T16:29:36.768543Z	string in ISO 8601 format
partySize	How many people were included in the request. Examples: 2	numeric string
service	The name of the service. Examples: Haircut Outside table	string
specialRequest	Any special request that was attached to the reservation. Examples: Table by the window.	string
address	The address of the business offering the service. Examples: 1600 Amphitheatre Pkwy, Mountain View, US	string
canceled	Whether 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 Group	OAuth Scope Name	Description	Exported Objects
order_reserve.purchases_reservations	https://www.googleapis.com/auth/dataportability.order_reserve.purchases_reservations	This resource group contains data for Order with Google and Reserve with Google.	Purchases Reservations