Forum Discussion

ColonelHawx1008's avatar
ColonelHawx1008
New Member
3 years ago

OData Feed | Parameters Existing Table Column

Hi All, 

 

Noob here with little BI skills, but I have tried searching and watched numerous videos with no luck.

 

My request:

 

I have an existing OData Feed that connects to a specific URL, this imports a column named "id"

 

I would like to create approx. 350 additional OData Feed Queries using a URL https://api.securitycenter.microsoft.com/api/recommendations/ENTER-THE-ID-HERE/machineReferences

 

However, I want to automate this query by PULLING the ID and inserting it to the portion of the URL where is says "ENTER-THE-ID-HERE.

 

Let say the column named id has the following id : va-_-adobe

 

The URL by default is and will always remain the same, with just the "id" field being different (350 different IDs) 

 

So it will then become: 

https://api.securitycenter.microsoft.com/api/recommendations/va-_-adobe/machineReferences, I want to pull the id int

 

Any idea how on earth I can perform this?

 

Thanking you in advance!!