saravanan384
New Contributor
Joined 2 years ago
User Profile
User Widgets
Contributions
Re: How to handle complex Json request payload when we use Excel sheet as data source?
Thanks for the detailed reply ChrisAdams . To answer your questions, The No of donuts, No of batter and No of toppings may vary test case by test case. For example my test case 1 may have 3 nos of donuts, my test case 2 may have 2 nos of donuts. Same thing applicable for batter and toppings too. That's why it is making too complex for me to handle the datasource. Can you please show me some example excel sheet to accommodate this complex JSON? Also help me by showing some sample datasource Steps and usage of datasource in ReadyAPI for this Complex JSON? Appreciate your effort on this!!708Views0likes0CommentsHow to handle complex Json request payload when we use Excel sheet as data source?
Hi All, I know how to do data driven testing using Datasource, Loop and so in Ready API. I would like to understand the best practice to handle Complex JSON request payload. In other words, If my JSON payload has multiple arrays and I need to run multiple iterations of data how could I efficiently handle this? For example, consider below is my JSON request payload. Lets assume, I will have to run 10 different iterations of data with the below pay load template. How could I approach my test data parameterization in Ready API? [ { "id": "0001", "type": "donut", "name": "Cake", "ppu": 0.55, "batters": { "batter": [ { "id": "1001", "type": "Regular" }, { "id": "1002", "type": "Chocolate" }, { "id": "1003", "type": "Blueberry" }, { "id": "1004", "type": "Devil's Food" } ] }, "topping": [ { "id": "5001", "type": "None" }, { "id": "5002", "type": "Glazed" }, { "id": "5005", "type": "Sugar" }, { "id": "5007", "type": "Powdered Sugar" }, { "id": "5006", "type": "Chocolate with Sprinkles" }, { "id": "5003", "type": "Chocolate" }, { "id": "5004", "type": "Maple" } ] }, { "id": "0002", "type": "donut", "name": "Raised", "ppu": 0.55, "batters": { "batter": [ { "id": "1001", "type": "Regular" } ] }, "topping": [ { "id": "5001", "type": "None" }, { "id": "5002", "type": "Glazed" }, { "id": "5005", "type": "Sugar" }, { "id": "5003", "type": "Chocolate" }, { "id": "5004", "type": "Maple" } ] }, { "id": "0003", "type": "donut", "name": "Old Fashioned", "ppu": 0.55, "batters": { "batter": [ { "id": "1001", "type": "Regular" }, { "id": "1002", "type": "Chocolate" } ] }, "topping": [ { "id": "5001", "type": "None" }, { "id": "5002", "type": "Glazed" }, { "id": "5003", "type": "Chocolate" }, { "id": "5004", "type": "Maple" } ] } ]855Views0likes6Comments