mpartyka
Contributor
Joined 11 years ago
User Profile
User Widgets
Contributions
Re: JSON as dataSource
Thanks again Rao ... I implemented your suggestion above ... almost there. Missing ROW 6 . ROW 1 - ProcedureTable1, columnAA ROW 2 - ProcedureTable1, columnBB ROW 3 - ProcedureTable1, columnCC ROW 4 - ProcedureTable2, columnAA ROW 5 - ProcedureTable2, columnBB ROW 6 - ProcedureTable3, columnAA - this row is not processed By reviewing the script log ... i can see that The data loop starts executing the "GroovyDataSource" test stepfor row = 5 (see script log in screen capture below - "row = 5" is present in the script log); The "GroovyScript1" test step logs the table name & column name from the"GroovyDataSource" test step. This log info does NOT appear in the script log below for row 5. Thanks again for all your help.How to read in multiple JSON files with DataSource and parse when # of child nodes differs ?
I am reading in 400+ JSON files from a directory using DataSource. Each individual JSON file is imported into a test step property using DataSource test step with Source = Directory I am then using DataSource test step with Source = JSON to read in the JSON from thetest step property for parsing. I want to do this in nested DataSourceLoops so that for each of the 400+ files I am reading in all the combinations of tableName and columns The number of tableNames and columns varies by file, but the structure of all files is identical Desired output is listed below. I am able to loop through the files and successfully obtain the ontologyName and the table names, but having difficulty with the column names Can anyone help? Scroll down for desired output and raw JSON. Thanks! { JSON FILE 1 { "ontologyName": "Resource01", "linkedResources": [ { "tableName": "Table01", "columns": [ "Resource01 - Table01 - a_reference", "Resource01 - Table01 - b_reference", "Resource01 - Table01 - c_reference", "Resource01 - Table01 - d_reference", "Resource01 - Table01 - e_reference" ] } ] } JSON FILE 2 { "ontologyName": "Resource02", "linkedResources": [ { "tableName": "Table01", "columns": [ "Resource02 - Table01 - a_reference", "Resource02 - Table01 - b_reference" ] }, { "tableName": "Table02", "columns": [ "Resource02 - Table02 - a_reference", "Resource02 - Table02 - b_reference", "Resource02 - Table02 - c_reference" ] },{ "tableName": "Table03", "columns": [ "Resource02 - Table03 - a_reference", "Resource02 - Table03 - b_reference", "Resource02 - Table03 - c_reference", "Resource02 - Table03 - d_reference", "Resource02 - Table03 - e_reference" ] } ] }
