Forum Discussion
Extracting Table for web -Between date Ranges - Error
Hi murthysydney ,
Maybe you can try adding queries to the Web.Contents, like this:
For more information, please refer to: Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Best Regards,
Winniz
Thanks, Winniz
The below is my URL:
So as you mentioned I have created the parameter to get the data but am not able to insert the full length of the URL.
let
Terms =
#table(
{"Term"},
{{"3"}, {"26"}, {"22"}}
),
SearchSuccessful = (Term) =>
let
Source =
Web.Page(Web.Contents(
"https://cmweb.internalapps.hhhhhhh/Default.aspx?Group=",
[Query=[q=Term]],
)
),
Success = Source[Data]
in
Success,
Output =
Table.AddColumn(
Terms,
"Search Successful",
each SearchSuccessful([Term])
),
#"Expanded Search Successful" = Table.ExpandListColumn(Output, "Search Successful"),
#"Expanded Search Successful1" = Table.ExpandTableColumn(#"Expanded Search Successful", "Search Successful", {"Column1", "Column2", "Column3"}, {"Search Successful.Column1", "Search Successful.Column2", "Search Successful.Column3"})
in
#"Expanded Search Successful1"
---------------------------------------------------------------------
How do we add this additional end text of the URL("Status=0&DateFrom=13/05/2000&DateTo=13/05/2022&IsActive=False") in the Source set.
Please assist.
Thanks