Dynamic tabels from API

[Anonymous]

Hello,

shared Helloworld.Contents = (optional message as text) =>
    let
        endpoint = "My link to the API",
        directive= "A",
        cache    = "false",
        headers  = Record.FromList({"Headers"}),
        payload  = Json.Document(Web.Contents(endpoint, headers)),
    value = payload[value],
    #"Converted to Table" = Table.FromList(value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", headers)
    in
        #"Expanded Column1"; 

When compile this, I get this error:

1 Arguments were passed to a function which expects 2. What can it be?

[v-yalanwu-msft]

Hi, @Anonymous ;

Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft · Accepted solution]

Hi， @Anonymous ；

May be the error come from Record.FromList

For example ,

= Record.FromList({1, 2}, {"a", "b"})

https://social.technet.microsoft.com/Forums/office/en-US/1fd26cde-2d33-4f36-974e-e5c74b9f0c37/recordfromlist-undocumentedwrong-how-to-use-it?forum=powerquery

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Is it showing the option to click here to see an error?

Any function with one argument is under doubt as of now

[Anonymous]

No, it doesn't show which function specifically has an error:(