Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pulling specific parameters other than action=list from an API
09-21-2023
03:43 AM
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.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-23-2023
11:22 AM
Query = [action = "list", echo_request = "1"],

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
09-05-2017 10:14 AM | |||
Anonymous
| 03-16-2021 06:19 AM | ||
04-02-2025 02:18 PM | |||
03-31-2025 07:24 AM | |||
04-28-2025 08:20 AM |