Get text From JSON

Discuss
#1

Hey Dear Sir !

I Have A JSON Format

{“PnrNumber”:“8509357089”,“Status”:“SUCCESS”,“ResponseCode”:“200”,“TrainNumber”:“12542”,“TrainName”:“LTT GKP SUP EXP”,“JourneyClass”:“SL”,“ChatPrepared”:“NO”,“From”:“LOKMANYATILAK T [LTT]”,“To”:“BADSHAHNAGAR [BNZ]”,“JourneyDate”:“2019-10-21”,“Passangers”:[{“Passenger”:“Passenger 1”,“BookingStatus”:“PQWL//36”,“CurrentStatus”:“PQWL 28//28”},{“Passenger”:“Passenger 2”,“BookingStatus”:“PQWL//37”,“CurrentStatus”:“PQWL 29//29”},{“Passenger”:“Passenger 3”,“BookingStatus”:“PQWL//38”,“CurrentStatus”:“PQWL 30//30”},{“Passenger”:“Passenger 4”,“BookingStatus”:“PQWL//39”,“CurrentStatus”:“PQWL 31//31”}]}

I Want To Get Some Data From The Above JSON Format I Am So Confuse With New Component Added From Kodular Eagle Can AnyOne help Me

I Want To Get All Belowe Data In labels

  1. Status

  2. Train No.

  3. TrainName.

  4. JourneyClass

  5. Chat Preared

  6. From

  7. To

  8. JourneyDate

  9. Booking Status

  10. Current Status
#2

Hi
First you have to show what you have tried so far.

1 Like
#3

This is yr readable JSON :sweat_smile: :

{
	“PnrNumber”: “8509357089”,
	“Status”: “SUCCESS”,
	“ResponseCode”: “200”,
	“TrainNumber”: “12542”,
	“TrainName”: “LTT GKP SUP EXP”,
	“JourneyClass”: “SL”,
	“ChatPrepared”: “NO”,
	“From”: “LOKMANYATILAK T[LTT]”,
	“To”: “BADSHAHNAGAR[BNZ]”,
	“JourneyDate”: “2019 - 10 - 21”,
	“Passangers”: [
	 {
		“Passenger”: “Passenger 1”,
		“BookingStatus”: “PQWL36”,
		“CurrentStatus”:“PQWL2828”
	}, 
	{
	 	“Passenger”:“Passenger 2”,
	  	“BookingStatus”:“PQWL37”,
	  	“CurrentStatus”:“PQWL 2929”
	},
	{
	  “Passenger”:“Passenger 3”,
	  “BookingStatus”:“PQWL38”,
	  “CurrentStatus”:“PQWL 3030”
	},
	{“Passenger”:“Passenger 4”,
	 “BookingStatus”:“PQWL39”,
	 “CurrentStatus”:“PQWL 3131”
	}
]
#5

Nothing Yet Bcz I am Confused

#7

Helo @Srrazmi
U will need an extension…
JSON Tools from Luke Gackle.

Don’t forget to credit him.

Get it - json tools.aix (14.3 KB) .

Here are the blocks for help - :smile:
image
(Do same for rest blocks :smile: )

Thanks! :wink:

3 Likes
Survey Apps from MYSQL using JSON
#8

Or you can use the JSON Utils component in the Utilities category

3 Likes
#9

Not Working

Here Is A Page Url

#10

What’s not happening?
What blocks are u using?
Please post them for help.

Not Working
Not working will not work for this.

#11

blocks%20(1)
blocks (1).png699×394 31.9 KB

1 Like
#12

Why Sir ? ?

#13

Can you please .aia here?
So, I can check where the problem is.

1 Like
#14

Maybe you should leave these web properties like this:
WebProperties

#15

If you get data from your url and put it in a label, you get this:

Screenshot_20190905-232213
Screenshot_20190905-232213.png1080×2160 204 KB

Obviously this is not a JSON…

It seems that the web generates Json with a Javascript and the web component does not support or does not execute Javascritp.

#16