Skip to main content
Solved

JSONExtractor: The JSON query is missing a JSON entity property (ie. type,size) at column 25

  • January 22, 2018
  • 1 reply
  • 79 views
P
Forum|alt.badge.img

I am getting the following error from a JSON Extactor:

The JSON query 'json["ResourceList"][0].LastModified' is missing a JSON entity property (ie. type,size) at column 25

How do I troubleshoot my error?

Query:

json["ResourceList"][0].LastModified

Data snippet:

{"TotalResults":1,"TotalPages":1,"Page":1,"ResourceList":[{"Id":"06255cb3-99ca-4d72-af3d-0786d381145a","LastModified":"2018-01-22T14:01:55"}],"test":[]}

Best answer by takashi

Hi @peterx, dot (.) separated expression is a JSON property expression, it won't extract the value of a member in a JSON object. If you intend to extract value of the "LastModified" member in the first element of the "ResourceList" array, you can use this JSON structure expression.

json["ResourceList"][0]["LastModified"]
See here to learn more about JSON Queries: JSON Queries | Help on the JSONFragmenter
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • 7843 replies
  • Best Answer
  • January 22, 2018

Hi @peterx, dot (.) separated expression is a JSON property expression, it won't extract the value of a member in a JSON object. If you intend to extract value of the "LastModified" member in the first element of the "ResourceList" array, you can use this JSON structure expression.

json["ResourceList"][0]["LastModified"]
See here to learn more about JSON Queries: JSON Queries | Help on the JSONFragmenter
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,087
Posts
121,858
Replies
39,729
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.