Value in the External object fields are getting Truncated when External Data Source Format is "Atom Pub" and the response is multi-line value
Last updated 2022-02-10 ·Reference W-3743812 ·Reported By 0 users
Summary
Value in the External object fields are getting Truncated when External Data Source Format is "Atom Pub" and the response is multi-line value
Repro
i) Create a record on the server end of the External Data Source with multi-line value in one of the fields
for example: "1\n2\n3\n4\n5\n6\n7\n8\n9\n10\n11\n12"
ii) Go to "External Data Sources" from Setup in Developer Org and create an External Data Sources setup with Format "Atom Pub"
iii) Click on Validate and Sync button and create a Tab for the External Object for which the above mention record in STEP 1 was created.
iv) Go to the above created Tab and find the record created in STEP 1 and open the record in Salesforce.
v) Compare the value in the field in which the multi-line response has been created.
The value might be truncated for example:
"11\n12"
Note : The value in External data Server and the Salesforce end could defer as Atom Pub parser is not able to parse the response from the endpoint correctly. It reads the value in chunks, but only the last chunk is retained which is why the end result is the last two rows of the multi-line value.
Workaround
Changing the Format in External Data Source setup in Salesforce from Atom Pub to JSON resolves the issue.
Reported By (0)
Is it Fixed?
Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.