Class DeveloperMetadataFinder

  • DeveloperMetadataFinder is used to search for developer metadata in a spreadsheet.

  • You can create a DeveloperMetadataFinder using methods on Range, Sheet, or Spreadsheet objects.

  • Thefind() method executes the search and returns matching metadata.

  • You can refine your search using methods likewithId(),withKey(),withLocationType(),withValue(), andwithVisibility().

  • onIntersectingLocations() is an option specifically for range-scoped searches to consider intersecting locations with metadata.

DeveloperMetadataFinder

Search for developer metadata in a spreadsheet. To create new developer metadata finder useRange.createDeveloperMetadataFinder(),Sheet.createDeveloperMetadataFinder(),orSpreadsheet.createDeveloperMetadataFinder().

Methods

MethodReturn typeBrief description
find()DeveloperMetadata[]Executes this search and returns the matching metadata.
onIntersectingLocations()DeveloperMetadataFinderConfigures the search to consider intersecting locations that have metadata.
withId(id)DeveloperMetadataFinderLimits this search to consider only metadata that match the specified ID.
withKey(key)DeveloperMetadataFinderLimits this search to consider only metadata that match the specified key.
withLocationType(locationType)DeveloperMetadataFinderLimits this search to consider only metadata that match the specified location type.
withValue(value)DeveloperMetadataFinderLimits this search to consider only metadata that match the specified value.
withVisibility(visibility)DeveloperMetadataFinderLimits this search to consider only metadata that match the specified visibility.

Detailed documentation

find()

Executes this search and returns the matching metadata.

Return

DeveloperMetadata[] — The developer metadata that match the search criteria.

Authorization

Scripts that use this method require authorization with one or more of the followingscopes:

  • https://www.googleapis.com/auth/spreadsheets.currentonly
  • https://www.googleapis.com/auth/spreadsheets

onIntersectingLocations()

Configures the search to consider intersecting locations that have metadata. This option isonly valid for range-scoped searches.

Return

DeveloperMetadataFinder — The developer metadata finder, for chaining.


withId(id)

Limits this search to consider only metadata that match the specified ID.

Parameters

NameTypeDescription
idIntegerThe ID to match when searching for metadata.

Return

DeveloperMetadataFinder — The developer metadata finder, for chaining.


withKey(key)

Limits this search to consider only metadata that match the specified key.

Parameters

NameTypeDescription
keyStringThe key to match when searching for metadata.

Return

DeveloperMetadataFinder — The developer metadata finder, for chaining.


withLocationType(locationType)

Limits this search to consider only metadata that match the specified location type.

Parameters

NameTypeDescription
locationTypeDeveloperMetadataLocationTypeThe location type to match when searching for metadata.

Return

DeveloperMetadataFinder — The developer metadata finder, for chaining.


withValue(value)

Limits this search to consider only metadata that match the specified value.

Parameters

NameTypeDescription
valueStringThe value to match when searching for metadata.

Return

DeveloperMetadataFinder — The developer metadata finder, for chaining.


withVisibility(visibility)

Limits this search to consider only metadata that match the specified visibility.

Parameters

NameTypeDescription
visibilityDeveloperMetadataVisibilityThe visibility to match when searching for metadata.

Return

DeveloperMetadataFinder — The developer metadata finder, for chaining.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-11 UTC.