aditya_sharma
7 years agoNew Contributor III
How to send output data as JSON from script snap
Hi,
I am doing some transformation in script snap and some of the objects I want to send as is to downstream to store them as json in redshift, but when they are loading in redshift they are storing like {abc:234,pqr:[1,2,3]} i.e. they are not properly quoted. I have tried using json module in my script snap as I am using python, it didn’t work as I have nested structure coming and when you read the type of the objects coming it shows as java data types. Also, sometimes it is replacing “:” within json to “=” sign in the redshift.
Thanks