Adding Rows to a Local DataSource for API Testing

Question

I want to use my Local Data Table as a dynamic source that I can add an unknown set of rows into. Is that doable?

The goal is to just attach it as a driver to the loop that needed to load data from an excel sheet that contains a subset of our master data variables. (200 possible test variables but for testing a specific section of the code we only need to twiddle 3 bits.

I could use an array, but this needs to be maintainable by untrained UFT testers when I'm gone. Easiest way is to create the list on the fly depending on the content of the data driver sheet.

Answer 1

You can attach dynamic an excel file, or you can use a step to populate a local data source.

In my case, I have one step called "Lookup" than load some registers from a web grid and populate the local data source of "Detail" step.

For Iterator = 1 To TestArgs("LookupIterations") Step 1
    If Browser("AWAT").Page("W").Frame("ipsToolbar").WebElement(getGridXpath(Iterator,3)).Exist(1) Then 
        DataTable.GetSheet("Detail").SetCurrentRow Iterator
        Datatable("RowId","Detail") = Iterator
        Datatable("FromType","Detail") = Browser("Water (AWAT) | IPS").Page("Water (AWAT) | IPS").Frame("ipsToolbar").WebElement(getGridXpath(Iterator,3)).GetROProperty("outertext")
        Datatable("FromID","Detail") = Browser("Water (AWAT) | IPS").Page("Water (AWAT) | IPS").Frame("ipsToolbar").WebElement(getGridXpath(Iterator,4)).GetROProperty("outertext")
        Datatable("ToType","Detail") = Browser("Water (AWAT) | IPS").Page("Water (AWAT) | IPS").Frame("ipsToolbar").WebElement(getGridXpath(Iterator,5)).GetROProperty("outertext")
        Datatable("ToID","Detail") = Browser("Water (AWAT) | IPS").Page("Water (AWAT) | IPS").Frame("ipsToolbar").WebElement(getGridXpath(Iterator,6)).GetROProperty("outertext")
    Else
        Iterator = TestArgs("LookupIterations") + 1
    End If
Next