Not loading one field from Json files

[gireesh1216]

Hello Team,

I was not able to load UserName filed from Json file. Could you please help me how to load UserName filed from Json file. Below is the sample Json file script.

Example:

[{"Author" : {"UseName" :"Gireesh12"},"ID":1216,"Title":"Email:12345"}]

Result:

Author	ID	Tital
9E5576C60A6C58A6	1216	Email:12345

Expected Result:

UserName	ID	Tital
Gireesh12	1216	Email:12345

[Rohan]

Hi Giresh,

Have you checked these functions :

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunc...

Regards,

Rohan.

[gireesh1216]

Thanks Rohan, Using Json get function will get expected value.

JsonGet('{"Author" : {"UseName" :"Gireesh12"},"ID":1216,"Title":"Email:12345"}','/Author/UserName')

[Rohan]

Hi Giresh,

So this worked for you right ?

Regards,

Rohan.