Query in Relative Path

Anonymous · ‎01-05-2024

I have the following query that returns the information following it. The area of the source URL noted by the blue is the device that I'm pulling the data from. What I want to do is replace the section in blue with a list of other devices. Upon some suggestions here and some other poking around I came up with the third picture...

New Attempt

In this case I added a relative path with an added query. My first attempt was to just added a different device.

This however is giving me the following error.

I'm assuming that something I'm doing is causing a syntax issue but I'm not sure what.

My next step is to replace the single device with the actual query that returns the list of other devices. which is...

And returns

Any help or ideas or maybe a better method to accomplish this would be appreciated.

Thank You

lbendlin · ‎01-05-2024

Do your process the other way round. Have a list of devices, call the API for each, process the results into a table format and return them as a custom column. Then expand that column across all devices.

Anonymous · ‎01-08-2024

"Do your process the other way round. Have a list of devices, call the API for each,"

Please forgive my ignorance as I'm fairly new to Power Query. I'm not sure how what you are saying to do is different then what I'm attempting to do.

I have the list, I want to call the API for each item on the list.

The item in Blue in teh first picture is just a single item off that list. I'm testing that single item before I attempt to do the entire list. I'm getting an error on the single item. Are you saying that if I use the list rather than a single item I won't get the error?

Or, are you saying make seperate calls for each device, not using relative path or the list and then combine? I had thought about doing that but seems like that is "Brute force'ish" and would be impossible to do for a long list.

Thank You