apps_script_projects

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

Overview

Name	apps_script_projects
Type	Resource
Id	google.integrations.apps_script_projects

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
projects_locations_apps_script_projects_create	insert	projectsId, locationsId		Creates an Apps Script project.
projects_locations_apps_script_projects_link	exec	projectsId, locationsId		Links a existing Apps Script project.

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
locationsId	string
projectsId	string

INSERT examples

projects_locations_apps_script_projects_create

Creates an Apps Script project.

INSERT INTO google.integrations.apps_script_projects (
data__appsScriptProject,
data__authConfigId,
projectsId,
locationsId
)
SELECT 
'{{ appsScriptProject }}',
'{{ authConfigId }}',
'{{ projectsId }}',
'{{ locationsId }}'
RETURNING
projectId
;

Manifest

# Description fields are for documentation purposes
- name: apps_script_projects
  props:
    - name: projectsId
      value: string
      description: Required parameter for the apps_script_projects resource.
    - name: locationsId
      value: string
      description: Required parameter for the apps_script_projects resource.
    - name: appsScriptProject
      value: string
      description: >
        The name of the Apps Script project to be created.
        
    - name: authConfigId
      value: string
      description: >
        The auth config id necessary to fetch the necessary credentials to create the project for external clients
        

Lifecycle Methods

projects_locations_apps_script_projects_link

Links a existing Apps Script project.

EXEC google.integrations.apps_script_projects.projects_locations_apps_script_projects_link 
@projectsId='{{ projectsId }}' --required, 
@locationsId='{{ locationsId }}' --required 
@@json=
'{
"scriptId": "{{ scriptId }}"
}';