How to handle complex Json request payload when we use Excel sheet as data source?

Question

Hi All,&nbsp;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?&nbsp;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?&nbsp;[
	{
		"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" }
			]
	}
]&nbsp;

chrisadams · Answer

It's difficult to elaborate more based on what you have given.
&nbsp;
As you say, the JSON is complex, even for a single donut.&nbsp; What isn't clear is how many donuts per payload?&nbsp; How much variation of batter and how much variation of toppings?&nbsp; How many items in batter?&nbsp; 1..n?&nbsp; &nbsp;1..3 max?
One thing I can say is that when using datasources, you don't have to restrict a cell in the datasource to be a single, discreet value.&nbsp; e.g. {$datasource$ingredient} gives chocolate.&nbsp; You could instead have a cell that contains the JSON for a whole topping record.&nbsp; E.g.&nbsp;{$datasource$topping} returns '
{ "id": "5001", "type": "None" }&nbsp;
&nbsp;or even...
{$datasource$topping} returns
{ "id": "5001", "type": "None" },{ "id": "5002", "type": "Glazed" },{ "id": "5003", "type": "Chocolate" },{ "id": "5004", "type": "Maple" }
&nbsp;With separate datasources of donuts, batters and toppings, with the latter two nested inside donuts, you potentially could test lots of variations with a relatively small numbers of rows in each.

chrisadams · Answer

In short, maybe multiple datasources and loops.&nbsp; Datasource loops can be nested...
&nbsp;

&nbsp;

saravanan384 · Answer

Can you please elaborate more?

saravanan384 · Answer

Thanks for the detailed reply&nbsp;ChrisAdams&nbsp;.&nbsp;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.&nbsp;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?&nbsp;Appreciate your effort on this!!

chrisadams · Answer

Hi,
Sorry, I not sure that I can without a lot of effort.
&nbsp;
The thing with datasources is that you call each row, so the random nature does make it harder to model.
&nbsp;
If randomness is key, have a look at Groovy script steps. E.g. a script that returns a random number of batters, toppings etc.
&nbsp;
You could use a combination of groovy scripts and excerpts of payloads in files that you could use to build a 'random' payload.
you could build your requests in text files

Forum Discussion

How to handle complex Json request payload when we use Excel sheet as data source?

6 Replies

Recent Discussions

Unable to authenticate license in Ready API Login button unresponsive

Assertions Panel issue to update assertions since update 3.63

ReadyAPI websocket plugin issue

Related Content

Delete with Request Body / Payload

Passing payload to GET request

Dynamic Rest request creation for an update payload