Can't save dataflow "One or more tables references a dynamic data source."

[MithSingh]

Hi Everyone,

I can't able to save it, getting an error. please help me with this.

let

  Source = List.Generate( () =>

        [ URL = "https://LPF.api.goflow.com/v1/orders?filters[date:gte]=2023-03-27T00:00:00Z" , Result = Json.Document(Web.Contents(URL,[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxxxxxxxx"]])) ],

        each [URL] <> null,

        each [ URL = [Result][next] , Result = Json.Document(Web.Contents([URL],[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxxxxxxxx"]])) ]

    ),

  #"Convert to table" = Table.FromValue(Source),

  #"Expanded Value" = Table.ExpandRecordColumn(#"Convert to table", "Value", {"URL"}, {"URL"})

in

  #"Expanded Value"

I also tried this M query, but I am also getting an error "Expression.Error: We cannot convert a value of type Binary to type Text."

let

  Source = List.Generate( () =>

        [ URL = Web.Contents(

        "https://LPF.api.goflow.com/",

        [

                RelativePath= "v1/",

                Query=[

                        orders= "filters[date:gte]=2023-03-27T00:00:00Z"

                ]

        ]

) , Result = Json.Document(Web.Contents(URL,[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxxxxxxxx"]])) ],

        each [URL] <> null,

        each [ URL = [Result][next] , Result = Json.Document(Web.Contents([URL],[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxxxxxxxx"]])) ]

    ),

  #"Convert to table" = Table.FromValue(Source),

  #"Expanded Value" = Table.ExpandRecordColumn(#"Convert to table", "Value", {"URL"}, {"URL"}),

  #"Transform columns" = Table.TransformColumnTypes(#"Expanded Value", {{"URL", type text}})

in

  #"Transform columns"

Please help me with this.

[lbendlin]

 Source = List.Generate( () =>

        URL = Web.Contents(
        "https://LPF.api.goflow.com/",
        [
                RelativePath= "v1/orders",
                Query=[
                        #"filters[date:gte]"="2023-03-27T00:00:00Z"
                ]
        ]
    ),
...

[MithSingh]

Thank you,

I tried this M query:

let

    Source = List.Generate( () =>

        [ URL = Web.Contents(

        "https://LPF.api.goflow.com/",

        [

                RelativePath= "v1/orders",

                Query=[

                        #"filters[date:gte]"="2023-03-27T00:00:00Z"

                ]

        ]

    ) , Result = Json.Document(Web.Contents(URL,[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxxxxxxxx"]])) ],

        each [URL] <> null,

        each [ URL = [Result][next] , Result = Json.Document(Web.Contents([URL],[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxxxxxxxx"]])) ]

    )

in

   Source

getting an error "Expression.Error: We cannot convert a value of type Binary to type Text."

[ImkeF]

Hi @MithSingh ,
try removing the square brackets around URL in the last step like so:

let
    Source = List.Generate(
        () => [
            URL = Web.Contents(
                "https://LPF.api.goflow.com/", 
                [RelativePath = "v1/orders", Query = [#"filters[date:gte]" = "2023-03-27T00:00:00Z"]]
            ), 
            Result = Json.Document(Web.Contents(URL, [Headers = [Authorization = "Bearer xxxxxxxxxxxxxxxxxxxxxxx"]]))
        ], 
        each [URL] <> null, 
        each [
            URL    = [Result][next], 
            Result = Json.Document(Web.Contents(URL, [Headers = [Authorization = "Bearer xxxxxxxxxxxxxxxxxxxxxxx"]]))
        ]
    )
in
    Source

[MithSingh]

already tried, and again tried it, getting an error "Expression.Error: We cannot convert a value of type Binary to type Text."