Issues with REST BAQ

Experts' Corner
22

BTW All I thought I’d go ahead and give that CData Odata ODBC Driver a try with our rest services v2 - works great and I’d think it should be a reasonable solution. You just have to know how to fill out the settings to align with our apis:

Here’s an example for the COM-CustJobs baq. Fill out

  • The root url for the baq or business object (don’t include /data, etc BaqSvc/BaqName/ is the root here)
  • use basic authentication with user/pass
  • Under custom headers add your api key X-API-KEY:YourApiKeyHere - this also works if you place the querystring in the custom url parameters like api-key=YourApiKeyHere

    Then you can query the one table “Data” using sql. so here in excel i’m just letting it do select *

image
image.png766×633 11.9 KB

image
image.png905×713 29.6 KB

image
image.png1569×960 73.8 KB

So - that’s i think a relatively reasonable way to hook up things that want SQL sources with the apis. nonwithstanding the odata source type in power query fighting our querystring additions.

11 Likes