Hello I am running into this error
when I am running the below query using the Excel add-in
Product7wordsorless is a custom field which has the attribute type of String
At first I thought the error was occuring because of the attribute type since TeamMemberships.Descriptions runs without error but I created a Product field with the attribute type of Text (same type as Description) and the same query error occurs.
Does the add-in not support subfields that are custom fields?
Has anyone run into this error before and know of any solutions?
Yes, this is a limitation of the current Excel add-in. See it being discussed here:
Creating Custom field and extracting it via Excel plugin
I also just tested your scenario and indeed the custom fields aren't working on the TeamMembership (or the Project object in general) regardless of their type (I tested both Strings, Texts and Drop-Downs).
We are currently working on a new version of the Excel add-in. I will discuss with Engineering if this can be made available in that next version.