Skip to main content
Solved

Extract json from json string

  • April 27, 2020
  • 4 replies
  • 132 views

nedwaterman
Contributor
Forum|alt.badge.img+9

I'm trying to extract attributes from the attached json string using a jsonextractor.

 

I thought the jsonquery field would be json["datetime"] but nothing is being returned.

 

Any help is gratefully received.

 

Thanks

N

 

 

Best answer by ebygomm

Assuming you want to get multiple features from this, I would use the JSONFragmenter with the following query

json[*] ["datetime"]
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.

4 replies

ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • Best Answer
  • April 27, 2020

Assuming you want to get multiple features from this, I would use the JSONFragmenter with the following query

json[*] ["datetime"]

nedwaterman
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • April 27, 2020

Assuming you want to get multiple features from this, I would use the JSONFragmenter with the following query

json[*] ["datetime"]

Cheers - I did finally figure this out through some judicious goggling (after the event!).

 

Thank you!


ebygomm
Influencer
Forum|alt.badge.img+46
  • Influencer
  • April 27, 2020

Cheers - I did finally figure this out through some judicious goggling (after the event!).

 

Thank you!

If you want all the parts as attribute values I'd use these settings though


nedwaterman
Contributor
Forum|alt.badge.img+9
  • Author
  • Contributor
  • April 27, 2020

Assuming you want to get multiple features from this, I would use the JSONFragmenter with the following query

json[*] ["datetime"]

Cheers!