Talend community forum / tFileInputJSON - How do I get the data out of the second level?

talendtester · 2012-06-29 01:52:01

I am able to pull the data for the field OBJECTID by doing "$..OBJECTID" in the JSONPath query in my tFileInputJSON component.

I need help getting the data for the x and y fields. What should the JSONPath query be to get the x and y data?

Here is what my small test file looks like:
{
"displayFieldName": "FM_NAME",
"fieldAliases": {
"OBJECTID": "OBJECTID",
},
"geometryType": "esriGeometryPoint",
"spatialReference": {"wkid": 1000},
"features": [
{
"attributes": {
"OBJECTID": 100,
},
"geometry": {
"x": -27.99,
"y": 67.33
}
}
]
}

The job runs and gives an error message of:
Can't find any data with JSONPath $...X
Can't find any data with JSONPath $...Y

I found this post, it looks like it hasn't been resolved, so that is why it is not working for me?
http://jira.talendforge.org/browse/TDI-17306

pedro · 2012-06-29 04:08:59

Hi

Try these two JSONPath.
"$.features[*]..x"
"$.features[*]..y"

Regards,
Pedro

Uploaded Images

talendtester · 2012-06-29 17:03:57

Thanks Pedro!

It gives me the right output now.

Do you know why it gives me these messages?

The Json resource datas maybe have some problems, please make sure the data structure with the same fields.
The Json resource datas maybe have some problems, please make sure the data structure with the same fields.

pedro · 2012-07-02 09:00:56

Hi

Please show me the settings of tFileInputJSON. I didn't get this info.

Regards,
Pedro

talendtester · 2012-07-02 18:50:06

Property Type: Built-In
Schema: Built-In
Filename: C:/folderName/fileName.txt

Column JSONPath query
----------------------------------------------
OBJECTID "$..OBJECTID"
X "$.features[*]..x"
Y "$.features[*]..y"

Nothing is in the Advanced Settings section.

The schema is:
OBJECTID String 3
X String 20
Y String 19

Last edited by talendtester (2012-07-02 18:51:55)

pedro · 2012-07-03 05:25:10

Hi

This is because in your json file there are two OBJECTIDs.
"OBJECTID": "OBJECTID"
"OBJECTID": 100

Use this jsonpath: "$.features[*]..OBJECTID".

Regards,
Pedro

Announcement

Unanswered posts

#1 2012-06-29 01:52:01

tFileInputJSON - How do I get the data out of the second level?

#2 2012-06-29 04:08:59

Re: tFileInputJSON - How do I get the data out of the second level?

#3 2012-06-29 17:03:57

Re: tFileInputJSON - How do I get the data out of the second level?

#4 2012-07-02 09:00:56

Re: tFileInputJSON - How do I get the data out of the second level?

#5 2012-07-02 18:50:06

Re: tFileInputJSON - How do I get the data out of the second level?

#6 2012-07-03 05:25:10

Re: tFileInputJSON - How do I get the data out of the second level?

Board footer