Reply
user180618
Helper I
Helper I

Pulling specific parameters other than action=list from an API

I am using Qualys's API documentation to pull their endpoints into Power Query. Doing the below works fine:

 

let
Url = "https://qualysapi.qualys.eu/api/2.0/fo/knowledge_base/vuln/",
AuthString = "Basic ###############################",
Source = Xml.Tables(
Web.Contents (
Url,
[
Headers = [ #"Authorization" = AuthString,
#"X-Requested-With" = "Power BI"],
Query = [action = "list"],
Content = Text.ToBinary("")
]

)
)

 

However, I'm not sure how to modify the 'Query' line to pull multiple parameters from the API, for example so that I can use both action=list and also something like echo_request.

 

Appreciate any suggestions.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Query = [action = "list", echo_request = "1"],

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Query = [action = "list", echo_request = "1"],
avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)