klincecum
July 13, 2023, 2:15pm
21
aosemwengie1:
How?
I have created an API and set its scope to just the BAQ I want to return. In the REST helper, I can paste the API in the header for REST v2. I get the data back as expected in the REST helper. However, I want to use this data in Excel to make some charts. I have tried a few different ways to pull it in, including power query editor, and the =webservice formula. Nothing has worked so far. I couldn’t get the power query editor to return anything, and the webservice formula always returned #Value.
…
I think all of it, but I’ve slept since then.
There’s a lot in that thread, but it sounds like it only works with api key + basic auth? We’re SSO so that’s still not a solution for us. Granted I haven’t tried it since I have been told it doesn’t work.
klincecum
July 13, 2023, 2:25pm
23
Be bold, people lie all the time!