products_fulfillment_places

Creates, updates, deletes, gets or lists a products_fulfillment_places resource.

Overview

Name	products_fulfillment_places
Type	Resource
Id	google.retail.products_fulfillment_places

Fields

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

Name	Accessible by	Required Params	Description
projects_locations_catalogs_branches_products_add_fulfillment_places	INSERT	branchesId, catalogsId, locationsId, productsId, projectsId	We recommend that you use the ProductService.AddLocalInventories method instead of the ProductService.AddFulfillmentPlaces method. ProductService.AddLocalInventories achieves the same results but provides more fine-grained control over ingesting local inventory data. Incrementally adds place IDs to Product.fulfillment_info.place_ids. This process is asynchronous and does not require the Product to exist before updating fulfillment information. If the request is valid, the update will be enqueued and processed downstream. As a consequence, when a response is returned, the added place IDs are not immediately manifested in the Product queried by ProductService.GetProduct or ProductService.ListProducts. The returned Operations will be obsolete after 1 day, and GetOperation API will return NOT_FOUND afterwards. If conflicting updates are issued, the Operations associated with the stale updates will not be marked as done until being obsolete.
projects_locations_catalogs_branches_products_remove_fulfillment_places	DELETE	branchesId, catalogsId, locationsId, productsId, projectsId	We recommend that you use the ProductService.RemoveLocalInventories method instead of the ProductService.RemoveFulfillmentPlaces method. ProductService.RemoveLocalInventories achieves the same results but provides more fine-grained control over ingesting local inventory data. Incrementally removes place IDs from a Product.fulfillment_info.place_ids. This process is asynchronous and does not require the Product to exist before updating fulfillment information. If the request is valid, the update will be enqueued and processed downstream. As a consequence, when a response is returned, the removed place IDs are not immediately manifested in the Product queried by ProductService.GetProduct or ProductService.ListProducts. The returned Operations will be obsolete after 1 day, and GetOperation API will return NOT_FOUND afterwards. If conflicting updates are issued, the Operations associated with the stale updates will not be marked as done until being obsolete.

INSERT example

Use the following StackQL query and manifest file to create a new products_fulfillment_places resource.

All Properties

/*+ create */
INSERT INTO google.retail.products_fulfillment_places (
branchesId,
catalogsId,
locationsId,
productsId,
projectsId,
type,
placeIds,
addTime,
allowMissing
)
SELECT 
'{{ branchesId }}',
'{{ catalogsId }}',
'{{ locationsId }}',
'{{ productsId }}',
'{{ projectsId }}',
'{{ type }}',
'{{ placeIds }}',
'{{ addTime }}',
{{ allowMissing }}
;

Manifest

- name: your_resource_model_name
  props:
    - name: type
      value: string
    - name: placeIds
      value:
        - string
    - name: addTime
      value: string
    - name: allowMissing
      value: boolean

DELETE example

Deletes the specified products_fulfillment_places resource.

/*+ delete */
DELETE FROM google.retail.products_fulfillment_places
WHERE branchesId = '{{ branchesId }}'
AND catalogsId = '{{ catalogsId }}'
AND locationsId = '{{ locationsId }}'
AND productsId = '{{ productsId }}'
AND projectsId = '{{ projectsId }}';