DataTable vs. xfDataTable
In a data connector rule, we need to run the api.Parser.ProcessDataTable funciton that can process a DataTable.
However, using SIC funciton, we have to get data from the source into a XFDataTable: ...
Forum Discussion
Not sure if this helps but I've done the following test on a extensibility rule and can tell you that it gives me the expected results:
Dim originalDT As Datatable = BRApi.Import.Data.FdxExecuteDataUnit(si, "PeoplePln", "E#UK", "Local", scenarioTypeId.Budget, "S#BudgetDefault", "T#2021M5", "YTD", True, "UD1 = 'IT' And Account = 'Bonus1'", 1, False)
brapi.ErrorLog.LogMessage(si,$"original DT - {PrintDataTable(si,originalDT)}")
Dim xfDT As xfDataTable = Nothing
xfDT = New xfDataTable(si,originalDT,Nothing,1000)
Dim resultDT As DataTable = xfdt.ConvertToDataTable(si)
brapi.ErrorLog.LogMessage(si,$"result DT - {PrintDataTable(si,resultDT)}")The ConvertToDataTable worked ok in my case so this could either be:
- a version related issue (I'm on v8.2.0)
- an issue with your objJobStatus.RemoteJobResult.ResultSet object
- some type of special name / character that is causing an incompatibility with the ConvertToDataTable - I'd try testing it with a simplified version of this table first