Importing data from import set Vs inserting data using json object

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-02-2024 12:24 AM
Hi Community,
We have come across situation where we have to convert json payload to csv file and insert the data from csv into target table using import set.
However, I want to know what are the advantages and disadvantages of inserting data directly from json file into servicenow table instead of going through import set?
Anyone come across same situation? any help would be appreciated.
TIA,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-03-2024 12:27 AM
Hi @Community Alums ,
I am explaining in couple of sentences advantage and disadvantage of inserting data directly from JSON file into ServiceNow table instead of going through Import Set...
Advantages of inserting data directly from JSON file into ServiceNow table:
Faster: Direct data insertion is generally faster than using import sets, especially for large datasets.
More efficient: Direct data insertion does not require the creation of an import set, which can save time and resources.
Simpler: The process of inserting data directly is more straightforward and requires fewer steps.
Disadvantages of inserting data directly from JSON file into ServiceNow table:
Less control: With direct data insertion, you have less control over the data import process. For example, you cannot use import sets to specify field mapping, data transformations, or duplicate checks.
Higher risk of errors: If there are any errors in the JSON file, they will be directly imported into the table, which can lead to data corruption.
Limited visibility: Direct data insertion does not provide as much visibility into the import process as import sets. You cannot track the status of the import or review the imported data before it is committed to the table.
When to use import sets:
For large datasets where you need more control and visibility over the import process.
When you need to perform data transformations or duplicate checks.
When you want to be able to review the imported data before it is committed to the table.
Please mark my answer Correct and Helpful if this in informative answer
Thanks & Regards
Adarsh Verma