Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Iam trying to get the data from Oracle database and create a json payload using TXMLMAP and then pass it to Restapi.I have 162k records and trying to implement a batch processing for every 10000 records extracted from db i need to send a single Restapi call.Right now for every record it is doing a call to a API. Please let me know how to implement that.Any help is appreciated .
Thanks in advance
Hi
Using tLoop to do a loop and only select 10000 records from DB, check the 'All in one' option on tXMLMap to generate one document to include all 10000 records for one API call.
Regards
Shong
Thanks i was able to implement. But the Json structure {"data":[
{"ban":"8348","AccountId":"103","d":"T","triggeringSystem":"ECN","Name":"1"},
{"ban:"20","AccountId":"4","d":"C","triggeringSystem":"ECN",
"Name":"2}
]}
But my rest api is throwing 400 Bad request error
About Bad request error, I think you need to check and get more information about API definition, what's the Json structure format does the API expect? Does it support multiple records in Json?