Skip to main content

product_sets_product

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

Overview

Nameproduct_sets_product
TypeResource
Idgoogle.vision.product_sets_product

Fields

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

Methods

NameAccessible byRequired ParamsDescription
projects_locations_product_sets_add_productINSERTlocationsId, productSetsId, projectsIdAdds a Product to the specified ProductSet. If the Product is already present, no change is made. One Product can be added to at most 100 ProductSets. Possible errors: * Returns NOT_FOUND if the Product or the ProductSet doesn't exist.
projects_locations_product_sets_remove_productDELETElocationsId, productSetsId, projectsIdRemoves a Product from the specified ProductSet.

INSERT example

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

/*+ create */
INSERT INTO google.vision.product_sets_product (
locationsId,
productSetsId,
projectsId,
product
)
SELECT
'{{ locationsId }}',
'{{ productSetsId }}',
'{{ projectsId }}',
'{{ product }}'
;

DELETE example

Deletes the specified product_sets_product resource.

/*+ delete */
DELETE FROM google.vision.product_sets_product
WHERE locationsId = '{{ locationsId }}'
AND productSetsId = '{{ productSetsId }}'
AND projectsId = '{{ projectsId }}';