Shows null values for tExtractJasonFields

[Parikhharshal]

Hi there

I have designed my job like below which shows result as NULL. I am sure my tExtractjsonFields is not configured properly.

Trying to extract Json (as shown below) using URL:

[
  {
    "assignment_id": 1234,
    "title": "Assignment 1",
    "points_possible": 10,
    "due_at": "2012-01-25T22:00:00-07:00",
    "unlock_at": "2012-01-20T22:00:00-07:00",
    "muted": false,
    "min_score": 2,
    "max_score": 10,
    "median": 7,
    "first_quartile": 4,
    "third_quartile": 8,
    "module_ids": [
        1,
        2
    ],
    "submission": {
      "submitted_at": "2012-01-22T22:00:00-07:00",
      "score": 10
    }
  },
  {
    "assignment_id": 1235,
    "title": "Assignment 2",
    "points_possible": 15,
    "due_at": "2012-01-26T22:00:00-07:00",
    "unlock_at": null,
    "muted": true,
    "min_score": 8,
    "max_score": 8,
    "median": 8,
    "first_quartile": 8,
    "third_quartile": 8,
    "module_ids": [
        1
    ],
    "submission": {
      "submitted_at": "2012-01-22T22:00:00-07:00"
    }
  }
]

 My tExtractJsonFields is configred as below:

Can someone please guide what am I doing wrong?

Thanks

Harshal.

[Parikhharshal]

@rhall and @nthampi:

I tried doing with Xpath.

but it shows me error like this:tExtractJSONFields_1 - Unbound prefix: 2018-11-01T18

Not sure why it cannot still read.

[Anonymous]

hi Parikhharshal,

your json path queries does not seem to be correct as per data provided and the requirement 

you better use <"$[*]"> for the loop query.

and then specify the jsonpath for fields.

Regards 

Chandra Kant

[Anonymous]

@Parikhharshal

If you are using Read By JsonPath, please mention the Loop Jsonpath query as below.

If you are using Read By Xpath, please mention the Loop Xpath query as below.

[Parikhharshal]

@CK395 and @kharindran: 

It works fine. Thanks.

Similarly I have got 2 different scenarios:

Can you please suggest what should be my Loop jSonpath query in tExtractJsonFields?

1. 

{
  "page_views": {
    "2012-01-24T13:00:00-00:00": 19,
    "2012-01-24T14:00:00-00:00": 13,
    "2012-01-27T09:00:00-00:00": 23
  },
  "participations": [
    {
      "created_at": "2012-01-21T22:00:00-06:00",
      "url": "https://canvas.example.com/path/to/canvas",
    },
    {
      "created_at": "2012-01-27T22:00:00-06:00",
      "url": "https://canvas.example.com/path/to/canvas",
    }
  ]
}

2. 

{
  "2012-01-24":{
    "instructorMessages":1,
    "studentMessages":2
  },
  "2012-01-27":{
    "studentMessages":1
  }
}

[Parikhharshal]

@rhall and @manodwhb: Can you pls respond to this?

[Anonymous]

@Parikhharshal

1. The loop Jsonpath query for this case would be $.participations

2. I am not sure about this as there seems no fixed variable name. Will check on this and update you if I find a solution.

[Parikhharshal]

@kharindan: thanks for your reply. What about page_views block which is in point 1.?

[Anonymous]

Hi,

first of all make your first json file valid,

and since there are no such looping elements thus without looping

for 1 jsonpath query would be :

<"$.pageviews">

<"$.participations[*].created_at">

<"$.participations[*].url">

and for 2 jsonpath query would be 

<"$.2012-01-24.instructorMessages">

and similarly for other keys

Regards

Chandra Kant

[Parikhharshal]

@CK395 : thanks for the reply. What do you mean by make first json valid? What do I need to do?

Also for the second one, dates keep changing, So I think the way you have setup is going to be hardcoded.

Does it mean for both json queries it should be fairly simple as just bringing fields and get them?