experimentation_items

Creates, updates, deletes, gets or lists an experimentation_items resource.

Overview

Name	experimentation_items
Type	Resource
Id	vercel.marketplace.experimentation_items

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:

Name	Accessible by	Required Params	Optional Params	Description
create	insert	integration_configuration_id, resource_id, items		Create one or multiple experimentation items
update	update	integration_configuration_id, resource_id, item_id, slug, origin		Patch an existing experimentation item
delete	delete	integration_configuration_id, resource_id, item_id		Delete an existing experimentation item

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.

Name	Datatype	Description
integration_configuration_id	string
item_id	string
resource_id	string

INSERT examples

create

Create one or multiple experimentation items

INSERT INTO vercel.marketplace.experimentation_items (
items,
integration_configuration_id,
resource_id
)
SELECT 
'{{ items }}' /* required */,
'{{ integration_configuration_id }}',
'{{ resource_id }}'
;

Manifest

# Description fields are for documentation purposes
- name: experimentation_items
props:
  - name: integration_configuration_id
    value: "{{ integration_configuration_id }}"
    description: Required parameter for the experimentation_items resource.
  - name: resource_id
    value: "{{ resource_id }}"
    description: Required parameter for the experimentation_items resource.
  - name: items
    value:
      - id: "{{ id }}"
        slug: "{{ slug }}"
        origin: "{{ origin }}"
        category: "{{ category }}"
        name: "{{ name }}"
        description: "{{ description }}"
        isArchived: {{ isArchived }}
        createdAt: {{ createdAt }}
        updatedAt: {{ updatedAt }}

UPDATE examples

update

Patch an existing experimentation item

UPDATE vercel.marketplace.experimentation_items
SET 
slug = '{{ slug }}',
origin = '{{ origin }}',
name = '{{ name }}',
category = '{{ category }}',
description = '{{ description }}',
is_archived = {{ is_archived }},
created_at = {{ created_at }},
updated_at = {{ updated_at }}
WHERE 
integration_configuration_id = '{{ integration_configuration_id }}' --required
AND resource_id = '{{ resource_id }}' --required
AND item_id = '{{ item_id }}' --required
AND slug = '{{ slug }}' --required
AND origin = '{{ origin }}' --required;

DELETE examples

delete

Delete an existing experimentation item

DELETE FROM vercel.marketplace.experimentation_items
WHERE integration_configuration_id = '{{ integration_configuration_id }}' --required
AND resource_id = '{{ resource_id }}' --required
AND item_id = '{{ item_id }}' --required
;