Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Web.Contents with more than one URL

Hey,    In future, I need to combine 2 web contents in ONE table - one for historical data and after a website relaunch for the "new" data.   currently, the expression is like this: = Json.Docum...
Need Help
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    Just follow the same pattern as before, something like this:

    let
    Source1 = Json.Document(Web.Contents("https://www.jsonkeeper.com/12345")),
    convToTable1 = Table.FromList(Source1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Source2 = Json.Document(Web.Contents("https://www.thisisafunnyurl.com")),
    convToTable2 = Table.FromList(Source2, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    combineQueries = Table.Combine({convToTable1, convToTable2})
in
    combineQueries

     

    If you're feeling particularly brave, you can combine the code into single steps for each source:

    let
    Source1 =
        Table.FromList(
            Json.Document(Web.Contents("https://www.jsonkeeper.com/12345")),
            Splitter.SplitByNothing(),
            null,
            null,
            ExtraValues.Error
        ),
    Source2 =
        Table.FromList(
            Json.Document(Web.Contents("https://www.thisisafunnyurl.com")),
            Splitter.SplitByNothing(),
            null,
            null,
            ExtraValues.Error
        ),
    combineQueries = Table.Combine({Source1, Source2})
in
    combineQueries

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi Steph,

 

No, Query1 would be like this:

 

let
    Source = Json.Document(Web.Contents("https://www.thisisafunnyurl.com"))
in
    Source

 

 

Query2 would be like this:

 

let
    Source = Json.Document(Web.Contents("https://www.jsonkeeper.com/12345"))
in
    Source

 

 

And you'd have a new Query3 like this:

 

let
    Source = Table.Combine({Query1, Query2})
in
    Source

 

 

You could reference one of the queries from within the other but, at that point, you may as well go for Option 1, which would look like this:

 

let
    Source1 = Json.Document(Web.Contents("https://www.jsonkeeper.com/12345")),
    Source2 = Json.Document(Web.Contents("https://www.thisisafunnyurl.com")),
    combineQueries = Table.Combine({Source1, Source2})
in
    combineQueries

 

 

Pete

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Seems as if it's going to work...

 

BUT: This error occurred:

 

 

I found a convert-to-table command in another of my (inherited) tables... but how do i adjust the command when dealing with 2 sources now?

 

#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

 

 

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

     

    Just follow the same pattern as before, something like this:

    let
    Source1 = Json.Document(Web.Contents("https://www.jsonkeeper.com/12345")),
    convToTable1 = Table.FromList(Source1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    Source2 = Json.Document(Web.Contents("https://www.thisisafunnyurl.com")),
    convToTable2 = Table.FromList(Source2, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    combineQueries = Table.Combine({convToTable1, convToTable2})
in
    combineQueries

     

    If you're feeling particularly brave, you can combine the code into single steps for each source:

    let
    Source1 =
        Table.FromList(
            Json.Document(Web.Contents("https://www.jsonkeeper.com/12345")),
            Splitter.SplitByNothing(),
            null,
            null,
            ExtraValues.Error
        ),
    Source2 =
        Table.FromList(
            Json.Document(Web.Contents("https://www.thisisafunnyurl.com")),
            Splitter.SplitByNothing(),
            null,
            null,
            ExtraValues.Error
        ),
    combineQueries = Table.Combine({Source1, Source2})
in
    combineQueries

     

    Pete