Essbase API access

[GG_Alteryx]

Does anybody have a use case of extracting data from API via Alteryx?

[danilang]

Hi @GG_Alteryx 

Check out the API for Beginners Article from @BrandonB.  It's a great overview on how to get data from API's.

Dan 

[Manoj_k]

Hi GG, the data extraction from the api depends on the complexity of the API, if the api is having no authentication then a simple input data tool and and a download tool can help you to extract the data. 

[apathetichell]

Here is the rest guide for essbase:

https://docs.oracle.com/en/database/other-databases/essbase/21/essrt/api-essbase.html

I'd expect there's also a Soap guide...

there is a swagger site here - https://myserver.example.com:9001/essbase/rest/doc/