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].LastModifiedData 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"]
+19Hi @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"]Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
