Multiple Fields missing from Data Source Selection
A customer is using Matillion ETL to extract records in their Zuora account. For at least two data sources (potentially others), not all fields selected in the "Data Selection" property are returned. The specific Zuora object in question is Rate Plan Charge. The MRR values do not seem to be extracted.
Regarding the Included Units field, there is a stipulation in the Zuora API that indicates that you cannot return this field if you are also attempting to return several other fields (e.g. price). However, in this specific case only Included Units are wanted in this API call.
"Checking under the hood", we (Matillion) found the current Zuora account endpoint https://rest.apisandbox.zuora.com/v1/action/query returns incorrect data - returning IDs instead of Included Units.
What could be causing this?