Forum Discussion
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:g...
lbendlin
Super User
Super User
Source = List.Generate( () =>
URL = Web.Contents(
"https://LPF.api.goflow.com/",
[
RelativePath= "v1/orders",
Query=[
#"filters[date:gte]"="2023-03-27T00:00:00Z"
]
]
),
...
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
Community Champion
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 Sourcealready tried, and again tried it, getting an error "Expression.Error: We cannot convert a value of type Binary to type Text."
