📖🖊...TRICK_AD_102...
We all know that we can export data from list view on any table in below formats and we can only see the data once we download and it may take time if the number of records are huge depending on export limitation set in the instance.
However, if we need to get the JSON of any table data (along with some specific columns only, if required) directly on the browser itself, we can achieve that by simply modifying the URL quickly.
Here are the steps below.
Step 1 (Optional): If we need the JSON only with specific columns then create a view on that table with those specific columns.
Step 2: Modify the browser URL as below and hit enter and we are all set.
https://<myinstance>.service-now.com/incident_list.do?JSONv2&useUnloadFormat=true&sysparm_view=<NewViewName>
**<myinstance> is the instance name and <NewViewName> is the view name that we created in the step 1.
Here we go!!! we can now see the records in JSON format on the browser console directly. SS below.
Pros:
1. It's a pretty quick way of getting the JSON if the number of records are not huge.
2. No need to export and download the file in the local machine to see the JSON.
Cons:
1. For huge number of records the browser may take longer time or go unresponsive for some time to load the data.
2. If the number of records are really huge (around 50K+) then some records may get truncated at the end.🖋📔
Thanks,
Animesh Das
Happy learning and sharing!
You may mark this helpful as well if it helps you.
