JSON Output Not Written

Hi,

Firstly check the result from the JSONFlattener with the Inspector (Feature Information window of Data Inspector).

In addition, I don't think you need to use the JSONFormatter before flattening a valid JSON object.

Takashi

In addition, if you set "Yes" to the "Load Keys as Attributes" and "Recursively Flatten Objects/Arrays" parameters of the JSONFragmenter, you can remove the JSONFlattener.

A simple way is to filter the features by the "name" attribute value after flattening the JSON objects. For example:

Tester: name Matches Regex ^\\d+$

This regular expression matches a string consisting of numbers only.

I'm not sure why the features cannot be filtered by the "name" attribute value. Could you please describe the situation in more detail?

The text you posted contains just one JSON object, which contains a string member called "name" and two array members called "routeSections" and "serviceTypes". Every element of those arrays also contains a member called "name".  Which objects do you want to extract?

This is the JSON object you posted.

{
   "$type" : "Tfl.Api.Presentation.Entities.Line, Tfl.Api.Presentation.Entities",
   "id" : "102",
   "name" : "102",
   "modeName" : "bus",
   "created" : "2015-12-07T14:16:21.757",
   "modified" : "2015-12-07T14:16:21.757",
   "lineStatuses" : [],
   "routeSections" : [
      {
         "$type" : "Tfl.Api.Presentation.Entities.MatchedRoute, Tfl.Api.Presentation.Entities",
         "name" : "Brent Cross Shopping Centre - Edmonton Green Bus Station",
         "direction" : "inbound",
         "originationName" : "Brent Cross Shopping Centre",
         "destinationName" : "Edmonton Green Bus Station",
         "originator" : "490004282D",
         "destination" : "490009983A",
         "serviceType" : "Regular"
      },
      {
         "$type" : "Tfl.Api.Presentation.Entities.MatchedRoute, Tfl.Api.Presentation.Entities",
         "name" : "Edmonton Green Bus Station - Brent Cross Shopping Centre",
         "direction" : "outbound",
         "originationName" : "Edmonton Green Bus Station",
         "destinationName" : "Brent Cross Shopping Centre",
         "originator" : "490009983G",
         "destination" : "490004282A",
         "serviceType" : "Regular"
      },
      {
         "$type" : "Tfl.Api.Presentation.Entities.MatchedRoute, Tfl.Api.Presentation.Entities",
         "name" : "Brent Cross Shopping Centre - Edmonton Green Bus Station",
         "direction" : "inbound",
         "originationName" : "Brent Cross Shopping Centre",
         "destinationName" : "Edmonton Green Bus Station",
         "originator" : "490004282D",
         "destination" : "490009983A",
         "serviceType" : "Regular"
      },
      {
         "$type" : "Tfl.Api.Presentation.Entities.MatchedRoute, Tfl.Api.Presentation.Entities",
         "name" : "Edmonton Green Bus Station - Brent Cross Shopping Centre",
         "direction" : "outbound",
         "originationName" : "Edmonton Green Bus Station",
         "destinationName" : "Brent Cross Shopping Centre",
         "originator" : "490009983G",
         "destination" : "490004282A",
         "serviceType" : "Regular"
      }
   ],
   "serviceTypes" : [
      {
         "$type" : "Tfl.Api.Presentation.Entities.LineServiceTypeInfo, Tfl.Api.Presentation.Entities",
         "name" : "Regular",
         "uri" : "/Line/Route?ids=102&serviceTypes;=Regular"
      }
   ]
}

OK, try the JSONFragmenter with these parameter settings.

• JSON Query: json["routeSections"][0]
• Load Keys as Attributes: Yes
• Attributes to Expose: name (and other key names which you want to expose)

The query extracts the first element (index = 0) of the "routeSections" array.

If the original JSON data is an array that contains multiple objects (i.e. [{...}, {...}, ...]) , replace the JSON Query with this query.

json[*]["routeSections"][0]

My previous post has not been displayed with my browser. Can you see that?

Yes... Its visible at the top of the first page. Even I am having a bit of confusion with that.

Regarding your query on JSON- json[*]["routeSections"][0], now the "id" is not being extracted. Only the elements which were in the array ["routeSelections"] are extracted. The "id" is not the part of that array, but needs to be extracted. I tried using json[*]["routeSections"][0]["id"], "id', id. I also tried for using 2 JSONFragmenter, one for "id" and other for name and merging them. Either ways id didn't work. Can we have a better solution than that?

A possible way is to use a combination of the JSONFragmenter and ListIndexer

JSONFragmenter

• JSON Query: json[*]
• Load Keys as Attributes: Yes
• Recursively Flatten Objects/Arrays: Yes
• Attributes to Expose: id, routeSections{}.name

ListIndexer

• List Attribute: routeSections{}
• List Index: 0

Note: If the "routeSections" array was empty, the resulting "name" would be the value of "name" of the root object because the root object also has a member called "name". If there could be such a case, check the number of "routeSections{}" elements before the ListIndexer.

# I didn't think that my previous answer has been moved to the top of the first page.