Integration Cloud 7.0.0 | Built-In Services | Built-In Services | delimitedDataStringToDocument
 
delimitedDataStringToDocument
Converts delimited data string to a document.
This service will convert the following delimited data string:
"Date","Pupil","Grade"
"25 May","Bloggs, Fred","C"
"25 May","Doe, Jane","B"
"15 July","Bloggs, Fred","A"
Note:
Here the fieldQualifier = Comma(,) and textQualifier= double quote(")
to a document that looks like: (useHeaderRowForFieldNames=true)
or to a document that looks like: (useHeaderRowForFieldNames=false)
Input Parameters
delimited DataString
String. Delimited string to convert to a document.
fieldQualifier
String Optional. The delimiter to use for separating entries in delimitedDataString. Default is comma (,).
textQualifier
String Optional. The character to use for quoted elements. Default is double quote (").
useHeader RowFor FieldNames
String Optional. Consider first line as header row and use the delimited data of this line as property names in the output document. Set to:
*true. The delimited data of first line will be used as the property name in the output document. This is the default.
*false. column1, column2...columnN will be used as the property name in the output document.
encoding
String Optional. The encoding to use while parsing the delimited data.
Output Parameters
document
Document. Document resulting from the conversion of delimitedDataString. This document contains document array rows[] corresponding to the delimited data.