I am trying to post multiple records to a business central, via the OData API, but not successful. I am however able to insert a record at a time.
Any assistance on how to go about this, is highly appreciated.
Below are screenshots of my postman.
Does that API support multiple records at the same time?
If not, then you might need to create some sort of loop, or a data driven test using the test runner.
Is there any error information returned by the API?
If you are new to Postman. I would recommend going through the Postman training if you havenât done so yet.
Postman Galaxy Training | Postman API Network
Run through the âAPIs 101 Trainingâ, then the âTesting and Automation Trainingâ course.
The following links provide a bit more info about data driven testing.
Importing data files | Postman Learning Center
API Testing âA Beginners Viewâ: Data-driven testing in Postman - Community showcase - Postman
Thank you @michaelderekjones for this insightful links.
Yes, OData does support multiple records. Hereâs how I managed it, by using $batch:
then thereâs the header and body. Body consisting of values to be inserted into the BC table.
The area with black shadding on POST is the MS Azure tenant ID.
A more better explanation of this will go a long way to helping understand the whole dynamic of the solution.
The body you have posted is an JSON array of objects. (Itâs also a JSON object in its own right).
The requests element is an array.
JSON uses key\value pairs. You can have arrays within arrays. (Structures can get complicated - there are tools on the web that help visualise complex JSON).
How an API will accept data is largely down to the API. I havenât looked up the ODataV4 standard to see if the requests\methodâs you have follow that standard or if its just how this API works.
I would say that the ability to post multiple requests at the same time preventing the need to write extra code to loop through requests appear to be a good design feature of this API.
Even better, it looks like you can submit different types of data in the same request through the URL.
I donât know if thatâs part of the core Dynamics API, or has been extended by the supplier. (We use Dynamics but I havenât been that involved in testing it, I do know it has well documented APIâs that can be used to inject test data to setup the known state before a particular test - just havenât used it in anger).
