1

I am trying to retrieve a Managed Metadata column from a SharePoint list using a REST call. The column/field name is Department. I found this site, https://threewill.com/pulling-managed-metadata-values-via-rest/ and I tried the query with TaxCatchAll, but it gives me the below error:

"The field 'TaxCatchAll' is not supported in query. The lookup list is in another web."

_api/web/lists/getbytitle('ListName')/items?$select=*,TaxCatchAll/Department&$filter=TaxCatchAll/Department eq 'ListName'&$expand=TaxCatchAll";

That is the only source I can find, is there another way to go about this or is it not possible to GET?

Improve this question

1 Answer 1

Reset to default
1

Retrieving TaxCatchAll column can help us get metadata id and term label.

Try to use this:

  _api/web/lists/getbytitle('ListName')/items?$select=Department,TaxCatchAll/ID,TaxCatchAll/Term&$filter=Department eq 'ListName'&$expand=TaxCatchAll
Improve this answer
2
  • I get an error message with a managed metadata field: The field 'Department' of type 'TaxonomyFieldType' cannot be used in the query filter expression. Thoughts? Commented Jun 3, 2022 at 12:54
  • You can refer to this question:sharepoint.stackexchange.com/questions/98827/… Commented Jun 4, 2022 at 9:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.