SuiteQL query executed through REST web services returns truncated field names
When executing the SuiteQL query below, custom field names longer than 26 characters are being truncated to 25 characters with a hash symbol (#
) at the end. Is there a way to configure the POST /services/rest/query/v1/suiteql request to return full field names instead of truncated field names?
SELECT custrecordzab_s_customer, custrecordzab_s_evergreen_months, custrecordzab_si_discount, custrecordzab_si_end_date, custrecordzab_si_overage_rate, custrecordzab_si_rate_plan, custrecordzab_si_start_date, custrecordzab_si_subscription, CUSTOMRECORDZAB_SUBSCRIPTION_ITEM.lastmodified FROM CUSTOMRECORDZAB_SUBSCRIPTION_ITEM INNER JOIN CUSTOMRECORDZAB_SUBSCRIPTION ON CUSTOMRECORDZAB_SUBSCRIPTION.id = CUSTOMRECORDZAB_SUBSCRIPTION_ITEM.custrecordzab_si_subscription INNER JOIN CUSTOMER ON CUSTOMER.id = CUSTOMRECORDZAB_SUBSCRIPTION.custrecordzab_s_customer
Two elements of the sample object below returned by the query highlight the unexpected truncation of field names.
- The
custrecordzab_si_rate_plan
field name is 26 characters long, and the full field name appears in the returned object. - The
custrecordzab_s_evergreen_months
field name is longer than 26 characters, and the field name is truncated to the 25 characters concatenated with the hash symbol.
{ "links": [], "custrecordzab_s_customer": "143271", "custrecordzab_s_evergreen#": "12", "custrecordzab_si_end_date": "12/21/2021", "custrecordzab_si_overage_#": "240", "custrecordzab_si_rate_plan": "1", "custrecordzab_si_start_da#": "12/22/2020", "custrecordzab_si_subscrip#": "74724", "lastmodified": "12/22/2020" }