What is the limit of bulk data we can import in import set table in ServiceNow?

[azam110]

I am trying to import the bulk data in import set table using API but do not know the limit of data(the CSV file) we can import .

What is the maximum limit of data we can import using API?

[azam110]

Thanks Pradeep,

Actually we are trying to import the data in import set table using the API

https://instance.service-now.com/sys_import.do?sysparm_import_set_tablename=table_name&sysparm_trans...

The post call above will import the data from the file mentioned in the path?

Would this be feasible solution or will there be any issue with it?

What if few records fails? I dont want to go at UI to see the total records inserted. I wants all to be done using API.

My rest call goes and insert the records into import set table and transform the data(in target table) and in the response it get the total records inserted and how many fails, the details of the records fails as it comes at UI.

Thanks

Azam

[Ankur Bawiskar]

Hi Pradeep,

Any idea how many records in an excel ServiceNow data load can handle while loading the data. I have read that while importing row size should not exceed 8126 bytes. But that doesn't tell exactly how many rows can be processed.

Also how to measure the row size if we have sample xls file for data load.

Regards

Ankur

[Gurpreet07]

It shoudn't be because it should be restricted by max attachment size defined by property com.glide.attachment.max_size com.glide.attachment.max_size

[azam110]

Thanks Gurpreet

What is the value the property com.glide.attachment.max_size?

Thanks

Azam

[Gurpreet07]

By default it's 1024 i.e.1 GB. We have reduced it to 30 for most of our clients.

Administering Attachments - ServiceNow Wiki