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

The following fields are returned by SELECT queries:

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

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
projects_locations_product_sets_add_productinsertprojectsId, locationsId, productSetsIdAdds 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_productdeleteprojectsId, locationsId, productSetsIdRemoves a Product from the specified ProductSet.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
locationsIdstring
productSetsIdstring
projectsIdstring

INSERT examples

Adds 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.

INSERT INTO google.vision.product_sets_product (
data__product,
projectsId,
locationsId,
productSetsId
)
SELECT
'{{ product }}',
'{{ projectsId }}',
'{{ locationsId }}',
'{{ productSetsId }}'
;

DELETE examples

Removes a Product from the specified ProductSet.

DELETE FROM google.vision.product_sets_product
WHERE projectsId = '{{ projectsId }}' --required
AND locationsId = '{{ locationsId }}' --required
AND productSetsId = '{{ productSetsId }}' --required;