online sharepoint: the query to the field & # 39; list / ChoiceField & # 39; is not valid ".

Consider the following scenario:

List A with columns:

  • Title (Single line text)
  • Column A (Single line text)
  • Column B (Choice)

Y

List B with columns:

  • Title (single line of text)
  • ColumnOne (single line of text)
  • ColumnX (Search from list A, assigned column A)

Then the REST query for List B would be:

https: /// _api / web / lists / getbytitle (& # 39; ListB & # 39;) / Items? $ expand = ColumnX & $ select = Title, ColumnX, ColumnX / ColumnB