Hi all,
I have a Queue item schema that is quite extensive. In order to prevent errors in the process and queue I want to create a standard collection through a C# code stage where all the fields, subcollections and subcollection fields are predefined and the standard Queue item collection is returned output.
I want to do this by code so I don't have to create tens of BP stages which all add a single field, and thereby keep everything manageable. However I am unable to recreate this possibility programmatically. Basically what I need to do is pre-define the DataTable schemas for the nested DataTables/collections. I am unable to do this however without adding new rows and then importing already defined nested datatable into a column/cell of type DataTable in that row, which is not the same. Also this is a bottom up approach that requires a lot of planning.
What I want to do is create the base DataTable with some columns of type string or boolean, and some columns of type DataTable. Within the DataTable columns I want to pre-define their own columns as well.
Is this possible and if so how? If not, what format does BP use for these nested collections, because they seem to pull it off?