Skip to main content
Solved

Extract json from json string


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"]
View original
Did this help you find an answer to your question?

4 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • 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
ebygomm wrote:

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+32
  • Influencer
  • April 27, 2020
nedwaterman wrote:

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
ebygomm wrote:

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

json[*] ["datetime"]

Cheers!   


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings