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"

}

Rookie Asked on December 30, 2020 in SuiteAnalytics.
Add Comment
0 Answer(s)

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor