Forum Discussion

LP2803's avatar
LP2803
Icon for Responsive Resident rankResponsive Resident
5 years ago

Formula.Firewall error while passing data from one query to another through parameter

Hi Team,

 

I have a problem with API call from passing data from one query to another through parameter.

 

Query1:

let
Source = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A[2019-10-01T00:00:00Z%20TO%20now/d]&size=10000")),
hits = Source[hits],
hits1 = hits[hits],
#"Converted to Table" = Table.FromList(hits1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_index", "_type", "_id", "_score", "_source"}, {"Column1._index", "Column1._type", "Column1._id", "Column1._score", "Column1._source"}),
#"Expanded Column1._source" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1._source", {"@timestamp"}, {"Column1._source.@timestamp"}),
#"Sorted Rows" = Table.Sort(#"Expanded Column1._source",{{"Column1._source.@timestamp", Order.Descending}})
in
#"Sorted Rows"

 

 

Query2:

let
Source1 = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A[2019-10-01T00:00:00Z%20TO%20now/d]&size=10000")),
Source = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A["& Parameter1 &"%20TO%20now/d]&size=10000")),
hits = Source[hits],
hits1 = hits[hits],
#"Converted to Table" = Table.FromList(hits1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"_index", "_type", "_id", "_score", "_source"}, {"Column1._index", "Column1._type", "Column1._id", "Column1._score", "Column1._source"}),
#"Expanded Column1._source" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1._source", {"@timestamp"}, {"Column1._source.@timestamp"}),
#"Sorted Rows" = Table.Sort(#"Expanded Column1._source",{{"Column1._source.@timestamp", Order.Ascending}})
in
#"Sorted Rows"

 

 

 

4 Replies