how i can change nature of business & searchinput every time user input different and show the output.
let
Query2 = let
url = "XXXXXXXXXXXXXXXXX",
headers = [#"Content-Type" = "application/json"],
postData = Json.FromValue([natureOfBusiness = "Employment",searchInput = "cyber tech"]),
response = Web.Contents(
url,
[
Headers = headers,
Content = postData
]
),
jsonResponse = Json.Document(response),
jsonResponse1 = jsonResponse{0}+jsonResponse{1}+jsonResponse{2},
#"Converted to Table" = Record.ToTable(jsonResponse1)
in
jsonResponse,
#"Converted to Table" = Table.FromList(Query2, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"organization", "abbreviated", "category", "score"}, {"organization", "abbreviated", "category", "score"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"score", Int64.Type}})
in
#"Changed Type"
