Forum Discussion
Dynamic tabels from API
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?
Hi， Anonymous ；
May be the error come from Record.FromList
For example ,
= Record.FromList({1, 2}, {"a", "b"})
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.
4 Replies
Anonymous , Is it showing the option to click here to see an error?
Any function with one argument is under doubt as of now
Hi， Anonymous ；
May be the error come from Record.FromList
For example ,
= Record.FromList({1, 2}, {"a", "b"})
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.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.
