REST API Table.FromList for multiple lists in a row

[Anonymous]

Hi,

I have a connection to a rest API and at the root after doing the query I need two lists to be opened in the same table.

I tried these steps :

data = Source[data],

included = Source[included],

#"Converted to Table" = Table.FromList({[data],[included]}, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

but it's not working.

Does someone knows how could I have data and included lists converted into a single table ?

Because of an API limitation I can't do it separatly and then use merge function.

Thanks in advance,

Regards,

Cado

[Anonymous · Accepted solution]

The solution is to convert to record first and then expand :

data = Source[data],
included = Source[included],
rec = Record.FromList({data,included},{"data","included"})