[resolved] Configuration of tExtractJSONFields

[Anonymous]

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

[Anonymous]

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]

[Anonymous · Accepted solution]

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

It works.