Solved

Extract json from json string

  • 27 April 2020
  • 4 replies
  • 15 views

Badge +3

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

 

 

icon

Best answer by ebygomm 27 April 2020, 15:22

View original

4 replies

Badge +10

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

json[*] ["datetime"]
Badge +3

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!

Badge +10

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

Badge +3

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

json[*] ["datetime"]

Cheers!   

Reply