Mockaroo is a great tool with flexible features.
Please check the following scheme:
As you can see, I have a nested json array - yearWiseMagiDetailList. Inside this array, yearWiseMagiDetailList.year is a field in which I want to create year list which starts from retirement_year field till life_expectancy year. But the Number function does not accept the start and end year which is dynamic in this case. Also, I tried the formula function with Ruby syntax but it didn’t work.
Please suggest some range function so that I can use it in this way - range(year(retirement_year), (year(birth_date) + life_expectancy))
Sample of the request -
{
“birthDate”:“02-2000”,
"retirementYear":“01-2067”,
"lifeExpectancy":68,
“singleVsMultipleMagi”:false,
“magiTierVsDollarAmount”:false,
“magiTier”:“3”,
“taxFilingStatus”:“MARRIED_FILING_SEPARATELY”,
“magiDollarAmount”:500001,
“healthGrade”:“2”,
“stateName”:“Colorado”,
“boughtPlanA”:“true”,
“reserveDaysUsed”:“0”,
“dental”:“true”,
“dentalHealthGrade”:“3”,
“tobacco”:true,
“yearWiseMagiDetailList”:[
{“year”:2067 ,“taxFilingStatus”:“MARRIED_FILING_JOINTLY”, “magiDollarAmount”:“110000”},
{“year”:2068 ,“taxFilingStatus”:“MARRIED_FILING_JOINTLY”, “magiDollarAmount”:“30000”}
]
}