How to do API work Around In power query ?

[Sowjanya2534]

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

[Anonymous]

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