topic Re: JSON Transformation in Report Server

JSON Transformation

panda2004 — Fri, 03 Aug 2018 12:24:22 GMT

How would you replace the following key/value paris into columns?

{
	"ProductId":"88432",
	"Tags":[
		{
			"Key":"Category",
			"Value":"Electricity"
		},
		{
			"Key":"IsNew",
			"Value":true
		},
		{
			"Key":"ShippingType",
			"Value":"Worldwide"
		}	
	]
}

Re: JSON Transformation

Anonymous — Sun, 05 Aug 2018 11:36:58 GMT

Have you checked following video?

https://m.youtube.com/watch?v=ipI6mrWLQKA

Re: JSON Transformation

panda2004 — Fri, 10 Aug 2018 12:59:27 GMT

Just what I needed, thanks!

For future intersted people:

The tags is a List type.
You have the ability to either expand each item into different column, such as Tag1.Key/Tag1.Value, Tag2.Key/Tag2.value, or either expand each item to a different row (which is pretty **bleep** cool!).