- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-12-2021 03:13 PM
Hey guys,
I am exploring Batch API
My requirement is , an internal team will post 10000 of Rest Calls per day.
Each Rest Call has around 300 records that has to be inserted to target table . So i cannot use Import Set API , as Import Set API only inserts/updates one record per call .
So I was exploring Scripted Rest API to parse the JSON and then insert to the Import Set table to transform.
There are some reference fields i have to populate and also create a Parent Child Relationships , so i would have to have a transform to build logic .
I also wanted to know about the Batch API .
Lets assume , i provide the Batch API end point to a different team, if they are going to post Rest Calls with multiple records , how is the data being transformed and how can i add logic before i transform data to Target table .
Is Batch API is an upgraded version of Table API with batches of Records ??
Thank You
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-17-2021 09:01 PM
Hi,
you need to send array of json objects
the key would be the column name in import set
Example:
field1 and field2 are the column names of the import set staging table
[
{
"field1":"value1",
"field2":"value2"
},
{
"field1":"value3",
"field2":"value3"
}
]
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2021 09:13 PM
Would you mind sharing what change you did which made it work.
You mentioned about the mode being set to Synchronous
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader