Script error in reporting module

[William_Mejia]

I am making a script to create a simple dataset where one column is the name of the product and the other is the weight. I choose this weight using system.tag.queryTagHistory and I save it in a variable to later use it when creating the dataset.

def updateData(data, sample):

dropDownMill = data['dropDownMill']
startTime = data['startTime']
endTime = data['endTime']
intervalTime = system.date.hoursBetween(startTime, endTime)


pathScaleB1 = '[Scales_Simulator]' + dropDownMill + '/scale b1/pv_totalweightnotclearable'
value = system.tag.queryTagHistory(paths=[pathScaleB1], startDate=startTime, endDate=endTime,  intervalHours=intervalTime, aggregationMode="Range")


headers = ["Products", "Weight"]
row = []
row.append(["B1", value])
ds = system.dataset.toDataSet(headers, row)
data['MyDataset'] = ds

When I go to the design tab I get an error, I attached images.

[pturmel]

You are placing a dataset inside of a dataset. queryTagHistory() returns a dataset. Which you then place into a row of your scripted dataset. Not permitted. The error is occurring when the gateway is trying to deliver this invalid dataset to the designer for you.

Extract the value from the history dataset to place in your row.

[William_Mejia]

Thanks for the help, it was very useful!! I fixed it by adding B1 = value.getValueAt(0,1)

dropDownMill = data['dropDownMill']
startTime = data['startTime']
endTime = data['endTime']
intervalTime = system.date.hoursBetween(startTime, endTime)


pathScaleB1 = '[Scales_Simulator]' + dropDownMill + '/scale b1/pv_totalweightnotclearable'
value = system.tag.queryTagHistory(paths=[pathScaleB1], startDate=startTime, endDate=endTime,  intervalHours=intervalTime, aggregationMode="Range")
B1 = value.getValueAt(0,1)

headers = ["Products", "Weight"]
row = []	
row.append(["B1", B1])
ds = system.dataset.toDataSet(headers, row)
data['MyDataset'] = ds