Is it possible to query the data in a data model in GoodData via an API? For example, let's say I had an accounts table in my data model in GoodData, and I wanted to query that table via an API (using SELECT * or something like that) to load the rows somewhere else, is that possible? If so, could you point me in the right direction in the documentation? I'm having trouble finding anything on this.

Hello @Mitchel Roling, are you using a hosted version of GoodData or the Cloud native one (GoodData.CN)?

@Tomas Muchka - Unfortunately I don't have CN. I'm on the Growth plan here: https://www.gooddata.com/pricing/

Hi Mitchel, in the classic GD platform, you will need to create a report and then export that report as a csv file to use to analyze someplace else.

@Mitchel Roling please check our GoodData.UI typescript framework which allows to execute analytical queries. The framework uses fluent API instead of SQL, but the construction should be pretty straightforward. I would recommend to try out GoodData.UI first before trying to use raw APIs as the framework helps you to handle authentication etc. https://sdk.gooddata.com/gooddata-ui/docs/custom_execution.html https://codesandbox.io/s/github/gooddata/gooddata-ui-examples/tree/master/example-execute?file=/src/App/CustomVisualization.js

@Joseph Heun - Yeah, I figured. Thanks!

🎉 New note created.