...
| Excerpt | ||||
|---|---|---|---|---|
Version 2: This section describes how you can import JSON files into
|
The basic workflow task is described by way of example. In the example workflowtask, the JSON file must be imported into
| D s product | ||
|---|---|---|
|
...
Each row is a complete JSON record containing keys and values.
Tip Tip: Nested JSON, such as
metricsabove, can be inserted as part of a record. It can then be unnested within the application.Each key's value must have a comma after it, except for the final key value in any row.
Info NOTE: The end of a JSON record is the right curly bracket (}). Commas are not added to the end of each line in this format.
...
Task
Import the JSON file.
- Any nested data must be unnested within columns. Each level in the JSON hierarchy must be un-nested in a separate step.
- When all of the JSON data is in tabular form, perform any
transformations.D s lang - If you need to rebuild the loose JSON hierarchy, you must nest the lower levels of the JSON hierarchy back into their original form.
- If it is ok to write out flat JSON records, you can export without nesting the data again.
- Run the job, generating a JSON output.
...
