I have the need to INCLUDE commas within the data that I am delimiting. On the CC API I was able to wrap this data in double quotes. The new API does not seem to support this functionality. Initially if I have the initial columns wrapped in quotes, I get a 400 error as seen below. If I remove the quotes from the column names, and leave the data wrapped in double quotes I get a 500. Is there a way to use a different delimiter? Is there a way to include comma’s in my data?
{
"messages": [
{
"localeOrigin": "DEFAULT",
"text": "Column: \"[\"id\", \"name\", \"displayName\", \"created\", \"description\", \"modified\", \"entitlements\", \"groups\", \"permissions\"]\" is unknown and/or column: \"[id, name, displayName, created, description, modified, entitlements, groups, permissions]\" is missing",
"locale": "en-US"
},
{
"localeOrigin": "REQUEST",
"text": "Column: \"[\"id\", \"name\", \"displayName\", \"created\", \"description\", \"modified\", \"entitlements\", \"groups\", \"permissions\"]\" is unknown and/or column: \"[id, name, displayName, created, description, modified, entitlements, groups, permissions]\" is missing",
"locale": "en-US"
}
],
"detailCode": "400.1.3 Illegal value",
"trackingId": "trackingidhere"
}