Data validation with One of range rule in Google Sheets API -

i'm trying implement data validation rule 1 of range using google sheets api.

in sheet1, have master list 1 column needs in 1 of values. possible dropdown values in separate sheet called dropdown.

what error in conditional value one_of_range?

dropdown_action = { 'setdatavalidation':{     'range':{          'startrowindex':1,         'startcolumnindex':4,          'endcolumnindex':5     },     'rule':{         'condition':{             'type':'one_of_range',              'values': [                 { "userenteredvalue" : "dropdown!a1:b2"                 }             ],         },         'inputmessage' : 'choose 1 dropdown',         'strict':true,         'showcustomui': true     }  } }  request = [dropdown_action] batchupdaterequest = {'requests': request} sheets.spreadsheets().batchupdate(spreadsheetid = id,                               body = batchupdaterequest).execute() 

however, encountered http error. able working if choose 1 of list instead of one_of_range. prefer use one_of_range can maintain possible values in same spreadsheet.

httperror 400 when requesting https://sheets.googleapis.com/v4/spreadsheets/id:batchupdate?alt=json returned "invalid requests[1].setdatavalidation: invalid conditionvalue.userenteredvalue: dropdown!a1:b2">

as sam berlin suggested, solution add '=' in range.

"=dropdown!a1:b2" work one_in_range data validation rule.