topic Re: [resolved] Configuration of tExtractJSONFields in Talend Studio

[resolved] Configuration of tExtractJSONFields

Anonymous — Sat, 16 Nov 2024 10:28:05 GMT

Hello,
I'm kind new on talend big Data Platform.
I would like to extract data from tRest which output json data in a csv File.
I am only looking for the data in the "rows" fields. Then I will output those rows in CSV file
Here is the data outputed by the TRest component:

{
  "count": 124,
  "name": "BI_Report_Example",
  "columnNames": [
    "Reference #",
    "Date Created",
    "1ID Profile",
    "type_of_canal_request",
    "type_of_contact",
    "Initial Response Due",
    "Resolution Interval",
    "Date Closed"
  ],
  "rows": [
    [
      "160503-000012",
      "'2016-05-03 08:35:31'",
      null,
      "Utilities",
      null,
     &n

To see the whole post, download it here

Re: [resolved] Configuration of tExtractJSONFields

Anonymous — Tue, 09 Aug 2016 10:30:30 GMT

This component uses in the JSON Path and you have set is NOT a valid JSON path expression.
Try to use the array expression [0] or [1]

Re: [resolved] Configuration of tExtractJSONFields

Anonymous — Tue, 09 Aug 2016 15:22:09 GMT

Thanks jlolling
I tried the following
Loop Jsonpath query: "$.rows"
json query: "$[0]", "$[1]",etc

It works.