Forum Discussion

mithsrini's avatar
mithsrini
New Contributor II
6 years ago
Solved

Conversion of json file to Reltio Specific format

Hello, We are creating a data interface between snaplogic and reltio with a .json file. Reltio expects the .json file to be in a specific format as below: Notice the ‘new line’ i.e ‘\n’ inserte...
  • koryknick's avatar
    koryknick
    6 years ago

    Try this. Basically, it still uses the JSON Formatter with “JSON Lines” but then added a Binary to Document with no conversion and a Mapper with Document input and Binary output views to replace the newline with comma-newline before writing back to file.

    Example pipeline converting a CSV to the JSON format requested attached.

    JSON_Lines_Create_File.zip (2.7 KB)

koryknick's avatar
koryknick
Employee
6 years ago

Not the most efficient, but update the expression in the Mapper snap to the following:

$content.replace(/\n/g, “,\n”).replace(/,\n$/, “”)

This will remove the comma and newline of the last record… if you want to keep the newline on the last line, use the following:

$content.replace(/\n/g, “,\n”).replace(/,\n$/, “\n”)