Nested DataSource loops
Hi, I am new to ReadAPI and API testing, so I’m learning as I go along… I’m using data driven testing and have the following issue: My rest request uses the customerID to get information about the ...
Forum Discussion
Is it possible to get the data in one pass Instead of two passes?
Of course I can get all the data in one pass, but it will look like the following, if say the Customer1 has one account, customer2 has 3 accounts, customer3 has one account and customer4 has four accounts :
Customer1, account11, balance11
customer2,account21,balance21
customer2,account22,balance22
customer2,account23,balance23
customer3,account31,balance31
customer4,account41,balance41
customer4,account42,balance42
customer4,account43,balance43
customer4,account44,balance44
I don't know how to process this data. The API accepts one customerID and returns a json containing information on all the accounts for the customer.
- Based on the data you shared, it seems you already did good.
However, it is possible to do entirely in single groovy script too if one wishes to do so. It will be little lengthy.
Are building json after getting the the query result for each customer id?
And how do you verify the accounts for the each customer id? Compare against SQL result?This is how my test looks like:
- Sterp1: Outer loop DataSource( returns customerId and number of accounts for each customer from DB) For the example I shared earlier, this select would return 4 lines:
- Customer1,1 (customer1 has one account)
- customer2, 3 (customer2 has three accounts)
- customer3, 1 (customer3 has one account)
- customer4, 4 (customer4 has four accounts)
- Step2: Call API using customer ID. API returns json with details for all the accounts of the customer.
- Step3: Assert that the API retuned the correct number of accounts
- Step4: Inner Loop Datasource (returns the account details for all the customer's accounts)
- Step5: Assert that the account details of the current row exist in the json response
- Step6: Inner Data Source loop
- Step7: Outer Data Source Loop
So, in the outer loop I check that the API response json has the correct number of accounts for the customer, and in the inner loop I check that each account is correctly represented in the response json.
So for the above example, the outer loop would be executed 4 times and the API would be called 4 times, once per customer. The inner loop would be executed once for Customer1, 3 times for customer2, once for customer3 and 4 times for customer4.
"However, it is possible to do entirely in single groovy script too if one wishes to do so. It will be little lengthy."
I still can't see how to I can do this using just a simple loop!
- Not sure with the datasource and one loop since you have varied number of rows per customer id.
