Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

REST API Table.FromList for multiple lists in a row

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

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

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

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

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