How to see raw JSON coming from response in SSIS JSON Source Preview

Many times you like to see raw JSON coming from SSIS JSON Source

It's very easy, just try below trick.

1. First make sure you don't have Filter Set
2. Raw output option must be unchecked
3. Enable array flattening must be unchecked
4. Now click preview to see your data
5. On Preview Grid click on Hyperlink to see raw JSON

How to see structure of your JSON response

If you like to see structure of your JSON then simply click on Select Filter Button 

SSIS JSON Source supports powerful feature to visualize the data structure of your JSON file or REST API. You can select any hierarchy you like to extract using select filter UI. Notice that JSON array is indicated using the different icon. 

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/