Symptom
You are performing a GET in OData and the values of a multivalue list are appearing in the same line separated by comma. E.g. 101,111,112.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP Cloud for Customer
Reproducing the Issue
1. Go to OData Console.
2. Select the desired entity and perform a GET.
3. Look for the Multivalue List field in the JSON result.
Result: You will see that the field are separated by comma, not in different lines.
Example:
Cause
The separator of the multiple values for the field is a comma, which is the same character as the delimiter of the columns in the CSV file.
In UI, you can see that the same behavior occurs: the value is shown separated by comma as well.
Example:
Resolution
This is the system expect behavior.
You can reach to Influence Portal in case you want to post an idea to improvement with your request.
See Also
Keywords
Multivalue List; Mutivalue; Code; OData; Line; Comma. , KBA , LOD-CRM-INT-API , OData API (C4C Only) , Problem