API truncates mediumtext fields even when 'Disable Text Cut' is checked

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Martin2019
    Junior Member
    • Nov 2019
    • 3

    API truncates mediumtext fields even when 'Disable Text Cut' is checked

    When requesting entities by API, attributes represented by mediumtext in MySQL are truncated even though in entity manager it is defined with ''Disable Text Cut" for the attribute.

    This bug only occurs when the query is done to the whole entity list. Querying an ID works fine.

    Steps to reproduce the bug:

    1. In EspoCRM administration define an entity
    2. Define an attribute of type 'Text' which will create a textbox in the EspoCRM dataset and a 'mediumtext' field in a MySQL database. Check 'Disable Text Cut' for this attribute.
    3. Insert a record and use huge text for the attribute created above. I use the attribute to store a big JSON object which is needed by an external application.
    4. Now query ...
    4a. the whole entity list: GET https://<domain>/api/v1/<entity>
    4b. only the ID of the record created above: GET https://<domain>/api/v1/<entity>/<ID>

    For 4a the results of the textbox attribute will be truncated. For 4b the results will correctly not be truncated.

    The problem is, that 4a destroys the JSON objects which causes problems in the application querying the entity list.

    Environment:
    * EspoCRM version: 5.7.6
    * Advanced Pack 2.4.1

  • yuri
    Member
    • Mar 2014
    • 8440

    #2
    It's an intentional behavior. You need to fetch the record separately to get full contents.
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • yuri
      Member
      • Mar 2014
      • 8440

      #3
      You customize this in a service class https://github.com/espocrm/espocrm/b...cord.php#L1268
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment

      Working...