# Purchases & Reservations Schema Reference

| Data Field \* | Field Definition | Data Field Type |
|---|---|---|
| customer.email | Email of the customer. Examples: abc@gmail.com | 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": "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 |
| 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: 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:]

| 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 |
[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:]

| Resource Group \* | Description | Exported Objects |
|---|---|---|
| order_reserve.purchases_reservations | This resource group contains data for Order with Google and Reserve with Google. | Purchases Reservations |
[A table representing Resource Groups and the objects that are exported with it.]