Hello! thank you for answering. So I checked that by printing the variable and I do get rows and columns from it. However, since there is nothing to hide with my code:
def createDataset(SPlist):
import datetime
ncpsT5 =[]
ncpsT6 =[]
ncpsC = []
ncpsP = []
estaciones = []
for ncp in SPlist:
date = datetime.datetime.strptime(ncp['Fechadeefectividad'],"%Y-%m-%dT%H:%M:%SZ")
#print([ncp['ID'],ncp['Title'],date,ncp['LineadeEnsamble'],ncp['Estaci_x00f3_n']])
if (date.isocalendar()[1] == datetime.datetime.today().isocalendar()[1]) and (date.isocalendar()[0] == datetime.datetime.today().isocalendar()[0]):
date = date.strftime('%d/%m/%Y')
if ncp['LineadeEnsamble'] == "Tractores Utilitarios":
oneRow = [ncp['ID'],ncp['Title'],date,ncp['LineadeEnsamble'],ncp['Estaci_x00f3_n']] #ncp['Fechadeefectividad']
ncpsT5.append(oneRow)
for est in ncp['Estaci_x00f3_n']:
oneRow = [ncp['ID'],ncp['LineadeEnsamble'],est]
estaciones.append(oneRow)
elif ncp['LineadeEnsamble'] == "Tractores Medianos y Grandes":
oneRow = [ncp['ID'],ncp['Title'],date,ncp['LineadeEnsamble'],ncp['Estaci_x00f3_n']] #ncp['Fechadeefectividad']
ncpsT6.append(oneRow)
for est in ncp['Estaci_x00f3_n']:
oneRow = [ncp['ID'],ncp['LineadeEnsamble'],est]
estaciones.append(oneRow)
elif ncp['LineadeEnsamble'] == "Cosechadoras":
oneRow = [ncp['ID'],ncp['Title'],date,ncp['LineadeEnsamble'],ncp['Estaci_x00f3_n']] #ncp['Fechadeefectividad']
ncpsC.append(oneRow)
for est in ncp['Estaci_x00f3_n']:
oneRow = [ncp['ID'],ncp['LineadeEnsamble'],est]
estaciones.append(oneRow)
elif ncp['LineadeEnsamble'] == "Plataformas":
oneRow = [ncp['ID'],ncp['Title'],date,ncp['LineadeEnsamble'],ncp['Estaci_x00f3_n']] #ncp['Fechadeefectividad']
ncpsP.append(oneRow)
for est in ncp['Estaci_x00f3_n']:
oneRow = [ncp['ID'],ncp['LineadeEnsamble'],est]
estaciones.append(oneRow)
headers = ["N NCP","Titulo","Fecha de efectividad","Linea de ensamble","Estaciones afectadas"]
data5 = system.dataset.toDataSet(headers,ncpsT5)
system.tag.writeBlocking(["[default]OpAgricolas/SharepointIntegration/NCPsT5000"],data5)
data6 = system.dataset.toDataSet(headers,ncpsT6)
system.tag.writeBlocking("[default]OpAgricolas/SharepointIntegration/NCPsT6000",data6)
dataC = system.dataset.toDataSet(headers,ncpsC)
system.tag.writeBlocking("[default]OpAgricolas/SharepointIntegration/NCPsCosechadoras",dataC)
dataP = system.dataset.toDataSet(headers,ncpsP)
system.tag.writeBlocking("[default]OpAgricolas/SharepointIntegration/NCPsPlataformas",dataP)
headers2 = ["NCP","Linea de ensamble","Estaciones"]
#print(len(estaciones))
data = system.dataset.toDataSet(headers2,estaciones)
system.tag.writeBlocking("[default]OpAgricolas/SharepointIntegration/NCPsEstaciones",data)