Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Sowjanya2534
New Member

How to do API work Around In power query ?

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

1 REPLY 1
v-jingzhan-msft
Community Support
Community Support

Hi @Sowjanya2534 

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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