Forum Discussion
Can't save dataflow "One or more tables references a dynamic data source
Hello Everyone,
I can't be able to save it, I have been trying to resolve it from last almost a month but have had no luck yet.
let
Source = List.Generate( () =>
[ URL = "https://LPF.api.goflow.com/v1/orders?filters[date:gte]=2023-05-05T00:00:00Z" , Result = Json.Document(Web.Contents(URL,[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxx"]])) ],
each [URL] <> null,
each [ URL = [Result][next] , Result = Json.Document(Web.Contents([URL],[Headers=[Authorization="Bearer xxxxxxxxxxxxxxxxx"]])) ]
),
#"Convert to table" = Table.FromValue(Source)
in
#"Convert to table"
1 Reply
ppm1Solution Sage
Please see this article about using the RelativePath and Query terms in Web.Contents.
Pat