Forum Discussion

MithSingh's avatar
MithSingh
Frequent Visitor
3 years ago

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

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(
        [
                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.
 
 
General Comment
Need Help
Show and Tell

4 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

     

     

     Source = List.Generate( () =>

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

     

     

    • MithSingh's avatar
      MithSingh
      Frequent Visitor
      3 years ago

      Thank you,

       

      I tried this M query:

       

      let
          Source = List.Generate( () =>

              [ URL = Web.Contents(
              [
                      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's avatar
        ImkeF
        Icon for Community Champion rankCommunity Champion
        3 years ago

        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