title: Data validation with One of range rule in Google Sheets API
body: <p>I'm trying to implement data validation where the rule is one of the range using Google Sheets API. </p>
  
  <p>In sheet1, I have a master list where one column needs to be in one of the values. The possible dropdown values are in a separate sheet called dropdown. </p>
  
  <p>What is the error in my conditional value for one_of_range?</p>
  
  <pre><code>dropdown_action = {
  'setDataValidation':{
      'range':{
  
          'startRowIndex':1,
          'startColumnIndex':4, 
          'endColumnIndex':5
      },
      'rule':{
          'condition':{
              'type':'ONE_OF_RANGE', 
              'values': [
                  { "userEnteredValue" : "dropdown!A1:B2"
                  }
              ],
          },
          'inputMessage' : 'Choose one from dropdown',
          'strict':True,
          'showCustomUi': True
      }
  
  }
  }
  
  request = [dropdown_action]
  batchUpdateRequest = {'requests': request}
  SHEETS.spreadsheets().batchUpdate(spreadsheetId = id, 
                               body = batchUpdateRequest).execute()
  </code></pre>
  
  <p>However, I encountered into http error. I was able to get it working if I choose one of list instead of one_of_range. But I prefer to use one_of_range so that I can maintain the possible values in the same spreadsheet. </p>
  
  <p>HttpError 400 when requesting <a href="https://sheets.googleapis.com/v4/spreadsheets/id:batchUpdate?alt=json" rel="nofollow">https://sheets.googleapis.com/v4/spreadsheets/id:batchUpdate?alt=json</a> returned "Invalid requests[1].setDataValidation: Invalid ConditionValue.userEnteredValue: dropdown!A1:B2"></p>