Forum Discussion

aignn's avatar
aignn
Helper II
6 years ago
Solved

How can i get data from web API with my json data?

Hello!

 

I have api, https://site.com/api

I have json data that I need to run the query:

{
  "aggs": {
    "round_aggs": {
      "terms": {
        "field": "host.hostname.keyword",
        "size": 2000
      }
    }
  },
  "size": 0
}

 

How can i get data from web API with my json data?

 

i have this example:

let
Json = Json.FromValue({[idType= "ID_ISIN", idValue= "US4592001014"], [idType = "ID_WERTPAPIER", idValue = "851399", exchCode = "US" ]}),
Source = Json.Document(Web.Contents("https://api.openfigi.com/v1/mapping?", [Headers=[#"Content-Type"="application/json"], Content=Json]))
in
Source

But I don't know how to do this with my json data

 

Thanks in advance

  • Hello aignn 

     

    use this syntax for your Json-step

    Json = Json.Document("{#(cr)#(lf)  ""aggs"": {#(cr)#(lf)    ""round_aggs"": {#(cr)#(lf)      ""terms"": {#(cr)#(lf)        ""field"": ""host.hostname.keyword"",#(cr)#(lf)        ""size"": 2000#(cr)#(lf)      }#(cr)#(lf)    }#(cr)#(lf)  },#(cr)#(lf)  ""size"": 0#(cr)#(lf)}")

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

1 Reply

  • Jimmy801's avatar
    Jimmy801
    Community Champion

    Hello aignn 

     

    use this syntax for your Json-step

    Json = Json.Document("{#(cr)#(lf)  ""aggs"": {#(cr)#(lf)    ""round_aggs"": {#(cr)#(lf)      ""terms"": {#(cr)#(lf)        ""field"": ""host.hostname.keyword"",#(cr)#(lf)        ""size"": 2000#(cr)#(lf)      }#(cr)#(lf)    }#(cr)#(lf)  },#(cr)#(lf)  ""size"": 0#(cr)#(lf)}")

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy