Purchases & Reservations Schema Reference

    Data Field * Field Definition Data Field Type
    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.
    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
    Data Field * Field Definition Data Field Type
    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.
    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
    Resource Group * Description Exported Objects
    A table representing Resource Groups and the objects that are exported with it.
    order_reserve.purchases_reservations
    		 This resource group contains data for Order with Google and Reserve with Google.
    Purchases
    Reservations
    * To obtain the OAuth Scope Name for a particular Resource Group, append "https://www.googleapis.com/auth/dataportability." to the Resource Group. For example, the OAuth Scope Name for the "myactivity.search" Resource Group is "https://www.googleapis.com/auth/dataportability.myactivity.search".
    Design a Mobile Site
    View Site in Mobile | Classic
    Share by: