Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I am using Qradar API to get Data into Power BI.
I have 2 tables
1. Saved Searches
2. Search results
I have a table named Saved Searches (Coming from API) Which will give you the Name and ID(ex:1234) columns. I want to add the Search_Id column.
To receive Search_Id(ex: XNFJHHG......), I have to use another API by passing a parameter ID.
To receive Search results in a table I have to pass Search_Id to another API.
I trying to automate this workaround.
Is this workaround API Calls possible in Power Query?
FYI:https://www.ibm.com/support/pages/qradar-how-export-saved-searches-results-using-qradar-api
It is possible to convert a POST or GET API request into power query code. However the document you linked is introducing how to get the result by using the QRadar GUI API. It doesn't show how the requests are generated or include the necessary information about the API endpoint you want to interact with. This includes the URL, headers, and request body (if applicable) .etc. So it's difficult for us to convert them. Can you provide more documentation about the necessary information related to these APIs?
Best Regards,
Jing
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |