Qodex.ai

Search Developer Metadata

POST {{baseUrl}}/v4/spreadsheets/:spreadsheetId/developerMetadata:search

Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup object, this will return all DeveloperMetadata entries selected by it. If the DataFilter represents a location in a spreadsheet, this will return all developer metadata associated with locations intersecting that region.

Request Params

KeyDatatypeRequiredDescription
access_tokenstringOAuth access token.
altstringData format for response.
callbackstringJSONP
fieldsstringSelector specifying which fields to include in a partial response.
keystringAPI key. Your API key identifies your project and provides you with API access, quota, and reports. Required unless you provide an OAuth 2.0 token.
oauth_tokenstringOAuth 2.0 token for the current user.
prettyPrintstringReturns response with indentations and line breaks.
quotaUserstringAvailable to use for quota purposes for server-side applications. Can be any arbitrary string assigned to a user, but should not exceed 40 characters.
upload_protocolstringUpload protocol for media (e.g. "raw", "multipart").
uploadTypestringLegacy upload protocol for media (e.g. "media", "multipart").
$.xgafvstringV1 error format.

Request Body

{"dataFilters"=>[{"a1Range"=>"aute", "developerMetadataLookup"=>{"locationMatchingStrategy"=>"INTERSECTING_LOCATION", "locationType"=>"DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED", "metadataId"=>-761178, "metadataKey"=>"consequat Duis", "metadataLocation"=>{"dimensionRange"=>{"dimension"=>"COLUMNS", "endIndex"=>-22955243, "sheetId"=>41865153, "startIndex"=>-49712859}, "locationType"=>"SHEET", "sheetId"=>77477058, "spreadsheet"=>true}, "metadataValue"=>"tempor", "visibility"=>"DOCUMENT"}, "gridRange"=>{"endColumnIndex"=>-69789235, "endRowIndex"=>-98601086, "sheetId"=>32219017, "startColumnIndex"=>-61197874, "startRowIndex"=>-91350843}}, {"a1Range"=>"Ut cu", "developerMetadataLookup"=>{"locationMatchingStrategy"=>"INTERSECTING_LOCATION", "locationType"=>"SHEET", "metadataId"=>-32999997, "metadataKey"=>"commodo sit esse consequat", "metadataLocation"=>{"dimensionRange"=>{"dimension"=>"ROWS", "endIndex"=>1730530, "sheetId"=>-56140506, "startIndex"=>82831554}, "locationType"=>"SPREADSHEET", "sheetId"=>58086209, "spreadsheet"=>false}, "metadataValue"=>"in pariatur in Ut", "visibility"=>"DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED"}, "gridRange"=>{"endColumnIndex"=>81731062, "endRowIndex"=>51216059, "sheetId"=>-87090690, "startColumnIndex"=>-26697783, "startRowIndex"=>-36015480}}]}

HEADERS

KeyDatatypeRequiredDescription
Content-Typestring
Acceptstring

RESPONSES

status: OK

{"matchedDeveloperMetadata":[{"dataFilters":[{"a1Range":"ullam","developerMetadataLookup":{"locationMatchingStrategy":"EXACT_LOCATION","locationType":"SHEET","metadataId":-96703507,"metadataKey":"cupidatat irure dolor eu","metadataLocation":{"dimensionRange":{"dimension":"COLUMNS","endIndex":-47261175,"sheetId":3032031,"startIndex":-13916935},"locationType":"SHEET","sheetId":34119692,"spreadsheet":true},"metadataValue":"commodo","visibility":"DOCUMENT"},"gridRange":{"endColumnIndex":-92591699,"endRowIndex":-77367572,"sheetId":21036335,"startColumnIndex":-90121416,"startRowIndex":-28441128}},{"a1Range":"eu dolor minim Lorem","developerMetadataLookup":{"locationMatchingStrategy":"EXACT_LOCATION","locationType":"DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED","metadataId":-74716743,"metadataKey":"aliqua est anim nisi","metadataLocation":{"dimensionRange":{"dimension":"DIMENSION_UNSPECIFIED","endIndex":71729621,"sheetId":25577647,"startIndex":88154583},"locationType":"DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED","sheetId":75611815,"spreadsheet":false},"metadataValue":"magna reprehenderit in minim","visibility":"PROJECT"},"gridRange":{"endColumnIndex":-84187908,"endRowIndex":-74735246,"sheetId":96622353,"startColumnIndex":-25608378,"startRowIndex":-22957175}}],"developerMetadata":{"location":{"dimensionRange":{"dimension":"DIMENSION_UNSPECIFIED","endIndex":-3673940,"sheetId":-65524837,"startIndex":-54517761},"locationType":"ROW","sheetId":-56245453,"spreadsheet":false},"metadataId":34322524,"metadataKey":"laborum veniam fugiat","metadataValue":"eiusmod qui Lorem est","visibility":"DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED"}},{"dataFilters":[{"a1Range":"dolore","developerMetadataLookup":{"locationMatchingStrategy":"EXACT_LOCATION","locationType":"DEVELOPER_METADATA_LOCATION_TYPE_UNSPECIFIED","metadataId":-40811642,"metadataKey":"adipisicing laboris ut velit","metadataLocation":{"dimensionRange":{"dimension":"ROWS","endIndex":-53824975,"sheetId":-93273913,"startIndex":86130672},"locationType":"ROW","sheetId":52856889,"spreadsheet":true},"metadataValue":"aliqua et aliquip occaecat aute","visibility":"PROJECT"},"gridRange":{"endColumnIndex":-73440610,"endRowIndex":28308616,"sheetId":37046200,"startColumnIndex":-5275558,"startRowIndex":-89666878}},{"a1Range":"officia non","developerMetadataLookup":{"locationMatchingStrategy":"INTERSECTING_LOCATION","locationType":"ROW","metadataId":14514280,"metadataKey":"ni","metadataLocation":{"dimensionRange":{"dimension":"DIMENSION_UNSPECIFIED","endIndex":90859887,"sheetId":24355574,"startIndex":-70400658},"locationType":"ROW","sheetId":8907501,"spreadsheet":true},"metadataValue":"ut aute dolore","visibility":"DOCUMENT"},"gridRange":{"endColumnIndex":-61886577,"endRowIndex":-27471726,"sheetId":28840797,"startColumnIndex":13238176,"startRowIndex":-28396473}}],"developerMetadata":{"location":{"dimensionRange":{"dimension":"ROWS","endIndex":76653041,"sheetId":-21267874,"startIndex":-66439347},"locationType":"SHEET","sheetId":21282299,"spreadsheet":true},"metadataId":8593114,"metadataKey":"sunt velit","metadataValue":"et","visibility":"DEVELOPER_METADATA_VISIBILITY_UNSPECIFIED"}}]}