parameterize json rest api request

Was wondering if anyone had input on best solution for parameterizing a json rest api request?

 

Here is what I'd like to parameterize: (sample request below)

MDOC_PRESENTED_QUESTION_ID

QUESTION

MDOC_ANSWER_ID

CHOICE_ID

CHOICE

 

Now I know there are the following datasource types to paramertize these:

Data Connection

Data Generator

Directory

Excel

File

Grid

Groovy

JDBC

Json

EML

 

I've tried Grid which seemed to require me to create seperate properties for each(so, questionid1, question1, answerid1, choiceid1, choice1, questionid2 etc etc etc....) and I also tried JDBC and was able to get first set of values for the first request block of question and choice ids via setting "prepared properties" for choiceid and answerid and then doing a query based on where clause = :QuestionID and :ChoiceID. This method seemed to be a challange vs grid since I need all differant values in the request for  :QuestionID and :ChoiceID and my query is only bringing back resutls for values set in the "prepared properties".

 

What would be the best route to take? Just stick with grid? Thinking of the most dynamic and least maintenance if values need to change etc....

 

 

 

sample Json request:

{
"mDOC_json_data": {
"mDOC_PRESENTED_QUESTION_json_dataList":
[{
"MDOC_PRESENTED_QUESTION_ID": 137,
"QUESTION": "Indicate_Persons_Overall_Health_Risk_137",
"ANSWER_LIST": [{
"MDOC_ANSWER_ID": 45,
"MDOC_PRESENTED_QUESTION_ID": 137,
"CHOICE_ID": 545,
"CHOICE": "Persons_Health_Conditions_Generally_Stable_545"
}]
},
{
"MDOC_PRESENTED_QUESTION_ID": 112,
"QUESTION": "HOSPITAL_Level_Of_Care_112",
"ANSWER_LIST": [{
"MDOC_ANSWER_ID": 202,
"MDOC_PRESENTED_QUESTION_ID": 112,
"CHOICE_ID": 75,
"CHOICE": "Certified_By_Physician_To_Require_Supports_Similar_To_Hospital_75"
}]
},
{
"MDOC_PRESENTED_QUESTION_ID": 82,
"QUESTION": "Clinical_Monitoring_Established_By_Persons_Physician_82",
"ANSWER_LIST": [{
"MDOC_ANSWER_ID": 100,
"MDOC_PRESENTED_QUESTION_ID": 82,
"CHOICE_ID": 314,
"CHOICE": "Person_Under_Clinical_Monitoring_Order_314"
}]
}],
"MDOC_ID": 12345,
"PERSON_ID": 965879,
"MC_REFERRAL_ID": 1322
},
"PERSON_ID": 965879,
"FIRST_NAME": "JOHN",
"MIDDLE_NAME": "M",
"LAST_NAME": "DOE",
"NAME_SUFFIX": "Sr."
}