How to perform batch insert operation for my custom servicenow table.

[Rohan18]

I was trying to perform batch insert operation for my custom table using Curl. Accoring to ServiceNow doc therir is possibility using "Table API" and "job Schedule".but still not getting exact solution.  

[Hitoshi Ozawa]

Not curl but it's possbile to setup a schedule in ServiceNow to do import.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/import-sets/task/...

[Rohan18]

Thanks for the suggestion hozawa.

[Ben Carlsten -]

Hello,

You can access your tables through REST if you do a couple things:

1. Make sure the table has 'Allow access to this table via web services' checked in the Application Access tab (screenshot below)
2. Send a POST call to the table using credentials of a user with proper access controls (if you use a user with 'admin' that'll be alright for sure).  You can get the structure of the call and code actually by looking at the REST API Explorer (search that in the navigator).  Use 'now', 'Table API', latest, and choose the table you want.  It'll give you curl commands on the bottom as well as a couple others.

Hope this helps,

Ben

[Rohan18]

Hi Ben Carlsten,

Thanks for the explanation,Its really help me.

Now I able to perfrom insert operation through "curl".Does it possible to insert multiple records using single "curl" using this approach.Do you have any idea about this?