iTwin Platform - Query iModel data through API

[Haval]

Hello, I'm looking to access information from a ProjectWise iModel through the iTwin Platform.  It appears that the API to do this would require creating a Report, iModel Mapping, Groups, Group Properties and then a data extraction.  This seems like a lot of steps to access information from within an iModel.  I wanted to confirm I'm heading down the right path or see if there is something that is a little more straightforward.

Are there any APIs or methods of querying the data without those steps.  Is it possible to perform ECSql queries directly through another endpoint?

Source: https://developer.bentley.com/apis/insights/overview/

Thank you

[aruniverse]

Hey @Haval thanks for your interest!

We unfortunately don't have a iTwin Platform API to execute raw ECSql queries (yet), so you would have to use iTwin.js to do so. Here's some docs for executing ECSql in a frontend and backend application using the iTwin.js libraries. Another option is to use the iModelConsole.

If these options don't meet your needs, we'd love to hear more about what you are doing and trying to solve, and work on providing a solution that does.

[Haval]

Hello @aruniverse

Unfortunately it doesn't sound like these options meet my needs. I'm looking into allowing a separate application the ability to query information out of an iModel without requiring direct file access to the data. From my understanding the closest way to get to this would be to create an iTwin platform app, grant the app the rights to the ProjectWise iTwin and then access information through the APIs there.

It would be great if there was a way to query tree structure/info out of the iModel along with performing ECSql queries. This application is consolidating data across a few sources, one of which would be the information in an iModel.

[aruniverse]

I'm looking into allowing a separate application the ability to query information out of an iModel without requiring direct file access to the data

When you say direct file access to the data, do you mean the iModel? You can spin up a standalone client side application using the iTwin.js libraries that can connect to an iModel remotely and run ECSql queries against it.

[Haval]

Yes to an iModel. When you say connect to an iModel remotely; how is that connection made?

To clarify, I'm looking specifically at making http/API requests to iModels that are in a ProjectWise project.